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

Repetition of data, application program flexibility, and data centralization

Incompatibility of files, tabular data structures, and data dependence

Separation of data, repetition of data, and data independence

Application program inflexibility, data dependence, and separation of data

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;