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


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

  4. A.

     True

    B.

     False


  5. A relation is a two-dimensional table.

  6. A.

     True

    B.

     False


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

  8. A.

     True

    B.

     False


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

  10. A.

     True

    B.

     False


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

  12. A.

     True

    B.

     False


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

  14. A.

     True

    B.

     False


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

  16. A.

     True

    B.

     False


  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


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

  20. A.

     True

    B.

     False