The Relational Model and Normalization

1.  Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that: A. A → B. B. A → C. C. A → (B,C). D. (B,C) → A.

2.	The different classes of relations created by the technique for preventing modification anomalies are called:
	A. normal forms. B. referential integrity constraints. C. functional dependencies. D. None of the above is correct.

3.	A relation is in this form if it is in BCNF and has no multivalued dependencies:
	A. second normal form. B. third normal form. C. fourth normal form. D. domain/key normal form.

4.	Row is synonymous with the term:
	A. record B. relation. C. column. D. field.

5.	The primary key is selected from the:
	A. composite keys. B. determinants. C. candidate keys D. foreign keys.

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

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.

8.	A relation is considered a:
	A. Column. B. one-dimensional table. C. two-dimensional table D. three-dimensional table.

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

10.	A functional dependency is a relationship between or among:
	A. tables. B. rows. C. relations. D. attributes