I’m studying and need help with a Health & Medical question to help me learn.
Develop logical data models for the following:
Data model #1
A patient can make multiple appointments to see a provider, but an appointment can only be associated with one patient visit.
Data model #2
A specific patient visit can be associated with only one provider (such as a nurse, or physician).
For both data models:
- A specific patient visit can be associated with multiple services (such as a physician visit, laboratory test, and other evaluation).
- Patient attributes include: medical record number, date of birth, last name, first name, gender.
- Appointment attributes include: appointment date, appointment time, and primary provider.
- Visit attributes include: visit date, visit time, provider, and services.
I attached an example