Kudler's Data Table Analysis

Topics: Entity-relationship model, Decision making, Entity Pages: 2 (565 words) Published: October 3, 2010
Kudler’s Data Table Analysis
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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Kudler Data Table Analysis Essay
  • Data Table Analysis Essay
  • Essay about Data Table Analysis
  • Data Table Analysis Essay
  • Kudler Fine Foods Data Table Analysis Essay
  • Data Table Analysis Essay
  • Data Table Analysis Essay
  • Essay on Kudler Data Table Analysis

Become a StudyMode Member

Sign Up - It's Free