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.

Looking for a similar assignment? Get help from our qualified experts!

Order Now