Montessori Training of Southern Nevada Entity Relationship Model

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 PDF created using Lucidchart that contains your model consisting of all the necessary entities, attributes, and relationships from the narrative. The diagram will use the Crow’s foot notation as demonstrated in our examples from class.

Individual Work
This assignment will be completed individually without collaboration with other students.

Submission
Your Lucidchart diagram must be submitted as a PDF file generated directly from Lucidchart (no embedded screenshots, etc). Failure to do so will result in a grade of zero points. It is your responsibility to correctly submit the entire assignment on time in Canvas and you may want to reopen your uploaded file to confirm the submission.

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 patient’s 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 provider’s 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 patient’s 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.