Kudler's Table Description Essay

Submitted By 1armyman
Words: 440
Pages: 2
Open Document
Table
Description
Customer
The Customer Table contains demographic data for each of Kudler’s customers. The data in this table is used to access the name and address of customers for order processing and for special mailings for anniversaries and/or birth dates, etc.
Inventory
The Inventory Table contains the components that make up an Item. It is used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, etc.
Item
The Item Table stores information pertaining to products that may appear on an order. It describes goods that can be purchased from a Store.
Order
The Order Table is used to record information pertinent to each Order placed with a given store. Each order will have one or more entries in the Order Line Table associated with it.
Order Line
The Order Line table contains detail on items appearing on an order. One or more Order Lines are associated with each order and each Order Line references an item being purchased with its description, quantity, price, etc.
Store
The Store Table retains data for each store location, such as name, address, phone numbers, emergency contacts, etc.
Supplier
The Supplier Table contains data concerning wholesalers, vendors and other suppliers from whom inventory is procured. These goods are used to prepare saleable items or are simply resold in their acquired form.
Tax Table
The purpose of the Tax Table is to provide tax rates applicable to orders placed at a given store.
Tender
The Tender Table provides a means to record the methods of payment used for an Order. For example an order may be paid for partially in cash and partially by credit card.

Pivot Table Example
There are varying formats for pivot tables; however, this example has been provided in order to allow students to begin
Show More

Related Documents: Kudler's Table Description Essay

Website Improvement Essay examples

become more competitive. As part of this task, we will discuss and analyze how we will integrate online shopping cart functionality to Kudler’s site and how to optimize their site for search engines. We will also discuss the steps that were taken, challenges and obstacles that arose, changes and improvements that we made as we improved the functionality of Kudler’s website. In order to accomplish this task, we split the assignment into seven subtasks or areas of concentration. These seven subtasks…

Words 704 - Pages 3

Business: Requirements Analysis and Frequent Shopper Program Essay example

offerings to best satisfy their valued customers. It has been determined that the best way to launch this initiative is through the user of a frequent shopper program. Ordinary programs of this sort will not satisfy the sophisticated senses of Kudler's elite customer base, so a decision has been made to partner with a loyalty points program that will provide rewards points to customers that can be used to purchase high-end gifts and upgrades. System Requirements Gathering During the initial stage…

Words 1253 - Pages 6

Electronic Commerce Related To The Development Of The Kudler Fine Foods

of: Table Description The Patron Table This table contains demographic information on every one of Kudler's patrons with a FSP card. This data contains names and address of patrons; this information is used for special mailings and order processing for birth dates and anniversaries. The Inventory Table This table is used to determine the inventory and manage ingredients that go into prepared items sold at the Deli or bakery. The Item Table This table stores information…

Words 1074 - Pages 5

Service Request SR-Kf-013

Service Request SR-kf-013 Final Paper Team C BSA 375 November 18, 2011 Karen G. Knox Introduction Kudler Fine Foods was first established in 1998 by Kathy Kudler in the San Diego, California metropolitan area (Kudler’s Fine Foods (2004). Today there are three locations, the first location to open in 1998 was La Jolla, second to open in 2000 was Del Mar, and third to open in 2003 was Encinitas. Each 8,000 square foot store is stocked with the very best domestic and imported foods and wines. Kudler…

Words 3587 - Pages 15

BSA375week 5 Essay

satisfy the needs of their valued customers. Management has decided to approach this initiative is through the implementation of a frequent shopper program. Traditional programs of this sort would not begin to satisfy the sophisticated senses of Kudler's elite customer base; as a result, a decision has been made to partner with a loyalty points program that will provide rewards points to customers that can be redeemed for high-end gifts and upgrades. System Requirements Gathering During the initial…

Words 4816 - Pages 20