Should NOT INCORRECT DB REMEMBER. I NEED GENUINE DB NOT ILLOGICAL. Access Workbench Part 3A. Figure 1 shows the column characteristics for the ASSIGNMENT table. Using the columncharacteristics, create the ASSIGNMENT table using 'create table' script in the WPC database. Createthe relationship and referential integrity constraint between ASSIGNMENT and PROJECT, andbetween ASSIGNMENT and EMPLOYEE.Figure 1: Column Characteristics for Assignment TableTypeKeyNumberPrimary Key,Foreign KeyColumn NameProjectIDEmployeeNumberHours WorkedProjectID100010001000110011001200120012001200130013001300Number140014001400NumberPrimary Key,Foreign KeyNoCopyright 2013 Pearson Education, publishing as Prentice HallB. For the ASSIGNMENT table, use figure 2 to insert the data in the ASSIGNMENT table.Figure 2: Assignment DataEmployee Number1810461245181045RequiredYes6YesNoRemarksLong IntegerLong IntegerDouble, fixed,1 decimal placesCopyright ©2013 Pearson Educator, publishing as Prentice HallHours Worked30.075.055.040.045.025.020.045.040.035.080.050.015.010.027.3C. Submit the create table and insert into script for the ASSIGNMENT table (WPC-assignment.sql).

A database table used to store assignments is typically referred to as an "assignment table". This…

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 Number 1300 1300 1400 1400 1400 Number Primary Key, Foreign Key No EmployeeNumber 1 8 10 4 6 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 1 2 4 5 1 8 10 Required Yes. 4 5 Yes No Remarks Long Integer Long Integer Copyright 2013 Pearson Education, publishing as Prentice Hall Double, fixed, 1 decimal places 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.5 C. Submit the create table and insert into script for the ASSIGNMENT table (WPC-assignment.sql).

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 Number 1300 1300 1400 1400 1400 Number Primary Key, Foreign Key No EmployeeNumber 1 8 10 4 6 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 1 2 4 5 1 8 10 Required Yes. 4 5 Yes No Remarks Long Integer Long Integer Copyright 2013 Pearson Education, publishing as Prentice Hall Double, fixed, 1 decimal places 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.5 C. Submit the create table and insert into script for the ASSIGNMENT table (WPC-assignment.sql).

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

Similar questions

What is a DBA? Why is this position necessary?
In regards to the DBA's technical role in providing design and implementation services, could you please elaborate?
What should a DBA be doing to keep a DBMS working well after it has been chosen?
What are the main criteria for assessing DBMs for data warehousing?
DBA configuration control responsibilities?
What are some safeguards DBAs at businesses or schools use to separate the production system from the test system?
DBMS query optimisation strategies and DBA time savings.
What are the advantages and disadvantages of Dbms? (database manegment system) Minimum write 6 to 7 advantages and disadvantages u can write more if u want to write Heading of advantages and then write 6 to 7 points and also write heading of disadvantage and write 6 to 7 points
What are the main tasks of a DBA when it comes to setup management?