preview

Essay on Kudler Fine Foods Data Table Analysis

Decent Essays

The company Kudler Fine Foods supplies 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 cheeses. The stores are owned by Kathy Kudler, and today continue to grow with high expectations offering their customers the convenience of a one-stop shopping experience. Ms. Kudler opened her first store in La Jolla, and after a five-year plan, opened her third store in Encinitas. She is committed to providing her customers with the best selection of fine foods and great wines.
Evaluation of the design elements
The Inventory Table contains the components that make up an Item. It is used for managing inventory and …show more content…

The current database provides a basic inventory system. For the new application to be a success, there are several items that need to be addressed with the current Kudler Database. For instance, Kudler needs additional tables such as Reserved Inventory table. This table will be a transaction table that will reserve the items by removing them from inventory and holding them in the reserved table until one of the following conditions is met.
In addition, the primary keys that are preserved will need to be configured as required fields, and there are several primary keys that can be replaced with Auto-Number Identities. The Inventory table will also need to be modified to indicate what quantities are on hand at each individual store. Under the current database, there is no visible way to show which store has inventory. For example, one store may have 35 boxes of Frog Legs, while there may be two other stores that are out of stock. Normalizing the database will ultimately result in minimizing data redundancy and optimizing the data structures by containing smaller, more flexible tables. Once the tables are normalized and data integrity has been maximized, referential integrity will be addressed by establishing relationships between data elements and their appropriate groupings. Upgrading to SQL Server is a more viable alternative should Kudler Fine Foods' require a larger database capable of

Get Access