NULL) Primary Key Class_Num Consider the Information Engineering Diagram Shown

Multiple Choice

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) 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) Res_Name, Building_ID) Primary Key R_ID Foreign Key Building_ID references BUILDING(Building_ID)