Quiz on Database Normalization

What is the main objective of normalization?

• To increase data redundancy

• To eliminate data anomalies

• To create multiple subjects in one table

• To store data in multiple tables

Which normal form requires that there are no repeating groups?

• First Normal Form (1NF)

• Boyce-Codd Normal Form (BCNF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

In which normal form are all columns dependent on the table's primary key?

• Second Normal Form (2NF)

• First Normal Form (1NF)

• Fourth Normal Form (4NF)

• Third Normal Form (3NF)

What is a characteristic of the Third Normal Form (3NF)?

• All columns must be unique

• Every determinant is a candidate key

• No non-key attributes determined by another non-key attribute

• No independent multivalued dependencies

Which of the following is NOT a characteristic of normalization?

• All nonprime attributes depend on the primary key

• Each row/column intersection contains multiple values

• Each table represents a single subject

• No data item is unnecessarily stored in more than one table

What does BCNF stand for?

• Boyce-Codd Normal Form

• Basic Candidate Normal Form

• Binary Candidate Normal Form

• Base Column Normal Form

Which normal form is considered the highest level necessary for most applications?

• Third Normal Form (3NF)

• Second Normal Form (2NF)

• Fourth Normal Form (4NF)

• First Normal Form (1NF)

What is an unnormalized data?

• Data that is organized in tables

• Raw data in its original state

• Data that has been fully normalized

• Data that contains no anomalies

Which of the following tables is an example of a 2NF table?

• Advisers

• Subjects

• StudentAdvisers

• Students

What is a data anomaly?

• A method of data storage

• A type of normalization

• A desirable outcome of data modification

• An undesirable consequence of a data modification