CIW Exam Questions

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)
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