Relational Databases (AQA A-Level Computer Science): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What is a relational database?
What is a relational database?
A method of organising data using tables
Why are link tables needed for many-to-many relationships?
Why are link tables needed for many-to-many relationships?
They break them into two one-to-many links
In a one-to-many relationship, how many records can one record be associated with?
In a one-to-many relationship, how many records can one record be associated with?
Multiple records in another table
What is an entity in database design?
What is an entity in database design?
An object about which you store info
What do attributes become when a database is implemented?
What do attributes become when a database is implemented?
Fields or columns in tables
What is the purpose of a primary key?
What is the purpose of a primary key?
To uniquely identify each record
What is a foreign key?
What is a foreign key?
A primary key from another table
What are the two requirements for First Normal Form?
What are the two requirements for First Normal Form?
No repeating groups and atomic data
What must be true for Second Normal Form?
What must be true for Second Normal Form?
Non-key attributes depend on whole key
What does Third Normal Form eliminate?
What does Third Normal Form eliminate?
Non-key dependencies