Question 2 HealFast is an IT services company that provides a variety of computer technologies to medical practices in order to make them more efficient and cost-effective to run. Electronic medical records, automated insurance claims processing and prescription submissions, patient billing, and other common components of medical operations are increasingly becoming automated. Your task is to create an EERD to reflect each phase of the creation of an insurance claims processing database, as well as to respond to questions from clients about the capabilities of the applications that the database supports at each stage. Refer to the descriptions below as guide to create the EERD i. 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. ii. A staff member (doctor, nurse, physician's assistant, etc.) has a staff ID, job title, gender, name, address, and list of degrees or qualifications. A staff member is either an office worker or medical officer. iii. Some staff members never have a patient contact that requires a claim to be processed (e.g., a receptionist greeting a patient does not generate a claim). iv. A patient sees a staff member via an appointment. An appointment has an appointment ID, 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 a list of reasons for the appointment. V. Patient may own one or more insurance policy. Information on the insurance policy include policy number and types of coverage. One insurance policy may cover many claims sent by the patient.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Question 2
HealFast is an IT services company that provides a variety of computer technologies to
medical practices in order to make them more efficient and cost-effective to run. Electronic
medical records, automated insurance claims processing and prescription submissions,
patient billing, and other common components of medical operations are increasingly
becoming automated. Your task is to create an EERD to reflect each phase of the creation of
an insurance claims processing database, as well as to respond to questions from clients
about the capabilities of the applications that the database supports at each stage.
Refer to the descriptions below as guide to create the EERD
i.
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.
ii.
A staff member (doctor, nurse, physician's assistant, etc.) has a staff ID, job title,
gender, name, address, and list of degrees or qualifications. A staff member is either
an office worker or medical officer.
iii.
Some staff members never have a patient contact that requires a claim to be
processed (e.g., a receptionist greeting a patient does not generate a claim).
iv.
A patient sees a staff member via an appointment. An appointment has an appointment
ID, 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 a list of reasons for the
appointment.
V.
Patient may own one or more insurance policy. Information on the insurance policy
include policy number and types of coverage. One insurance policy may cover many
claims sent by the patient.
Transcribed Image Text:Question 2 HealFast is an IT services company that provides a variety of computer technologies to medical practices in order to make them more efficient and cost-effective to run. Electronic medical records, automated insurance claims processing and prescription submissions, patient billing, and other common components of medical operations are increasingly becoming automated. Your task is to create an EERD to reflect each phase of the creation of an insurance claims processing database, as well as to respond to questions from clients about the capabilities of the applications that the database supports at each stage. Refer to the descriptions below as guide to create the EERD i. 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. ii. A staff member (doctor, nurse, physician's assistant, etc.) has a staff ID, job title, gender, name, address, and list of degrees or qualifications. A staff member is either an office worker or medical officer. iii. Some staff members never have a patient contact that requires a claim to be processed (e.g., a receptionist greeting a patient does not generate a claim). iv. A patient sees a staff member via an appointment. An appointment has an appointment ID, 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 a list of reasons for the appointment. V. Patient may own one or more insurance policy. Information on the insurance policy include policy number and types of coverage. One insurance policy may cover many claims sent by the patient.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY