CS561WS Karlapudi RahulSai HW9.docx - Homework – 9 Name:...

Homework – 9
Name: Rahul Sai karlapudi
CWID: 20007304
Course: CS-561 WS
1.
Employee table ER diagram
The above diagram shows the Employee table ER diagram. As super ssn has key in its own table it
can be drawn as following

Drawing Department table ER diagram.
Combining Both Employee and Department table.

Drawing ER diagram for DLocations.
As a result, DLocation can only exist if there is a Department. Because of the dependency. It is seen
as a weak entity by us. We obtain the result by combining all three
tables.

Project table ER diagram.
All together ER diagram of Employee, Project, Department, Delocation can be Drawn as follows.

ER diagram of Works On table
 The