Wednesday, 11 September 2013

5.Tom is working in an organization as a database administrator. Based on the hierarchy, the organization has multiple departments and each department has multiple employees. The following ER diagram represents the relationship between the departments and the employees.

The following listdescribes the entition,attributes,and relationship of the preceding ER diagram:


*  Entities - Department and Employee
*  Attributes of Department - DepID,DepName,and DepHead
*  Attributes of Employee -EmpID,EmpName,and DepID
*  Type of Relationship- Many-to-one

No comments:

Post a Comment