Nurses
| NurseID | Name | PatientID | HoursWorked | ExperienceLevel |
| 1 | Anne Buche | 230 | 8.5 | Intermediate |
| 2 | John Smith | 367 | 9.0 | Advanced |
| 3 | Jane Doe | 455 | 7.5 | Beginner |
PhysiciansAssistants
| PAID | Name | PatientID | HoursWorked | Specialization |
| 1 | Anne Buche | 230 | 8.5 | Cardiology |
| 2 | John Smith | 367 | 9.0 | Gastroenterology |
| 3 | Jane Doe | 455 | 7.5 | Orthopedics |
Doctors
| DoctorID | Name | MedicalLicenseNumber | YearsOfPractice |
| 1 | Dr. Alice Johnson | M123456 | 10 |
| 2 | Dr. Bob Brown | B654321 | 15 |
| 3 | Dr. Carol White | W789012 | 5 |
Clinics
| ClinicID | Address | PhoneNumber | NumberofDoctors |
| 1 | 123 Main St, Anytown | 555-1234 | 3 |
| 2 | 456 Elm St, Anothertown | 555-5678 | 5 |
Departments
| DepartmentID | ClinicID | DepartmentName |
| (→ Clinics.ClinicID) | |
| 1 | 1 | Family Medicine |
| 2 | 2 | Dermatology |
Appointment
| AppointmentID | DoctorID | Date | ReasonForVisit |
| (→ Doctors.DoctorID) | | |
| 1 | 1 | 2022-01-01 10:00:00 | Routine checkup |
| 2 | 2 | 2022-01-02 14:00:00 | Flu shot |
| 3 | 3 | 2022-01-03 16:00:00 | Skin rash consultation |