OPPapers.com

Database

The Company
The company is a store name Kudler Fine Foods, supplying the freshest ingredients and the tools enabling their customers to become a gourmet cook. They are a specialized food store with a worldwide selection of vegetables, meats, wines, and cheese, to mention a few. The stores are own by Kath Kudler, became a reality in 1998, and today continues to grow with high expectations offering their customers the convenience of a one-stop shopping experience. Ms. Kudler opens her first store in La Jolla, and after a five-year plan, opens her third store in Encinitas. She is committed to providing her customers with the very best selection of fine foods and great wines.
The Project
The project is that of a Microsoft 2000 Access database representing all the associated Kudler Fine Foods stores. The current database utilizes tables that are in reference to customers and the organization operations. Many of the tables require normalization, creating new tables, Entity Relational Model (ERM) relationships, and investigating the requirements of associated indexes. New reports are required in support of the relationships between tables, business operations, and the necessities in meeting the need of the customer.
The current tables are as follows:
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...