Question: Question 2-2 points 1. Break apart the above table, to reduce redundancy, and create 4 entities 2. Use the following business rules and draw an

 Question 2-2 points 1. Break apart the above table, to reduce

Question 2-2 points 1. Break apart the above table, to reduce redundancy, and create 4 entities 2. Use the following business rules and draw an ER Diagram in ERDPlus.com diagram tool a. A Building has one or more Rooms. A Room is in only one Building b. A Teacher can be assigned to one or more Rooms. c. A Room can be assigned to one or more Teachers d. No teacher can be assigned to more than one room at the same Days Time 3. Create the ER Diagram showing the Entities and Relationships only (no need - PKs, FKs) 4. Paste the PNG image of the ER Diagram, exported from ERDPlus, in the document below

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!