Bsa 385 Week 3

Once you understand the benefits associated with a relational database you decide to build a small database to help you track and analyze customer orders and sales information.

Partners in the scheme can avail themselves of a much richer databank on their customers, analyzing their purchases across a cross section of different products, purchased in many different outlets.

- Tables are useful in showing relationships and making comparisons. They should have title, row, column headings, population, source and explanations.

A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.

3 types of goods that classify as inventory are goods awaiting sale (the merchandise of a trading concern and the finished goods of a manufacturer), goods in the course of production (work in process), and goods to be consumed directly or indirectly in production (raw materials and supplies).

Developing software is far from an exact science and without a structured system to guide the process a project is likely to fail. Defining and adhering to a Software Development Life Cycle (SDLC) early in the project will help to guide the development of a new information system. In addition to having the structure for the development team to work within a defined and agree upon SDLC will help to set the proper expectations for deliverables with the stakeholders and customer(s). Smith Consulting has been given the task of creating a Frequent Shopper program for Kudler Fine Foods. As a result Smith Consulting needs to decide on which SDLC will work best for this project. In addition to selecting a SDLC to use Smith Consulting will

TRANSACTION ID: TRANSACTION_TYPE_ TYPE OF TRANSACTION BEING PRERFORMED: Having more than one item sold is a good thing. Having a transaction id can help the customer with their many orders.

The manager of Kudler Fine Foods, Kathy Kudler, has requested the development of a system to track customer purchases through a Frequent Shopper Program to award loyalty points for redemption. (Apollo, 2011)

A Table is where you are organised and store data so you have to create the table before store any data. By creating table, you need to define few things, Fields name, Data type, and the Description.

This decision was facilitated by the availability of a number of quality off-the-shelf solutions that would meet the company’s needs. Two vendors were identified as possible partners to develop this new frequent shopper program with Kudler. These systems were FXmedia and Incentivelogic.

The management team of Kudler fine Foods uses the intranet to keep demographic data on each of its customers. They can access their names, addresses and important data for special mailings. The inventory is managed and the availability of ingredients can be determined. The items from a store can be obtained from what has been purchased. An order table can be used to record pertinent information. The order line can be seen to show the description, quantity and price. The store table is used to retain data for each store. The supplies table contains data information from tax table is used to provide accurate taxes. The tender table is used to provide a record of payment for an order.

The Loyalty Points Program, also known as “frequent shopper program”, is a program that would allow the customer to accumulate points that can be used within the Kudler Fine Foods stores. With this program, customers shopping and purchasing habits can also be tracked. With the points that have been accumulated by the customer, the points can be exchanged for high-end items within the stores. By employing this program, Kudler Fine Foods will be more familiar with their customers as well as their spending habits. In addition to, this program will allow Kudler Fine Foods to keep track of each and every customer on the frequency of their visits to the stores and keep having them come back to accumulate more points.

The objective of this project request is to track purchases of individual customer’s. The customer purchases will be tracked and accumulated as loyalty points for redemption by the customer for

The article “Personalized Pricing” by Olga Kharif explores the emerging and growing concept of personalized pricing and loyalty programs. The author offers the example of a shopping mother that logs on to Safeway’s Just for U site to see her personalized offers. When she logs on, she views process set for her by algorithms, on items she buys frequently. Later, at the supermarket, she starts shopping using an electronic list that keep track of her specials, and finally checks out using her Club Card or phone number and receives the discounts she loaded; while Safeway gets more information to tailor future marketing pitches.

On a domestic and international level, Kudler wants to improve the perception of its product line as offering unique added value to the consumer in the wine and cheese market