Insurance_Plan

PlanIDPlanNameMonthlyPremium
1Basic30.99
2Standard61.98
3Deluxe120.97
4Premier180.95
5Ultimate240.92

Coverage

CoverageIDDescription
1Prescription Drugs
2Preventive Care
3Hospitalization
4Mental Health Services
5Laboratory Tests

Insurance_Plan_Coverage

PlanIDCoverageID
(→ Insurance_Plan.PlanID)(→ Coverage.CoverageID)
11
21
31
41
51
52

Patient

PatientIDNameDOB
1John Doe1990-01-01
2Jane Smith1992-02-02
3Tom Johnson1988-03-03
4Emily Brown1994-04-04
5William Davis1996-05-05

Doctor

DoctorIDNameSpecialty
1Dr. John WilsonCardiology
2Dr. Jane ThompsonGastroenterology
3Dr. Tom HarrisNeurology
4Dr. Emily MartinOrthopedics
5Dr. William LeeEndocrinology

Appointment

AppointmentIDDateReasonPatientIDDoctorID
(→ Patient.PatientID)(→ Doctor.DoctorID)
12022-01-01 10:00:00Annual checkup11
22022-02-01 14:00:00Follow-up visit22
32022-03-01 09:00:00Consultation33
42022-04-01 11:00:00Wound care44
52022-05-01 13:00:00Diabetes management55