Home / CSE / Database System 2 - CS :: The Relational Model and Normalization

CSE :: Database System 2 - CS

  1. In a relation, the order of the rows matters.

  2. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. In a relation, the rows are sometimes called "records".

  4. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. A relation is a two-dimensional table.

  6. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Any table that meets the definition of a relation is said to be in first normal form.

  8. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Given the functional dependency R → (S,T) , then it is also true that R → S.

  10. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. A candidate key is a determinant that determines all the other columns is a relation.

  12. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. The only reason for the existence of relations is to store instances of functional dependencies.

  14. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. A relation is in 5NF when multivalued dependencies are isolated in their own relation.

  16. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. The functional dependency R → S means that the value of S can be determined when we are given a value of R.

  18. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. In a relation, the columns are sometimes called "attributes".

  20. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum