Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
bie. racteristics, create the ASSIGNMENT table using 'create table' script in the WPC datab relationship and referential integrity constraint between ASSIGNMENT and PR ween ASSIGNMENT and EMPLOYEE. Figure 1: Column Characteristics for Assignment Table a Name ID Туре Number Key Primary Key, Foreign Key Required Rem Yes Long reeNumber Number Primary Key, Forcign Key Yes Long Worked Number No No Doul

bie. racteristics, create the ASSIGNMENT table using 'create table' script in the WPC datab relationship and referential integrity constraint between ASSIGNMENT and PR ween ASSIGNMENT and EMPLOYEE. Figure 1: Column Characteristics for Assignment Table a Name ID Туре Number Key Primary Key, Foreign Key Required Rem Yes Long reeNumber Number Primary Key, Forcign Key Yes Long Worked Number No No Doul

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
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 Column Name Key Primary Key, Foreign Key Required Remarks Long Integer Туре ProjectID Number Yes EmployeeNumber Number Primary Key, Forcign Key Yes Long Integer Hours Worked Double, fixed. 1 decimal places Number No No Cepyright e2013 Pearson bducation, pblishing as Prentice Hall В. For the ASSIGNMENT table, use figure 2 to insert the data in the ASSIGNMENT table. Figure 2: Assignment Data ProjectID EmployeeNumber Hours Worked 1000 30.0 1000 8. 75.0 1000 10 55.0 1100 4 40.0 1100 6 45.0 1200 1 25.0 1200 20.0 1200 4 45.0 1200 40.0 1300 1 35.0 1300 8. 80.0 1300 10 50.0 1400 4 15.0 1400 10.0 1400 6 27.5 Copynght e2013 Pearson Educabor, pubishing as Prentice lal 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 Column Name Key Primary Key, Foreign Key Required Remarks Long Integer Туре ProjectID Number Yes EmployeeNumber Number Primary Key, Forcign Key Yes Long Integer Hours Worked Double, fixed. 1 decimal places Number No No Cepyright e2013 Pearson bducation, pblishing as Prentice Hall В. For the ASSIGNMENT table, use figure 2 to insert the data in the ASSIGNMENT table. Figure 2: Assignment Data ProjectID EmployeeNumber Hours Worked 1000 30.0 1000 8. 75.0 1000 10 55.0 1100 4 40.0 1100 6 45.0 1200 1 25.0 1200 20.0 1200 4 45.0 1200 40.0 1300 1 35.0 1300 8. 80.0 1300 10 50.0 1400 4 15.0 1400 10.0 1400 6 27.5 Copynght e2013 Pearson Educabor, pubishing as Prentice lal C. Submit the create table and insert into script for the ASSIGNMENT table (WPC-assignment.sql).
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS