C&A Company wants to store employee skill data. Each employee may possess one or more specific skills, and several employees may have the same skill. Include the following facts in the database:

date hired 

date of birth 

date skill acquired

Data from Table 4-16

REQUIRED

a. Design a set of relational tables to store these data.

b. Identify the primary key for each table, and identify any needed foreign keys.

c. Implement your schema using any relational DBMS. Specify primary and foreign keys, and enforce referential integrity. Demonstrate the soundness of your design by entering sample data in each table.

Transcribed Image Text:

TABLE 4-16 Database That Needs to Be Extended Inventory Item Number Description 10573 19" Monitor 10574 21" Monitor 10622 Laser Printer 10623 Color Laser Prin 10624 Multi-function 0 Record: 46 of 6 Record: 446 of 6 Y Customer Customer Number . Name 11255 G. Hwang 12971 J. Jackson 13629 P. Szabo 15637 5. Martinez 18229 B. Adams 0 Ha Y Quantity on Hand Street 2993 Main 466 W. Oak 246 E. Palm 2866 Spring 1744 Apache No Fier Search Search City Mesa Tempe Mesa Tempe Tempe AZ RRRRR AZ AZ AZ AZ ▾ 13 8 22 12 0 State X List Price Y $495.00 $949.00 $395.00 $699.00 $799.00 $0.00 Zip Code -Credit Limit Account Balance - $4,000.00 $5,000.00 85281 85286 85281 85287 85287 0 $6,000.00 $5,000.00 $3,000.00 $0.00 $875.00 $2,588.00 $3.955.00 $250.00 $1.675.00 $0.00