CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 6

5. (TCO 3) A ____ occurs when a relationship is
improperly or incompletely identified and, therefore, is
represented in a way that is not consistent with the real
world. (Points : 4)
surrogate primary keys
time-variant data
design trap
fan trap
6. (TCO 3) All of the following are true about a prime
attribute except_____________. (Points : 4)
it is a key attribute
it is at least part of a key
it is not a key attribute
it may be part of a composite key
7. (TCO 3) The conflicts between design efficiency,
information requirements, and processing speed are often
resolved through_____________. (Points : 4)
conversion from 1NF to 2NF
conversion from 2NF to 3NF
compromises that include denormalization
conversion from 3NF to 4NF
8. (TCO 4) When a constraint is created at the ______
level with the CREATE TABLE command, the constraint