🏥 Clinic Booking System - Database Project

This project is a relational database system designed for managing a clinic appointment and prescription workflow using MySQL.

---

📌 Use Case

The Clinic Booking System helps manage:

• Doctors and their specialties
• Patients and their information
• Appointment scheduling and statuses
• Prescriptions and medicine tracking

---

🗂️ Database Schema

Tables Included:

Table Name	Description
Doctors	Stores doctor details including specialty
Patients	Stores patient records
Appointments	Links doctors to patients with schedule and status
Prescriptions	Stores prescriptions related to appointments
Medicines	List of available medicines
Prescription_Medicines	Join table for many-to-many between prescriptions and medicines

---

🔗 Relationships

• One-to-Many:
  • One doctor → many appointments
  • One patient → many appointments
• One-to-One:
  • One appointment → one prescription
• Many-to-Many:
  • One prescription ↔ many medicines

---

⚙️ Setup Instructions

1. Open your MySQL client (like MySQL Workbench).
2. Run the script file clinic_booking_system.sql.
3. The script will:
   • Create the database ClinicBookingSystem
   • Create all required tables
   • Insert sample data for doctors, patients, appointments, and prescriptions

---

💾 File Structure

clinic_booking_system/
│
├── clinic_booking_system.sql   # SQL script with schema and sample data
├── README.md                   # Project overview and instructions