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. Python Labs
  2. /Build a table with a primary key
Computer ScienceEasyHigh School (9–10)Computer Science › Databases and SQL

Build a table with a primary key

You will finish the Books table of a small library, choose the data types of two fields and choose the primary key.

Your tasks.

  1. Add the two missing books to the list books: ("B4", "Sea Stories", 240, 7.5) and ("B5", "Bird Songs", 96, 4.25).
  2. In the dictionary types, give Pages and Price their SQLite data types: INTEGER or REAL.
  3. Set key_field to the name of the field that is a suitable primary key.

Run it first, just as it is. The checker at the end prints FAIL for each task. Then do the tasks one at a time, and run the program again after each one. A Hint appears under every check that still fails.

When every line says PASS, add a sixth book with the same title as another book. Do the checks still pass? Why is the title not a good key?

StemPy LabContributed by StemPy Lab
python
Loading Python runtime…

A worked solution

Have you tried it?

Do the tasks in the editor first, and run the checker after each one. Its hints help when a check fails. When you are ready, compare your code with this solution.

Log in to save
← All Labs
← Saving and loading a listValidation checks before a record is stored →
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 labs on this topic

  1. Two conditions with AND and OREasy
  2. Counting and adding up salesEasy
  3. Sorting with ORDER BYEasy
  4. Choosing records with WHEREEasy
Validation checks before a record is storedEasy
All labs on this topic →