🏥 Hospital Management System (SQL)

A comprehensive SQL-based database management system designed to streamline hospital operations, including doctor scheduling, patient records, appointments, and financial billing. This project features a robust relational schema with 50+ patient records and 15+ specialized doctors.

🌟 Key Features

• Doctor Management: Profiles for 15+ specialized doctors across various departments (Cardiology, Neurology, Surgery, etc.).
• Patient Records: Securely managing personal details for 50+ patients.
• Appointment Tracking: Efficiently linking patients with doctors using relational mapping.
• Billing Module: Automated billing generation with payment status tracking (Paid/Unpaid).

🛠️ Database Concepts Used

• Relational Integrity: Implemented FOREIGN KEY with ON DELETE CASCADE and DEFAULT constraints.
• Advanced Queries: Utilized JOINs to generate comprehensive reports across multiple tables.
• Data Aggregation: Used SUM, COUNT, and AVG functions for financial reporting and statistics.
• Normalization: Followed standard database normalization rules for efficient data storage.

📂 Database Schema

The system consists of 4 core tables:

1. doctors - Specialized medical professionals.
2. patients - Patient demography and records.
3. appointments - Scheduling link between patients and doctors.
4. billings - Transactional data for medical services.

🚀 How to Use

1. Clone this repository or download the .sql file.
2. Open MySQL Workbench or any SQL editor.
3. Import and execute the script to set up the database and populate it with sample data.