Relational Databases (AQA GCSE Computer Science): Quizzes
📚Quizzes
Practise the questions
12 questions from this quiz
ShowHide
Practise the questions
12 questions from this quiz
What is a database?
What is a database?
A persistent store of organized data
What does 'persistent' mean in the context of databases?
What does 'persistent' mean in the context of databases?
Data stays until deleted
What is a record in a database?
What is a record in a database?
A complete entry about one item/person
What is a field in a database?
What is a field in a database?
A category of information within a record
What is a primary key?
What is a primary key?
A field that uniquely identifies a record
Why is a primary key important in a database table?
Why is a primary key important in a database table?
It helps distinguish records uniquely
What is data redundancy?
What is data redundancy?
Same info repeated multiple times
What problem does data redundancy cause?
What problem does data redundancy cause?
Larger file size and wasted storage
What is data inconsistency?
What is data inconsistency?
Same info appears differently
What problem does data inconsistency cause?
What problem does data inconsistency cause?
Confusion about real information
What is a relational database?
What is a relational database?
Information split across linked tables
What is an advantage of relational databases?
What is an advantage of relational databases?
Eliminates data redundancy