CIS 336 STUDY Extraordinary Life/cis336study.com CIS 336 STUDY Extraordinary Life/cis336study.com | Page 6

( Points : 4 ) 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 )

( Points : 4 ) 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 )