![er diagram er diagram](https://4.bp.blogspot.com/-vzWGZE9arS0/W3rcXarGHlI/AAAAAAAAAas/kaZXAA4Wq9oKCUHvLEOP64ls1ACrA5huQCLcBGAs/s1600/ER-Customer-Care.png)
One employee works on several projects and the number of hours worked by the employee on a single project is recorded.Įach Employee has dependents. One department has many projects but one project can not come under many departments. Many employee works in one Department but one employee can not work in many departments.Įmployee works under the manager of the Department and the manager records the date of joining of employee in the department.
![er diagram er diagram](https://ermodelexample.com/wp-content/uploads/2020/10/diagram-generate-er-diagram-from-mysql-online-full-version.png)
![er diagram er diagram](https://ermodelexample.com/wp-content/uploads/2019/10/first-form-of-database-normalization-stack-overflow-pertaining-to-er-diagram-normalization.jpg)
ER DIAGRAM FULL