Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

Consider the Information Engineering diagram shown in the exhibit.

CIW 1D0-541 Full Course Access
CIW 1D0-541 View All Questions

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.

CREATE TABLE BUILDING (

Building_ID NOT NULL PRIMARY KEY,

Bldg_Name, Location, Room_Count);

B.

CREATE TABLE BUILDING ( Building_ID NOT NULL PRIMARY

KEY, Bldg_Name, Location, Room_Count, FOREIGN KEY

Building_ID REFERENCES BUILDING (Building_ID));

C.

CREATE TABLE BUILDING (Building_ID

INTEGER NOT NULL PRIMARY KEY,Bldg_Name

VARCHAR (20), Location VARCHAR (50),

D.

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

1D0-541 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now 1D0-541 pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
With regard to databases, what is normalization?
In which situation would the DBMS use a serial schedule to execute the transactions?
Previous