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 sports day table has these fields. Suggest a suitable data type for each one…
EasyComputer ScienceHigh School (9–10)Computer Science › Databases and SQLConceptualNumericalIGCSE

A sports day table has these fields. Suggest a suitable data type for each one…

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 sports day table has these fields. Suggest a suitable data type for each one.

  • RunnerID, such as R017
  • Surname
  • House, one letter: R, G, B or Y
  • Age, such as 141414
  • Time100m, such as 13.4213.4213.42 seconds
  • FinishedRace, yes or no
  • RaceStart, such as 10:30

How many of the seven fields are text?

Check your answer

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

Need a reminder? The key ideaShowHide

The six basic data types are text (alphanumeric), character, Boolean, integer, real and date/time. Choose a type from what the values look like and what you will do with them. A primary key is a field whose value is unique in every record and never empty, so it identifies exactly one record.

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. Go through the fields.

  • RunnerID: text, because it mixes a letter and digits.
  • Surname: text.
  • House: character, because it is always exactly one letter.
  • Age: integer, a whole number.
  • Time100m: real, because it has a decimal part (seconds).
  • FinishedRace: Boolean, TRUE or FALSE.
  • RaceStart: date/time.

Step 2. Count the text fields. RunnerID and Surname: 222 fields.

Watch out. RunnerID contains digits, but it is not a number: nobody adds two IDs together.

Answer: 222 text fields, with the types above.

Log in to save this for later
← All Problems
← A delivery company has a table Customers with the fields CustomerID, FullName and Address…A garden centre stores its plants in this table… →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. Data types and the primary keyDatabase 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 →