Hospital Data Management System | SQL Project

Goal: Design and optimize a SQL-based system to streamline hospital operations while ensuring 100% data consistency and integrity.

---

🗂️ Dataset

• Hospital data (patients, doctors, appointments, billing).
• ~10+ tables, fully normalized (3NF).
• Key entities: Patients, Doctors, Appointments, Billing, Departments.

---

⚙️ Tech Stack

• SQL (Joins, Subqueries, Window Functions)
• Indexing & Views for query optimization
• Database Normalization (up to 3NF)

---

📊 Steps

1. Designed fully normalized SQL database schema.
2. Wrote 40+ advanced queries for reporting & analytics.
3. Applied indexing & views → 30% faster data retrieval.
4. Ensured 100% data integrity with constraints & relationships.

---

🔑 Key Insights

• Optimized schema reduces redundancy and anomalies.
• Indexed queries significantly speed up reporting.
• Example: Patient billing retrieval reduced from 2.3s → 1.6s.

---

▶️ How to Run

1. Clone the repo:

   git clone https://github.com/NikitaAI0512/sql-hospital-management.git