Draw your ER diagram based on the following narrative about a hospital. Be sure to indicate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Draw your ER diagram based on the following narrative about a hospital. Be sure to indicate the various attributes of each entity and relationship, underline the identifier of an entity, and specify the cardinalities and cardinality constraints for each relationship. A hospital depends on four major groups of persons for its continued success: employees, physicians, patients, and volunteers. A small number of persons in the hospital community do not belong to any of these four groups. A particular person may belong to two (or more) of these groups at a given time. For example, a volunteer or employee may also be a patient at the hospital at some point in time. Furthermore, a particular person can have zero or more dependents, and a particular dependent is dependent of only one person. A dependent has attributes: Name, Gender, and Relationship to the person employed at the hospital. A dependent cannot exist without the employed person that s/he is related to. The four groups of people listed above share many common characteristics such as a unique identifier (SSN), Name, Street Address, City, State, Zip_Code, Birth_Date, Phone, and Email. Then there are characteristics that apply to only one of these groups. For example, a hire date (Date_Hired) is recorded for employees only, and Skills are recorded for volunteers in order to place them appropriately. Physicians have pager number (Pager_No) and Specialty (e.g. pediatrics, oncology, etc.). For patients, the hospital records the date of first contact with the hospital (Contact_Date). In addition to the characteristics already mentioned, the hospital records a number of other characteristics about its patients: emergency contact information (EC_Name, EC_Relationship, and EC_Phone), insurance information (Insurance_Name, Policy_No, Group_No, Insurance_Phone), and information about insurance subscriber in case the patient is not the insurance subscriber (Subs_Name, Subs_Relationship, Subs_Address, Subs_Phone). At this hospital, each patient has one (and only one) physician responsible for that patient. A given physician may not be responsible for a patient at any given time or may be responsible for one or more patients. Furthermore, the hospital wants to keep the information on the treatment that the patients receive from their physicians. The only attribute of treatment is the identifier Treatment_ID, which consists of two components: Treatment_No and Treatment_Name. Each physician can perform many treatments to many patients or does not perform any treatment to any patient at all; each treatment can be performed by many physicians to many patients, or it is not performed by any physician to any patient at all; and each patient can receive many treatments from many physicians, or the patient may not receive any treatment from any physician at all. Moreover, the hospital wants to track when a treatment is performed by a physician to a patient (Treatment _StartDate), and the results of the treatment (Results). This two information is tied to a specific physician who performed a specific treatment to a specific patient. Draw your ER diagram based on the following narrative about a hospital. Be sure to indicate the various attributes of each entity and relationship, underline the identifier of an entity, and specify the cardinalities and cardinality constraints for each relationship. A hospital depends on four major groups of persons for its continued success: employees, physicians, patients, and volunteers. A small number of persons in the hospital community do not belong to any of these four groups. A particular person may belong to two (or more) of these groups at a given time. For example, a volunteer or employee may also be a patient at the hospital at some point in time. Furthermore, a particular person can have zero or more dependents, and a particular dependent is dependent of only one person. A dependent has attributes: Name, Gender, and Relationship to the person employed at the hospital. A dependent cannot exist without the employed person that s/he is related to. The four groups of people listed above share many common characteristics such as a unique identifier (SSN), Name, Street Address, City, State, Zip_Code, Birth_Date, Phone, and Email. Then there are characteristics that apply to only one of these groups. For example, a hire date (Date_Hired) is recorded for employees only, and Skills are recorded for volunteers in order to place them appropriately. Physicians have pager number (Pager_No) and Specialty (e.g. pediatrics, oncology, etc.). For patients, the hospital records the date of first contact with the hospital (Contact_Date). In addition to the characteristics already mentioned, the hospital records a number of other characteristics about its patients: emergency contact information (EC_Name, EC_Relationship, and EC_Phone), insurance information (Insurance_Name, Policy_No, Group_No, Insurance_Phone), and information about insurance subscriber in case the patient is not the insurance subscriber (Subs_Name, Subs_Relationship, Subs_Address, Subs_Phone). At this hospital, each patient has one (and only one) physician responsible for that patient. A given physician may not be responsible for a patient at any given time or may be responsible for one or more patients. Furthermore, the hospital wants to keep the information on the treatment that the patients receive from their physicians. The only attribute of treatment is the identifier Treatment_ID, which consists of two components: Treatment_No and Treatment_Name. Each physician can perform many treatments to many patients or does not perform any treatment to any patient at all; each treatment can be performed by many physicians to many patients, or it is not performed by any physician to any patient at all; and each patient can receive many treatments from many physicians, or the patient may not receive any treatment from any physician at all. Moreover, the hospital wants to track when a treatment is performed by a physician to a patient (Treatment _StartDate), and the results of the treatment (Results). This two information is tied to a specific physician who performed a specific treatment to a specific patient.
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
The largest land mammal is the African Elephant. The average adult has a mass of 5,400 kilograms. Express this mass in grams.
-
Management of Mittel Company would like to reduce the amount of time between when a customer places an order and when the order is shipped. For the first quarter of operations during the current year...
-
Algebraic Representation: Write the function that gives the height of water at a given time t measured in minutes for a tank that is 5 ft in diameter that has 4 feet of water in the tank at the...
-
On December 31, 2021, there is a batch of commodities sold under FOB destination conditions in the shipping area, and this batch of commodities is not included in the inventory count middle. There is...
-
Analysis of Subsequent Expenditures Plant assets often requires expenditures subsequent to acquisition. It is important that they be accounted for properly. Any errors will affect both the balance...
-
A manufactured component has its quality graded on its performance, appearance, and cost. Each of these three characteristics is graded as either pass or fail. There is a probability old.40 that a...
-
Kemesia Boota Ward signed a contract on February 17, 2010, to hold her wedding reception at the Deauville Hotel on July 9, 2010. (The wedding ceremony was being held elsewhere.) Renting the ballroom...
-
On January 1, 2014, O'Brien Company issued a $210,000, six-year, 9% installment note to Bulldog Bank. The note requires annual payments of $46,813, beginning on December 31, 2014. Journalize the...
-
6. 7. 8. 9. You are given a converging lens with equal radii of curvature and a diverging lens with the same radii of curvature as those of the converging lens. The lenses are made of material with n...
-
The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...
-
Franklin Inc. manufactures 2 types of lamps. The company is budgeting for the upcoming year that they will likely sell 6 0 , 0 0 0 luxury lamps, and 1 4 0 , 0 0 0 units of the basic lamp. The company...
-
A special 4to6-line decoder is to be designed. The input codes used are 000 through 101. For a given code applied, the output D i , with i equal to the decimal equivalent of the code, is 1 and all...
-
Harvey is a self-employed accountant with earned income from the business of $120,000 (after the deduction for one-half of his self-employment tax). He has a profit sharing plan (e.g., defined...
-
Meredith, who is single, would like to contribute $5,500 to her Roth IRA. What is the maximum amount that Meredith can contribute if her AGI is $117,000?
-
Historic Philadelphia is a booming travel destination. Among the many sites tourists visit while in one of the nations oldest cities is the Granovetter Church, a partially restored building nearly...
-
Search the Internet for a U.S. 801(k) plan. Explain what it is.
-
Find the domain and the range of the relation shown on the graph to the right. Use the vertical line test to determine whether the graph is the graph of a function. A OB. The domain of the relation...
-
Vectors are drawn from the center of a regular n-sided polygon in the plane to the vertices of the polygon. Show that the sum of the vectors is zero.
-
There is a strong movement toward wireless mobile computing using thin-client technology. Go to the Web and visit some of the major computer vendors that are producing thin-client products such as...
-
List the deliverables from the conceptual data modeling part of the analysis phase of the systems development process.
-
Why do corporations rely so heavily on vendor support?
-
Action Quest Games adjusts its accounts annually. The following information is available for the year ended December 31, 2025. 1. Purchased a 1-year insurance policy on June 1 for $1,800 cash. 2....
-
With each pass of a comet about the Sun, the comets mass (a) remains virtually unchanged. (b) actually increases. (c) is appreciably reduced.
-
Why is carbon such a special atom?
Study smarter with the SolutionInn App