a) Draw the Entity Relationship (E-R) diagram from the following relations: Employee (EmployID, FirstName, LastName, SSF, Gender,
Fantastic news! We've Found the answer you've been seeking!
Question:
a) Draw the Entity Relationship (E-R) diagram from the following relations:
Employee (EmployID, FirstName, LastName, SSF, Gender, Department)
Contact (PhoneNo, EmployID, EmailAddress, SkypeID, DigitalAddress, PostalAddress)
Department (DeptID, EmployID, DeptName, DeptHead) explaining the symbols used.
b) State all possible primary keys and foreign key from the relations above.
c) Deduce if any, derived attributes from the diagram.
Posted Date: