logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Design Using Normalization Comments
  • Question

  • When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • Database Design Using Normalization problems

    Search Results

    • 1. We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. We use the SQL construct COUNT(*) to count the number of rows in a table.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. We have normalized a table into BCNF if all candidate keys are determinants.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. When building a database from an existing set of tables, we still need to consider normalization principles.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Proper normalization eliminates duplicated data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.

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