Critical Information System Paper
Ted Ko, BSA 310
University of Phoenix
August 21, 2011
Greg Walker

Critical Information System
Kudler Fine Foods is a local gourmet grocery store located in San Diego, with three locations. All the stores carry the very best domestic and imported goods. Kathy Kudler, Owner of Kudler Fine Foods, opened the first of three stores in 1998. In the year 2000, Kathy opened a second store with the third store opening in 2003 (Kudler Virtual Organization, 2006). Kudler Fine Foods utilizes an information technology system that is vital to its business. The company uses the POS (Point of Sales) Database System to organize and keep track of items and orders. Without this, they would not be as successful as they are.
Point of Sales System Databases keeps track of inventory, supplier, order, customer, store, tender (sales), tax table, order line, and item. A successful business cannot function accurately without all these tables. The Inventory Table contains the components that make up an item. Such as, perishable indicator, quantity on hand, and unit cost. It is also “used for managing inventory and determining the availability of ingredients that go into prepared items, such as bakery products, ect” (Kudler Virtual Organization, 2006). “The Supplier Table data concerning wholesalers, vendors and other suppliers from whom inventory is procured” (Kudler Virtual Organization, 2006). Meaning, depending on the inventory, which is going to determine who the supplier is going to be in general. Under Order Table, it is used to record information pertinent to each order placed with a given store. So, depending on the store the Order and the Order line will differ; because, the Order Line contains detail on the items appearing on an order. The Customer Table contains the demographic data of each of Kudler’s customers. The data in this table holds