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 cinema wants a single-table database of its films…
MediumComputer ScienceHigh School (9–10)Computer Science › Databases and SQLConceptualNumericalIGCSE

A cinema wants a single-table database of its films…

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 cinema wants a single-table database of its films. For each film it must store the title and the running time in minutes. It also stores the age rating (one letter or number, such as U or 12), the date it was first shown and whether it is shown in 3D. Two films can have the same title.

Define the table: give it a name, list the field names, and say how many fields it has.

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.

Plan. One record for each film, and one field for each item of data. Then add a field that is unique.

Step 1. The items to store. Title, running time, age rating, date first shown, and 3D or not. That is 555 items, so 555 fields.

Step 2. A unique field. Two films can have the same title, so the title cannot tell the records apart. Add a field FilmID.

Step 3. Name the table and the fields. A table Films with the fields FilmID, Title, RunningTime, AgeRating, FirstShown and Is3D. That is 666 fields.

Check. Each field holds one item of data, and no field name has a space.

Answer: the table Films with 666 fields: FilmID, Title, RunningTime, AgeRating, FirstShown, Is3D.

Log in to save this for later
← All Problems
← A school library keeps its books in a table called Books…A delivery company has a table Customers with the fields CustomerID, FullName and Address… →
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 →