Python SQL Programming Assignment

I’m trying to learn for my Python class and I’m stuck. Can you help?

The attached PDF file contains the assignment.

Here is some useful readings that may help!:

1. Relational databases tutorial – A quick guide covering relational databases
2. Back to Basics SQL Tutorial – A good run down of using SQL and SQLite
3. SQLite Python Tutorial – how to use SQLite from python