StudentShare solutions
Triangle menu

Data Model and Data Flow Diagram Assignment - Essay Example

Not dowloaded yet

Extract of sample
Data Model and Data Flow Diagram Assignment

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 customer 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 ...Show more

Summary

PresRX is a new online pharmacy that wants to provide prescription and non-prescription drugs to Canadian consumers. When a customer goes online, he is shown the drugs PresRX sells. To make the shopping easy, we allow the customer to search our products based on the following categories: pharmaceutical company, product type (prescription or non-prescription), drug type (antibiotics, antidepressant drugs or vitamins or cold/ flu drugs etc.), problems (like allergies or pain relief etc.) and the main ingredient (like penicillin)…
Author : muhammadconn
Data Model and Data Flow Diagram Assignment essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Data Model and Data Flow Diagram Assignment"
with a personal 20% discount.
Grab the best paper

Related Essays

Data mining Assignment
Many people especially the old have fallen victims due to fraud. This is because this group of people has irregular checks of their cards and bank accounts. Most of the time these people are assisted by people whom they trust to perform their transactions who later becomes the perpetrators.
9 pages (2250 words) Essay
Data Warehouse assignment
It was analyzed that there was a correlation of 0.76 between the measures: sales amount and sales quantity. This significantly high correlation value means that the higher the sales quantity, the higher the sales figure. Though this is a logically true relationship, the fact that this is one of the findings from the data in the warehouse makes it an analysis of the data from the data mart.
11 pages (2750 words) Essay
Data Model
2 pages (500 words) Essay
Data
2003) Hunerbein, M, C Stroszczynski, C Ulmer, T Handke, R Felix, and PM Schlag. "Prospective comparison of transcutaneous 3-dimensional
2 pages (500 words) Essay
Secondary Data Analysis Assignment
CANI provides marketing research and consumer classification data. In the following I will present some data analysis based on 2001 census data and then some information from ACRON. This practice will help
6 pages (1500 words) Essay
Managing Data Assignment
The key purpose was to not only learn the interpretation and re-presentation of data, but also improved our skills in accurately understanding and recording data (Ferrari, 2010). The course comprised of three managing data workshops where we put into practice. These were
4 pages (1000 words) Essay
Managing Data Assignment
We made notes on the information we got from the segment and then asked to answer questions on low energy light bulbs. The questions were; 1.Are low energy light bulbs as efficient as incandescent
3 pages (750 words) Essay
Data Flow Diagram Level 1
Moreover, the chosen identifier has a data type of ‘Number’, and it is recommended that the value of the identifier should incremented automatically upon addition of each record. In this case, the identifier is not required to be
6 pages (1500 words) Essay
RELATIONAL DATA MODEL
The most basic step towards using the oracle database management system is to install the system in the computer and be able to run it and use it to carry out
2 pages (500 words) Essay
Data Flow charts
To create better and understandable flowchart the following simple guidelines must be adhered to; Complex DFD are done through a
2 pages (500 words) Essay
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation