You are a database developer. You plan to create a database by using SQL Server 2008.
The database will store information about students, teachers, classes, and rooms in a
school. The database will be used by a scheduling application. In the design plan, the
following facts have to be considered: ·Each teacher can teach one or more classes. ·Each
student can register for one or more classes. ·Each class can be in one or more rooms.
·Each room can host one or more classes. You identify the following entities for the
database design: ·Students ·Teachers ·Classes ·Rooms ·ClassesStudents
·ClassesTeachers You need to design the database to ensure normalization. What should
you do?
A.
1. Add a new entity named TeachersStudents. 2. Establish a relationship between the
Teachers and Students entities by using the TeachersStudents entity.
B.
1. Add a new entity named ClassesRooms. 2. Establish a relationship between the
Classes and Rooms entities by using the ClassesRooms entity.
C.
1. Add a new entity named TeachersRooms. 2. Establish a relationship between the
Teachers and Rooms entities by using the TeachersRooms entity
D.
1. Create a new entity named StudentsRooms. 2. Establish a relationship between the
Students and Rooms entities by using the StudentsRooms entity.