Zhenxuan Ding 101269248
- Open pgAdmin4 and create a new database
- Run the scripts under
SQL Scripts
directory in the Query Tool (DDL.sql
first, thenDML.sql
)
- To install the required libraries, open the terminal and run:
pip install psycopg
(not psycopg2) andpip install prettytable
- To run the program, execute
main.py
in any way you want, the environment must support console input - Assuming you have kept the default settings for PostgreSQL, enter the database name and your
postgres
user password - If you have altered the settings, edit the first lines of
main.py
to modify the username, host and port then run the modified program - After you successfully connect to the database, try each function out by entering 1, 2, 3, 4, or exit by entering 5