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 garden centre stores its plants in this table…
MediumComputer ScienceHigh School (9–10)Computer Science › Databases and SQLConceptualIGCSE

A garden centre stores its plants in this table…

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 garden centre stores its plants in this table.

table
PlantCode  Name      Colour  Height  Price
GC01       Lily      White   40      6.50
GC02       Fern      Green   30      4.00
GC03       Rose      Red     40      8.25
GC04       Lily      Pink    35      6.50
GC05       Daisy     White   25      3.75
  1. Which field is the most suitable primary key? Explain why each of the other fields is not suitable.
  1. Suggest a data type for Height (in centimetres, always a whole number) and for Price (in dollars).
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. Look for repeats.

  • Name: Lily appears twice. Not unique.
  • Colour: White appears twice. Not unique.
  • Height: 404040 appears twice. Not unique.
  • Price: 6.506.506.50 appears twice. Not unique.
  • PlantCode: every value is different, and the codes are made to be unique.

Step 2. Choose. PlantCode is the primary key. It identifies exactly one plant.

Step 3. Data types. Height is an integer, because it is always a whole number of centimetres. Price is real, because it has a decimal part.

Answer: (a) PlantCode; every other field has a repeated value. (b) Height integer, Price real.

Log in to save this for later
← All Problems
← A sports day table has these fields. Suggest a suitable data type for each one…A shop gives every product a code: the letter P followed by a fixed number of digits, such as P0427… →
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 →