Data Model and Data Flow Diagram Assignment

Undergraduate
Essay
Miscellaneous
Pages 6 (1506 words)
Download 0
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)…

Introduction


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. ...
Download paper
Not exactly what you need?

Related papers

Data Mining
The computing power is increasing at the rate specified by Moore's law, doubling every eighteen months. The technology upgrade to parallel processing has vastly contributed to more powerful machines. There have been a number of statistical applications and algorithms that were waiting for larger computing power to arrive. Data mining makes use of these algorithms to enable data mining…
Groupbased assignment for Financial data analysis
The report analyses the risk and return of these two companies. Then the cost structure of these companies is compared. The first part of the report focuses on calculating the means and the variances of the two companies. 'Mean' provides a measure of average return to investors while the 'variance' and hence the 'standard deviation' indicate risk. The second part of this report focuses on…
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…
Data Security
The purpose of this report is to research the necessary solutions and to provide recommendations for management team.…
Data Model
Database management system for the fitness centre is intended to track people's participation in various fitness activities. So it should include at least entities for fitness activities, members and trainers of the centre and usage of the activities by members and their trainers.
Horizontal Flow, Inwardoutward Flow, Vertical Information flow, and Downward information Flow of financial data in the Kuali system
There are essentially four different groups involved in the Kuali process: the initiator, the department representative or BSC, the account manager, and the DFA. Horizontal flow would occur between any individuals that are contained within the same group. For example, an initiator sharing information with a co-worker on the same level or an account manager sharing information with another account…
Data Model for Fitness Centre
It is only for the targeted people. This means that to attract new customer, one need to do target marketing. The basic requirement of target marketing is the identification of the prospect clients.…