Home / CSE / Database System 2 - CS :: ER Model and Business Rules

CSE :: Database System 2 - CS

  1. A subtype discriminator is which of the following?

  2. 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

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. 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?

  4. A.

     Disjoint with total specialization

    B.

     Disjoint with partial specialization

    C.

     Overlap with total specialization

    D.

     Overlap with partial specialization

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. A subtype entity name should be which of the following?

  6. A.

     A singular noun

    B.

     Specific to the organization

    C.

     Concise

    D.

     All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Use of a supertype/subtype relationship is necessary when which of the following exists?

  8. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Which of the following is not one of the three ways to classify an action assertion?

  10. A.

     Condition

    B.

     Integrity Control

    C.

     Authorization

    D.

     Enabler

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Packaged data models are meant to be exactly right straight out of the box.

  12. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. An action assertion is a statement that expresses some aspect of the static structure of the organization.

  14. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. A supertype can only have only one subtype.

  16. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. There is cardinality on an EER between the supertype and subtype.

  18. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).

  20. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum