Quiz 8 Flashcards
An entity whose identifier includes the identifier of another entity is a(n) ________.
a. required entity
b. optional entity
c. strong entity
d. weak entity
d. weak entity
Supertype/subtype entities are said to have a(n) ________ relationship.
a. redundant
b. HAS-A
c. recursive
d. IS-A
d. IS-A
To represent an association pattern in an E-R model, ________.
a. create a new ID-dependent entity with a 1:1 relationship to one other entity
b. create a new weak, but not ID-dependent entity with a 1:1 relationship to one other entity
c. create a new strong entity with a 1:1 relationship to one other entity
d. create a new ID-dependent entity with a N:1 relationship to two parent entities
d. create a new ID-dependent entity with a N:1 relationship to one other entity
A line-item pattern must involve what kind of entity?
a. Strong entity
b. Weak entity with one identifying relationship
c. Weak entity with two identifying relationships
d. Supertype entity
b. Weak entity witb one identifying relationship
Suppose you have created a data model for an airline based on a variety of forms, reports, user interviews, data sources, etc. Your client comes forward with a new desired report that includes passenger weights and a relationship between passengers and employees, neither of which is in your E-R diagram. You should ________.
a. create a new, separate E-R diagram with just the new information
b. add the weight attribute but not the relationship
c. add the relationship but not the weight attribute
d. add the relationship and the weight attribute to the existing data model
d. add the relationship and the weight attribute to the existing data model
