• Each medication dispensed by prescription is linked to both the prescription number and the medication ID number , recording the item price and the quantity dispensed .
As a convenient and affordable means of providing hospice care , palliative care , and convalescent care to patients that need occasional / intermittent skilled nursing , but do not require hospitalization , the hospital offers limited in-home care . Recording of in-home care includes the healthcare worker ID , their departure time and return time , and also the prescription ID for any prescriptions administered by the healthcare worker in the home setting .
The hospital administrator would like to know what home-care visits have been made to whom , by whom , when , and how long they took . There is concern at this point that the cost of providing limited home healthcare is not providing adequate return on investment , and the program should be revised or discontinued .
Requirements
You have been asked to develop a logical data model for University Medical Center based on the information given to you by the new hospital administrator and their staff . Through analysis of the nouns and verbs in the case study above , you have accumulated the following entity , attribute , and relationship information shown in the table below . The attribute list may not be complete . If you determine that additional attributes are needed to better define an entity , then you should add them .
Entities Attributes and Relationships for University Medical Center ( Parallel Lab Exercise ):
Entity Attributes Relationships