Skip to content

Course home

Relational databases

Relational databases

Easy
1234567891011121314151617181920212223242526272829303132333435363738
Question 30

Client

ClientIDForenameSurnameDateRegistered
C101AmandaVance2022-03-12
C102MarcusSterling2022-03-15
C103ChloeVance2022-04-01
C104ArthurPendleton2022-05-18

Appointment

AppointmentIDClientIDSessionDateServiceType
A801C1012022-04-10Consultation
A802C1012022-04-17Follow-up
A803C1032022-05-01Consultation
A804C1022022-05-12Therapy

State the name of the field from the Client table that is the most suitable to use as the primary key.

[1]
Markscheme

Relational databases Questions

  1. GCSE
  2. /Computer Science
  3. /Relational databases

38 exam-style questions on AQA GCSE Computer Science Relational databases. Each one has a worked solution and a mark scheme showing where the marks go.

Question bank