medical clink

The Clinic Management System is designed to support a small to medium-sized medical clinic by managing patients, doctors, appointments, medical records, and billing. The system ensures smooth operations and accurate record-keeping.

2. Functional Requirements

2.1 Patient Management

Store basic patient information (name, contact, date of birth, emergency contact).

2.2 Doctor Management

Maintain records of doctors, including name, specialty, and contact information.

2.3 Appointments

Record details of appointments: patient, doctor, date, time, and status.

2.4 Medical Records

Store medical history for patients, including diagnoses, treatments, prescriptions, and doctor notes.

2.5 Billing

Record payments and billing details related to appointments.

2.6 Departments (Optional)

Organize doctors by medical department or specialty (e.g., Pediatrics, Cardiology).

3. Database Design – 6 Tables

Patient → stores patient details.

Doctor → stores doctor details.

Appointment → manages patient-doctor scheduling.

MedicalRecord → stores patient treatment and history.

Billing → handles payment and billing information.

Department → manages clinic departments and specialties.

4. Key Relationships

Patient → Appointment = 1:M

Doctor → Appointment = 1:M

Appointment → MedicalRecord = 1:1 (or 1:M if multiple notes)

Appointment → Billing = 1:1

Department → Doctor = 1:M