Create a ERD diagram for clinic management system where take patient$$s registration and treat them with medication. Include patient registration, appointment schedule, patient online health record, medicine inventory and billing management.

Entities and Attributes:

$1.$ Patient

$$ PatientID $($Primary Key$)$

$$ Name

$$ DateOfBirth

$$ Gender

$$ Address

$$ PhoneNumber

$$ Email

$2.$ Appointment

$$ AppointmentID $($Primary Key$)$

$$ PatientID $($Foreign Key$)$

$$ DoctorID $($Foreign Key$)$

$$ AppointmentDate

$$ AppointmentTime

$$ Status

$3.$ HealthRecord

$$ RecordID $($Primary Key$)$

$$ PatientID $($Foreign Key$)$

$$ VisitDate

$$ Diagnosis

$$ Treatment

$$ DoctorNotes

$4.$ Doctor

$$ DoctorID $($Primary Key$)$

$$ Name

$$ Specialty

$$ PhoneNumber

$$ Email

$5.$ Medicine

$$ MedicineID $($Primary Key$)$

$$ Name

$$ Description

$$ StockQuantity

$$ Price

$6.$ Prescription

$$ PrescriptionID $($Primary Key$)$

$$ RecordID $($Foreign Key$)$

$$ MedicineID $($Foreign Key$)$

$$ Dosage

$$ Duration

$7.$ Billing

$$ BillID $($Primary Key$)$

$$ PatientID $($Foreign Key$)$

$$ AppointmentID $($Foreign Key$)$

$$ TotalAmount

$$ PaymentStatus

$$ PaymentDate

$$ PaymentMethod