NULL) Primary Key Class_Num
Consider the Information Engineering diagram shown in the exhibit.
Which DBDL definition best describes this diagram?
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)