Home / CSE / Database System 2 - CS :: Modeling Data in the Organization

CSE :: Database System 2 - CS

  1. A composite attribute is which of the following?

  2. A.

     An attribute that can be broken into components

    B.

     An attribute that cannot be broken into components

    C.

     Multiple attributes

    D.

     An identifier


  3. A binary relationship cannot be which of the following?

  4. A.

     One-to-One

    B.

     One-to-Many

    C.

     Many-to-Many

    D.

     Zero-to-Zero


  5. A ternary relationship involves how many entities?

  6. A.

     3 or less

    B.

     3

    C.

     More than 3

    D.

     3 or more


  7. When the minimum number of instances of an entity is one, you know which of the following?

  8. A.

     Mandatory one

    B.

     Optional one

    C.

     Mandatory many

    D.

     Cannot tell


  9. A good business rule is which of the following?

  10. A.

     Declarative

    B.

     Imprecise

    C.

     Redundant

    D.

     Compound


  11. An attribute is a person, place, object, event in a user environment.

  12. A.

     True

    B.

     False


  13. Output reports should be included as part of an ERD.

  14. A.

     True

    B.

     False


  15. Cardinality specifies the number of instances of one entity that can be associated with each instance of another entity.

  16. A.

     True

    B.

     False


  17. Relationships cannot have attributes.

  18. A.

     True

    B.

     False


  19. Business rules and policies are universal.

  20. A.

     True

    B.

     False