Microsoft
70-451 · Question #78
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…
The correct answer is B. 1. Add a new entity named ClassesRooms. See the full explanation below for the reasoning.
Question
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?
Options
- A
- Add a new entity named TeachersStudents.
- B
- Add a new entity named ClassesRooms.
- C
- Add a new entity named TeachersRooms.
- D
- Create a new entity named StudentsRooms.
How the community answered
(56 responses)- A7% (4)
- B77% (43)
- C2% (1)
- D14% (8)
Community Discussion
No community discussion yet for this question.