Quiz on normalization and functional dependency 6

Relational model and Normalization Quiz

1. Functional dependency analysis helps in the normalization of a relational schema. TRUE / FALSE?

TRUE
FALSE

2. Normalization attempts to reduce redundant information that are stored as part of a relation. TRUE/FALSE?

TRUE
FALSE

3. Redundancy is at the root of insertion and deletion anomalies in a relational database. TRUE/FALSE?

TRUE
FALSE

4. A null value has exactly one interpretation, ie., one meaning. TRUE/FALSE?

TRUE
FALSE

5. A functional dependency is a relationship between an attribute "Y" and a determinant (1 or more other attributes) such that for a given value of a determinant the value of the attribute Y is uniquely defined. TRUE/FALSE?

TRUE
FALSE

6. Functional dependencies can be found out algorithmically (automatically) by analysis of the relation. No semantic analysis is required. TRUE/FALSE?

TRUE
FALSE

7. In practical terms, we want non-key attributes to be functionally dependent on the primary key in any relation. TRUE/FALSE?

TRUE
FALSE

8. Transitivity of functional dependencies means that if a →b and a→c then c→b. TRUE/FALSE?

TRUE
FALSE

9. Decomposition of functional dependencies would mean that if a→bc then a→b and a→c. TRUE/FALSE?

TRUE
FALSE

10. Functional dependencies are reflexive, i.e., if a →b then b →a. TRUE/FALSE?

TRUE
FALSE

Score =

Correct answers: