AQA A Level Computer Science (7517)

4.10: Fundamentals of Databases: revision quiz and key terms

Free practice for 4.10: Fundamentals of Databases in AQA A Level Computer Science (7517). It has 5 parts: 4.10.1 Conceptual Data Models and Entity Relationship Modelling, 4.10.2 Relational Databases, 4.10.3 Database Design and Normalisation Techniques, 4.10.4 Structured Query Language (SQL) and 4.10.5 Client Server Databases. Try the questions, then check the key terms.

Try 5 free questions

No sign-in needed. Tap an answer to check it.

Question 1 · Multiple choice

What does the SELECT statement do?

Question 2 · True or false?

The lost update problem occurs when two clients edit the same record at the same time, overwriting each other's changes.

Question 3 · Multiple choice

Which SQL statement changes the values stored in existing records?

Question 4 · True or false?

Databases are normalised to deliberately increase data redundancy as much as possible.

Question 5 · Multiple choice

How is a many-to-many relationship between Student and Course normally implemented in a relational database?

In RADevo, this topic has fill-in-the-blank, matching, multiple-choice and true or false activities, and every question you get wrong comes back in Revise today until you've learnt it.

Key terms for 4.10: Fundamentals of Databases

Attribute: A specific piece of data associated with an entity.
Commitment ordering: Manages the order in which transactions are finally committed to maintain consistency.
DELETE statement: Used to remove existing records from a table.
Foreign key: An attribute in one table that is the primary key of another table, used to link them.
Join operation: Used to combine related records from multiple tables in a query.
Primary key: An attribute, or combination of attributes, that uniquely identifies each record within a table.
SELECT statement: Used to retrieve data from one or more tables.
Third normal form: A database is in 3NF when it is in 2NF and every non-key attribute depends only on the primary key.

What 4.10: Fundamentals of Databases covers

In RADevo this topic has a full topic test and a focused quiz for each part:

4.10.1 Conceptual Data Models and Entity Relationship Modelling
4.10.2 Relational Databases
4.10.3 Database Design and Normalisation Techniques
4.10.4 Structured Query Language (SQL)
4.10.5 Client Server Databases

Teaching AQA A Level Computer Science (7517)?

Set this topic as homework in two clicks, see who has done it and which questions your class got wrong, and start every lesson with a Do Now built from their mistakes.

Start a free 2-week trial

Revising for this?

If your school uses RADevo, sign in to do the full quizzes and keep your progress. If it doesn't, show this page to your Computing teacher.