Database - The Relational Model and Normalization

Exercise :: The Relational Model and Normalization - General Questions

6. 

Which of the following is a group of one or more attributes that uniquely identifies a row?

A. Key
B. Determinant
C. Tuple
D. Relation

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

7. 

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

A. transitive dependency.
B. insertion anomaly.
C. referential integrity constraint.
D. normal form.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

8. 

A relation is considered a:

A. Column.
B. one-dimensional table.
C. two-dimensional table.
D. three-dimensional table.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

9. 

In the relational model, relationships between relations or tables are created by using:

A. composite keys.
B. determinants.
C. candidate keys.
D. foreign keys.

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

10. 

A functional dependency is a relationship between or among:

A. tables.
B. rows.
C. relations.
D. attributes.

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.