nerdexam
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)
  • A
    84% (32)
  • B
    11% (4)
  • C
    3% (1)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice