Question

Create an ERD diagram from the following problem:

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

1. Employee name

2.Skill number

3.Skill name

4.Employee number

5. Date hired

6. Date of birth

7. Date skill acquired

Answer 1

The necessary tables, with their attendant primary and foreign keys, are as follows

Table Name	Primary Key	Foreign Keys	Other Attributes
Employees	Employee Number	Supervisor number(another employee number)	Employee name pay rate Date hired Date of birth
Skills	Skill Number		Skill name
Employees-Skills	Skill Number and Employee number		Date skill acquired

There is no single solution to part c as students will select different software packages and enter different data in the tables.