MGMT 329 (Fall 2008) Exam #2 Page 1 of 9
MGMT 329 - Fall 2008
Exam 2
Fill in the blank with the BEST answer from the list below (5 points each):
1. In a table with multiple _________________________ only one can be chosen as the primary key.
2. A table is not in ____________________________ if one of its non-key attributes can be computed by
multiplying two other non-key attributes in the same table.
3. A table is not in ____________________________ if it describes more than one many-to-many
relationship.
4. Synonyms for the term “column” include ____________________________ and
____________________________.
5. If attribute A is a determinant of attribute B then attribute B is ____________________________ on
attribute A.
6. If attribute A is functionally dependent on the combination of attributes X and Y then the combination
of attributes X and Y is a(n) ____________________________.
7. An example of a(n) ____________________________ is a requirement that an attribute named Sport in
a table named SaleItem must contain one of the following values: “Baseball”, “Football”, or
“Basketball”.
Key Terms List
1NF
2NF
3NF
4NF
attribute
BCNF
candidate key
cascading delete
cascading update
column
composite determinant
composite key
data type
determinant
domain constraint
field
file
foreign key
functional dependency
primary key
range constraint
record
referential integrity constraint
relation
relationship
row
surrogate key
table
tuple
