Hospital Management System – University Project
🚀 Project Overview
For my university project, I designed and developed a Hospital Management System using SQL and stored procedures to efficiently manage patients, doctors, medical reports, appointments, and billing. The system ensures data integrity, easy retrieval, and smooth hospital operations by leveraging database views, stored procedures, and queries.
🔹 Tech Stack Used:
✅ SQL Server – Database management system
✅ Stored Procedures & Views – Efficient query handling
✅ Normalization Techniques – Optimized data storage
✅ User Role-Based Queries – Secure data access for doctors, patients, and admin
🌟 Key Features & Technologies
✅ Patient & Doctor Management – Efficient storage and retrieval of patient and doctor details.
✅ Stored Procedures for Automation – Insert, update, and delete patient and appointment records.
✅ Appointment Scheduling – Manage appointments with automated token generation.
✅ Medical Report Management – Store and retrieve patient medical reports.
✅ Room Availability Check – Ensures real-time room status updates.
✅ Billing System – Calculates total patient bills, including medical and room charges.
✅ Views for Role-Based Access – Doctors and patients can access only relevant data.
