logo

CuriousTab

CuriousTab

Database Design Using Normalization problems


  • 1. Read-only databases are ________ updated.

  • Options
  • A. always
  • B. commonly
  • C. seldom
  • D. never
  • Discuss
  • 2. Each answer below shows example data from a table. Which answer is an example of the inconsistent 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
  • 3. Needing to using more complicated SQL in database applications is a(n) ________ of normalization.

  • Options
  • A. advantage
  • B. disadvantage
  • C. either an advantage or disadvantage
  • D. neither an advantage nor disadvantage
  • Discuss
  • 4. Normalization ________ data duplication.

  • Options
  • A. eliminates
  • B. reduces
  • C. increases
  • D. maximizes
  • Discuss
  • 5. When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:

  • Options
  • A. first step.
  • B. second step.
  • C. third step.
  • D. fourth step.
  • Discuss
  • 6. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column 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
  • 7. Multivalued dependencies should ________ be eliminated.

  • Options
  • A. always
  • B. commonly
  • C. seldom
  • D. never
  • Discuss
  • 8. When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

  • Options
  • A. first step.
  • B. second step.
  • C. third step.
  • D. fourth step.
  • Discuss
  • 9. When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:

  • Options
  • A. first step.
  • B. second step.
  • C. third step.
  • D. fourth step.
  • Discuss
  • 10. Eliminating modification anomalies is a(n) ________ of normalization.

  • Options
  • A. advantage
  • B. disadvantage
  • C. either an advantage or disadvantage
  • D. neither an advantage nor disadvantage
  • Discuss

First 2 3