logo

CuriousTab

CuriousTab

Discussion


Home Database The Relational Model and Normalization Comments

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

  • Correct Answer
  • A ? B. 


  • The Relational Model and Normalization problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. 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
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. If attributes A and B determine attribute C, then it is also true that:

    • Options
    • A. A ? C.
    • B. B ? C.
    • C. (A,B) is a composite determinant.
    • D. C is a determinant.
    • Discuss
    • 10. The primary key is selected from the:

    • Options
    • A. composite keys.
    • B. determinants.
    • C. candidate keys.
    • D. foreign keys.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment