Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

Consider the following relation definition:

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

HOUSING(

Housing_ID: integer NOT NULL

Student_Number: integer NOT NULL

Building: variable length character string length 25 NOT NULL)

Primary Key Housing_ID

Foreign Key Student_Number References

STUDENT(Student_Number)

ON DELETE NO CHECK

ON UPDATE

Which integrity constraint is violated in this relation definition?

A.

Entity integrity

B.

Domain constraint

C.

Referential integrity

D.

Enterprise constraint

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

Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

A.

INSERT INTO Atlanta_Customers

VALUES( SELECT * FROM

Customer s WHERE Sales_Office =

Atlanta

B.

INSERT INTO Atlanta_Customers

SELECT * FROM Customers

WHERE Sales_Office = Atlanta

C.

INSERT INTO Atlanta_Customers SELECTCust_No,

Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers

WHERE Sales_Office = Atlanta

D.

INSERT INTO Atlanta_Customers SELECT Cust_No,

Cust_Name, Sales_Office, Sales_Rep_No FROM Customers

WHERE Sales_Office = Atlanta

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create an intersection of the two relations with the widest variety of Structured Query Language dialects?

A.

SELECT *

FROM Dept1_Parts

AND

(SELECT *

FROM Dept2_Parts);

B.

SELECT *

FROM Dept1_Parts

INTERSECTION

(SELECT *

FROM Dept2_Parts);

C.

SELECT *

FROM Dept1_Parts

WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

D.

SELECT *

FROM Dept1_Parts

WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

FROM Registration WHERE

Consider the following relational algebraic expression: Which of the following SQL Course_Code = 'A4343';

statements is equivalent to this relational algebraic expression?

A.

SELECT Sales_Rep_No(108)

FROM Orders;

B.

INSERT INTO Orders

VALUES(Sales_Rep_No = 108)

WHERE Sales_Rep_No = NULL;

C.

SELECT'FROM Orders

WHERE Sales_Rep_No = 108;

D.

SELECT'FROM Orders

WHERE Sales_Rep_No = ?08?

What is the highest normal form of the relation(s) shown in the exhibit?

A.

Boyce-Codd normal form

B.

First normal form

C.

Second normal form

D.

Third normal form

NULL) Primary Key Class_Num

Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

A.

BUILDING(Building_ID, Bldg_Name, Location, Room_Count)

Primary Key Building_ID RESIDENT(R_ID, Room_Num,

Res_Name, Building_ID) Primary Key R_ID

B.

BUILDING(Building_ID, Bldg_Name, Location, Room_Count)

Primary Key BUILDING RESIDENT(R_ID, Room_Num,

Res_Name, Building_ID) Primary Key RESIDENT

C.

BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING ForeignKey BUILDING(Building_ID) references RESIDENT(Building_ID) RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT

D.

BUILDING(Building_ID, Bldg_Name, Location, Room_Count)

Primary Key Building_ID RESIDENT(R_ID, Room_Num,

Res_Name, Building_ID) Primary Key R_ID Foreign Key

Building_ID references BUILDING(Building_ID)

Which of the following is a characteristic of the three-tier database architecture?

A.

A Web browser is used as the application server.

B.

The application logic is centralized on a dedicated server.

C.

A thick client is used to perform business application logic functions locally.

D.

Database application logic and database functionality are integrated and reside on a common server.

Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

A.

Create intermediate entities.

B.

Create a logical data model.

C.

Resolve many-to-manyrelationships.

D.

Identify and resolve complex relationships.

Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?

A.

Union

B.

Intersection

C.

Natural join

D.

Cartesian product