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 table of part-time jobs has a field HoursPerWeek…
MediumComputer ScienceHigh School (9–10)Computer Science › Databases and SQLNumericalIGCSE

A table of part-time jobs has a field HoursPerWeek…

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 table of part-time jobs has a field HoursPerWeek. It must be a whole number from 111 to 404040, including both ends.

  1. How many different whole numbers does the range check accept?
  1. Give two values that test the ends of the range and should be accepted, and two values just outside the range that should be rejected.
  1. A programmer writes the check as hours > 1 AND hours < 40. Which values from part (b) does it get wrong?

Check your answer

Work it out on paper, then type your number. The answer itself stays hidden.

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. Count. The accepted values are 1,2,…,401, 2, \ldots, 401,2,…,40. That is 40−1+1=4040 - 1 + 1 = 4040−1+1=40 values.

Step 2. Test values. The ends 111 and 404040 should be accepted. The values 000 and 414141, just outside, should be rejected.

Step 3. The wrong check. hours > 1 is false for 111, and hours < 40 is false for 404040. So the check rejects 111 and 404040, which should be accepted. It handles 000 and 414141 correctly.

Watch out. A range check that includes its ends needs >= and <=.

Answer: (a) 404040 values. (b) Accept 111 and 404040; reject 000 and 414141. (c) It wrongly rejects 111 and 404040.

Log in to save this for later
← All Problems
← A hotel stores its bookings in a table. For each field, choose one suitable validation check and…A hotel validates each booking before it is added… →
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 →