The tears relations Ea me em ho gi na A ( s se as A A P P After completing a course in database management , you have been hired as a summer intern by Mountain View Community Hospital. Your first assignment is to work as part of a team of three people to develop a high-level E-R diagram for the hospi- tal. You conduct interviews with a number of hospital adminis trators and staff to identify the key entity types for the hospital. You have also seen the preliminary enterprise -level diagram shown in MVCH Figure 1-3 and subsequent revisions. As a result, your team has identified the following entity types: Care Centera treatment center within the hospital. Examples of care centers are maternity, emergency care, or multiple sclerosis center. Each care center has a care center ID (identifier) and a care center name. Patienta person who is either admitted to the hospital or is registered as an outpatient. Each patient has an iden- tifier, the medical record number ( MRN), and a name. Physician a member of the hospital medical staff who may admit patients to the hospital and who may adminis- ter medical treatments. Each physician has a physician ID ( identifier ) and name. Beda hospital bed that may be assigned to a patient who is admitted to the hospital. Each bed has a bed num- ber ( identifier) , a room number , and a care center ID. Item any medical or surgical item that may be used in treating a patient . Each item has an item number (identi- fier), description , and unit cost. Employee any person employed as part of the hospital staff. Each employee has an employee number (identifier ) and name. Diagnosis a patient’s medical condition diagnosed by a physician . Each diagnosis has a diagnosis ID /code and diagnosis name . Mountain View Community Hospital is using the HIPAA – mandated ICD -9 -CM Volume 1 diagno- sis codes for patient conditions ( e.g., 00.50 , STAPH FOOD POISONING , 173.3 , BASAL CELL CARCINOMA , 200.2 , MALIGNANT MELANOMA , BURKITT’S TYPE or 776.5 . CONGENITAL ANEMIA ) Treatment any test or procedure ordered by and / or per- formed by a physician for a patient . Each treatment has a treatment ID/ treatment code and treatment name using standard codes . HIPAA -mandated ICD – 9- CM Volume 3 Procedure Codes are used for diagnostic and therapeutic procedures ( e.g. 03.31 , SPINAL TAP 14.3 , REPAIR OF RETINAL TEAR , 87.44 , ROUTINE CHEST X -RAY , or 90.5 MICROSCOPIC EXAMINATION OF BLOOD ) Order any order issued by a physician for treatment and / or services such as diagnostic tests (radiology labo- ratory ) and therapeutic procedures ( physical therapy diet C Case
[Verified Answer]: The tears relations Ea me em ho gi na A ( s…
Need help with your Neurological Disorders case study or NCLEX preparation? Connect with a verified Nursing expert now.