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

CSE :: Database System 2 - CS

  1. Table is synonymous with the term:

  2. A.

     record.

    B.

     relation.

    C.

     column.

    D.

     field.

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Which of the following is not a restriction for a table to be a relation?

  4. A.

     The cells of the table must contain a single value.

    B.

     All of the entries in any column must be of the same kind.

    C.

     The columns must be ordered.

    D.

     No two rows in a table may be identical.

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. For some relations, changing the data can have undesirable consequences called:

  6. A.

     referential integrity constraints.

    B.

     modification anomalies.

    C.

     normal forms.

    D.

     transitive dependencies.

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. A key:

  8. A.

     must always be composed of two or more columns.

    B.

     can only be one column.

    C.

     identifies a row.

    D.

     identifies a column.

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. An attribute is a(n):

  10. A.

     column of a table.

    B.

     two dimensional table.

    C.

     row of a table.

    D.

     key of a table.

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. A relation in this form is free of all modification anomalies.

  12. A.

     First normal form

    B.

     Second normal form

    C.

     Third normal form

    D.

     Domain/key normal form

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. If attributes A and B determine attribute C, then it is also true that:

  14. A.

     A → C.

    B.

     B → C.

    C.

     (A,B) is a composite determinant.

    D.

     C is a determinant.

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. A tuple is a(n):

  16. A.

     column of a table.

    B.

     two dimensional table.

    C.

     row of a table.

    D.

     key of a table.

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. If attribute A determines both attributes B and C, then it is also true that:

  18. A.

     A → B.

    B.

     B → A.

    C.

     C → A.

    D.

     (B,C) → A.

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. One solution to the multivalued dependency constraint problem is to:

  20. A.

     split the relation into two relations, each with a single theme.

    B.

     change the theme.

    C.

     create a new theme.

    D.

     add a composite key.

    View Answer

    Workspace

    Discuss Discuss in Forum