Skip to content

Latest commit

 

History

History
25 lines (19 loc) · 1.13 KB

README.md

File metadata and controls

25 lines (19 loc) · 1.13 KB

Project v2: Health and Fitness Club Management System

Group Members: Allan Cao, Vivian Ngan, Lucy Wang.

An application in Python that connects to a PostgreSQL database to simulate an application for a Health and Fitness Club Management System. It serves as a comprehensive platform catering to the diverse needs of club members, trainers, and administrative staff.

Prerequisites Install: Python - pip install python in your terminal psycopg2 - pip install psycopg2 in your terminal - pip install psycopg2-binary (if above option does not work) Download: application.py from the GitHub DDL.sql from the SQL folder on the GitHub DML.sql from the SQL folder on the Github

PostgreSQL Set Up Login to pgAdmin 4 and create a new database with a name of your choice Go to the Query tool and open the DDL.sql and DML.sql script to run the example DDL and DML commands These commands create the necessary tables and populate the tables with initial sample data

Compliation Run the Python program using your IDE

Video Demo: https://youtu.be/_dLKm3Qzztk