Kudler Fine Foods Proposal
Background and Business Application Proposal
Kudler Fine Foods is an upscale specialty food store, servicing the fine food conesouer from their three California locations. Kudler's business objective is to maximize profits by offering the highest quality products at competitive prices. Through adding the on-line ordering system, Kudler hopes to boost profits by increasing their customer base beyond customers in their local areas. The Kudler on-line ordering system will add three important advantages to Kudler customers. First, the on-line ordering system will allow current Kudler customers to access the system, place their order, and have it ready for pickup when they arrive at the store. The second benefit for Kudler's on-line clientele is the added convenience of local delivery service. This feature, allows the customer to place their order and select a timeframe in which the order will be delivered to their home or place of business. The third and final new offering from Kudler will be worldwide shipping. Using major shipping companies, such as Federal Express, UPS and DHL, Kudler will provide next day shipping to customers from around the world.
Database Revisions to support Application Proposal
In order to implement these new services, the current Kudler database needs to be examined and revised. The current database is in a Microsoft Access format and provides a basic inventory system, as well as a list of current customers. For the new application to be a success, there are several items that need to be addressed with the current Kudler Database.
Additional Tables Needed
1. 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: a.The transaction has obtained credit approval. Once this...