Explanation: The result is not uniquely defined, since a set of functional dependencies can have more than one canonical cover, and, further, in some cases, the result of the algorithm depends on the order in which it considers the dependencies in Fc . 6. The functional dependency can be tested easily on the materialized view, using the constraints ____________.
A. Primary key
B. Null
C. Unique
D. Both b and c
Answer:A
Explanation: The result is not uniquely defined, since a set of functional dependencies can have more than one canonical cover, and, further, in some cases, the result of the algorithm depends on the order in which it considers the dependencies in Fc . 6. The functional dependency can be tested easily on the materialized view, using the constraints ____________.
A. Primary key B. Null C. Unique D. Both b and c
Explanation: Primary key contains both unique and not null constraints . 7. Which normal form is considered adequate for normal relational database design?