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
Get step-by-step solutions from verified subject matter experts
