Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help putting this into a normalized E-R diagram that uses crows foot notation. In addition to the care provided to the patients by
I need help putting this into a normalized E-R diagram that uses crows foot notation.
In addition to the care provided to the patients by the contract physicians and employee nurses, UMC also provides pharmaceutical services. Each center operates a pharmacy in the same building as the clinic facilities. UMC employs licensed pharmacists to fill prescriptions for its patients in these pharmacies Only prescriptions written by UMC physicians for UMC patients are filled at these pharmacies. This allows the pharmacies to maintain a relatively restricted inventory of medications, as they can tailor their stock to the drugs of choice of the physicians contracted with by the centers. Patients can, however, fill their prescriptions at pharmacies not affiliated with UMC ifthey prefer. Although the pharmacies carry some medications that do not legally require a prescription to purchase (e.g., topical antibacterial creams), company policy requires that all medications dispensed from a UMC pharmacy to a patient require a prescription order by one of the UMC physicians Each new order is assigned a unique prescription number. This number begins with a letter signifying which of the center pharmacies filled the prescription (A is used by the first center, B by the second center, etc.) followed by a five digit sequential number that originally began at each center with 00001 and is incremented (e.g., A00002, A00003, etc.) for each new prescription filled. Each prescription indicates which physician wrote it and the name of the patient for whom the medication is intended. The medication itself is, of course, specified on the prescription, as is the quantity to be dispensed and the instructions for use. Also necessary to record is which pharmacist filled the prescription and the price charged for it For medications that legally require a prescription, the price is calculated as the wholesale cost of the medication plus a $3.00 dispensing fee. For medications that do not legally require a prescription (so called "over the counter, or OTC drugs), the price is wholesale cost plus 30 percent Another company policy forbids "refills" of UMC prescriptions. Thus, a given prescription can only be filled once. Should a UMC physician desire to provide more ofthe same medication to the same patient (e.g., on a subsequent visit), then they must write another prescription. A copy of a prescription order form andthe associated prescription bottle label is shown below The drug inventory at each UMC pharmacy must also be properly tracked. Each drug (both prescription and non prescription is uniquely identifiable by a code called an NDC (National Drug Code) number. This is a number assigned by drug manufacturers that follows a standard format: five digits comprising a manufacturer code, a dash, four digit comprising a product code, another dash, and two digits comprising a package code. (Example for Amoxil 250mg in a bottle size of 100 capsules: 00029-6006-30.) Other facts maintained for each medication item are: drug name/strength, package quantity, unit (e.g., tablet, gram milliliter, etc.), and average wholesale price (AWP) per package size. The AWP for all drugs is readily obtainable from published catalogs. Although small differences in pricing exist between wholesalers, AWP is commonly used as a pricing basisStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started