| PlanID | PlanName | MonthlyPremium |
|---|---|---|
| 1 | Basic | 30.99 |
| 2 | Standard | 61.98 |
| 3 | Deluxe | 120.97 |
| 4 | Premier | 180.95 |
| 5 | Ultimate | 240.92 |
| CoverageID | Description |
|---|---|
| 1 | Prescription Drugs |
| 2 | Preventive Care |
| 3 | Hospitalization |
| 4 | Mental Health Services |
| 5 | Laboratory Tests |
| PlanID | CoverageID |
|---|---|
| (→ Insurance_Plan.PlanID) | (→ Coverage.CoverageID) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 2 |
| PatientID | Name | DOB |
|---|---|---|
| 1 | John Doe | 1990-01-01 |
| 2 | Jane Smith | 1992-02-02 |
| 3 | Tom Johnson | 1988-03-03 |
| 4 | Emily Brown | 1994-04-04 |
| 5 | William Davis | 1996-05-05 |
| DoctorID | Name | Specialty |
|---|---|---|
| 1 | Dr. John Wilson | Cardiology |
| 2 | Dr. Jane Thompson | Gastroenterology |
| 3 | Dr. Tom Harris | Neurology |
| 4 | Dr. Emily Martin | Orthopedics |
| 5 | Dr. William Lee | Endocrinology |
| AppointmentID | Date | Reason | PatientID | DoctorID |
|---|---|---|---|---|
| (→ Patient.PatientID) | (→ Doctor.DoctorID) | |||
| 1 | 2022-01-01 10:00:00 | Annual checkup | 1 | 1 |
| 2 | 2022-02-01 14:00:00 | Follow-up visit | 2 | 2 |
| 3 | 2022-03-01 09:00:00 | Consultation | 3 | 3 |
| 4 | 2022-04-01 11:00:00 | Wound care | 4 | 4 |
| 5 | 2022-05-01 13:00:00 | Diabetes management | 5 | 5 |