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)