What is the highest normal form of the relation(s) shown in the exhibit?
A.
Second normal form
B.
First normal form
C.
Boyce-Codd normal form
D.
Third normal form
E.
STUDENT( Student_Number: integer NOT NULL Name:
variable length character string length 20 NOT NULL)
Primary Key Student_Number CLASS( Class_Num: integer
NOT NULL Class_Name: integer NOT NULL) Primary Key
Class_Num
F.
STUDENT( Student_Number: integer NOT NULL Name:
variable length character string length 20 NOT NULL)
Primary Key Student_Number CLASS( Class_Num: integer
NOT NULL Class_Name: integer NOT NULL) Primary Key
Class_Num Foreign Key Class_Num References STUDENT
G.
STUDENT( Student_Number: integer NOT NULL Name:
variable length character string length 20 NOT NULL)
Primary Key StudenMMumber STU_CLASS(
Student_Number: integer NOT NULL Class_Num: integer
NOT NULL) Primary Key Student_Number CLASS(
Class_Num: integer NOT NULL Class_Name: integer NOT
NULL) Primary Key Class_Num
I think this question is some how mixed with another question.
The correct answer is 2NF because the key is Registration_ID (for sure! nn Registration relation) and we have a transitive relation unsolved First Name and Last Name depend on Student ID which has to migrate on a separate relation.
We have repetitive group (Last Name and First Name of the student) so it qualify for 1NF but the key is one column so this case 1NF -> 2 NF