Home / CSE / Database System 2 - CS :: Data Models into Database Designs

CSE :: Database System 2 - CS

  1. A foreign key is used to implement relationships between tables.

  2. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. The terms alternate key and candidate key mean the same thing.

  4. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. In 1:N relationships, which entity becomes the parent entity is arbitrary.

  6. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

  8. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. In a 1:1 relationship, the primary key placement is arbitrary.

  10. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. When the parent entity is required, a new child row can always be inserted.

  12. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. All primary keys are required.

  14. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. Intersection tables are ID-dependent on both their parent tables.

  16. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. For every relationship, there are six possible sets of minimum cardinalities.

  18. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. An intersection table is required to represent M:N relationships.

  20. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum