Introduction to Structured Query Language - Database Processing: Fundamentals, Design, and Implementation - page 99

ProjectID Name Department MaxHours StartDate EndDate

1000 2013 Q3 Product Plan Marketing 135.00 10-MAY-13 15-JUN-13

1100 2013 Q3 Portfolio Analysis Finance 120.00 07-JUL-13 25-JUL-13

1200 2013 Q3 Tax Preparation Accounting 145.00 10-AUG-13 15-OCT-13

Figure 2-31
Sample Data
for the WPC
Database
PROJECT Table

1300 2013 Q4 Product Plan Marketing 150.00 10-AUG-13 15-SEP-13

1400 2013 Q4 Portfolio Analysis Finance 140.00 05-OCT-13

ASSIGNMENT

Column Name Type Key Required Remarks

ProjectID Number Primary Key,

Foreign Key

Yes Long Integer

Figure 2-32
Column
Characteristics for
the WPC Database
ASSIGNMENT
Table

EmployeeNumber Number Primary Key,

Foreign Key

Yes Long Integer

HoursWorked Number No No Double

Figure 2-33
Sample Data for the
WPC Database
ASSIGNMENT Table

ProjectID EmployeeNumber HoursWorked

1000 1 30.0

1000 8 75.0

1000 10 55.0

1100 4 40.0

1100 6 45.0

1100 1 25.0

1200 2 20.0

1200 4 45.0

1200 5 40.0

1300 1 35.0

1300 8 80.0

1300 10 50.0

1400 4 15.0

1400 5 10.0

1400 6 27.5