• A healthcare worker logs in at a facility at the start of a shift and logs out at the end .
• The name , address , Social Security number and other information is recorded for every healthcare worker .
• All healthcare workers have one billing rate , which is determined by their job description .
• 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