Table: Patient

Attributes:

Patient ID $($Primary Key$)$

Name

Age

Gender

Contact Info

Table: Doctor

Attributes:

Doctor ID $($Primary Key$)$

Name

Specialty

Contact Info

Table: Appointment

Attributes:

Appointment ID $($Primary Key$)$

Date

Time

Patient ID $($Foreign Key references Patient$($Patient ID$))$

Doctor ID $($Foreign Key references Doctor$($Doctor ID$))$

Table: Medical Record

Attributes:

Record ID $($Primary Key$)$

Patient ID $($Foreign Key references Patient$($Patient ID$))$

Doctor ID $($Foreign Key references Doctor$($Doctor ID$))$ Note: One$-$to$-$One Relationship with Doctor table

Diagnosis

Treatment

Table: Billing

Attributes:

Billing ID $($Primary Key$)$

Patient ID $($Foreign Key references Patient$($Patient ID$))$

Appointment ID $($Foreign Key references Appointment$($Appointment ID$))$ Note: One$-$to$-$One Relationship with Appointment table

Total Amount

Payment Status