Question: 1) Database Design Consider the Entity-Relationship Model for a database as given in the figure below. If you make any assumptions about the model, include
1) Database Design Consider the Entity-Relationship Model for a database as given in the figure below. If you make any assumptions about the model, include them in your answer 1.1) Refer to the E-R diagram in the figure below. 1.1a) Suggest changes to the diagram to make it complete, while maintaining the meaning of the diagram, as you interpret it, noting any assumptions that you are making. Redraw any parts of the diagram that you think should be updated. 1.1b) Give an equivalent relational schema. In-Charge Instructor Teaching Popularity Rating salary Book Prerequisite Hour/Room Hour Seating Capacit Room Building
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
