Week 6 Assignment- Develop Logical Data Models

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