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
HealthcareWorkerHealthcareWorkerID , LastName , FirstName , SSN , Address , City , State , Zip , Phone Number , HealthcareWorkerTypeID A healthcare worker can belong to any one of the three job categories , but can belong to one and only one of the three . healthcare worker has names and other contact information .
HealthcareWorkerTypeHealthcareWorkerTypeID , HealthcareWorkerTypeDesc , HourlyBillingRate A healthcare worker can be either a physician ( diagnoses , prescribes medication ), nurse