PrepAway - Latest Free Exam Questions & Answers

Which DBDL definition best describes this diagram?

NULL) Primary Key Class_Num
Consider the Information Engineering diagram shown in the exhibit.

Which DBDL definition best describes this diagram?

PrepAway - Latest Free Exam Questions & Answers

A.
BUILDING(Building_ID, Bldg_Name, Location, Room_Count)
Primary Key Building_ID RESIDENT(R_ID, Room_Num,
Res_Name, Building_ID) Primary Key R_ID

B.
BUILDING(Building_ID, Bldg_Name, Location, Room_Count)
Primary Key BUILDING RESIDENT(R_ID, Room_Num,
Res_Name, Building_ID) Primary Key RESIDENT

C.
BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING Foreign
Key BUILDING(Building_ID) references RESIDENT(Building_ID) RESIDENT(R_ID, Room_Num,
Res_Name, Building_ID) Primary Key RESIDENT

D.
BUILDING(Building_ID, Bldg_Name, Location, Room_Count)
Primary Key Building_ID RESIDENT(R_ID, Room_Num,
Res_Name, Building_ID) Primary Key R_ID Foreign Key
Building_ID references BUILDING(Building_ID)


Leave a Reply