Develop Data Models

Week 6 Assignment- Develop Logical Data Models BOOK: ENTERPRISE HEALTH INFORMATION MANAGEMENT AND DATA GOVERNANCE

Review pages 132-133 in your textbook regarding the Logical Data Model.

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.
  • ISBN: 978-1-58426-155-1
 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"