Relational databases

Easy
123456789101112131415161718192021222324252627282930313233343536373839
Question 31
Easy

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]

Relational databases Questions

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