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.

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.

Database Schema