Data Table Analysis: Kudler Fine Foods
Data Table Analysis
Introduction
Kudler Fine Foods was founded by Kathy Kudler in the summer of 1998 in La Jolla, California. Two other stores were opened at Del Mar and Encinitas California, Kudler Fine Foods deals in specialty foods sells; fresh bakery/Pastries fresh produce fresh meat & seafood condiments and packaged foods cheese's and specialty dairy products (Kudler Fine Foods, 2003). The Entity Relation diagram and pivot table would help Kudler Fine Foods improve the data tables and improve the decision making.
Entity Relationship Diagram An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables.
Data Tables from Accounting Perspective …show more content…
The codes are all of six digits, La Jolla store GL code starts with “12,” Del Mar starts with “13,” and Encinitas starts with “14.” The uniformity of the codes will help the management of Kudler Fine Foods forecast future purchases and help manage the inventory of all three stores. In the charter of accounts the inventory GL code are the same, this will make the accounting less complex. The POS module system transmits data from the cash register to inventory report by calculating the cost of goods sold and calculating merchandise inventory using the FIFO method (Kudler Fine Foods,
Introduction
Kudler Fine Foods was founded by Kathy Kudler in the summer of 1998 in La Jolla, California. Two other stores were opened at Del Mar and Encinitas California, Kudler Fine Foods deals in specialty foods sells; fresh bakery/Pastries fresh produce fresh meat & seafood condiments and packaged foods cheese's and specialty dairy products (Kudler Fine Foods, 2003). The Entity Relation diagram and pivot table would help Kudler Fine Foods improve the data tables and improve the decision making.
Entity Relationship Diagram An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables.
Data Tables from Accounting Perspective …show more content…
The codes are all of six digits, La Jolla store GL code starts with “12,” Del Mar starts with “13,” and Encinitas starts with “14.” The uniformity of the codes will help the management of Kudler Fine Foods forecast future purchases and help manage the inventory of all three stores. In the charter of accounts the inventory GL code are the same, this will make the accounting less complex. The POS module system transmits data from the cash register to inventory report by calculating the cost of goods sold and calculating merchandise inventory using the FIFO method (Kudler Fine Foods,