Database Normalisation Quiz

What is the primary goal of Normalisation?

• To increase redundancy

• To organize data

• To create multiple primary keys

• To eliminate all data

Which Normal Form requires that all data is atomic?

• 2NF

• 3NF

• 4NF

• 1NF

What does 2NF aim to fix?

• Transitive dependency

• Redundancy

• Partial dependency

• Atomicity

In which Normal Form must non-key fields not depend on other non-key fields?

• 1NF

• 2NF

• 3NF

• 4NF

What is a requirement for a table to be in 1NF?

• It must have no primary key

• It must have repeating groups

• All data must be atomic

• It must have a composite primary key

Which of the following is NOT a goal of 3NF?

• Remove transitive dependency

• Ensure all non-key fields rely on the primary key

• Ensure all data is atomic

• Eliminate redundancy

What is a characteristic of a table in 2NF?

• It has repeating groups

• All non-key attributes depend on the whole primary key

• It has no primary key

• It is not in 1NF

Which statement is true about a primary key?

• It can be composite

• It must be a non-key attribute

• It can have duplicate values

• It is not necessary for 1NF

If a table is in 3NF, which of the following must be true?

• It has partial dependencies

• It is also in 1NF

• It has repeating groups

• It has no primary key

What does the term 'atomic' refer to in 1NF?

• Data that is redundant

• Data that is unique

• Data that is indivisible

• Data that is complex