🏥 Hospital Management Database

This project contains a Microsoft SQL Server database schema for a hospital management system.
It provides structured storage for departments, doctors, patients, appointments, prescriptions, and billing.

---

📋 Features

• Manage hospital departments and doctors
• Register and track patients
• Schedule and manage appointments
• Handle prescriptions and medications
• Maintain billing and payment status

---

🧱 Database Schema Overview

Table Name	Description
Departments	Stores hospital departments and their locations.
Doctors	Contains doctor information including specialization and salary.
Patients	Stores patient demographics and contact details.
Appointments	Manages patient–doctor appointment schedules.
Medications	Lists available medicines with price and description.
Prescriptions	Links patients, doctors, and medications with dosage and date info.
Billing	Tracks payment status and total charges for each patient.

---

⚙️ How to Use

1. Open Microsoft SQL Server Management Studio (SSMS).
2. Copy the contents of hospital_management.sql.
3. Run the script to create all tables and relationships.

---

🧑‍💻 Author

[Your Name]
📧 [your.email@example.com]
💼 GitHub: (https://github.com/iphosein)

---

📄 License

This project is licensed under the MIT License — feel free to use, modify, and distribute it.