Question: Map the given E-R diagram (Fig. 1) to a relational schema, where relations (i.e., tables) are used to model the database system. As we learned

 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 (i.e., tables) are used to model the database system. As we learned in the class, when we do such logical design, different types of relationships should be mapped to logical tables differently. In your logical design, please indicate clearly the primary keys (e.g., underlined) and foreign keys (e.g., using italic fonts). Links from foreign keys to primary keys also need to be shown. Please refer to your textbook (Chapter 4) or lecture slides (e.g., slides 11, 30, 36, etc.) for examples. You can use any tool to draw your schema. Please submit your schema/drawing in PDF format. Is Supervised by Start_Date EMPLOYEE + Vanages OH DEPARTMENT Supervision Dupament Number Deprene -ot work for Supervises Location Employee Name Fare , Mare, Lame Employee Sex Employee Address Employee Salary HI- Controls Hours Dependents Works.com DEPENDENT Dependent PROJECT Project Number Dependent Sex Pro Dependent on Location

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!