The Busy B Company wants to store data about its employees’ skills. Each employee may possess one or more specific skills. In addition, several employees may have the same skill. The following facts need to be included in the database:

date hired date of birth date skill acquired employee name employee number pay rate

skill name skill number supervisor 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 to which you have access. 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-15 Customer Table Customer Numb 1000 Smith Name City State Credit Limit Phoenix AZ 2500 1001 Jones St Louis 1500 1002 Jeffnes Atlanta GA 4000 1003 Gilkey Phoenix AZ 5000 1004 Lankford Pheenix AZ 2000 1005 2010 Chicago IL 2000 1006 Pagnozzi Salt Lake City UT 3000 1007 Archa Chicago IL 1000 Racor 14 of 9 Sales Inventory: Table Invoice Number Item Number Quantity Extension 101 1025 3 699.95 101 1035 1 849 95 Inventory: Table LOX 102 1045 3 299.86 Rem Number Desorption Une Cost Unit Price Quantity on Hand 103 1010 1 29.95 1010 Blender 14 29.96 200 1015 Toaster 1020 Mar 12 19.95 300 23 33.95 250 888 103 1015 1 19.95 103 1025 2 1399.90 104 1025 1 699 $5 1025 Television 499 599 96 74 104 1045 1 99.95 + 1030 Freezer 999 95 32 105 1036 1 849 95 1035 Refrigerator 699 849 951 25 106 1045 1 99.96 1040 Radio 45 79 95 100 107 1030 1 999 95 1045 Clock. 79 99.95 300 107 1035 1. 849.95 107 1040 2 159 90 Record 5 of 9 107 1045 2 199 90 108 1025 699.95 108 1045 99.95 Sales: Table Record D 17 af 17 Invoice Number Date Salesperson Customer Number Amount 101 10/3/2008 Wilson 1000 1549.90 102 10/5/2008 Mahomet 1003 299.95 103 10/5/2008 Jackson 1002 1449.80 104 10/15/2008 Drezen 1000 799.50 106 10/16/2008 Martinez 1005 849 95 106 10/16/2008 Martinez 1007 99.96 107 10/29/2000 Mahomet 1002 2209 70 100 11/3/2008 Martinez 1000 779.90 Record: