Microsoft
98-364 · Question #39
You work as a Database Administrator for Dowtech Inc. A table named StudentInformation exists in a database. The table has columns named student_names, student_marks, and student_courses. Some…
The correct answer is A. 4 NF. See the full explanation below for the reasoning.
Question
You work as a Database Administrator for Dowtech Inc. A table named StudentInformation exists in a database. The table has columns named student_names, student_marks, and student_courses. Some students who have opted for various courses have got different marks in them. This implies that the table has two many-to-many relationships. You have to ensure that these two relationships are not represented in a single table and that the student_name column exists in both tables. Which of the following normal forms will you use to represent these relationships in the tables?
Options
- A4 NF
- B3 NF
- C2 NF
- D1 NF
How the community answered
(38 responses)- A84% (32)
- B11% (4)
- C3% (1)
- D3% (1)
Community Discussion
No community discussion yet for this question.