Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram?
A) STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NUL
L) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NUL
L) Primary Key Class_Num
B) Foreign Key Class_Num References STUDENT
C) STU_CLASS( Class_Num: integer NOT NUL
D) Primary Key Student_Number, Class_Num

Question

Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram? 
A) STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NUL
L) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NUL
L) Primary Key Class_Num 
B) Foreign Key Class_Num References STUDENT 
C) STU_CLASS( Class_Num: integer NOT NUL
D) Primary Key Student_Number, Class_Num

Quizplus · Accepted Answer

The Answer of Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram? 
A) STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NUL
L) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NUL
L) Primary Key Class_Num 
B) Foreign Key Class_Num References STUDENT 
C) STU_CLASS( Class_Num: integer NOT NUL
D) Primary Key Student_Number, Class_Num

Consider the Entity-Relation (ER) Diagram Shown in the Exhibit