Question: Create an ER diagram for the scenario described below: Consider a large company that wants to keep track of the training courses that its employees

Create an ER diagram for the scenario described below:

Consider a large company that wants to keep track of the training courses that its employees have taken.

An employee has a name, identification number and salary. An employee works in at most one department.

A department has a unique number, a name and the identification number of the manager of that department.

An employee can take many training courses but can take a given course at most once.

Each course is identified by a course number, descriptive name, its instructor and its length in hours. Since a particular course may be offered several times, the date that an employee takes a course is also recorded.

Draw it out.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!