Lesson 4.10.1.1

4.10.1.1 Entity relationship modelling 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.1.1, Entity relationship modelling: 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. In database design, what term describes a real-world object about which data is stored?

    • Domain
    • Entity
    • Attribute
    • Tuple

  2. What database term describes a single property or characteristic of an entity?

    • Relation
    • Entity
    • Primary key
    • Attribute

  3. In entity descriptions, what does an underlined attribute represent?

    • Optional attribute
    • Foreign key
    • Composite attribute
    • Entity identifier

  4. Which degree of relationship connects one entity instance to multiple instances of another?

    • Many-to-many
    • One-to-many
    • Recursive
    • One-to-one

  5. Which relationship type exists when each entity instance links to exactly one other instance?

    • Many-to-many
    • One-to-many
    • Many-to-one
    • One-to-one

  6. How is a many-to-many relationship implemented in a relational database?

    • Junction table
    • Database index
    • Primary key
    • Foreign key

  7. A customer can place many orders, but each order belongs to one customer. What relationship is this?

    • Many-to-many
    • Ternary
    • One-to-many
    • One-to-one

  8. Students enrol in many courses, and each course has many students. What relationship type is this?

    • One-to-one
    • Many-to-many
    • One-to-many
    • Many-to-one

  9. Which notation correctly shows an entity named Book with attributes ISBN, Title, and Author?

    • Book[ISBN, Title, Author]
    • Book{ISBN: Title: Author}
    • Book(ISBN, Title, Author)
    • Book<ISBN, Title, Author>

  10. A teacher teaches many classes, but each class has one teacher. What is this relationship?

    • One-to-one
    • One-to-many
    • Many-to-many
    • Zero-to-one

  11. Which attribute is the best entity identifier for Student(StudentID, Name, DateOfBirth)?

    • Name
    • StudentID
    • DateOfBirth
    • Surname

  12. A supplier supplies many products, but each product has one supplier. What relationship is this?

    • One-to-many
    • One-to-one
    • Recursive
    • Many-to-many

  13. Which attribute in the Order table acts as the foreign key linking it to Customer?

    • Date
    • OrderID
    • CustomerID
    • Name

  14. How is a many-to-many relationship resolved in relational database design?

    • Secondary index
    • Linking table
    • Foreign key
    • Composite key

  15. What database term describes whether participation in a relationship is mandatory or optional?

    • Normalisation
    • Degree
    • Cardinality
    • Optionality

  16. In a database for Patient, Doctor, and Appointment entities, which table contains foreign keys?

    • Doctor
    • Patient and Doctor
    • Appointment
    • Patient

  17. How must a many-to-many relationship be implemented in a relational database?

    • Linking table
    • Recursive foreign key
    • Candidate key
    • Composite attribute

  18. Which attribute is the most appropriate primary key for a Vehicle entity?

    • Make
    • Registration
    • Colour
    • Model

  19. What structure is required to link Customer and Address in a many-to-many relationship?

    • Recursive key
    • Primary key
    • Foreign attribute
    • Junction table

  20. Which pair of entities demonstrates a one-to-one relationship?

    • Customer and order
    • Author and book
    • Country and capital
    • Student and subject

All AQA Computer Science quizzes