Terrapin Hospital needs to redesign their control database. The following information has been uncovered:

• Each hospital employee is assigned to work in one or more care centers. Each care center has at least one employee and may have many. The hospital records the number of hours per week that a given employee works in a particular care center.
• Each care center has exactly one employee who is designated Nurse in Charge for that center.
• Each care center may or may not have beds.
• A given patient may or may not be assigned to a bed (since some are outpatients). A bed may or may not be assigned to a patient.
• A patient must be referred to the hospital by exactly one physician. A physician may refer any number of patients or may not refer any patients.
• Physicians may perform any number of treatments on behalf of any number of patients or may not perform any treatments. A patient may have treatments performed by any number of physicians. For each treatment performed on behalf of a given patient by a particular physician, the hospital records the following information: treatment date, treatment time, and results.
• A patient may optionally consume any number of items. A given item may be consumed by one or more patients, or may not be consumed. For each item consumed by a patient, the hospital records the following: date, time, quantity, and total cost (= quantity * unit cost).

Draw the ER diagram for this Terrapin Hospital:

• Use the UMD Lucidchart to design the ER diagram.
  • UMD Lucidchart accounts are hosted by Lucid and managed by UMD's Division of IT.
  • http://it.umd.edu/lucidchart
• Include entities, attributes and relationships.
  • Primary keys:

Come up with appropriate primary key for each entity type. (Typically, entity ID or a composite key.)

A simple primary key should be indicated with {PK} after the attribute name.

A composite primary key should be indicated with {PPK} after every attribute names.

Other attributes:

Add more attributes that you believe each entity and relationship type should have. However, please do not add too many. You should add all attributes required by statements above.

Derived attributes should be indicated with {Derived} after the attribute name.

• Specify multiplicity on every relationship – i.e., cardinality and participation.

 

 

Hours
EMPLOYEE
EmpID(PK)
CARECENTER EmpNAme Assign CareCenterID(pk)
CareCenterID Nurse_In_Charge Has
BED
BenNo(PK)
RoomNo PHYSICIAN CarecentID(FK) Physician_ID(Pk)
Physician_Name Is_Assigned
Quantity
PATIENT
Date Consumption Patient_No(PK)
Patient_Name Perform
Total_Cost Result ITEM Treatment_Time Treatment_Date ItemNo(PK)
Description
Unit_cost TREATMENT
Treatment_ID(PK)
Treatment_No
Treatment_Name

• 1494464782-ERD .pdf

ComputerScienceExpert

(11)

Status NEW Posted 11 May 2017 01:05 AM My Price 9.00

-----------

Attachments

file 1494464780-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer