This material corresponds to the ElMasri-Navathe Chapters 3,4,9,23. Thus, in consultation with the creators and users of the data, ER diagrams provide a graphical picture of the data and data relationships and constraints as it is used by the organization. The company is organized into depts - each with a name, number, manager. Each manager has a startdate. Each department can have several locations.
Departments control projects - each with a name, number, location.
Each employee has a name, SSN, sex, address, salary, birthdate, dept, supervisor. Each employee dependent has a name, sex, birthdate and relationship. It includes the entity name and the list of its attributes. Entity Type does not change often - very static. They are very dynamic.