Database - Database Design Using Normalization
Database - Database Design Using Normalization
1. Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
- advantage
- disadvantage
- either an advantage or disadvantage
- neither an advantage nor disadvantage
2. Eliminating modification anomalies is a(n) ________ of normalization.
- advantage
- disadvantage
- either an advantage or disadvantage
- neither an advantage nor disadvantage
4. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
- The multivalue, multicolumn problem
- The inconsistent values problem
- The missing values problem
- The general-purpose remarks column problem
5. When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
- first step.
- second step.
- third step.
- fourth step.
6. Creating a read-only database is a task that is ________ assigned to beginning database professionals.
- always
- commonly
- seldom
- never
7. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
- Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- Three rows have the values Brown, NULL, and Blue in the same column.
- One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
8. For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
- read-only
- updateable
- either a read-only or an updateable
- None of the above is correct.
9. Most of the time, modification anomalies are serious enough that tables should be normalized into:
- 1NF.
- 2NF.
- 3NF.
- BCNF.
10. Each answer below shows example data from a table. Which answer is an example of the missing values problem?
- Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- Three rows have the values Brown, NULL, and Blue in the same column.
- One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.