Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
mple one line

mple one line

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Simple one line DB. 

Access Workbench Part 3 A. Figure 1 shows the column characteristics for the ASSIGNMENT table. Using the column characteristics, create the ASSIGNMENT table using 'create table' script in the WPC database. Create the relationship and referential integrity constraint between ASSIGNMENT and PROJECT, and between ASSIGNMENT and EMPLOYEE. Figure 1: Column Characteristics for Assignment Table Type Key Number Primary Key, Foreign Key Column Name ProjectID EmployeeNumber Hours Worked ProjectID 1000 1000 1000 1100 1100 1200 1200 1200 1200 1300 1300 1300 Number 1400 1400 1400 Number Primary Key, Foreign Key No Copyright 2013 Pearson Education, publishing as Prentice Hall B. For the ASSIGNMENT table, use figure 2 to insert the data in the ASSIGNMENT table. Figure 2: Assignment Data Employee Number 1 8 10 4 6 1 2 4 5 1 8 10 4 5 Required Yes 6 Yes No Remarks Long Integer Long Integer Double, fixed, 1 decimal places Copyright ©2013 Pearson Educator, publishing as Prentice Hall Hours Worked 30.0 75.0 55.0 40.0 45.0 25.0 20.0 45.0 40.0 35.0 80.0 50.0 15.0 10.0 27.3 C. Submit the create table and insert into script for the ASSIGNMENT table (WPC-assignment.sql).
Transcribed Image Text:Access Workbench Part 3 A. Figure 1 shows the column characteristics for the ASSIGNMENT table. Using the column characteristics, create the ASSIGNMENT table using 'create table' script in the WPC database. Create the relationship and referential integrity constraint between ASSIGNMENT and PROJECT, and between ASSIGNMENT and EMPLOYEE. Figure 1: Column Characteristics for Assignment Table Type Key Number Primary Key, Foreign Key Column Name ProjectID EmployeeNumber Hours Worked ProjectID 1000 1000 1000 1100 1100 1200 1200 1200 1200 1300 1300 1300 Number 1400 1400 1400 Number Primary Key, Foreign Key No Copyright 2013 Pearson Education, publishing as Prentice Hall B. For the ASSIGNMENT table, use figure 2 to insert the data in the ASSIGNMENT table. Figure 2: Assignment Data Employee Number 1 8 10 4 6 1 2 4 5 1 8 10 4 5 Required Yes 6 Yes No Remarks Long Integer Long Integer Double, fixed, 1 decimal places Copyright ©2013 Pearson Educator, publishing as Prentice Hall Hours Worked 30.0 75.0 55.0 40.0 45.0 25.0 20.0 45.0 40.0 35.0 80.0 50.0 15.0 10.0 27.3 C. Submit the create table and insert into script for the ASSIGNMENT table (WPC-assignment.sql).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Web Technologies
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS