In all cases, normalization into BCNF is desirable.

More Questions from Database Design Using Normalization

• Denormalized tables are in BCNF.
• Normalization requires programmers to write more complex SQL.
• 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.
• One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.
• Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.
• We use the SQL construct COUNT(*) to count the number of rows in a table.
• 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.
• One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.
• We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.
• We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

Discussion & Comments