Scalable Hospital Patient Management System
A comprehensive, database-driven hospital management system designed using MySQL Workbench, emphasizing scalability, data integrity, security, backup & recovery, and a hybrid SQL–NoSQL architecture.
Technologies / Concepts Used
- MySQL 8.0
- MySQL Workbench
- ER Modeling & Normalization
- RBAC Security
- mysqldump
Key Features
- Normalized relational database design up to Third Normal Form (3NF)
- Management of patients, doctors, appointments, billing, and medical records
- Role-Based Access Control (RBAC) with audit logging
- Transaction management with ACID compliance and concurrency control
- Backup and recovery implementation using mysqldump