Database - The Relational Model and Normalizartion
Database - The Relational Model and Normalizartion
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 ? B.
- A ? C.
- A ? (B,C).
- (B,C) ? A.
2. The different classes of relations created by the technique for preventing modification anomalies are called:
- normal forms.
- referential integrity constraints.
- functional dependencies.
- None of the above is correct.
3. A relation is in this form if it is in BCNF and has no multivalued dependencies:
- second normal form.
- third normal form.
- fourth normal form.
- domain/key normal form.
5. The primary key is selected from the:
- composite keys.
- determinants.
- candidate keys.
- foreign keys.
6. Which of the following is a group of one or more attributes that uniquely identifies a row?
- Key
- Determinant
- Tuple
- 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):
- transitive dependency.
- insertion anomaly.
- referential integrity constraint.
- normal form.
8. A relation is considered a:
- Column.
- one-dimensional table.
- two-dimensional table.
- three-dimensional table.
9. In the relational model, relationships between relations or tables are created by using:
- composite keys.
- determinants.
- candidate keys.
- foreign keys.
10. A functional dependency is a relationship between or among:
- tables.
- rows.
- relations.
- attributes.