Database Normalisation

What is First Normal Form (1NF)?

• Each field contains only atomic values
• Each non-key field depends only on the primary key
• There are no non-key dependencies
• Each record is sorted alphabetically

Which of the following are requirements of Second Normal Form (2NF)?

• No repeating groups
• Must be in 1NF
• No partial dependencies
• All data types must be integers

Which of the following describes Third Normal Form (3NF)?

• No non-key dependencies
• Data is sorted by primary key
• Must be in 2NF
• All tables must be indexed

What does normalisation help reduce?

• Data redundancy
• Query speed
• Data inconsistency
• File size

What is a partial dependency?

• A field depends on part of a composite primary key
• A field is completely unrelated
• A field depends on the whole primary key
• A field links to another table

Which normal form removes partial dependencies?

• 1NF
• 2NF
• 3NF

What is a non-key dependency?

• A non-key field depends on another non-key field
• A key field depends on a non-key field
• Two fields depend on each other
• All fields are atomic

Which normal form removes non-key dependencies?

• 1NF
• 2NF
• 3NF

Which of the following are benefits of normalisation?

• Reduced data redundancy
• Easier to maintain data integrity
• Increased data duplication
• Faster disk access

What is the goal of 1NF?

• Eliminate repeating groups
• Ensure atomic values
• Remove non-key dependencies
• Create indexes for every table