Chapter 3 HW
Name: DINESH BABU BALMURI

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1) In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ________ rule.

1) _______

A) overlap B) generalization C) specialization D) disjoint

2) The following figure shows an example of:

2) _______

A) the disjoint rule. B) the underdog rule.
C) the completeness rule. D) the overlap rule.

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
3) In a supertype/subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy. 3) _______

4) It is easy to miss the opportunity to visualize future requirements shown in the full data model when using a packaged data model. 4) _______

5) The following figure is an example of the overlap rule.

5) _______

6) Supertype/subtype relationships should be used when the instances of a subtype participate in no relationships which are unique to that subtype. 6) _______

7) Data models of an existing database are harder for data modelers to read. 7) _______

8) Creating a data model from a packaged data model requires much more skill than creating one from scratch. 8) _______

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
9) In packaged data models, all subtype/supertype relationships follow the ________ and ________ rules. 9) _______

A) total specialization; overlap B) partial specialization; overlap
C) total specialization; disjoint D) partial specialization; disjoint

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
10) When the total specialization rule is set for a supertype/subtype relationship, one could roughly compare the supertype to an abstract class in object-oriented programming. 10) ______