Data Table Analysis
University of Phoenix
Accounting Information Systems
December 12, 2010
Data Table Analysis
Kathy Kudler established Kudler Fine Foods In 1998 in La Jolla. At the time and with only one location, Kathy opted to employ Microsoft Access for tracking inventory, sales, orders, employees, and customers. Inventory must be carefully tracked because the products are perishable. If the informatin is out dated, incomplete, or inaccurate, it will have no value. The use of pivot tables and entity relationship diagrams allows Kathy Kudler to prepare better ...view middle of the document...
The total quantity of the inventory is difficult to determine based on the current inventory tables.
Entity Relationship Diagram
Entity relationship (E-R) diagrams are used to illustrate the hierachy of how data is reviewed. These diagrams represent the relationship between business entities. There are four symbols used for E-R Diagrams:
Table 1: Entity Relationship (E-R) Diagram Symbols
Symbol | Representation |
Rectangles | Business entity |
Diamonds | Relationship |
Ovals | Entity Characteristics |
Connecting Lines | Depicts Relationships |
The key entity is Kudler Fine Foods followed by each location – La Jolla, Del Mar, and Encinitas. Each store has a unique GL codes for each inventory item. This is for the purposes of tracking sales transactions. The day to day accounting transactions occurring at Kudler Fine Foods are sales, purchases, sale receipts, and payments.
Recommendations for Improvements to the Data Tables
A Pivot Table is a two dimensional statistical summary of database information. Databases can be improved by designing the accounting codes chronologically and sorting the data by product inventory levels. This method permits the tracking of inventory for departments that offer different products. By sorting the data, end users can more efficiently find the information needed for more effective decisions.
Benefits Through the Use of Pivot Tables
Kudler’s current inventory system is overloaded with a large amount of...