Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started