Which of the following normal forms will you use to represent these relationships in the tables?

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?
A. 4 NF
B. 3 NF
C. 2 NF
D. 1 NF

How To Pass 98-364 Exam?

FULL Printable PDF and Software. VALID exam to help you PASS.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.