Big Data

The breadth of centers MEMO inventory that encompasses on the whole wireless skirt nonices is unmatched in the wireless nettleory application. 1. 2 Executive Summary This document represents the artifacts collected for the customer Cell Phone Accessories Purchase Project at Accessories Fulfillment pennyer (AFC) located in Houston, TX. AFC take to have a plan that allow engage its customer to get satisfactorily business experience. The bearing of this project is to develop a high aim training flow de scar from the customer first appearance into the vane ordain to the successful purchase. Our mission is to create cling to.We want to deliver a service where customers sack find and realize every cell phone take ins that they might want to taint online, and endeavors to sally its customers the lowest comply-at- competent expenses. Every client has their own highly complex fulfillment and logistics challenges and we are here to help add-on operating income, lever age return on investment, improve market agility, and fall upon higher levels of customer service. We conceptualize that our customer This paper leave highlight the information elements needed to support such a program as well as the contracts and sub-entities that come into play.It will focus initially on the interactions compulsory among our customers and arrangings as well as the methods they may practice session to make these purchases. Next it will discuss the information elements that deed to be considered in these transactions. We will provide a fully attributed Entity Relationship Diagram (RED) masking the entities, primary and foreign keys, as well as the individual information attributes needed by each(prenominal) entity. We will similarly blanket the contracts held between these entities. A Data Flow Diagram ( videodisk) will in addition be provided to depict the flow of information through the clays and the work / processing performed by the system.This will cover the logical design of the system. Finally, we will discuss our decision epitome with a matrix of potential solutions and the concluding decision we landed on. . 3 Problem statement M any companies and institutions have lack of designed web based application that pile help and offer check service to customers employees and administers. As AFC Houston, its official site of AFC web retributive tests the basic information of the company and the variety of product. If customers need to buy accessories from AFC, they have to repulse to AFC or make phone call to AFC. As we stub see the AFC web is non customized and ineffectively to increase sale.So the main problem is the company needs an online obtain system in which weed show office web information and has unctions such as product lookup, customer registration, product ordering and online pay. With the bare-assed system, AFC screwing create value and offer customer a better obtain experience. 1. 4 precondition There are two assumptions we assume for establishing AFC online obtain system 1 . It is common for company to engage network technology to digitize system of information management. 2. The customer prefers to use online obtain system to achieve the purchasing activity.Online Shopping System Requirement Analysis 2. 1 Requirement Definition E-commerce makes our shopping experiences more convenience, fast and versification. AFC online shop system not only needs to have the basic functions of identify the AFC online shopping system flow in Figure 1 . Then we fix the functional requirements and non-functional requirements. 3 AFC online shopping system flow 2. 2. 1 Functional Requirement According to the characteristic of AFC online shopping systems basic process, we define some essential components for system function. 1 Only the constituentship can use the function of shopping pushchair. Products information needs a classification to users search. 3 Shopping cart needs serial depend. Members can inquire the order. Considering these components, the main functions of the AFC online shopping system are embodied in the operation of providing, saving, updating and inquiring which include member information management, product information management, shopping cart management, order management and payment method. The figure 2 shows the frame of system function module. 4 System Function Module We can conclude more functional requirement in detail from the plot above. ) Member Register and Login to begin with youthful user puts the products into the cart, the system will guide the user to sign up the new neb part. New user has to fill in the information such as surname, password, Email address, phone number. The animated member then needs to enter the correct surname and password. The system will check the information and authorize the member to log in. B) Modify Members Information User can modify their registration information after log in which includes surname, c) Administrator User Administrator is a special user it can manage normal account, classify the products and deal with order. ) Browse the product All the guest and member can browse the products. E) Manage shopping cart Add products into shopping cart Browse the shopping cart Member can see the list of shopping relic includes quantity, serial number, and total price in their own shopping cart. Delete the products Edit the quantity of product Clear the shopping cart f) erect processing System will generate the order after member go to check in shopping cart. The system provide the function of inquire order to members after they complete the purchasing activity. ) stipend Method The system will allow member pay the product by Credit Debit tantalise payment or Papal. 2. 1. 2 Non-functional requirement a) Operational management The system should run on any PC, proroguet Pc, mobile phone which can be connected to internet. MISSES 6 Final Project The system should always be monitored by one of the administer during its working time. B) Security No members can access any other members personal information and purchase record. All the personal information filled in AFC web Just can be seen by registrants himself and the administer who has been authorized.The information should be protected during contagious disease by Secure Sockets Layer(SSL) parcel, which encrypts information member input. C) Cultural and Political All content included on AFC site, such as text, graphics, logos, button icons and images is the property of AFC s content suppliers and protected by the United States and supranational copyright laws. customer satisfaction is Oafs goal. All the question and complaint that the system received will be deal within 48 hours. 3. Orders are guaranteed to ship within 1-2 days.The Entity Relationship Diagram helps us better to understand our data cut ind into the database. Each entity table specified is on the basis of requirements needed t o fulfill our Customer Online Shopping System. For instance, Product_Detail entity table represents the information that needs to store for every new product, it can be update or deleted. Same with Member_Detail entity table, it is required to store data for every new customer willing to become member of the company. The Member entity table represents data that is unique for every member of the company, e surname and password.The Cart_lutes entity table represents the number of different products that a customer wants to have in his shopping cart. The Shopping Cart entity table has all the information of various products kept in the cart y the customer. It is nothing but the shopping understructure with all the purchase details in it. Payment entity table takes cares of the payment required to make by the customer for the purchase from the company. And 7 Order_Detail table shows the details of the purchase made by the customer.A customer can directly inquire the stead of his purch ase made from the company. Each attributes in the table includes the details required will be stored each entity. The following is the explanation of primary keys, foreign keys and cardinality of kin of each entity table ) Member prime find User_ID User can be of two types, either returning old customer or guest. Previous customer has their information available in system so they Just need to put their surname and password but for new customer we required to have all the basic information.Therefore, there is affinity between Member and Member Detail. B) Member_Detail Primary advert Member_old Foreign Key User_old. New customers willing to be member of the company need their data to be entered. There is relationship between Member and Member_Detail and IM relationship tit product. C) Product_Detail Primary Key Product_old All the wears and tears of the product need to be stored in this table. There is IM relationship with Member and MN relationship with Cart_lutes. D) Cart _lutes Primary Key Correlate_old Foreign Key Product_old.Product_Detail. E) Outcroppings Primary Key Cart_old Foreign Key Member_old, Correlate_old 8 There is IM relationship with Cart_lutes table, 11 relationship with payment and relationship with Member Detail. This table contains all the details of product that a customer is willing to buy. F) Payment Primary Key Payment_old. There would be 11 relationship between payment and Cart_late and also after successful verification of the payment, there is 11 relationship with the Order_Detail. G) Order_Detail Primary Key Order_old.There is 11 relationship with the payment and Ml with Member. A member can directly inquire for the status of his purchase with the order_old. The Entity Relationship Diagram for Customer Online Shopping system of Accessory Fulfillment Center is shown beneath in figure 3. 9 Entity Relationship Diagram Logical design Process Modeling (DVD) DVD is a graphical representation of the flow of data through an information system. Based on the functional requirement and RED, the processes and entity of AFC online shopping system is clear.We draw the context diagram and DVD level O diagram for our system. The context diagram defines how the electronic computer system interacts with its environment. In AFC case, external entities are the customer who will need the various services from the system, and the administration office who will manage and request the reports. The figure 4 shows how AFC online system interacts with guest, member and administer. Context Diagram The level O diagram shows all the processes at the first level of numbering, the data stores, external entities, and data flow among them.We define 3 external entities, 8 processes and 5 data stores. The system data flow starts from the customer browses AFC web and register the membership. Next the customer will claim the product to shopping cart then pay the product which will generate the order. Each order will have a unique number for customer to track the order activities. The number will also help administer to manage the order. Administer is external entities who will do he primer coat work such as manage the membership and deal with the order.The figure 5 and 6 will show each process pointt and the integrated level O DVD. DVD Fragment 1 Figure 6 Decision Analysis In order to measure how beneficial or realistic an information system will be to an organization, we consider conduct feasibility analysis on the AFC online shopping system. The feasibility analysis is an evaluation and analysis of the potential of a proposed project which is based on prolonged investigation and research to support the process of decision making. This part will elaborate the feasibility analysis from orotund dataData was only realized after the electronic scanners were multi-dimensional software were made broadly installed. superstar could range that the data were the available. Twenty-five years ago, Big Data genre - exhaust fumes resulting from the primary use of dated by PUC point-of-sale scanners changed the The scanners to eliminate the costs of price marking face of marketing in the consumer packaged goods Oust as today, Big Data are often defined to be data (CUP) industry by causing marketing spending to that are a by-product of the use of a computer to tilt ominously in favor of price discounts and away solve an operational problem). Cent years, from advertising. Today, real time digital Big Data generated by From the Analog Audit to digital Scanning the meshing offer the ostensible benefits of pro- The Impact on Short-term Marketing Strategies viding consumers with an easy way to find the in advance the approaching of scanner data, CUP marketers lowest price for any product while also armament had to hope on bi-monthly manual audits of stores marketers with dramatically expanded advertising to understand the trends in their carry gross sales and optimisation capabilities. Arr est share at retail (See Figure 1). The data were Marketers would be wise, however, to heed the sessions of write up and identify that for all the not available until six weeks after the end of the bi-month period. Benefits Big Data afford, they also come with per- Then, suddenly, retail merchants and manufacturers had Is that may not be as readily apparent. Ultimately, timely access to weekly (and even daily) scanner real-time digital Big Data must be used correctly if data.The coarseness of these new data all the way they are to have a positive impact on brand health revealed the substantial impact of short-term mar- and improve marketing return on investment (ROI) kiting tactics, including fugacious price reductions tooth today and in the future. Supported by newspaper advertisements (which communicated the price) along with prominent in- HISTORICAL thought store merchandising support-?often in the form of How the Availability of Data Has end-aisle displays (See Figure 2) .Transformed Markets Though auditing data showed a relatively stable Back in the sass, the motivation for retailers to bi-monthly sales trend, weekly scanner data clearly invest $1 50,000 to equip a typical supermarket with revealed the large and volatile sales increases that PUC scanners was not the value of the data they occurred when newspaper feature advertisements would obtain but rather the cost savings from not inform price reductions and in-store merchant- having to price mark each of the hundreds of thou- dosing support was implemented.Armed with this sands items on stores shelves. With scanners, it was type of gamy information, retailers were able to necessary only to display each SKU (stock-keeping twinge manufacturers for more trade-promotion units) price via a sign at the shelf because the check- dollars, and manufacturers-?as a result of the out cash register obtained the price for each undivided- tillers pressure along with their own desire for all item by looking up the items PUC recruit in the a short-term sales lift-?willingly increased their stores PUC/price file as the item was scanned.With this advent of these new data sources, CUP marketing Business often looked quite stable underwent a original marketing shift from advertising to price discounting. Bimonthly Brand Sales 50 Today, software fiend SAP GAG reports that the average CUP manufacturer spends fully 67 share of its marketing reckon on trade promotion and 10 percent on direct- $ Millions to-consumer promotions (mainly cents-off coupons), whereas less than 23 percent is 20 spent on branding advertising. With so 10 much being spent on retailer incentives that, in turn, then are used to temporarilyJan-Feb. Mar-Par May-June reduce price, the concern that resonates July-Gauge through the industry is that brand fair-mindedness Figurer Market Information in CUP Before Scanners Brand Sales metrical by Bimonthly Manual Store Audits is being eroded as consumers become trained to bu y on the basis of price discounts alone. Thats an unhealthy situation for any brand. Big Data in the Digital manhood but weekly scanner data revealed to retailers and manufacturers the huge short- term impact of trade promotions. 70 % ledger Sold (Newspaper/Display/Price Discount) Dollar Sales -10 Jan 12 Jan 19 Jan 26Big dataData was only realized after the scanners were multi-dimensional software were made broadly installed. One could say that the data were the available. Twenty-five years ago, Big Data genre- exhaust fumes resulting from the primary use of dated by PUC point-of-sale scanners changed the The scanners to eliminate the costs of price marking face of marketing in the consumer packaged goods Oust as today, Big Data are often defined to be data (CUP) industry by causing marketing spending to that are a by-product of the use of a computer to tilt ominously in favor of price discounts and away solve an operational problem). Cent years, from advertising. Today, real-time digital Big Data generated by From the Analog Audit to Digital Scanning the Internet offer the ostensible benefits of pro- The Impact on Short-term Marketing Strategies viding consumers with an easy way to find the Before the advent of scanner data, CUP marketers lowest price for any product while also arming had to rely on bi-monthly manual audits of stores marketers with dramatically expanded advertising to understand the trends in their brand sales and optimization capabilities. Arrest share at retail (See Figure 1). The data were Marketers would be wise, however, to heed the sessions of history and recognize that for all the not available until six weeks after the end of the bi-month period. Benefits Big Data afford, they also come with per- Then, suddenly, retailers and manufacturers had Is that may not be as readily apparent. Ultimately, timely access to weekly (and even daily) scanner real-time digital Big Data must be used correctly if data.The granularity of these new data clearly they are to have a positive impact on brand health revealed the substantial impact of short-term mar- and improve marketing return on investment (ROI) kiting tactics, including temporary price reductions tooth today and in the future. Supported by newspaper advertisements (which communicated the price) along with prominent in- HISTORICAL PERSPECTIVE store merchandising support-?often in the form of How the Availability of Data Has end-aisle displays (See Figure 2).Transformed Markets Though auditing data showed a relatively stable Back in the sass, the motivation for retailers to bi-monthly sales trend, weekly scanner data clearly invest $1 50,000 to equip a typical supermarket with revealed the large and volatile sales increases that PUC scanners was not the value of the data they occurred when newspaper feature advertisements would obtain but rather the cost savings from not announced price reductions and in-store merchant- having to price mark each of the hundreds of tho u- dosing support was implemented.Armed with this sands items on stores shelves. With scanners, it was type of granular information, retailers were able to necessary only to display each SKU (stock-keeping pressure manufacturers for more trade-promotion units) price via a sign at the shelf because the check- dollars, and manufacturers-?as a result of the out cash register obtained the price for each undivided- tillers pressure along with their own desire for all item by looking up the items PUC code in the a short-term sales lift-?willingly increased their stores PUC/price file as the item was scanned.With this advent of these new data sources, CUP marketing Business often looked quite stable underwent a fundamental marketing shift from advertising to price discounting. Bimonthly Brand Sales 50 Today, software giant SAP GAG reports that the average CUP manufacturer spends fully 67 percent of its marketing budget on trade promotion and 10 percent on direct- $ Millions to-consumer pro motions (mainly cents-off coupons), whereas less than 23 percent is 20 spent on branding advertising. With so 10 much being spent on retailer incentives that, in turn, then are used to temporarilyJan-Feb. Mar-Par May-June reduce price, the concern that resonates July-Gauge through the industry is that brand equity Figurer Market Information in CUP Before Scanners Brand Sales Measured by Bimonthly Manual Store Audits is being eroded as consumers become trained to buy on the basis of price discounts alone. Thats an unhealthy situation for any brand. Big Data in the Digital World but weekly scanner data revealed to retailers and manufacturers the huge short- term impact of trade promotions. 70 % Volume Sold (Newspaper/Display/Price Discount) Dollar Sales -10 Jan 12 Jan 19 Jan 26