Question: I need help getting this to normalized E-R diagram that uses the Crows Foot notation UNIVERSITY MEDICAL CENTERS (UMC) The Company Dr. Joanne Rover is





I need help getting this to normalized E-R diagram that uses the Crows Foot notation
UNIVERSITY MEDICAL CENTERS (UMC) The Company Dr. Joanne Rover is the owner and CEO of UMC, a chain of four medical centers located in Charlotte, North Carolina. The centers are for people without a regular family physician that need occasiona medical care. The centers fill a middle ground between traditional family physician practices and hospital emergency rooms. Most of the patients treated at UMC make advance appointments to be seen at a center. Walk-in patients are also accepted if there are available appointment slots. The centers are open fr om 9 a.m. to 7 p.m., Monday through Friday, and are closed on weekends and holidays Business Analysis Each of the four UMC centers has a unique Center ID number (1, 2, 3, or 4) assigned to it. All centers also have a name e.g., Foxtrot UMC), address, and phone numbe r. Each of the centers employs a number of personnel. Each employee falls into one of three distinct categories: administrative workers (e.g., managers, clerks, receptionists, etc.), nurses, and pharmacists. The company records several pieces of information about all its employees: social security number (which serves as an identification number name (first name, middle initial, and last name address, home and cell phone number, and the center at which the employee works. No employee works at more than one center Specific additional information is recorded for employees in each of the personnel categories. Administrative personne have their job title recorded. Nurses and pharmacists have both their license number and license expiration date recorded. The license numbers are assigned by the state and are codes that begin with two letters ("PH" for pharmacists and "RN" for nurses) followed by five digits, which are sequentially assigned to each new licensee in the state. A pharmacist license number example would be PH00178. Nurse and pharmacist licenses must be renewed every two years and UMC keeps track of the expiration dates in order to make sure that none of the nurses or pharmacists neglect to renew their license on time. Each UMC center is managed by one administrative employee In addition to these UMC employees, the company also requires the services of contract physicians. These doctors are not considered employees of UMC, but rather are paid as independent contractors to provide medical service at the four UMC centers. The company these records information on physicians, including their name, pager number, and specialty (e.g., cardiology, orthopedics, etc.). A physician may have more than one specialty. Each physician is uniquely dentified by their ML (Medical License) Number. This is a 2-letter+ r combination (e.g., AR1234563) that is assigned to licensed physicians by the federal Drug Enforcement Administration. The first letter is always "A" or "B" and the second letter is always the first letter of the physician's last name. These doctors are scheduled in advance to serve at the various clinics. They are not assigned exclusively to a single center, but may be assigned to different centers on different days, as demand requires. They may even, in fact, be assigned to one center for part of a day and another center for another part of the same day. Thus, the company needs to keep track of which physicians work at which centers on which days and the start time and end time for each assignmen The patients that are seen at the UMC centers must have information recorded about them, and about the appointments that they make to be seen for care Each patient, on their first contact with UMC, is assigned a unique six-digit Patient ID number (e.g., 100312). This number uses the first digit to indicate the UMC center (1, 2, 3, or 4) at which the patient was first seen. The rema ning digits are assigned sequentially Patients can make appointments different but their at centers, Patient ID number never changes, once assigned. Also recorded for all patients are their name, address, phone number, email, and insurance status (yes or no). Although all transactions with UMC are paid for directly by the patient if the patient has an insurance status of "yes" then the UMC personnel know to fill out special detailed receipts that the patient can then use to place a claim for reimbursement with their insurance company
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
