StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Data Model and Data Flow Diagram - Essay Example

Cite this document
Summary
This essay "Data Model and Data Flow Diagram" presents 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…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER96.2% of users find it useful
Data Model and Data Flow Diagram
Read Text Preview

Extract of sample "Data Model and Data Flow Diagram"

Data Model and Data Flow Diagram for PresRX Case: 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). Each product also has the strength of the main ingredient (e.g. Allegra 30 mg, Allegra 50 mg etc.). The same product with different quantity in each package is treated as a separate product (e.g. Allegra 30 mg with 10 pills is different from Allegra 30 mg with 20 pills). 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 can be abused, we want to monitor (via regular reports) the hospitals and the doctors that give out most PresRX, the drugs they give the PresRX for and the customers that appear with multiple clinics/physicians for the same drug. We also want report on the orders we place with the suppliers. The main attributes are: CUSTOMER: name, date of birth, gender, email address, address, city and province of residence PHYSICIAN: name, address, physician id info including clinic of practice or hospital of practice DRUG: description DRUG INTERACTION (CAL) - what types of drugs customer could potentially be allergic too DRUG- description DRUG TYPES (CSL) -drugs available ENROLLMENT- enrollment number ORDER SECURITY (SSL)- secure payment information for transactions PAYMENT- customer id, date created, date due, amount due, amount paid and payment method (M/C or VISA) First: Entities: Customer Shipping (since there are two different types of shipping: overnight or regular) Drug ordered Drug type Main drug ingredients and strength Pharmaceutical company Payment method Historical data (to keep a record for the customer and physician's portal for future orders) Drug interactions/allergies Physician (this includes the physician needing to authorize processing of prescription orders through the physician's portal) Next: Attributes: Customer: first name, last name, Date of Birth, Gender, Address, Email, place of residence (city, province, postal code) Physician: ID, first name, last name, address, city, province, postal code, phone number, email, clinic of practice Shipping: Methods (currently two that includes overnight or regular) Drug: Description Pharmaceutical company Historical Report: By customer ID and includes all drugs that have been ordered Drug interactions: allergies, etc. Main drug ingredients (e.g. Allegra 30 mg, Allegra 50 mg) Physician's Portal: by physician ID which includes what has been approved, etc. to eliminate prescription fraud 1. Customer sets up information and any drug interactions are entered into a database that is populated through the answer to a specific question when first registering. 2. The customer is given a shopping card 3. If any shopping cart items contain prescription drugs, the customer must provide the Rx of the physician (an alert is then sent to the physician's portal for validation and approval) 4. The customer can then select shipping methods they would prefer. Those products/drugs that are on time and temperature sensitivity, there will be no further option to select shipping as this will be automatically selected for the customer. 5. If there is insurance company information to be provided, this will be asked and then the insurance company contacted. 6. Credit card information will then be validated and authorized with that information being provided to the customer upon final check out 7. When your bank informs the customer service representative and customer that the order is paid for, the product will only then be shipped out 8. Every order that is created, the information is added to the historical information database for the customer to either have printed out monthly and sent via email or snail mail, or, it can be included each time with the orders. 9. The physician's portal will be alerted for each customer ordering a prescription drug and the customer will be notified that until the physician is contacted and approves the order, the prescription drug part of the order cannot be shipped. The customer can then be given the option of waiting to ship the entire order or do a partial shipment. Explanation Data flow 1: The data first goes into the process Data flow 2: The data comes out after the process has been finished Data flow 3: Data going into the process Data flow 4: Tables being updated and parents being sent the statement after the process of statement creation. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Data Model and Data Flow Diagram Assignment Essay”, n.d.)
Data Model and Data Flow Diagram Assignment Essay. Retrieved from https://studentshare.org/miscellaneous/1518246-data-model-and-data-flow-diagram-assignment
(Data Model and Data Flow Diagram Assignment Essay)
Data Model and Data Flow Diagram Assignment Essay. https://studentshare.org/miscellaneous/1518246-data-model-and-data-flow-diagram-assignment.
“Data Model and Data Flow Diagram Assignment Essay”, n.d. https://studentshare.org/miscellaneous/1518246-data-model-and-data-flow-diagram-assignment.
  • Cited: 0 times

