CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 8

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
definition is simply included as part of the column
definition.(Points : 4)