September 27, 2010
Kudler Fine Foods is a fast growing company established in 1998 and their Initial store selected Microsoft Access as the database to track inventory, sales, orders, employees, and customers. Kudler’s products are perishable and inventory must be properly tracked. This paper will evaluate database tables from accounting perspective, and provide recommendations for improvement. Pivot Table and Entity Relationship diagram will help Kudler’s to build better decision-making process.
Evaluation of the design elements of the data tables from an accounting perspective.
Data Table analysis is essential to the success of Kudler, the information provided in these tables is available for the end user to determine how much inventory is available and when it require to order more inventory. The design of data tables organizes the financial data into department, financial codes, items and then sums of total amount of transaction. Data table maximize the visual and informational presentation for the financial data. The user can easily identify information that item belongs to certain department, and how many items were received at the given cost for a certain period. It allows finding total amount and quantity on hand for an item and calculating average price for an item.
Entity relationship diagram illustrates the hierarchy of how information reviewed by end users. The data represented in entity relation diagrams (E-R) includes the business entities and the relationship among them. E-R diagrams use four symbols: rectangles to represent entities, diamonds to describe relationship, ovals describe the entity, characteristics, and connecting lines depicts relationships.
Recommendation for improvements to the Data Tables
The Pivot Table is two-dimensional statistical summaries of database information and can be improved by arranging the codes chronologically and sort the...