HelpContactFor teachers and institutes
>_StemPy Lab
Mock TestsClasses

>_StemPy Lab

Learn. Solve. Code the solutions. Test yourself.

Live examsFree mock exams, timed and rankedEveryone starts together, and your score and rank come the moment it ends.See the exams →

Learn

  • Physics
  • Chemistry
  • Mathematics
  • Biology
  • Python Programming
  • Statistics & Data Science
  • Computer Science
  • Classes
  • Groups

Practice

  • Problems
  • Quizzes
  • Mock Tests
  • Prepare for an Exam
  • Question Sets
  • Exams
  • Certificates
  • Python Labs
  • AI Practice Generator
  • Student-Created Tests

Community

  • Discussions
  • Resources
  • Notes
  • Glossary
  • Blog

Account

  • Log in
© 2026 senLearn. All rights reserved.HelpFor SchoolsAboutContactPrivacy PolicyTerms of UseRefund Policy
  1. Problems
  2. /A hotel stores its bookings in a table. For each field, choose one suitable validation check and…
EasyComputer ScienceHigh School (9–10)Computer Science › Databases and SQLConceptualIGCSE

A hotel stores its bookings in a table. For each field, choose one suitable validation check and…

StemPy LabContributed by StemPy Lab

Try it on paper first. A hint, the key idea and the worked solution are here when you need them.

A hotel stores its bookings in a table. For each field, choose one suitable validation check and say what it checks.

  • BookingRef: always the letter H then four digits
  • GuestName: must be filled in
  • Nights: a whole number from 1 to 7
  • Email: must be filled in and must contain the @ symbol
Need a reminder? The key ideaShowHide

Validation is an automatic check that data is sensible before it is stored: a range check, a length check, a type check, a presence check, a format check or a check digit. A field can need several checks. Validation cannot prove that a sensible value is the true one.

The worked solution

Have you tried it?

Work it out on paper first. It is fine to get stuck or make a mistake: that is how we learn. When you are ready, go through the solution one step at a time, and check each step against your own.

Step 1. BookingRef. A format check: H and then four digits. A length check (exactly 555 characters) also helps.

Step 2. GuestName. A presence check: the field is not empty.

Step 3. Nights. A type check (a whole number) and a range check from 111 to 777.

Step 4. Email. A presence check, and a format check that the text contains the @ symbol.

Answer: format (and length) for BookingRef, presence for GuestName, type and range for Nights, presence and format for Email.

Log in to save this for later
← All Problems
← A student designs a table of club members and stores the phone number 07700 900814 in a field Phone…A table of part-time jobs has a field HoursPerWeek… →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. Validation in a database tableDatabase Tables, Data Types and Primary Keys

More on this topic

  1. A restaurant stores its staff in a table Staff…Hard
  2. A town library stores its readers in a table Readers…Medium
  3. A gym stores its members in a table Gym…Easy
  4. A school garden club records each plot in a table Plots: the water it needs each day in litres, its…
Hard
  • A school weather station stores one record a day in a table Weather: the rainfall in millimetres…Medium
  • All problems on this topic →