Week 6 Assignment – Develop Logical Data Models

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.
Data Architecture Documentation Techniques and Tools
Figure 6.19. Logical data model example
Clinic Department Provider PK Clinic ID PK Dept ID PK Provider ID Clinic Name Street_Address +O-has / is part of+ HO has / is of —+ City Dept_Name Phone_Number Clinic ID Provider_LN Provider_FN License_No FK1 Dept_ID State FK1 Zip Code Phone_Number has , is of Patient Appointment PK MRN PK Appt ID Patient_LN Patient_FN DOB Street_Address O—- has / is of— Date Time Provider_ID FK1 FK2 MRN City State Zip Home_Phone Gender L. Johns

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.