CHECK THESE SAMPLES OF Data Model and Data Flow Diagram

Systems, Process & Data Modeling

It is the main concern of the following paper to explain a decomposition diagram and what it is used for.... This research is governed by the following research question, which will aid in attaining objectives and aim of the research: How can a decomposition diagram be used in the logical process formulation?... The notations being used for use case modeling are illustrated in the table below: Table 1: Showing grammatical constructs for Use Case diagram Using the notations mentioned in Table 1 above a use case model can be easily assembled....
13 Pages (3250 words) Research Paper

UML-Based Languages for Software Process Modeling

based design and modeling, the elements of a system are depicted in the diagram in defining the structure and model of the system as a whole3.... techniques include their elements and specific functions in illustrating different parts of a model of a system.... to design and model systems.... diagramming plays different roles in communicating the structure and design of the system model....
9 Pages (2250 words) Report

Management and Modeling of Oracle Data Modeler

Considering a data model, it is a flowchart or diagram that brings out the specific relationships present within data values.... It provides database-specific kind of representation of a data model.... This implies that outputs like XML Schemas (XSD) and Entity Relationship Diagrams (ERDs) are used to provide data model outputs.... The paper "Management and Modeling of Oracle data Modeler" focuses on the environment provided by the Oracle program....
12 Pages (3000 words) Assignment

The Structure of the E-Consignment System from the Standpoint of the Process Logistics Strategy

he data flow diagram modeling is a top-down decomposition technique, which results in process descriptions.... To create the data flow diagram we will undertake the following steps: define the target system, identify the main processes and activities (sub-systems) within the system, decompose each of the subsystems into constituent sub-systems or processes until the set of diagrams for the system which cannot be decomposed further is obtained.... ata flow Diagrams, as the name suggests, illustrates the flow of information in a system....
9 Pages (2250 words) Essay

IT425-1403A-01 : Systems Analysis, Design and Integration

A data flow diagram is well-drawn as it disintegrates the system into smaller parts called processes that characterize the pizza system.... The data flow diagram also provides a clear representation of the system.... The student uses the top-down expansion to accomplish the analysis in the best way possible (“data flow diagram Software”, 2014).... A data flow diagram is also simple and straightforward (Kozar, 1997).... tmData flow diagram Software, Create data flow diagrams rapidly with free examples and templates....
2 Pages (500 words) Assignment

Data Migration Between Clouds

Generally, the paper "data Migration Between Clouds" has provided an exploratory overview of the topic of data computing technology and described an effective model that can address the challenges associated with the Amazon cloud system considerably.... The study has described the Windows Azure platform that may be effective in transferring data among clouds.... Lastly, Cloud portability is primarily the ability to transfer data from one a cloud-managed by a particular dealer to the one serviced by a different dealer (Shroff, 2010)....
18 Pages (4500 words) Thesis

Web Development for Business

The information system was primarily defined through its functionality in which data and functions are kept separated.... The objects are illustrations of the classes, which contain data that again forms its attributes (Bharathiar University, 2015; Ambler, 1998).... On the other hand, the object-oriented system focuses on the objects that integrate data and functionality for the proper structuring of the models.... In the context of designing the environment based on object orientation, the software is a collection of separate and distinguished objects, which summarizes its data and functionality to reflect the real scenario objects....
12 Pages (3000 words) Coursework

Creating UML Diagram for E-bay

The UK site alone has been considered as a business organization and efforts have been made to model it with UML ( Unified Modeling Language) models and Business Process Modeling Notation ( BPMN ) including data flow diagrams and others.... Creating UML diagram for e-bay.... Creating UML diagram for e-bay.... The next section of the paper shows the various model diagrams of the chosen e-bay....
6 Pages (1500 words) Coursework
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us