________ integrity can prevent the deletion of a record if the record has a prim
ID: 3688067 • Letter: #
Question
________ integrity can prevent the deletion of a record if the record has a primary key that matches foreign keys in another table.
a. Referential
b. Candidate
c. Nonkey
d. Secondary
A ________ relationship exists when one occurrence of the first entity can relate to many instances of the second entity, but each instance of the second entity can associate with only one instance of the first entity.
a. one-to-two
b. one-to-one
c. one-to-many
d. many-to-many
A ________ relationship exists when one instance of the first entity can relate to many instances of the second entity, and one instance of the second entity can relate to many instances of the first entity.
a. one-to-two
b. one-to-one
c. one-to-many
d. many-to-many
A(n) ________ is a set of one or more fields that can occur any number of times in a single record, with each occurrence having different values.
a. subschema
b. associative entity
c. repeating group
d. relational model
A table design that contains a repeating group is called ________ .
a. mnemonic
b. normalized
c. unnormalized
d. multivalued
To convert an unnormalized design to ________ , you must expand the table's primary key to include the primary key of the repeating group.
a. 3NF
b. 0NF
c. 1NF
d. 2NF
from systems analysis and design 10th
a. subschema
b. associative entity
c. repeating group
d. relational model
Explanation / Answer
referential intigrity
one - many
many - many
subschema
multivalued
1NF
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.