ACC 542 Week 3 Individual Assignment Data Table Analysis
Data Table Analysis
ACC/542
University of Phoenix
Data Table Analysis
Kudler fine foods are a chain of stores founded and operated by Kathy Kudler in June 1998. A Kudler fine food has three different branches throughout San Diegoe, CA. The management of the company wants to improve its inventory reports, tables and other reports. The company should plan on breaking down all inventory reports and the organization of these reports. The plan will include the following items; evaluate the data tables, create an entity relationship diagram, create a pivot table with their inventory data, and recommend improvements of these items.
Data Tables Evaluated
The Kudler 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 Kudler 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 Kudler 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 make reading the tables much easier. Kudler 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 Kudler 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 Kudler Foods does not have that the management should consider which would benefit the business is an “employee table”. This way; Kudler could have personal information, sales numbers, last date he/she was reviewed, and just able to keep up
ACC/542
University of Phoenix
Data Table Analysis
Kudler fine foods are a chain of stores founded and operated by Kathy Kudler in June 1998. A Kudler fine food has three different branches throughout San Diegoe, CA. The management of the company wants to improve its inventory reports, tables and other reports. The company should plan on breaking down all inventory reports and the organization of these reports. The plan will include the following items; evaluate the data tables, create an entity relationship diagram, create a pivot table with their inventory data, and recommend improvements of these items.
Data Tables Evaluated
The Kudler 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 Kudler 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 Kudler 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 make reading the tables much easier. Kudler 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 Kudler 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 Kudler Foods does not have that the management should consider which would benefit the business is an “employee table”. This way; Kudler could have personal information, sales numbers, last date he/she was reviewed, and just able to keep up