Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an ERD to capture information found at different phases in the case below. Doctors Information lechnolosynlDoclT) is an IT services company supporting medical practices

image text in transcribed

Draw an ERD to capture information found at different phases in the case below. Doctors Information lechnolosynlDoclT) is an IT services company supporting medical practices (clients) with a variety of computer technologies to make medical offices more efficient and less costly to run. Medical offices are rapidly becoming automated with electronic medical records, automated insurance claims processing and prescription submission, patient billings, and other typical aspects of medical practices. In this assignment, you will address only insurance claims processing: however, what you develop must be able to generalized and expanded to these other areas of their clients' medical practice. Your assignment is to draw an ERD to represent each phase of the development of an insurance claims processing database. Make additional assumption when needed a. Phase I/ Scenario I The first phase deals with a few core elements. Draw an ERD to represent this initial phase, described by the following .A patient is assigned a patient ID and you need to keep track of a patient's gender, date of birth, name, current address, and list of allergies .A staff member (doctor, nurse, physician's assistant, etc.) has staff ID, job title, gender, name, address, and list of degrees or qualifications. A staff may be included in the database even if they do not have to meet with a patient. Similarly, the company wants to record patient information even if they have not been seen by its staff members. If a patient is related to other patients, the company would like to know who they are related to When a patient is scheduled to meet with staff member(s), a date and time of when the appointment is scheduled or when it occurred as well as a date and time when the appointment was made, and list of reasons for the appointment must be recorded . DOLL

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 Universal Database V7.1 Application Development Certification Guide

Authors: Steve Sanyal, David Martineau, Kevin Gashyna, Michael Kyprianou

1st Edition

ISBN: 0130913677, 978-0130913678

More Books

Students also viewed these Databases questions

Question

3. Write a policy statement to address these issues.

Answered: 1 week ago