The BusyB Company wants to store data about its employee skills. Each employee may possess...

The BusyB Company wants to store data about its employee skills. 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

employee name

employee number

pay rate

skill name

skill number

supervisor

TABLE Database That Needs to Be Extended

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.