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, 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
Get step-by-step solutions from verified subject matter experts
