Consider the Information Engineering diagram shown in the exhibit.
Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name and Res_Name are
represented by variable-length strings with a maximum of 20 characters. Location can be up to 50
characters long, and no building has more than 600 rooms. Which SQL statement best
implements the BUILDING relation shown in this diagram?
A.
CREATETABLE BUILDING (
Building_ID NOT NULL PRIMARY KEY,
Bldg_Name, Location, Room_Count);
B.
CREATETABLE BUILDING ( Building_ID NOT NULL PRIMARY
KEY, Bldg_Name, Location, Room_Count, FOREIGN KEY
Building_ID REFERENCES BUILDING (Building_ID));
C.
CREATETABLE BUILDING (Building_ID
INTEGER NOT NULL PRIMARY KEY, Bldg_Name
VARCHAR (20), Location VARCHAR (50),
D.
CREATETABLE BUILDING (Building_ID
INTEGER NOT NULL PRIMARY KEY, Bldg_Name
VARCHAR (20), Location VARCHAR (50),
Room_Count INTEGER CHECK (Room_Count >
Room_Count INTEGER CHECK (
-1 And Room_Count < 601));
Room_Count > -1 Or Room_Count < 601));