This project is a MySQL-based database system designed to manage and streamline operations in a healthcare clinic.
It provides structured storage and management for patients, doctors, appointments, billing, medicines, and prescriptions.
The system ensures efficient handling of clinical data and demonstrates strong skills in database design, ER modeling, and SQL queries.
SQL queries were written to:
- Store and manage patients (Users) and doctors data
- Book and track appointments with status (Scheduled/Completed)
- Record billing details with payment tracking (Paid/Unpaid)
- Manage medicines and assign them to patients through prescriptions
- Join multiple tables to generate meaningful reports, such as:
- Appointments by patient and doctor
- Billing reports by appointment
- Prescriptions linked to medicines and patients
- Users → Patients registered in the clinic
- Doctors → Doctors with specialization and availability
- Appointments → Connects patients and doctors with date & time
- Billing → Tracks payments for each appointment
- Medicines → Stores medicine details
- Prescriptions → Maps medicines to patient appointments
The Entity-Relationship Diagram (ERD) visually represents the schema and relationships.
- Patient & doctor management
- Appointment booking with date and time
- Billing and payment tracking
- Prescription management with medicines
- Relational queries using primary & foreign keys
- Report generation through SQL joins and sorting
- MySQL – database design & management
- MySQL Workbench – schema & ER diagram
- SQL Queries – data retrieval and reporting
Syed Danish Ahmed
Aspiring Data Scientist | Computer Engineering Student
If you find this project helpful, please ⭐ the repository. Your support is greatly appreciated!