ER Model and Business Rules problems
- 1. A subtype entity name should be which of the following?
Options- A. A singular noun
- B. Specific to the organization
- C. Concise
- D. All of the above Discuss
Correct Answer: All of the above
- 2. A supertype/subtype hierarchy has which of the following features?
Options- A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
- B. Attributes are assigned at the highest logical level.
- C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
- D. Attributes are assigned at the lowest logical level. Discuss
Correct Answer: Attributes are assigned at the highest logical level.
- 3. Which of the following is not one of the three ways to classify an action assertion?
Options- A. Condition
- B. Integrity Control
- C. Authorization
- D. Enabler Discuss
Correct Answer: Enabler
- 4. 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?
Options- A. Disjoint with total specialization
- B. Disjoint with partial specialization
- C. Overlap with total specialization
- D. Overlap with partial specialization Discuss
Correct Answer: Overlap with total specialization
- 5. An action assertion must include which of the following?
Options- A. Anchor object
- B. Action
- C. Corresponding object
- D. All of the above. Discuss
Correct Answer: All of the above.
- 6. An oval represents which of the following in an EER?
Options- A. Attribute
- B. Entity
- C. Optional One
- D. Relationship Discuss
Correct Answer: Attribute
- 7. Which one of the following symbols is not used in an ERD?
Options- A. Rectangle
- B. Oval
- C. Diamond
- D. Circle Discuss
Correct Answer: Circle
- 8. A supertype/subtype hierarchy is which of the following?
Options- A. Each subtype has only one attribute.
- B. Each supertype has only one attribute.
- C. Each subtype has only one supertype.
- D. Each supertype has only one subtype. Discuss
Correct Answer: Each subtype has only one supertype.
- 9. A subtype discriminator is which of the following?
Options- A. An attribute of the supertype whose values determine the subtype
- B. An attribute of the subtype whose values determine the supertype
- C. An attribute of the supertype whose values determine the supertype
- D. An attribute of the subtype whose values determine the subtype Discuss
Correct Answer: An attribute of the supertype whose values determine the subtype
- 10. Use of a supertype/subtype relationship is necessary when which of the following exists?
Options- A. An instance of a subtype participates in a relationship that is unique to that subtype.
- B. An instance of a subtype participates in a relationship that is the same as the other subtypes.
- C. Attributes apply to all of the instances of an entity type.
- D. No attributes apply to any of the instances of an entity type. Discuss
Correct Answer: An instance of a subtype participates in a relationship that is unique to that subtype.
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.