The Relational Model and Normalization – True or False

6. A candidate key is a determinant that determines all the other columns is a relation.

A. True
B. False

Correct Answer:  A. True
Advertisement

7. The only reason for the existence of relations is to store instances of functional dependencies.

A. True
B. False

Correct Answer:  A. True
Advertisement

8. A relation is in 5NF when multivalued dependencies are isolated in their own relation.

A. True
B. False

Correct Answer:  B. False
Advertisement

9. The functional dependency R → S means that the value of S can be determined when we are given a value of R.

A. True
B. False

Correct Answer:  A. True
Advertisement

10. In a relation, the columns are sometimes called “attributes.”

A. True
B. False

Correct Answer:  A. True
Advertisement

Leave A Comment?