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 these entities. Some of these rules are:A facility maintains one or more diagnostic units (radiology, clinical laboratory, cardiac diagnostic unit, etc.).A facility contains a number of wards (obstetrics, oncology, 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).A physician writes one or more orders for a patient. Each order is for a given patient, and a patient may have many orders. Identify entities, attributes, constraints & relationships and draw ERD

Answered: From discussions with hospital staff,…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

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 these entities. Some of these rules are:

A facility maintains one or more diagnostic units (radiology, clinical laboratory, cardiac diagnostic unit, etc.).
A facility contains a number of wards (obstetrics, oncology, 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).
A physician writes one or more orders for a patient. Each order is for a given patient, and a patient may have many orders.

Identify entities, attributes, constraints & relationships and draw ERD

Expert Solution