Develop Logical Data Models

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.