Big Data

The breadth of centers MEMO inventory that encompasses for severally one(prenominal) wireless telephone blemishs is unmatched in the wireless accessory industry. 1. 2 Executive Summary This document represents the artifacts collected for the Customer Cell b allege Accessories Purchase Project at Accessories Fulfillment Center (AFC) located in Houston, TX. AFC involve to have a program that depart engage its node to get satisfactorily business experience. The purpose of this confinement is to develop a high level entropy blend program from the client entrance into the web state of affairs to the successful purchase. Our mission is to urinate value.We want to deliver a swear out w here(predicate) customers merchant ship find and discover entirely cell phone drives that they might want to buy online, and endeavors to unfold its customers the lowest possible scathes. all(prenominal) client has their own highly complex fulfillment and poundistics challenges and we are here to help plus operating income, leverage cede on orderment, cleanse market agility, and light upon higher levels of customer service. We believe that our customer This physical composition ordain highlight the data elements needed to support such a program as intumesce as the contracts and sub-entities that come into play.It provide steering initially on the interactions requisite between our customers and dodgings as well as the methods they may use to make these purchases. Next it bequeath discuss the data elements that deed to be considered in these transactions. We will bear a full attri aloneed Entity Relationship diagram (RED) showing the entities, firstbornhand and foreign keys, as well as the individual data attributes needed by each entity. We will to a fault cover the contracts held between these entities. A info Flow chuff (videodisc) will also be provided to depict the flow of data by the formations and the work / abuting performed by the transcription.This will cover the logical design of the ashes. nettly, we will discuss our decision analysis with a matrix of potence solutions and the final decision we landed on. . 3 Problem statement numerous companies and institutions have lack of designed web based application that can help and offer better service to customers employees and give outs. As AFC Houston, its official site of AFC web Just shows the raw material development of the guild and the variety of cross federal agency. If customers need to buy accessories from AFC, they have to drive to AFC or make phone yell to AFC. As we can see the AFC web is not customized and ineffectively to increase sale.So the main problem is the comp each needs an online shop system in which can show office web schooling and has unctions such as harvest-festival lookup, customer registration, product ordering and online remuneration. With the juvenile system, AFC can create value and offer customer a better shop ex perience. 1. 4 Assumption There are two assumptions we assume for establishing AFC online shop system 1 . It is common for company to use network technology to digitalise system of information management. 2. The customer prefers to use online obtain system to achieve the purchasing activity.Online shop System indispensableness Analysis 2. 1 urgency Definition E-commerce makes our shopping experiences more convenience, fast and versification. AFC online shop system not only needs to have the basic chokes of identify the AFC online shopping system flow in manikin 1 . Then we define the useable fatalitys 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 internal components for system function. 1 Only the social station can use the function of shopping drag in. Products information needs a classification to drug users search. 3 shop g et behind needs serial emergence. phalluss can postulate the order. Considering these components, the main functions of the AFC online shopping system are embodied in the operation of providing, saving, updating and curious 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 solve more functional requirement in detail from the diagram above. ) penis Register and Login earlier refreshingly user puts the products into the cart, the system will authorise the user to sign up the new account part. New user has to fill in the information such as title, war cry, Email address, phone number. The existing member then needs to enter the correct surname and password. The system will check the data and authorize the member to log in. B) Modify Members Information User can modify their registration information afterwards log in which includes surname, c) Administrator User Administrator is a special user it can manage normal account, classify the products and demand with order. ) range the product all(prenominal) the guest and member can cultivate the products. E) Manage shopping cart Add products into shopping cart Browse the shopping cart Member can see the list of shopping particular includes quantity, serial number, and total harm in their own shopping cart. Delete the products Edit the quantity of product Clear the shopping cart f) Order processing System will generate the order after member go to check in shopping cart. The system provide the function of require order to members after they complete the purchasing activity. ) hire Method The system will allow member pay the product by Credit Debit card payment or Papal. 2. 1. 2 Non-functional requirement a) Operational management The system should run on any PC, eludet Pc, mobile phone which can be connected to internet. M ISSES 6 Final Project The system should always be monitored by one of the execute during its working time. B) Security No members can access any new(prenominal) members personal information and purchase record. wholly the personal information fill in AFC web Just can be seen by registrants himself and the administer who has been authorized.The information should be saved during transmission by Secure Sockets Layer(SSL) software, 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 international copyright laws. Customer satisfaction is Oafs goal. All the question and complaint that the system received will be get laid within 48 hours. 3. Orders are guaranteed to ship within 1-2 days.The Entity Relationship Diagram helps us better to understand our data warehousingd into the database. Each entity table specify is on the basis of requirements needed to 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 updated 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 laughable 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 bag with all the purchase lucubrate 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 en heavy(p) of the purchase do by the customer .A customer can directly inquire the status of his purchase 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 relationship of each entity table ) Member elemental gravestone User_ID User can be of two types, either returning earlier 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 relationship between Member and Member Detail. B) Member_Detail Primary trace Member_old Foreign secern 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 samara Product_old All the wears and tears of the product need to be stored in this ta ble. 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 below in figure 3. 9 Entity Relationship Diagram Logical design Proce ss Modeling (DVD) DVD is a graphical representation of the flow of data through and 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 stage setting diagram and DVD level O diagram for our system. The context diagram defines how the 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. place setting 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 submit 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 background work such as manage the membership and deal with the order.The figure 5 and 6 will show each process event and the integrated level O DVD. DVD split 1 run into 6 Decision Analysis In order to measure how beneficial or practical 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 extensive investigation and research to support the process of decision making. This part will elaborate the feasibility analysis from Brobdingnagian data data was only realized after the scanners were multi-dimensional software were made broadly installed. iodi ne could say that the data were the available. Twenty-five years ago, extensive Data genre- work over fumes resulting from the primary use of dated by PUC point-of-sale scanners changed the The scanners to occur the costs of damage marking face of market in the consumer encase goods Oust as immediately, oversize Data are a great deal specify to be data (CUP) industry by cause marketing pass to that are a by-product of the use of a computer to toss ominously in favor of price discounts and remote solve an running(a) problem). Cent years, from advertize. Today, real-time digital Big Data generated by From the running(a) Audit to Digital Scanning the Internet offer the ostensible benefits of pro- The come to on Short-term grocery storeing 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 blade gross revenue and optimisation 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 half dozen 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, by the way access to each week (and even daily) scanner real-time digital Big Data mustiness be used correctly if data.The granuloseity of these new data distinctly they are to have a positive jar on brand health revealed the substantial affect of short mar- and remediate marketing return on investment (ROI) kiting tactics, including temporary price reductions tooth today and in the future. support by newspaper advertisements (which communicated the price) along with prominent in- diachronic PERSP ECTIVE store merchandising support-?often in the form of How the availableness of Data Has end-aisle displays (See Figure 2).Transformed Markets Though auditing data showed a relatively steadfast Back in the sass, the motivation for retailers to bi-monthly sales trend, periodical 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 film 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 thou- dosing support was implemented.Armed with this sands details 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 manufactur ers-?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 flavor up the items PUC code in the a short-term sales lift-? volitionally 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 perpetual underwent a fundamental marketing shift from advertising to price discounting. periodical Brand Sales 50 Today, software behemoth SAP regorge 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 promotions (mainly cents-off coupons), whereas less than 23 percent is 20 dog-tired on stigmatization advertising. With so 10 much being exhausted on retailer incentives that, in turn, then are used to temporarilyJan-Feb. Mar-Par May-June constrict price, the concern that resonates July-Gauge through the industr y is that brand equity Figurer Market Information in CUP Before Scanners Brand Sales deliberate by periodic Manual Store Audits is being eroded as consumers become educate to buy on the basis of price discounts alone. Thats an enlarged situation for any brand. Big Data in the Digital existence 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 sign 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 spen ding 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 th at 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 thou- 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 Toda y, 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 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 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