Ql. Develop an ER diagram for a company XYZ, from the following requirements usi

Question

Ql. Develop an ER diagram for a company XYZ, from the following requirements using the ER model concepts discussed in class. . XYZ has departments, which have a unique name, a unique identifier, one director but the department can be in several locations. XYZ tracks the date a director assumed responsibility for directing the department. . Each department manages a set of projects, which have a unique name, a unique identifier and are in a single location. . XYZ tracks each employee?s name, social security number, address, salary, gender, and birthdate. . Each employee has one direct department supervisor. . Employees are members of one department, but may be members of multiple projects and those projects can be managed by multiple other departments. . XYZ tracks the hours each employee works on each project. . Employees have zero, one or more dependents and XYZ tracks dependent first name, gender, birthdate, and relationship to employee.

Explanation / Answer

ER diagram for XYZ company:

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---