Hospital Database

Home

Repository

Check out the full code and data on GitHub.

Overview

Built a full-stack hospital management system focused on robust relational database design and SQL-driven data operations. The backend leverages Python’s Flask framework, while the front-end is crafted with dynamic HTML and CSS. The system includes secure user authentication (sign-up, login, password change) and role-based content access, allowing Admins, Doctors/Nurses, and Patients to interact with personalized dashboards and features.

Tech Stack

Python (Flask)
MySQL
HTML/CSS
JavaScript
Git/GitHub

Data Sources

All data used in this project was synthetically generated.

Project Highlights

Designed and normalized the relational database schema to ensure data integrity and scalability.
Implemented the database locally using MySQL and populated it with synthetic data.
Integrated the front-end and backend by establishing secure database connections using Flask.
Developed and managed user roles with tiered access levels, including secure authentication via hashed passwords.
Generated and displayed summary statistics for user activity and system usage.