logo

CuriousTab

CuriousTab

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
  • 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
  • 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
  • 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
  • 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
  • 6. An oval represents which of the following in an EER?

  • Options
  • A. Attribute
  • B. Entity
  • C. Optional One
  • D. Relationship
  • Discuss
  • 7. Which one of the following symbols is not used in an ERD?

  • Options
  • A. Rectangle
  • B. Oval
  • C. Diamond
  • D. Circle
  • Discuss
  • 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
  • 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
  • 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

First 2