Solved–Final Project –Solution

Description

Description

The final project is designed to let you apply the skills we learned in class to a project of your own. The final project is open ended, with a few guidelines:

Build a CRUD application of your choosing using Python (or other programming language if you wish) and SQLite or MySQL

1. The project must encompass all aspects of a CRUD application (similar to the banking assignment)
   1. Create, Read, Update, Delete functionality
2. The project must utilize a backend relational database similar to the one built in the banking assignment
   1. The data should have 4+ tables
3. The data must be big enough to query and analyze (500+ records)
   1. This can be manually generated using python, or you can do something better like web scraping or finding csv files online
4. It must be an application that can be used by an actual user
   1. Takes user input to interact with the database (reading, updating, etc.)
   2. CLI is acceptable
   3. Building a GUI that interacts with your data is better and good experience
   4. We will be going over some Tableau basics in class. You can use this for GUI if you think it is a good use case for your data.
5. The data can be whatever type of data you want to work with
   1. You are in charge of creating table schemas and relationships between tables
6. Your application should have some options to query the data in different ways
   1. Think about GROUP BYs, WHERE conditions, aggregations, etc
   2. ex: if you do a student-class database, I should be able to filter for students in a given class through the app, and see the results

You have freedom to pick something that you like, use it!

Idea Submission

Idea submissions will be through email. They will include what data you plan to use, how you plan to get it, and what your database schema might look like. You will have a week from assignment (11/6) to receive approval from me. This means you should send me your idea ASAP in case you need to think of another one in the case your first idea is not approved.

Partners

You may work individually or in teams of 2 (MAX). If you work in a pair, you will both submit the deliverables. In the idea submission, please notify me of who you are working with.

Turn In

Your turn in will be a zip file with the following files:

1. a python (.py) file (or other language file) that runs your app/GUI
   1. this file will also contain the code that is used to populate your data (loops, web scraping, csv files, etc)
2. a sql (.sql) file that includes all of the DDL (table creation statements) for your database
3. an excel file that includes a data dictionary for all of your tables
4. a powerpoint that describes your project and includes screenshots of the workflow of your application. A rough outline would look something like this:
   1. Title slide
   2. Project description – what are you accomplishing with this project?
   3. Where did the data come from and how did you get it?
   4. Screenshots/screen recording of your application working and moving through the different options available