Question: Please specify which are entities and make an Entity Relationship diagram A business consists of many departments Each department has a name, number (unique), employees,

Please specify which are entities and make an Entity Relationship diagram

A business consists of many departments

Each department has a name, number (unique), employees, and a

manager.

The manager is also an employee.

For each Employee we maintain the

social security number(unique),

name, address, salary, sex, and birth date.

Track is kept of the date that the department manager started

managing the department.

Each department controls a number of projects.

Each project has a name, number(unique) and a location, and an

employee who leads it.

Each employee works for exactly one department but may work on

several different projects.

We keep track of the number of hours per week that an employee has

worked on each project.

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!