Week 6 Assignment- Develop Logical Data Models BOOK: ENTERPRISE HEALTH INFORMATION MANAGEMENT AND DATA GOVERNANCE
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
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