Igor Tascu COMP 3005 - Final Project V2
---------List of Files---------
- SQL/ddl.sql - sql script that creates all the required tables in the DB
- SQL/dml.dql - sql script that populates the tables with initial data
- src/script.py - python script that acts as the CLI for the project and interacts with the DB
- src/queries.py - python script that contains all the queries used by the script.py prompts and user interactions
- Report.pdf - Project Report
- README.txt
---------How to Run---------
-
replace details marked within "<>" with your own database credentials in order to connect to your DB
-
Run the ddl.sql and dml.sql script in your DB or Just run the main function since it automatically injects the scripts
-
Run the python script and play around with the prompts to test DB interactivity
-
Make sure all dependencies and python packages are installed if not already. (Use pip or whatever installer you have to download them)