Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has residents. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters. Which SQL statement best implements the relations shown in this diagram?

Question

Accepted Answer

C. CREATE TABLE BUILDING (

Answer

A. CREATE TABLE BUILDING (

Answer

B. CREATE TABLE BUILDING (

Answer

D. CREATE TABLE BUILDING (

Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has…

Question

Exhibit

Options

How the community answered

Community Discussion