Question
Can someone help me with this question? I already started working on the question. Below is the first 3 entities of the ER diagram. Your
Can someone help me with this question? I already started working on the question. Below is the first 3 entities of the ER diagram.
Your task: Panther Memorial has contracted with you to develop an entity relationship model for a patient visit database. Use the business narrative on the next page to develop an entity relationship diagram. Deliverables A Microsoft Visio diagram that contains your model consisting of all the necessary entities, attributes, and relationships from the narrative. The diagram will use the Crows foot notation.
Business Narrative:
Your company is developing a database for a small hospital called Panther Memorial. You have been provided a high level overview of what is need in the database: In this system, patients are anyone who has been admitted to our hospital. For a patient, we would want to assign a medical record number to identify each and every patient. Also, we want to collect the patients SSN, name, birth date, gender, marital status, race, ethnicity, and address. We also want to be able to mark whether the patient has expired. Another type of person we want to track is our providers. We want to record each providers National Provider Identifier, SSN, name, degree (MD, DO, DPM, CNM, NP, etc), state license number, age, years of service, gender, and email. The main point of this database is to record a patients admission to our hospital. Each patient is admitted to a particular department within the hospital. We only need to record the department name for now, but may expand what we track about a department later. When a patient is admitted, we note the date, the admission type (Emergency, Urgent, Elective, Newborn), & the admission source (direct admission, transfer, emergency room). Upon discharge, we record the date and the discharge status (Routine/discharged home, Left against medical advice, Discharged/transferred to short-term facility, Discharged/transferred to long-term care institution, Expired). Also, we record which provider admitted the patient and also which provider is currently attending the patient. An admission must have an admitting and attending provider recorded. For each admission, we track the diagnoses for the admission along with what orders were placed by the provider. From the diagnoses for the admission, one is marked by the provider as the primary diagnosis. A reference list of all possible diagnosis is maintained. The diagnosis reference table merely contains a diagnosis code and a diagnosis description. As mentioned, orders for procedures are also tracked. We note which provider placed the order (this is required for any order placed), what the procedure was that was ordered, and the amount we charge for the order. Like diagnoses, a reference table of all procedures is maintained and consists of a code and description. The procedures and diagnoses in the reference tables may not have been used for an admission.
The begining of my answer:
Patient Provider Admission National Provider ID SSN First Name Last Name Degree State License Number Birth Date Employed Date Gender Email Patient Medical PK Admission ID PK Record Number PK SSN First Name Last Name Birth Date Gender Marital Status Race Ethnicity Address Line 1 Address Line 2 City State ZIP Code Expired Patient Medical Record Number Department Name Admission Date Admission Type Admission Source Discharge Date Discharge Status Admitting Provider ID Attending Provider ID FK FKStep 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