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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started