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 school library keeps its books in a table called Books…
EasyComputer ScienceHigh School (9–10)Computer Science › Databases and SQLNumericalIGCSE

A school library keeps its books in a table called Books…

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 school library keeps its books in a table called Books.

table
BookID  Title        Author  Pages  OnLoan
B101    Ocean Life   Grant   212    FALSE
B102    Star Maps    Osei    96     TRUE
B103    Clay Craft   Lund    148    FALSE
B104    River Towns  Osei    305    TRUE
B105    Quick Maths  Iqbal   88     FALSE
B106    Wild Birds   Grant   176    FALSE
B107    Code Club    Mori    130    TRUE
  1. How many records does the table have?
  1. How many fields does it have?
  1. How many data items does it hold?
  1. Write down the field names, and the data in the fourth record.

Check your answer

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

Need a reminder? The key ideaShowHide

A single-table database keeps all its data in one table. A record is one row: all the data about one thing. A field is one column: one item of data about every thing, and its heading is the field name. A table with rrr records and fff fields holds r×fr \times fr×f data items.

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.

Given. The Books table, with a heading row and rows of data.

Step 1. Records. There is one row of data for each book, from B101 to B107. That is 777 records. The heading row is not a record.

Step 2. Fields. There are 555 columns: BookID, Title, Author, Pages and OnLoan. These are the field names.

Step 3. Data items. Each record holds one item in each field, so the table holds 7×5=357 \times 5 = 357×5=35 data items.

Step 4. The fourth record. B104, River Towns, Osei, 305305305 and TRUE.

Answer: (a) 777 records. (b) 555 fields. (c) 353535 data items. (d) The field names are BookID, Title, Author, Pages and OnLoan; the fourth record is B104, River Towns, Osei, 305305305, TRUE.

Log in to save this for later
← All Problems
← A long scenario question. A teacher has the names of 5 students in the file Names.txt, one name a…A cinema wants a single-table database of its films… →
More onComputer Science › Databases and SQL

Discussion (0)

Log in to join the discussion.

Loading…

Learn it in

  1. Tables, fields and recordsDatabase 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 →