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.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.

2.
Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.

3.
When building a database from an existing set of tables, we still need to consider normalization principles.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.

4.
We have normalized a table into BCNF if all candidate keys are determinants.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.

5.
We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.