Clinic Management System

he Clinic Management System is a relational database designed to manage the daily operations of a medical clinic. It organizes information about patients, doctors, appointments, treatments, medications, and prescriptions in a structured way. The system ensures that all data is normalized, relationships are clearly defined, and queries can be executed efficiently to support real-world healthcare workflows.

✨ Key Features

• Patient Management: Stores patient details, including multiple phone numbers and contact information.

• Doctor Management: Tracks doctors, their specialties, and weekly schedules.

• Appointments: Connects patients with doctors, including appointment dates, status (Scheduled, Completed, Cancelled), and linked treatments.

• Treatments: Records medical procedures/tests performed during appointments.

• Medications & Prescriptions: Manages medications and prescriptions issued during appointments, including dosage and duration.

• Multivalued Attributes:

◦ Patients can have multiple phone numbers (PatientPhone).

◦ Doctors can have multiple weekly schedules (DoctorSchedule).

• Relationships:

◦ Patient ↔ Appointment (1:M)

◦ Doctor ↔ Appointment (1:M)

◦ Appointment ↔ Treatment (M:N via AppointmentTreatment)

◦ Appointment ↔ Prescription (1:M)

◦ Prescription ↔ Medication (M:1)