Database - Database Design Using Normalization

Exercise :: Database Design Using Normalization - True or False

6. 

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.

A. True
B. False

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

7. 

In all cases, normalization into BCNF is desirable.

A. True
B. False

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

8. 

Denormalized tables are in BCNF.

A. True
B. False

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

9. 

We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

A. True
B. False

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

10. 

Proper normalization eliminates duplicated data.

A. True
B. False

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.