Get the Bookshop Database

Download and save the bookshop.db file to your computer:


bookshop.db


Create a Python file named books.py, and move the database (.db) file into the same folder as your new Python file (.py), so that the Python file and the Database file sit side by side:



This is the data that can be found inside the bookshop.db books table:

    Core Activities:

  1. From the image above:
    • How many fields are in the books table?
    • How many tuples are in the books table?

    2. Extension Activities:

  2. What data types do you think the data in each field is? Hint: common data types in Python are string, integer, float (meaning decimal), bool (meaning true or false)