Free 1D0-541 Web TestEngine Demo | VCEDump

Exit VCEDump 1D0-541 CIW v5 Database Design Specialist

Q4 Single 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?

Question 4 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
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
C
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
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
D
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
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

Previous Check answer

Question map4 / 20

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Current Correct Answered Incorrectly Reviewed 0 Remaining 20

Marked Questions0

No marked questions.

Answered Incorrectly0

No incorrect answers.