CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 6
UNIQUE PRIMARY KEY FOREIGN KEY NOT NULL
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
UNIQUE PRIMARY KEY FOREIGN KEY NOT NULL
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 )