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

CREATE VIEW Emp_Dept AS SELECT

Last_Name, First_Name, Dept_ID FROM

Employee;

UPDATE VIEW Emp_Dept

AS SELECT * FROM

Employee;

UPDATE VIEW Emp_Dept AS SELECT

Last_Name, First_Name, Dept_ID FROM

Employee;

CREATE VIEW Emp_Dept

AS SELECT * FROM

Employee WHERE ID = 0001

AND ID = 0002 AND ID =

0003 AND ID = 0004;

Third normal form

Second normal form

No normal form

First normal form