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.   
ANS: A - A → B.

No answer description available for this question

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.   
ANS: A - normal forms.

No answer description available for this question

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   
ANS: C - fourth normal form

No answer description available for this question

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

No answer description available for this question

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

No answer description available for this question

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   
ANS: A - Key

No answer description available for this question

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   
ANS: C - referential integrity constraint

No answer description available for this question

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

No answer description available for this question

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   
ANS: D - foreign keys

No answer description available for this question

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

No answer description available for this question