Using ERDPlus:

Mountain View Hospital (MVH) records information regarding each patient stay in their hospital.

-When admitted to the hospital, patients provide personal information (e.g., name, address, SSN, insurance, etc.).

-MVH hires doctors to care for patients in their hospital and records typical personal information as required by the government (e.g., name, address, SSN, license, etc.).

-Medicaid dictates a list of procedures and codes which the hospital must use for billing purposes. Insurance companies accept the list as the set of all possible reimbursable procedures.

-MVH stocks certain medical supplies which are required for patient care such as syringes, bandages, braces, etc.

-MVH has an inventory of rooms in which patients are housed for their stay. These rooms have different designations (e.g., in the cardiac wing, only patients with heart problems are housed, in pediatrics only children under the age of 14 are housed, etc.)

The business rules for MVH are:

-A patient is not assigned any particular doctor. However, a specific doctor must order any procedure which is performed for a patient. A patient may have many procedures ordered by many doctors, or may not have any procedure ordered by any doctor. A doctor may not have ordered any procedures for any patients. A procedure may not have been ordered by a doctor for a patient. MVH needs the date and time recorded for any procedure ordered by a doctor for a patient.

-When admitted to MVH each patient is assigned to a specific room. A patient is not admitted until there is a room for that patient. A room may have housed many patients over time, or may not have ever housed a patient. Because a patient may have been admitted to the hospital many times over the course of their life, he or she could stay in different rooms. The hospital needs to record the date the patient is admitted to a room.

-During the course of a patients stay at MVH, different supplies may be used for that patient. A supply item may not have been used, but can be used by only one patient.

Be sure to:

-Convert all many-to-many relationships and ternary (three-way) relationships to associative entities.

-Convert all multivalued attributes to entities.

-Specify the maximum and minimum cardinality for each relationship.

-Show the attributes associated with each associative entity (i.e., the many-to-many entity or the ternary entity) if any.

Do not show any attributes other than primary keys and foreign keys for the other entities.