The aim of this undertaking petition is to track purchases of single customer’s. The client purchases will be tracked and accumulated as trueness points for salvation by the client for gift points. forte nutrients and other merchandises or services as made available through partnerships with other external companies. The strategic intent of the Frequent Shopper Program is described on the Gross saless & A ; Marketing page of the Kudler Fine Foods Intranet site. Aim: Kudlers’s new enterprise is tracking purchase behaviour at the single client degree and supplying high value inducements through a partnership with a trueness points plan.

The client purchase behaviour forms will assist Kudler polish its procedures and offerings to outdo satisfy their values clients. Price is non the primary differentiating factor for Kudler consumers ; these consumers are focused on quality and happening specialised points. Therefore. instead than supplying mundane price reductions to the clients for their purchase frequence like lower terminal markets. Kudler has partnered with a trueness points plan to supply clients with points which can be redeemed for high terminal gift points. air hose first-class ascents. or other forte nutrients. Technology Infrastructure and Architecture

The undermentioned subdivisions of this papers will supply an overview of the hardware. web. package. databases. and security demands for the frequent shopper plan. These demands are implicative Hardware Platform: Kudler Fine Foods presently has an luxuriant web of hardware that may be used to implement the frequent shopper plan. Client-Side hardware:

1. Each shop uses NCR RealPOS 82XRT terminuss linked to the web through a POS waiter. ( These terminuss will be used during buying to originate informations aggregation including client ID and purchase history informations for the FSP ) 2. The 19 ( at present count ) corporate direction and other admin forces all utilize Dell Vostro computing machines running Windows 7 OS. These disposal forces besides portion 3 HP networked pressmans. ( In relation to the FSP. these computing machines will be used by direction to question and analyse client purchase history for concern service refinement. )

Server-Side Hardware: 1. POS Servers- are used to treat orders from the POS terminuss and connect to the Kudler web for database file storage 2. HP Blade Server system- c3000 system. Unix OS. SAP Retail SW. Print/File. Communications. Email. Storage. Web. These Servers will be used to hive away informations sing single client purchase history and queried for concern analysis every bit good as trueness points add-on and redemption. ) Network Platform: 1. Each of the three Kudler Stores has a Local Area Network which connects together Via T3 Dedicated high velocity lines. 2. Each store’s LAN is connected via 100 base T Ethernet. The communications into and out of the shops is ported through 2 Cisco routers and firewalls. 3. Each Local Area Network is besides connected to the cyberspace via 25Mbps high velocity concern cyberspace connexions. 4. Network Diagrams ( Shown Below )

Software Development Tools: 1. The Frequent Shopper Program is an extra service that will be implemented in concurrence with the bing Information Technology System used throughout Kudler Fine Foods. Because of the complexness and functionality of the bing system. it is recommended that the usage of AGILE development methodological analysiss be used to develop the FSP system and unify the application into the bing system. 2. Ocular Studio 2012- This Integrated Development Environment will be used to develop the application faculties and user interfaces for the FSP development. 3. The codification will be implemented in the C # linguistic communication. ( used for faculty development ) b. ASP. NET & A ; MVC – used to develop dynamic. synergistic web based application for clients to entree. proctor. and deliver trueness points

Databases: 1- Customer Table – The Customer Table contains demographic informations for each of Kudler’s clients. The information in this tabular array is used to entree the name and reference of clients for order processing and for particular mailings for day of remembrances and/or birth day of the months. etc. – Order Table – The Order Table is used to enter information pertinent to each Order placed with a given shop. Each order will hold one or more entries in the Order Line Table associated with it. 3- Order Line Table – The Order Line tabular array contains detail on points looking on an order. One or more Order Lines are associated with each order and each Order Line references an point being purchased with its description. measure. monetary value. etc. 4- Item Table – The Item Table shops information refering to merchandises that may look on an order. It describes goods that can be purchased from a Shop.

The current database tabular arraies can be re-used and combined to make the FSPoints Table The FSPoints table ( Frequent Shopper Points tabular array ) . will include the Customer ID and all correlating information. Item purchase history. and Item Points Value. The amount of all points’ values will be expressed and added to the Customer’s redeemable points at the terminal of each FSP period. User Interfaces: Describe the interface for informations aggregation and presentment to hive away forces and clients.

1. The initial User Interface will stay the same at the point of sale ( POS ) . Additional package will be added to initialise the FSP on applicable dealing. Software faculties will be initialized as needed that will roll up the CustomerID every bit good as the single points purchased. 2. Web Applications: Through the usage of the aforesaid tools including ASP. NET and MVC. an synergistic web application will be available to registered clients. and forces to entree. reappraisal. and deliver trueness points. There will be an sole page created for the Frequent Shopper Program. Controls: System truth cheques will be in topographic point to verify alone CustomerID’s at the POS terminuss. Every client that participates in the Frequent Shopper Program will hold a alone customerID.

Each dealing will get down by come ining this identifier which when verified for truth will get down roll uping item purchase informations. Each point is scanned at the POS. and compared to its matching FSPoints table to add trueness points to the Customers FSPoint record. If the CustomerID or any points purchased to non register in the confirmation processing system. an exclusion will be returned to advise the client and teller at the clip of purchase. Each dealing will shut with a printed reception naming the order line information. every bit good as the points accumulated at that dealing.

A points sum may be requested via the cyberspace based Frequent Shopper Program Web application on the Kudler Fine Foods web site. Security: The necessary security mechanisms need to be in topographic point when storing and traveling most data entities. particularly Customer personal information. Hashing and encoding techniques will be used when sensitive informations is stored in all information shops. and unafraid informations transportation protocols ( e. g. . SSL. HTTPS. and WS-Security ) will be used when information is Personal Information will be secured through the usage of informations encoding methods and secure networking protocols when information is transmitted over the web.