Lesson 4.10.2.1

4.10.2.1 Relational databases Quiz: AQA Computer Science, Unit 10

20 questions

Written by Revision Ninja · Last reviewed 11 October 2026

In partnership with Revision Ninja

Lesson 4.10.2.1, Relational databases: 20 multiple choice questions for the AQA Computer Science (7517), Unit 10: Fundamentals of databases, written with Revision Ninja.

Host it live on the board and students join with a game code on their own devices, or revise alone with Free Play. The answers are revealed in the game.

Host this setFree Play

The 20 questions

  1. What is the formal relational database term for a table column?

    • Domain
    • Relation
    • Attribute
    • Tuple

  2. What term describes an attribute that uniquely identifies each row in a table?

    • Secondary key
    • Foreign key
    • Primary key
    • Composite key

  3. What type of key combines multiple attributes to uniquely identify a record?

    • Alternate key
    • Foreign key
    • Surrogate key
    • Composite primary key

  4. What attribute in one table cross-references the primary key of another table?

    • Candidate key
    • Secondary key
    • Foreign key
    • Composite key

  5. What is the formal relational database term for a table row?

    • Relation
    • Entity
    • Attribute
    • Tuple

  6. What is the formal relational database term for a data table?

    • Relation
    • Schema
    • Tuple
    • Attribute

  7. What property must the primary key CustomerID have in a Customer table?

    • Text values
    • Numeric values
    • Unique values
    • Foreign values

  8. Which attribute is the best primary key for a table of books?

    • Title
    • Genre
    • Author
    • ISBN

  9. What property ensures that foreign key values match primary key values in linked tables?

    • Domain integrity
    • Data duplication
    • Referential integrity
    • Entity integrity

  10. What type of key consists of two or more attributes combined to uniquely identify records?

    • Candidate key
    • Composite primary key
    • Secondary key
    • Foreign key

  11. In the table Enrolment (StudentID, CourseID, Grade), which attributes form the composite primary key?

    • StudentID and CourseID
    • StudentID only
    • StudentID and Grade
    • CourseID and Grade

  12. What is the term for a single unique identifier column chosen for a table?

    • Composite key
    • Primary key
    • Foreign key
    • Secondary key

  13. A foreign key in a relational table points directly to which key in another table?

    • Primary key
    • Secondary key
    • Candidate key
    • Composite key

  14. What type of key is ISBN in the Loan table when referring to the Book table?

    • Candidate key
    • Primary key
    • Composite key
    • Foreign key

  15. A Class table includes TeacherID to link to a Teacher table. What key is TeacherID in Class?

    • Candidate key
    • Primary key
    • Foreign key
    • Composite key

  16. In a Student table with StudentID, Name, and Form, which attribute must be unique?

    • StudentID
    • Form
    • Name
    • Name and Form

  17. What is a primary reason for storing data across separate linked tables in databases?

    • Eliminate primary keys
    • Reduce data redundancy
    • Increase search time
    • Allow duplicate records

  18. Which database concept maintains consistency between related records in separate tables?

    • Atomic values
    • Data redundancy
    • First normal form
    • Referential integrity

  19. Which key structure is needed when no single attribute uniquely identifies a record?

    • Secondary key
    • Composite key
    • Candidate key
    • Foreign key

  20. What is any attribute or set of attributes capable of uniquely identifying a table row called?

    • Candidate key
    • Secondary key
    • Composite key
    • Foreign key

All AQA Computer Science quizzes