Design e-r diagram to review hospital documents

Assignment Help Software Engineering

Reference no: EM1367097

1. Draw an E-R diagram for the following situations.

From discussions with hospital staff, reviewing hospital documents and studying existing information systems, the study team developed a list of business rules describing the policies of the hospital and nature of the hospital's operation that govern the relationships between entities. Some of the rules are:-
• A facility maintains a number of laboratory(ies) : radiology, electrodiagnosis, hematology and so on.
• A facility contains a number of wards (obstetrics, emergency, rehabilitation, geriatrics, etc).
• Each ward is assigned a certain number of staff members (nurses, secretaries, etc); a staff member may be assigned to multiple wards.
• A facility staffs its medical team with a number of physicians. A physician may be on the staff of more than one facility.
• A physician treats patients and a patient is treated by any number of physicians.
• A physician diagnoses patients and a patient is diagnosed by any number of physicians.
• A patient may be assigned to a ward (outpatients are not assigned to a ward). The hospital cares only about the current ward a patient is assigned to (if assigned at all).
• A patient uses medical/surgical items, which are supplied by vendors. A vendor also provides supply items that are used for housekeeping and maintenance purposes.
• A laboratory performs tests about patients.

Reference no: EM1367097

Questions Cloud

Write table in dbdl notation after applying methodology : Proceed with all steps in information-level design to add this user view to existing cumulative design. Is this table in1st NF?___No____ . If Yes skip. If not, write Table in DBDL notation after applying the methodology we use for converting into 1NF..

Agent relationship in aging services : Describe the problems which could exist in the principal and agent relationship in aging services like case manager and an nursing home.

Country economic and trade summary reports : Global marketing managers must understand economics and trade rules of countries and regions within which they trade.

Positive clinical and financial outcomes : The evolution of health care delivery models has resulted in positive clinical and financial outcomes across the continuum of care. Recognize one health care delivery model.

Design e-r diagram to review hospital documents : Design an E-R diagram for the following situations. From discussions with hospital staff, reviewing hospital documents and studying existing information systems, study team developed list of business rules

Environment-fit model : Person-Environment Fit: Please thread your respond onto this question---- Your 90 year-old grandmother will be visiting your home. Based on the environment-fit model

Find the equilibrium interest rate : The consumption function is given by C = 200 + 0.75(Y - T ). The investment function is I = 200 - 25r, r is the real interest rate. Government buy and taxes are both 100.

Description of one intergenerational program : Using the library data base search engines or the internet, find out a description of one intergenerational program.

How operating system is clearly superior for any application : Consider the advantages and disadvantages of each major operating system that Amy might use on the Web server. If you don't think that one operating system is clearly superior for this application, describe why.

User Account

All Pages