Draw ER diagram 1) entity types 2) Relationship types 3) keys 4) Cardinality ratio 5) Connection
One employee must work for one and only one department. One department must have 4 or more employees.
One employee may manage one and only one department. One department must be managed by one and only employee.
One department may control one or more projects. One project must be controlled by one and only one department.
One employee must work on one or many projects. One project must have one or many employees to work on.
One employee may have one or more dependents. One dependent must belong to one and only one employee.
One employee may supervise many other employees. One employee may be supervised by another employee.