Databases (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 a database?
What is a database?
An organised collection of structured data
How does a relational database organise data?
How does a relational database organise data?
Into multiple tables that can be linked
What is a field in a database?
What is a field in a database?
A single attribute within a table
What is a record in a database table?
What is a record in a database table?
A row representing a single item/entity
What is the purpose of a primary key?
What is the purpose of a primary key?
To uniquely identify each record
What does a foreign key do?
What does a foreign key do?
Links to the primary key of another table
How does a flat file database store data?
How does a flat file database store data?
In a single table or file
What is a benefit of flat file databases?
What is a benefit of flat file databases?
Suitable for small amounts of data
What is a major limitation of flat file databases?
What is a major limitation of flat file databases?
Redundant data is common
What is a key benefit of relational databases?
What is a key benefit of relational databases?
Reduces redundancy by using separate tables
What is a limitation of relational databases?
What is a limitation of relational databases?
More complex to set up
What is normalisation in relational databases?
What is normalisation in relational databases?
Structuring to minimise redundancy