Data Model and Data Flow Diagram Assignment Essay

Data Model and Data Flow Diagram Assignment - Essay Example As the customer starts selecting products, the customer is given a "shopping cart". At the end, the customer can check out the shopping cart. At this time, he will be asked for personal information as well as login information for future purposes. The personal information includes the email, gender and date of birth in addition to the usual personal information needed for online shopping. He is also asked for credit card information (PresRX accepts only Master, Visa and American Express). Since PresRX also sells prescription drugs, if the "shopping cart" for the customer contains a product that is available only by prescription, the customer must provide the physician's information as well. This information will include the physician's name, address, specialty, phone number, email, fax number and hospital/clinic affiliation (we care about only the clinic that our customer goes to). (If the physician's info is not provided, we will contact the customer and obtain the info.) The custom er can also select the shipping method: we provide overnight, standard air and standard ground. For some of the drugs that are time and temperature sensitive, the customer will not be able to select the shipping method: the shipping method will automatically be chosen. The products will always be shipped to the person who orders them. If the customer wishes to use his insurance to make the purchase, we obtain the insurance company information as well as the insurance number and we will validate it by contacting the insurance company. Once the credit card is validated, we request validation from the insurance company on the prescription, physician on the prescription and validation of the physician from the hospital/clinic (to prevent fraudulent prescriptions). This is done via an automated email sent to the clinic as well as the physician. If emails are not made available, one of the employees will fax the request. This request will contain the drug requested, the quantity ordered, date it was ordered and the customer's name, address and phone number. The insurance company is called. We do this every time the person shops. The physician's office is given access to a physician's portal where his office can approve the prescription drug order. On approval, the drug is packed and shipped to the customer. The physician's portal is available where physicians can log in to not only approve the prescription request but also to renew the prescription for their patients. We also need to obtain supplies regularly. The reordering is based on need, triggered by low stocks. The system will have to reorder from the supplier via automatic ordering. As the products are shipped to our customers, the system updates the product quantity and as soon as the quantity goes to a pre-set "low" (different for each product), the system will immediately send an order to the product's supplier. Since we handle brand items, each product will have only one supplier. For each product we receive, our employees will update the product quantities in our system. The employees doing this will be the warehouse managers and we need to know who entered which batch of received shipments. Since prescription drugs