64) Saying that two entities are functionally dependent means that ________.
A) the entities are always connected by a mathematical equation
B) for one of the entities, if we are given the value of that entity, we can determine the value of
one other entity
C) for both entities, if we are given the value of one entity, we can determine the value of the
other entity
D) the functional dependency will have to be removed through normalization
65) Given the functional dependency A → (B, C), A is a(n) ________.
A) independent variable
B) dependent variable
C) determinant
D) composite determinant
66) Given the functional dependency (A, B) → C, (A, B) is a ________.
A) dependent variable
B) determinant
C) composite determinant
D) Both B and C are correct
67) Given the functional dependency (A, B) → C, then ________.
A) A and B together → C
B) A → C
C) B → A
D) Both A and B are correct
68) Which of the following is NOT true about the functional dependency A → (X, Y)?
A) X is functionally dependent on A.
B) A determines Y.
C) X and Y together determine A.
D) X and Y are functionally dependent on A.
69) Which of the following is true about the functional dependency (A, B) → (C, D)?
A) A is the determinant of C.
B) A and B together are determined by C and D together.
C) A and B together determine D.
D) C and D together determine A.
70) The only reason(s) for having relations is to ________.
A) store instances of functional dependencies
B) store equation components
C) store equation results
D) Both B and C are correct
71) A combination of one or more columns used to identify rows in a relation is a ________.
A) record
B) field
C) key
D) tuple
72) A combination of two or more columns used to identify rows in a relation is a ________.
A) record
B) composite key
C) foreign key
D) surrogate key
73) A determinant that determines all the other columns in a relation is a ________.
A) record
B) surrogate key
C) foreign key
D) candidate key
74) When designing a database, one of the candidate keys in a relation is selected as the
________.
A) composite key
B) primary key
C) foreign key
D) surrogate key
75) An artificial column added to a relation to serve as the primary key is a ________.
A) composite key
B) candidate key
C) foreign key
D) surrogate key
76) A key consisting of one or more columns that is a primary key in another relation is a
________.
A) composite key
B) candidate key
C) foreign key
D) surrogate key
77) Referential integrity constraints are used to limit the possible values of a ________.
A) composite key
B) candidate key
C) foreign key
D) surrogate key
78) A ________ is used to limit the possible values of a foreign key.
A) composite key
B) surrogate key
C) functional dependency
D) referential integrity constraint
79) Having to enter facts about two entities when we want to enter facts about only one is an
example of ________.
A) insertion anomaly
B) update anomaly
C) deletion anomaly
D) normalization anomaly
80) If the removal of facts about one entity results in the unintentional loss of data about another
entity, this is referred to as a(n) ________.
A) normalization anomaly
B) insertion anomaly
C) update anomaly
D) deletion anomaly
81) Suppose that you need to update one value of the column SalesCost in a relation. The way
the relation is constructed, this value needs to be changed in three different rows. However, you
only change the value in two of the rows. You have just created a(n) ________.
A) normalization anomaly
B) insertion anomaly
C) update anomaly
D) deletion anomaly
82) A table that meets the definition of a relation is in ________.
A) First Normal Form
B) Second Normal Form
C) Third Normal Form
D) Boyce-Codd Normal Form
83) A relation is in second normal form (2NF) if and only if it is in 1NF and ________.
A) all non-key attributes are determined by the entire primary key
B) there are no non-key attributes determined by another non-key attribute
C) every attribute is a candidate key
D) every candidate key is a determinant
84) A relation is in third normal form (3NF) if and only if it is in 2NF and ________.
A) all non-key attributes are determined by the entire primary key
B) there are no non-key attributes determined by another non-key attribute
C) every attribute is a candidate key
D) every candidate key is a determinant
85) A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and ________.
A) all non-key attributes are determined by the entire primary key
B) there are no non-key attributes determined by another non-key attribute
C) every attribute is a candidate key
D) every determinant is a candidate key
86) If a table is designed so that every determinant is a candidate key, then that relation is in
________.
A) First Normal Form
B) Second Normal Form
C) Third Normal Form
D) Boyce-Codd Normal Form
87) If a relation is in BCNF, and each multivalued dependency has been moved to a relation of
its own, then the first relation is in ________.
A) Third Normal Form
B) Boyce-Codd Normal Form
C) Fourth Normal Form
D) Domain/key normal form
88) A relation is in fourth normal form if it is in BCNF and it has no ________.
A) transitive dependencies
B) multivalued dependencies
C) partial dependencies
D) deletion dependencies
89) A relation is in domain/key normal form if ________.
A) every key of the relation is a logical consequence of the definition of constraints and
determinants
B) every key of the relation is a logical consequence of the definition of constraints and domains
C) every constraint on the relation is a logical consequence of the definition of keys and
determinants
D) every constraint on the relation is a logical consequence of the definition of keys and domains
90) In general, each relation should have ________.
A) one and only one theme
B) one or more themes
C) exactly two themes
D) one or two themes
91) What is a functional dependency? Give an example not used in the text.
92) Describe the requirements that a table must meet to qualify as a relation.
20
Copyright © 2019 Pearson Education, Inc.
93) Explain the terms relation, tuple, and attribute.
94) Distinguish between the primary key and a candidate key.
95) Briefly describe the various tasks of the primary key.
96) Explain the relationships among primary keys and functional dependencies.
97) Explain the concept of a foreign key.
98) Explain the concept of a surrogate key.
99) Explain the essence of normalization that is implemented using normal forms.
100) Explain the steps in the process of putting a relation straight into Boyce-Codd Normal Form
(BCNF).