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

Explanation:
Fourth normal form (4NF) is a normal form used in database normalization. Introduced by Ronald
Fagin in 1977, 4NF is the next level of
normalization after Boyce-Codd normal form (BCNF). Whereas the second, third, and Boyce-Codd
normal forms are concerned with functional
dependencies, 4NF is concerned with a more general type of dependency known as a multivalued
dependency. Symbolically, it can be
represented as follows:
If A -> > B|C, then A -> B and A -> C
Here, A, B, and C are attributes.
Answer D is incorrect. First normal form exists when all the columns in a table are atomic i.e., only a
single value is allowed in each
column. Also, there should not be a group value like more than one phone number in a phone
number column. If a table violates the first
normal rule, following steps should be taken to normalize the database:
To make column atomic, divide them into multiple columns.
If there is group value, create separate tables for the column and relate new table with a foreign key.
Answer C is incorrect. Second normal form (2NF) is used in database normalization. A table that is in
first normal form must meet
additional criteria if it is to qualify for second normal form. Specifically, a 1NF table is in 2NF if and
only if, given any candidate key and any
attribute that is not a constituent of a candidate key, the non-key attribute depends upon the whole
of the candidate key rather than just a
part of it.
Answer B is incorrect. Third normal form (3NF) is used in database normalization. A table is in 3NF if
and only if the relation S (table) is
in second normal form (2NF) and every non-prime attribute of S is non-transitively dependent on
every key of S.