Database analysis

Kudler Fine Foods

Kudler Fine Foods is a local upscale specialty food store located in the
San Diego metropolitan area. The company has three locations (La Jolla,
Del Mar and Encinitas). Each store has approximately 16,000 s.f. of
retail space located in a fashionable shopping center. The stores are
stocked with the very best domestic and imported foodstuffs and divided
into the following departments:

Fresh Bakery and Pastries

Fresh Produce

Fresh Meat & Seafood

Condiments and Packaged Foods

Cheese's and Specialty Dairy Products





History

Our founder, Kathy Kudler, was the Vice-President of Marketing for a
large defense contractor. Weary of the constant travel and the pressures
of corporate life, Kathy was looking for other opportunities. As it
happened, Kathy relieved her stress through gourmet cooking and on a
shopping trip for ingredients for a gourmet repast, she suddenly
realized that there was an opportunity for an upscale epicurean food
shop in La Jolla.

Kathy developed a business plan, obtained financing and six months
later, on June 18, 1998, the first Kudler Fine Foods opened. Within nine
months the store was at break-even and was profitable for the year.

In 2000, a second store was opened in Del Mar and in 2003 our third shop
opened in Encinitas.

Database Tables

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.