logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ The Relational Model and Normalization Comments
  • Question

  • The only reason for the existence of relations is to store instances of functional dependencies.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • The Relational Model and Normalization problems

    Search Results

    • 1. A relation is a two-dimensional table.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A primary key is a composite key that was selected to be the main identifier for the relation.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. A functional dependency is a relationship between or among attributes.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Keys made up of two or more attributes are called composite keys.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. A relation is in 5NF when multivalued dependencies are isolated in their own relation.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Given the functional dependency R ? (S,T) , then it is also true that R ? S.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Any table that meets the definition of a relation is said to be in first normal form.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. In a relation, the order of the rows matters.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Given the functional dependency R ? S , R is called the determinant.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.