logo

CuriousTab

CuriousTab

Discussion


Home Database Database Design Using Normalization Comments

  • Question
  • Most of the time, modification anomalies are serious enough that tables should be normalized into:


  • Options
  • A. 1NF.
  • B. 2NF.
  • C. 3NF.
  • D. BCNF.

  • Correct Answer
  • BCNF. 


  • Database Design Using Normalization problems


    Search Results


    • 1. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

    • Options
    • A. The multivalue, multicolumn problem
    • B. The inconsistent values problem
    • C. The missing values problem
    • D. The general-purpose remarks column problem
    • Discuss
    • 2. For a number of reasons, normalizations is not often an advantage for a(n) ________ database.

    • Options
    • A. read-only
    • B. updateable
    • C. either a read-only or an updateable
    • D. None of the above is correct.
    • Discuss
    • 3. Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?

    • Options
    • A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
    • B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
    • C. Three rows have the values Brown, NULL, and Blue in the same column.
    • D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
    • Discuss
    • 4. Creating a read-only database is a task that is ________ assigned to beginning database professionals.

    • Options
    • A. always
    • B. commonly
    • C. seldom
    • D. never
    • Discuss
    • 5. Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.

    • Options
    • A. advantage
    • B. disadvantage
    • C. either an advantage or disadvantage
    • D. neither an advantage nor disadvantage
    • Discuss
    • 6. If a table has been normalized so that all determinants are candidate keys, then that table is in:

    • Options
    • A. 1NF.
    • B. 2NF.
    • C. 3NF.
    • D. BCNF.
    • Discuss
    • 7. When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:

    • Options
    • A. first step.
    • B. second step.
    • C. third step.
    • D. fourth step.
    • Discuss
    • 8. Each answer below shows example data from a table. Which answer is an example of the missing values problem?

    • Options
    • A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
    • B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
    • C. Three rows have the values Brown, NULL, and Blue in the same column.
    • D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
    • Discuss
    • 9. Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?

    • Options
    • A. MUST COVER
    • B. MUST NOT
    • C. Both of the above.
    • D. None of the above is correct.
    • Discuss
    • 10. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

    • Options
    • A. primary key.
    • B. foreign key.
    • C. composite key.
    • D. surrogate key.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment