ER Model and Business Rules problems
- 1. Inheritance is which of the following?
Options- A. When a supertype entity inherits values of the subtype attribute
- B. When a subtype entity inherits values of the supertype attribute
- C. When a supertype entity inherits values of another supertype attribute
- D. When a subtype entity inherits values of another subtype attribute Discuss
Correct Answer: When a subtype entity inherits values of the supertype attribute
- 2. When an entity instance must be a member of only one subtype, it is which of the following?
Options- A. Disjoint with total specialization
- B. Disjoint with partial specialization
- C. Overlap with total specialization
- D. Overlap with partial specialization Discuss
Correct Answer: Disjoint with total specialization
- 3. A rectangle represents which of the following in an EER?
Options- A. Attribute
- B. Entity
- C. Optional One
- D. Relationship Discuss
Correct Answer: Entity
- 4. Specialization is which of the following processes?
Options- A. Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
- B. Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
- C. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
- D. Defining one or more supertypes of the subtype and not forming supertype/subtype relationships. Discuss
Correct Answer: Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
- 5. Which of the following statements concerning business rules is true?
Options- A. It should be complex.
- B. It should not be convertible to computer code.
- C. It may include restrictions.
- D. All of the above. Discuss
Correct Answer: It may include restrictions.
- 6. Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.
Options- A. True
- B. False Discuss
Correct Answer: True
- 7. There is cardinality on an EER between the supertype and subtype.
Options- A. True
- B. False Discuss
Correct Answer: False
- 8. A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.
Options- A. True
- B. False Discuss
Correct Answer: False
- 9. Total specialization is represented by double lines between the supertype and subtype on an EER.
Options- A. True
- B. False Discuss
Correct Answer: True
- 10. If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.
Options- A. True
- B. False Discuss
Correct Answer: False
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.