CIW 1D0-541 Exam - Topic 3 Question 124 Discussion

Question

CIW 1D0-541 Exam - Topic 3 Question 124 Discussion

Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID,Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location andRes_Name are all represented by variable-length strings with a maximum of 20 characters. WhichSQL statement best implements the RESIDENT relation shown in this diagram?

A) CREATE TABLE RESIDENT ( R_ID INTEGER NULL PRIMARY KEY, Room_Num FLOAT, Res_Name VARCHAR, Building_ID INTEGER NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

B) CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num BINARY, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

C) CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL);

Accepted Answer

D) CREATE TABLE RESIDENT ( R_ID INTEGER NOT NULL PRIMARY KEY, Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

CIW 1D0-541 Exam - Topic 3 Question 124 Discussion

CIW 1D0-541 Exam - Topic 3 Question 124 Discussion

Contribute your Thoughts:

Tammara

Kirk

Glory

Derrick

Kristal

Fannie