What is (are) Problem(s) on This Data Table? customer Abercrombie, Kristy Babcock's Music Shop Baker, Chris Balak, Mike Barley, Renee Bauman, Mark Bolinski, Rafal Bristol, Sonya Burch, Jason Carr's Pie Shop Castillo, Eloisa Cook, Brian Craven, Pam Davies, Aaron Duncan, Dave Dunn, Eric C.W. Easley. Paula Ecker Designs Fisher, Jennifer Fomin, Slava Freeman, Kirby Average Days to Pay 18.83 11.00 28.00 4.00 194.00 20.00 5.00 3.00 46.00 16.00 21.50 20.67 17.00 12.00 9.00 26.00 36.00 46.40 Notes D 8919 - + 50% (80.286 KB) e Design of a Set of Relational Tables Suppose Honda has the following data for purchases of Inventory item number date of purchase vendor number vendor address vendor name purchase price quantity purchased employee number employee name purchase order number description quantity on hand extended amount total amount of purchase How should we design a set of relational Tables (Inventory, Purchases. Inventory-Purchases, Vendors, employees) to store above data? What should be the primary and foreign keys? Are there any data we do not want to store in Tables? Notes - ata.ppt (80.286 KB) You lieu lu dll, It Salel to stay in Protected View. Enable Editing to close some apps. Update now Excel Work Project 3 (Due March 15) You are asked to analyze P-card data. This company implemented a P-card system. This card allows employees to charge their work related expenses. The use of this card is limited only for work related expenses. A manager wants to know how emplovees use this P-card, and to evaluate if P-card are used properly. There are seven variables. ACC# is an ID for each employee in a department. T# is another ID which can be ignored. Year is year of the expenses. But there are missing values that you need to fill in all In addition, she also wants you to check if they are correct by checking it with Date (the next column). Date is time, day, month and year end event occurs. How they are spent. Amount is the amount spent and Merchant is the name of Marchant. There is the second data that is related to Category. This data show expense classes. Use Pivot tables and Vloopup to create a dashboard that will help a manager to understand how P-card is used by employees In addition, use a conditional format and icons to create a level of warning that you think a manager should pay attention to Notes 88 . - 3. (80.286 KB Lead What is (are) Problem(s) on This Data Table? customer Abercrombie, Kristy Babcock's Music Shop Baker, Chris Balak, Mike Barley, Renee Bauman, Mark Bolinski, Rafal Bristol, Sonya Burch, Jason Carr's Pie Shop Castillo, Eloisa Cook, Brian Craven, Pam Davies, Aaron Duncan, Dave Dunn, Eric C.W. Easley. Paula Ecker Designs Fisher, Jennifer Fomin, Slava Freeman, Kirby Average Days to Pay 18.83 11.00 28.00 4.00 194.00 20.00 5.00 3.00 46.00 16.00 21.50 20.67 17.00 12.00 9.00 26.00 36.00 46.40 Notes D 8919 - + 50% (80.286 KB) e Design of a Set of Relational Tables Suppose Honda has the following data for purchases of Inventory item number date of purchase vendor number vendor address vendor name purchase price quantity purchased employee number employee name purchase order number description quantity on hand extended amount total amount of purchase How should we design a set of relational Tables (Inventory, Purchases. Inventory-Purchases, Vendors, employees) to store above data? What should be the primary and foreign keys? Are there any data we do not want to store in Tables? Notes - ata.ppt (80.286 KB) You lieu lu dll, It Salel to stay in Protected View. Enable Editing to close some apps. Update now Excel Work Project 3 (Due March 15) You are asked to analyze P-card data. This company implemented a P-card system. This card allows employees to charge their work related expenses. The use of this card is limited only for work related expenses. A manager wants to know how emplovees use this P-card, and to evaluate if P-card are used properly. There are seven variables. ACC# is an ID for each employee in a department. T# is another ID which can be ignored. Year is year of the expenses. But there are missing values that you need to fill in all In addition, she also wants you to check if they are correct by checking it with Date (the next column). Date is time, day, month and year end event occurs. How they are spent. Amount is the amount spent and Merchant is the name of Marchant. There is the second data that is related to Category. This data show expense classes. Use Pivot tables and Vloopup to create a dashboard that will help a manager to understand how P-card is used by employees In addition, use a conditional format and icons to create a level of warning that you think a manager should pay attention to Notes 88 . - 3. (80.286 KB Lead