Database - ER Model and Business Rules
Database - ER Model and Business Rules
11. A subtype discriminator is which of the following?
- An attribute of the supertype whose values determine the subtype
- An attribute of the subtype whose values determine the supertype
- An attribute of the supertype whose values determine the supertype
- An attribute of the subtype whose values determine the subtype
12. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
- Disjoint with total specialization
- Disjoint with partial specialization
- Overlap with total specialization
- Overlap with partial specialization
13. A subtype entity name should be which of the following?
- A singular noun
- Specific to the organization
- Concise
- All of the above
14. Use of a supertype/subtype relationship is necessary when which of the following exists?
- An instance of a subtype participates in a relationship that is unique to that subtype
- An instance of a subtype participates in a relationship that is the same as the other subtypes.
- Attributes apply to all of the instances of an entity type.
- No attributes apply to any of the instances of an entity type.
15. Which of the following is not one of the three ways to classify an action assertion?
- Condition
- Integrity Control
- Authorization
- Enabler