Exercise: Database Design Using Normalization

Questions for: Database Design Using Normalization

Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
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.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Normalization ________ data duplication.
A:
eliminates
B:
reduces
C:
increases
D:
maximizes
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
A:
first step.
B:
second step.
C:
third step.
D:
fourth step.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
A:
advantage
B:
disadvantage
C:
either an advantage or disadvantage
D:
neither an advantage nor disadvantage
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Read-only databases are ________ updated.
A:
always
B:
commonly
C:
seldom
D:
never
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz