will work in both directions . Make sure to use Crow ‘ s Feet notation in your ERD .
Narrative / Case Study
The University Medical Center is a small , community hospital . A new hospital administrator has recently been hired by the Board of Directors , and directed to right-size patient care and pharmacy services and improve profitability . The hospital operates three clinical facilities : the main hospital , a mid-town clinic , and an Urgent Care location . The hospital also offers selected in-home care services . Many of the patients are repeat or regular patients who receive regular treatment for various conditions , and many utilize the hospital ‘ s pharmacy services for prescription medications .
The pharmacy dispenses about 3,000 different prescription medications of various kinds . Every prescription is associated with one patient , and is logged by the dispensing clinic . The new administrator wants to know which drugs are most prescribed , and also which are the most profitable .
The following is some general information about the organization and its current processes .
• The hospital operates three clinical facilities .
• 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 .