Data Normalisation (OCR A-Level Computer Science): Quizzes
📚Quizzes
Practise the questions
12 questions from this quiz
ShowHide
Practise the questions
12 questions from this quiz
What is the main goal of data normalisation in relational databases?
What is the main goal of data normalisation in relational databases?
Reduce redundancy & improve integrity
What does 'atomic' mean in the context of First Normal Form (1NF)?
What does 'atomic' mean in the context of First Normal Form (1NF)?
Indivisible values
Which requirement must be met for a table to satisfy First Normal Form (1NF)?
Which requirement must be met for a table to satisfy First Normal Form (1NF)?
Eliminate repeating groups
What type of dependency does Second Normal Form (2NF) remove?
What type of dependency does Second Normal Form (2NF) remove?
Partial dependencies
When does Second Normal Form (2NF) apply to a table?
When does Second Normal Form (2NF) apply to a table?
When it has composite primary keys
What is a composite primary key?
What is a composite primary key?
A key made of more than one field
What must a table satisfy before achieving Second Normal Form (2NF)?
What must a table satisfy before achieving Second Normal Form (2NF)?
First Normal Form (1NF)
What type of dependency does Third Normal Form (3NF) eliminate?
What type of dependency does Third Normal Form (3NF) eliminate?
Transitive dependencies
Which normal form must be achieved before reaching Third Normal Form (3NF)?
Which normal form must be achieved before reaching Third Normal Form (3NF)?
Second Normal Form (2NF)
What benefit does normalisation provide regarding data storage?
What benefit does normalisation provide regarding data storage?
Reduces redundancy & storage costs
How does normalisation affect database maintenance tasks?
How does normalisation affect database maintenance tasks?
Simplifies updates, inserts & deletes
What is a common mistake when normalising databases?
What is a common mistake when normalising databases?
Skipping steps to jump to 3NF