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

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

Logical

Physical

Application

Conceptual