1. Home
  2. Discussions
  3. CIW
  4. CIW Web Development Series
  5. 1D0-541 Discussions
  6. 1D0-541 Exam Topic 1 Question 3 Discussion

CIW v5 Database Design Specialist 1D0-541 Question # 3 Topic 1 Discussion

 CIW Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

CIW v5 Database Design Specialist 1D0-541 Question # 3 Topic 1 Discussion

1D0-541 Exam Topic 1 Question 3 Discussion:
Question #: 3
Topic #: 1

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?

1D0-541 Question 3
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);

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

Get Premium 1D0-541 Questions
Actual exam question for CIW 1D0-541 exam by Sage43456 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next