University Health Management System

Developed as learning project for the course - Database Management Systems CS5200 at Northeastern University

• Designed a MySQL Database Schema for a hospital, and various database programming objects such as procedures, triggers, prepared statements, and functions
• Developed a web application using Python‑Flask, PyMySQL, and HTML to demonstrate learning of MySQL’s CRUD operations on the front end by establishing a connection with the designed schema
• Learnt to develop and use various HTTP request/response methods for API
• Integrated a third‑party calendar tool to visualize doctor’s and patients’ appointments on a monthly calendar using JavaScript

Steps to Run the Project

1. Unzip the project, and open the project in Visual Studio Code (You can download it from here: https://code.visualstudio.com/download)
2. Download the latest version of python from here: https://www.python.org/downloads/)
3. Open the terminal in Visual Studio Code and run the command "pip3 install -r requirements.txt". If this command doesn't work, try "pip install -r requirements.txt". This will install all the required libraries and dependencies.
4. Using MySQL Workbench, create a database named "dbmsprod" and import the dump file "SqlDump.sql" into the database.
5. In the file app.py, change the value of the database connection credentials to your own database credentials. Set value of db to "dbmsprod" and set the value of user and password to your own database credentials.
6. Run the command "python3 app.py" or "python app.py" to run the project.
7. Open the browser and go to the URL "http://localhost:5000" to view the project.

Admin credentials:

1. Username: admin.1@gmail.com Password: Pranove*2
2. Username: padmin@gmail.com Password: 44444444

Patient credentials:

1. Username: ross@gmail.com Password: rossgeller
2. Username: tony@gmail.com Password: tonystark
3. Username: phoebe@gmail.com Password: phoebebuffay

Doctor credentials:

1. Username: ap.doc@gmail.com Password: aprilkepner 2 Username: ca.doc@gmail.com Password: callietorres
2. Username: ma.doc@gmail.com Password: marksloan