logo

CuriousTab

CuriousTab

The Relational Model and Normalization problems


  • 1. A relation is considered a:

  • Options
  • A. Column.
  • B. one-dimensional table.
  • C. two-dimensional table.
  • D. three-dimensional table.
  • Discuss
  • 2. Row is synonymous with the term:

  • Options
  • A. record.
  • B. relation.
  • C. column.
  • D. field.
  • Discuss
  • 3. The different classes of relations created by the technique for preventing modification anomalies are called:

  • Options
  • A. normal forms.
  • B. referential integrity constraints.
  • C. functional dependencies.
  • D. None of the above is correct.
  • Discuss
  • 4. A relation in this form is free of all modification anomalies.

  • Options
  • A. First normal form
  • B. Second normal form
  • C. Third normal form
  • D. Domain/key normal form
  • Discuss
  • 5. One solution to the multivalued dependency constraint problem is to:

  • Options
  • 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.
  • Discuss
  • 6. A relation is in this form if it is in BCNF and has no multivalued dependencies:

  • Options
  • A. second normal form.
  • B. third normal form.
  • C. fourth normal form.
  • D. domain/key normal form.
  • Discuss
  • 7. If attribute A determines both attributes B and C, then it is also true that:

  • Options
  • A. A ? B.
  • B. B ? A.
  • C. C ? A.
  • D. (B,C) ? A.
  • Discuss
  • 8. A tuple is a(n):

  • Options
  • A. column of a table.
  • B. two dimensional table.
  • C. row of a table.
  • D. key of a table.
  • Discuss
  • 9. 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:

  • Options
  • A. A ? B.
  • B. A ? C.
  • C. A ? (B,C).
  • D. (B,C) ? A.
  • Discuss
  • 10. Which of the following is a group of one or more attributes that uniquely identifies a row?

  • Options
  • A. Key
  • B. Determinant
  • C. Tuple
  • D. Relation
  • Discuss

First 2 3 4 5