Quiz 5

Question 1

Saying that two entities are functionally dependent means that ________.

a. the entities are always connected by a mathematical equation
b. the functional dependency will have to be removed through normalization
c. for both entities, if we are given the value of one entity, we can determine the value of the other entity
d. for one of the entities, if we are given the value of that entity, we can determine the value of one other entity

Answer 1

D. for one of the entities, if we are given the value of that entity, we can determine the value of one other entity

Question 2

Given the functional dependency (A, B) → C, (A, B) is a ________.
a. dependent variable
b. determinant
c. Both determinant and composite determinant are correct
d. composite determinant

Answer 2

C. Both determinant and composite determinant are correct

Question 3

A determinant that determines all the other columns in a relation is a ________.
a. candidate key
b. surrogate key
c. record
d. foreign key

Answer 3

a. candidate key

Question 4

A ________ is used to limit the possible values of a foreign key.
a. functional dependency
b. referential integrity constraint
c. composite key
d. surrogate key

Answer 4

b. referential integrity constraint

Question 5

[T/F] The columns of a relation are sometimes called tuples.

Answer 5

False