Database - Database Design Using Normalization

Exercise :: Database Design Using Normalization - True or False

1. 

When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.

A. True
B. False

Answer: Option B

Explanation:

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

2. 

Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.

A. True
B. False

Answer: Option A

Explanation:

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

3. 

When building a database from an existing set of tables, we still need to consider normalization principles.

A. True
B. False

Answer: Option A

Explanation:

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

4. 

We have normalized a table into BCNF if all candidate keys are determinants.

A. True
B. False

Answer: Option B

Explanation:

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

5. 

We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.

A. True
B. False

Answer: Option B

Explanation:

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