You intend to use SQL Server 2008 to create a database which will be use by a scheduling application. The following information is stored in this database:
* Rooms
* Classes
* Students
* Teachers
You have to consider the following facts in the design plan:
* Each room can host one or more classes;
* Each class can be in one or more rooms;
* Each teacher can teach one or more classes;
* Each student can register for one or more classes.
Look at the entities below:
* Rooms;
* Classes;
* Students;
* Teachers;
* ClassesTeachers;
* ClassesStudents
You identify these entities for the database design. In order to ensure normalization, you have to design thedatabase. So what should you do?
A.
First, a new entity named ClassesRooms should be added.Then use this entity to establish a relationship between the Classes and Rooms entities
B.
First, a new entity named TeachersRooms should be added.Then use this entity to establish a relationship between the Teachers and Rooms entities
C.
First, a new entity named StudentsRooms should be created.Then use this entity to establish a relationship between the Students and Rooms entities.
D.
First, a new entity named TeachersStudents should be added.Then use this entity to establish a relationship between the Teachers and Students entities