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

CSE :: Database System 2 - CS

  1. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

  2. A.

     A → B.

    B.

     A → C.

    C.

     A → (B,C).

    D.

     (B,C) → A.


  3. The different classes of relations created by the technique for preventing modification anomalies are called:

  4. A.

     normal forms.

    B.

     referential integrity constraints.

    C.

     functional dependencies.

    D.

     None of the above is correct.


  5. A relation is in this form if it is in BCNF and has no multivalued dependencies:

  6. A.

     second normal form.

    B.

     third normal form.

    C.

     fourth normal form.

    D.

     domain/key normal form.


  7. Row is synonymous with the term:

  8. A.

     record.

    B.

     relation.

    C.

     column.

    D.

     field.


  9. The primary key is selected from the:

  10. A.

     composite keys.

    B.

     determinants.

    C.

     candidate keys.

    D.

     foreign keys.


  11. Which of the following is a group of one or more attributes that uniquely identifies a row?

  12. A.

     Key

    B.

     Determinant

    C.

     Tuple

    D.

     Relation


  13. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

  14. A.

     transitive dependency.

    B.

     insertion anomaly.

    C.

     referential integrity constraint.

    D.

     normal form.


  15. A relation is considered a:

  16. A.

     Column.

    B.

     one-dimensional table.

    C.

     two-dimensional table.

    D.

     three-dimensional table.


  17. In the relational model, relationships between relations or tables are created by using:

  18. A.

     composite keys.

    B.

     determinants.

    C.

     candidate keys.

    D.

     foreign keys.


  19. A functional dependency is a relationship between or among:

  20. A.

     tables.

    B.

     rows.

    C.

     relations.

    D.

     attributes.