Skip to content

Course home

Relational databases

Relational databases

Easy
1234567891011121314151617181920212223242526272829303132333435363738
Question 12

A local medical clinic is changing its record system from a single flat-file spreadsheet to a relational database.

Doctor

DoctorIDDoctorNameSpecialism
DOC01Dr. SmithPediatrics
DOC02Dr. JonesCardiology

Patient

PatientIDPatientNameDateOfBirth
PAT401Sarah Connor12/11/1984
PAT402John Doe05/04/1990

Appointment

AppointmentIDPatientIDDoctorIDAppointmentDate
APP001PAT401DOC0115/10/2023
APP002PAT401DOC0218/10/2023
APP003PAT402DOC0119/10/2023

Identify one benefit of using this relational database structure instead of keeping all the data in a single flat-file spreadsheet.

A

It prevents data inconsistency because common details (such as a doctor's name) only need to be updated in one place.

B

It simplifies the design process because relationships do not require primary or foreign keys.

C

It increases data redundancy because patient or doctor details must be repeatedly typed for every appointment.

D

It stores all related data in a single table, making the database structure easier to read.

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