Essay on Kudler Fine Foods Database Project - 897 Words

Kudler Fine Foods Database Project Background and Business Application Proposal Kudler Fine Foods is an upscale specialty food store, servicing the fine food conesouer from their three California locations. Kudlers 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†¦show more content†¦? 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 condition is met, the ?reservation? entry is removed. b. The items have been reserved for 30 minutes without activity, at that time the reservation entry is removed, and the items are placed back in general inventory. 2. ?Shipping Method? Table ? this table will indicate how the order will be delivered. Shipping charges will be calculated by multiplying the total purchase price by a shipping factor. Options for this table will include a. In store purchase b. Pickup c. Local Delivery d. FedEx e. UPS f. DHL 3. ?City State Zip? table ? This table will allow the customer to enter their Zip Code and the city and state will automatically populate in the online order form. 4. Emergency Contact information ? This information should be moved to its own table, making this information easier to maintain and update. 5. Building Information - Floor Space, Lease Owner, and Lease Rate should be in its own table. 6. Unit_of_Measure - Should be in its own table with an ID and a foreign key added to the Inventory table. In addition to adding several tables to service the newShow MoreRelatedBsa 310 Kudler Frequent Shopper Program1557 Words   |  7 PagesKudler Fine Foods is a much renowned food store, established at the different locations in California. The main focus of the store is to have ‘profit maximization’ by providing quality products at appropriate prices, in comparison of the competitors. The firm also wants to satisfy its clientele. Through this objective, the store wants to acquire major expansion. It currently wishes to enlarge its services by attaining perfection in the in the operational activities. Kudler also desires to increaseRead MoreDetailed Design Process1733 Words   |  7 Pages[Placeholder] Tradeoff Approach Though an ultimate and extravagant system is desired for Kudler Fine Foods’ Frequent Shopper Program, it is likely that some tradeoffs will have to be made to ensure that the project remains feasible for the company. In designing the Frequent Shopper Program for Kudler Fine Foods, it is important to consider certain tradeoffs of the project, in terms of costs, the schedule of the project, and the performance of the system, regardless of which approach is chosen (UniversityRead MoreKudler Fine Foods - Marketing Focus1655 Words   |  7 PagesIntroduction Kudler Fine Foods is a company that deals with bakery and pastries products, along with providing produce, meats, seafood, condiments, cheese, specialty dairy products, and they also package foods if necessary throughout their many locations within California. Kudler Fine Foods ultimate goal is very similar to all businesses alike, which is to have an excess amount of income over expenditure. According to what is stated on the Intranet for Kudler Fine Foods, their drive as a businessRead MoreBsa/385 Week 3 Essay1119 Words   |  5 PagesShopper Program, Part II Kudler Fine foods would like to enhance the clients shopping experience by developing a system in order to track the customer purchases which will be known as a Frequent Shopper Program. This will award loyalty points in order for the customer to have an opportunity to redeem these points for goods services. â€Å"Kudler Fine Foods is a Local upscale specialty food store committed to providing customers with the finest selection of specialty foods and wine.† Apollo Group IncRead MoreService Request Sr-Kf-013 Paper900 Words   |  4 PagesKudler Fine Foods Frequent Shopper Program Kudler Fine Foods is a local and upscale specialty food store with a total of four stores in La Jolla, Del Mar, and Encinitas California with their main base store in San Diego, California. Each store maintains and sells high quality bakery, pastries, fresh produce, meat, seafood, specialty condiments, packaged foods, cheeses, and dairy products. Kathy Kudler owner and founder of Kudler Fine Foods is looking to expand her company and market her productsRead MoreService Request Sr-Kf-013 Essay822 Words   |  4 Pages Service Request SR-kf-013 Draft In today’s economy many individuals try to cut costs as much as possible. Kudler Fine Foods thought that creating a frequent shopper program for their valued customers would be a profitable and resourceful venture. Not familiar with the steps in implementing this type of program, Kudler hired a team of information technology business managers. Kudler believes that this team would greatly benefit the implementation process. In this summary, the team of IT businessRead MoreBsa 385 Week 4 Paper1204 Words   |  5 Pages The scope of this document is to outline the process and procedures take to ensure the Kudler Fine Foods is in the best position to maintain the Frequent Shopper Rewards program that Smith consulting has put into place. The following document is a tool for Kudler Fine Foods to use to make sure that there is a checks and balances system in place as they move toward expanding the Rewards program and growing their customer base. ToRead MoreEssay on Audit Proposal1327 Words   |  6 Pagesaccounts receivable, payroll, and inventory systems for Kudler Fine Foods. Kudler would now like to see a proposed audit schedule for these systems. The team will distinguish between the types of audits that may use for each process. The team will also recommend the most appropriate audit for each process and explain how to conduct the audits. Identifying events that may prevent reliance on auditing through the computer will also be presented to Kudler for review (Apollo Group, 2009) . Types of Audits Read MoreBsa 375 Final4504 Words   |  19 Pages Kudler Fine Foods Frequent Shopper Program Student BSA375/Fundamentals of Business Systems Development University of Phoenix Kudler Fine Foods Frequent Shopper Program Kudler Fine Foods is one of the preeminent destinations for the discerning shopper looking for all kinds of gourmet and specialty food items they are also one of the finest shopping destinations for anyone who just likes good food. At Kudler Fine Foods theRead MoreLt Service Request Sr-Kf-013 Final Paper3711 Words   |  15 PagesNovember 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 prides itself on using the finest and freshest organic