Solved

What Is the Highest Normal Form of the Relation(s) Shown

Question 29

Multiple Choice

What is the highest normal form of the relation(s) shown in the exhibit? 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)  Class_Num Foreign Key Class_Num References STUDENT G)  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


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) Class_Num Foreign Key Class_Num References STUDENT
G) 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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions