The specification was to design a Python based database management system. The database schema is run on SQLite with the Python application used for managing a database of film information all stored on one table. Alongside basic features (add, update, delete) users can search for a film and there is a ‘film reports’ section where users can filter to show films meeting certain search criteria or show all films.