logo

CuriousTab

CuriousTab

Discussion


Home Database The Relational Model and Normalization Comments

  • Question
  • 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.

  • Correct Answer
  • A ? B. 


  • The Relational Model and Normalization problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. Row is synonymous with the term:

    • Options
    • A. record.
    • B. relation.
    • C. column.
    • D. field.
    • Discuss
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. A key:

    • Options
    • A. must always be composed of two or more columns.
    • B. can only be one column.
    • C. identifies a row.
    • D. identifies a column.
    • Discuss
    • 10. An attribute is a(n):

    • Options
    • A. column of a table.
    • B. two dimensional table.
    • C. row of a table.
    • D. key of a table.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment