Write a python script to read in the csv files and populate the database

a) A document (in pdf or word) with a summary of your results. This document is not a

formal academic report.

The document should include:

i) The entity relationship diagram and the design choices for the database.

ii) The SQL schema for all the tables.

iii) A discussion of any data cleaning required, if there are for example missing


iv) The screen-shots showing the working of the GUIs.

b) All the python code written for the coursework. I suggest you put all the python

code in a zip file.

c) The SQLite database you created.