The Judder Foods current data table has been sufficient but the company is suggested some changes to make it easier to understand and even more descriptive as well. First thing Judder Foods could do is change the table to a schematic database design. A schematic database will combine a few of the tables that already exist and explain each table a bit more in detail with less words and these tables are known as relationship tables. The Judder Foods need to design an entity relationship diagram to illustrate what needs to be on the table.
A few of the tables could be combined to cake reading the tables much easier. Judder foods could combine inventory/ order relationship, for example; order/sale relationship table, inventory/sale relationship table, and sale/receive payment relationship table. By combining any one of these tables Judder Foods could process orders faster, find information faster by having the data in order and labeled and overall making the company’s system more efficient. One table Judder Foods does not have that the management should consider which would benefit the business is an “employee table”.
This way; Judder could have personal information, sales numbers, last date he/she was reviewed, and just able to keep up with the employee’s performance (Beggaring, 2008). The management should evaluate Judder Food’s inventory data and see if it can recommend changes that will improve the day-to-day operations at each store. Inventory Data Evaluated Judder Food’s inventory data is well kept but there are some recommendations that will help improve management’s decision making. The first thing to remember is to create a pivot table for the inventory data.
Pivot tables are “two-dimensional statistical summaries of database information” (Beggaring, 2008). By creating this type of table it will allow each store to keep the quantities of each item alongside the price which makes it easier to keep up with what is in stock and what items need to be reorder. The pivot table makes it easier to track customer demands by data mining, “which means using a set of data analysis and statistical tools to detect relationships, patterns, or trends among stored data” (Beggaring, 2008).
This type of information cut cost on thrown away inventory by keeping products on the shelves that thee customers are buying because what might be popular atone store may not necessarily be at the other stores. By cutting own this type of cost Judder Foods could add hundreds of thousands of dollars of profit from each store. These are the recommendations and tools to improve the problems found in the current data tables and inventory data at Judder Foods.