Page 1 of 1

NULL) Primary Key Class_Num - Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition b

Posted: Sat Jul 23, 2022 7:29 pm
by answerhappygod
NULL) Primary Key Class_Num -
Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?
Null Primary Ke 1
Null Primary Ke 1 (51.54 KiB) Viewed 81 times
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)