Develop Data Models


November 9, 2021
Mental Illness Presbycusis and Macular Degeneration Discussion
November 9, 2021

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. Discount Code - "Newclient"!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp