Solved

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

Question 60

Multiple Choice

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? 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 NULL)  Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL)  Primary Key Class_Num B)  Foreign Key Class_Num References STUDENT C)  STU_CLASS( Class_Num: integer NOT NULL)  D)  Primary Key Student_Number, Class_Num


A) 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
B) Foreign Key Class_Num References STUDENT
C) STU_CLASS( Class_Num: integer NOT NULL)
D) Primary Key Student_Number, Class_Num

Correct Answer:

verifed

Verified

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

Related Questions