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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
