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 referential integrity constraints have been enforced on the data we are given.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 


  • Database Design Using Normalization problems


    Search Results


    • 1. Normalization requires programmers to write more complex SQL.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. Denormalized tables are in BCNF.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. In all cases, normalization into BCNF is desirable.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. SQL is a programming language.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.

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

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. 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
    • 10. 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


    Comments

    There are no comments.

Enter a new Comment