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?

Question

Accepted Answer

D. CREATE TABLE BUILDING (

Answer

A. CREATE TABLE BUILDING (

Answer

B. CREATE TABLE BUILDING (

Answer

C. CREATE DOMAIN ID AS INTEGER;

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…

Question

Exhibit

Options

How the community answered

Community Discussion