Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help putting this into a normalized E-R diagram that uses crows foot notation. In addition, the pharmacists in each store are responsible for

image text in transcribedimage text in transcribedI need help putting this into a normalized E-R diagram that uses crows foot notation.

In addition, the pharmacists in each store are responsible for determining the minimum stock levels that should be maintained for each drug item based on their knowledge of their customer's needs and seasonal variations. The actual quantity on hand of each drug item is currently estimated; an accurate inventory is desirable to facilitate timely reordering. A listing of sample drug product data is shown below Each patient's prescription history is recorded using patient prescription profile cards. These are 8Vi" by 11" cards, kept in a counter-top file box, arranged alphabetically. These must be updated each time a prescription is filled or any other information about the patient changes, so that the pharmacist knows how often the patient has received certain medications and what other drugs are being prescribed for the patient, to allow the pharmacist to check for potential drug interactions. A copy of a patient profile card is shown below The typical procedure for the filling of a prescription is as follows: verify the patient's name and address written on the prescription order when presented by the patient retrieve the patient's prescription profile card (or prepare a new card if patient is new type the prescription bottle label get the product from the shelf put the appropriate amount in the patient's bottle use a numbering stamp machine to assign a sequential prescription number which must be posted on the patient profile card, the prescription order form, and the label on the prescription bottle price the prescription record the prescription information and price on the patient profile, the daily transaction log (a listing of data on all prescriptions filled that day), the prescription receipt, and the prescription order form prepare an insurance claim form (in addition to the simpler payment receipt) for those customers who have prescription insurance coverage (about 30% of the customers have health insurance that covers prescriptions; the patients pay cash for their prescriptions and then submit the standard claim form to their insurer for reimbursement re-file the patient profile card alphabetically file the prescription order form numericall present prescription to patient and collect payment for If the prescription is for a controlled substance, additional paperwork must be done. The prescription order must be marked with a red "C" letter stamp and the dispensing information (Rx number, drug name, strength, and quantity dispensed) must be entered into a controlled substances daily log form so that government pharmacy inspectors are able to determine what, and how many, controlled substance prescriptions are filled on a daily basis Additionally, the pharmacist must flag the drug for re-order if the quantity on the shelf is below the minimum stock level for that item and post the drug NDC number and quantity of packages desired in the order book (a loose leaf notebook) The orders are then phoned in to a drug wholesaler at the end of each day. Each such order is assigned a unique order number, which is formulated as the center number, a dash, and a four-digit sequential number (e.g., 2-0187). In addition to the order number, also recorded are the date the order was placed and the Vendor ID of the wholesaler with which the order was placed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Driven Web Sites

Authors: Mike Morrison, Joline Morrison

1st Edition

061901556X, 978-0619015565

More Books

Students also viewed these Databases questions