Question: Map the given E-R diagram (Fig. 1) to a relational schema, where relations/tables are used to model the database system. Please indicate the foreign keys

Map the given E-R diagram (Fig. 1) to a relational schema, where relations/tables are used to model the database system. Please indicate the foreign keys (e.g., using italic fonts). Links from foreign keys to primary keys also need to be shown. Please submit your schema/drawing in PDF format. Is supervised by Start_Date EMPLOYEE Manages- OH DEPARTMENT SSN PK Department Number Supervision Employee Name (FName, MName, Name) Department Name works for Supervises Employee DOB Location + Employee Sex Employee Address Employee Salary Controls Hours Dependents_01 Works_on DEPENDENT PROJECT Dependent First Name Dependent DOB Project Number Dependent Sex Project Name Dependent Relationship Location Fig. 1 E-R diagram for the company described in Assignment 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
