My professor stated that Primary key cannot be used twice.

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

Required

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

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