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.