COMP3005 Final Project

Version 2
Team 19
Tanisi Das 101216265
Ashley Fong 101226835
13 April 2024

Demonstration Video:

YouTube: https://youtu.be/Lp9sewt37s4

Repository Includes:

DDL.sql: DDL file to create tables
DML.sql: DML file to insert into tables
main.py: Application code
README.md: This file

How to test application:

Ensure python is on your computer
Install psycopg2 if you don't have it yet with (depends on pip version):
```
pip install psycopg2
pip3 install psycopg2 
```
Open pgAdmin and set up database called "finalproject" or change database name in connect() function to one that is on your computer
Download main.py to your computer. Open terminal in that directory or open with VSCode.
Run in terminal or run directly in VSCode.
```
python3 main.py
python main.py 
```
Follow the prompt in the menu to see all functions.
Use pgAdmin to see how commands and inputs can manipulate the database.