The BusyB Company wants to store data about employee skills. Each employee may possess one or more

Question:

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

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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Accounting Information Systems

ISBN: 978-0132552622

12th edition

Authors: Marshall B. Romney, Paul J. Steinbart

Question Posted: