Instructions

Assignment $2$: Demonstrating SQLite Python & Data Analysis with Pandas

Overview

Based on the knowledge and skills you have learned:

Part $1$: Fill out the Pandas worksheet $($attached zip file$)$

Part $2$: Create a single python script that demonstrates basic CRUD with SQLite.

More detailed instructions are in the 'How to Complete the Assignment' section below.

Half of the marks for this assignment are acheived by showing and explaining your work to your instructor.

How to Complete the Assignment

$($Please read all steps before proceeding$)$

Part $1$: Pandas worksheet

Download the attached zip file and extract it$.$

Fill out the Jupyter Notebok worksheet.

Part $2$: CRUD with SQLite

Your script must demonstrate, in this order:

Creation of a new database with a randomly generated name $($ie$,$ every time the script is run it should create a new database with a random name$)$

Creation of at least three new tables. Each table must have at least three columns.

Insertion of at least three rows of data for each table.

At least one table must contain references to another table.

After the above steps, output the entire contents of the database to the console.

Update at least one row of data in the database.

After updating, select the changed data and output it to the console.

Delete at least one row of data from the database.

After deleting, output the entire table that the data was deleted from to the console.

Make sure you close the connection to the database when you are finished.

Notes:

Please use best programming practices, and add proper Python documentation throughout.

Please also use frequent comments!

Please don't use the same tables$/$data as the tutorials.

Supporting Resources for this Assignment

W$3$Schools NumPy Tutorial

W$3$Schools Pandas Tutorial

Module $2$ Lesson Notes$-$ Section $1($SQLite Tutorial$)$

SQLite Database File Viewer

Submission

Zip the completed worksheet and the Python script together for submission.

Submit your assignment to the Learn Dropbox.

You may submit as many times as you like before the deadline, but only the most recent submission is kept.

Evaluation

To complete this course successfully, you must complete and submit all the assignments and secure at least $50\%$ in aggregate.

Grading

This assignment is worth $20$ marks or $20\%$ of your