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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!