Discuss CIW 1D0-541 Exam Topic 3 Question 124

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 and

Res_Name are all represented by variable-length strings with a maximum of 20 characters. Which

SQL statement best implements the RESIDENT relation shown in this diagram?

ACREATE 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));

BCREATE 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));

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

DCREATE 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));

Suggested Answer: D

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

20 comments · newest first

Lucy 2 months ago

Right? D ensures data integrity with the foreign key.

Roxanne 2 months ago

I feel like A is too loose with NULLs.

Francis 2 months ago

D is definitely correct. It meets all requirements.

Reed 2 months ago

Option C is tempting, but it lacks the foreign key.

Dorethea 2 months ago

I agree, D looks solid. Room_Num should be INTEGER, not FLOAT.

Nan 3 months ago

I think option D is the best. It has all the right data types.

Lucina 3 months ago

Is it really necessary to have NOT NULL for Building_ID? Seems strict.

Azzie 3 months ago

Definitely going with D, it checks all the boxes!

Johnetta 3 months ago

Wait, Room_Num should be an integer, right?

Chanel 3 months ago

I think C is missing the foreign key, so it’s not right.

An 3 months ago

Option D looks solid with the foreign key.

James 4 months ago

Is it really necessary to have NOT NULL for Building_ID? Seems strict.

Chu 4 months ago

Definitely going with D, it checks all the boxes!

Rosalind 4 months ago

Wait, Room_Num should be an integer, right?

Tammara 6 months ago

I think C is missing the foreign key, so it’s not right.

Kirk 6 months ago

Option D looks solid with the foreign key.

Glory 6 months ago

I think option D is the best because it has the NOT NULL constraint for Building_ID and includes the foreign key reference.

Derrick 6 months ago

I’m not sure about the data types; I thought Room_Num should be an integer, but I’m confused about the FLOAT in option A.

Kristal 6 months ago

I feel like I’ve seen a similar question before, and I think the foreign key is important for linking to the BUILDING table.

Fannie 7 months ago

I remember we discussed that the primary key should be NOT NULL, so I think options A and B are not correct.

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