1D0-541 Exam Dumps : CIW v5 Database Design Specialist

Degree of a relation

Cardinality of a relation

Primary key of a relation

Determinant of a relation

It is the primary key for an entity.

It uniquely identifies every instance of an entity.

One or more keys are joined together to form a composite key.

One or more keys may be used to form a primary key.

INSERT INTO Atlanta_Customers

VALUES( SELECT * FROM

Customer s WHERE Sales_Office =

Atlanta

INSERT INTO Atlanta_Customers

SELECT * FROM Customers

WHERE Sales_Office = Atlanta

INSERT INTO Atlanta_Customers SELECTCust_No,

Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers

WHERE Sales_Office = Atlanta

INSERT INTO Atlanta_Customers SELECT Cust_No,

Cust_Name, Sales_Office, Sales_Rep_No FROM Customers

WHERE Sales_Office = Atlanta