Pizza My Heart Database ormation Systems: Understand Relational Database Structure ion Systems You are an accountant at the accounting firm, DGJ, that is helping Pizza My Heart create a relational database for their business. You have already created the tables PIZZA MY HEART INCOME CTATEMENTT 203A ANO 2025- The business wi trucks. lando for thei - The company began to turn a profit in 2025. Sales nearly doubled for the Fort Lauderdale truck and more than doubled for the Orlando truck. - With the rapid increase in sales, Sal and Franco needed a better way to capture their financial and non-financial data. Pizza My Heart Database PAC 2.1 Accounting Information Systems: Understand Relational Database Structure Now, you must create joins between the tables. PAC 2.2 Auditing: Create Analyses for Completeness of Cash first quarter. Use pivot tables where applicable. 1. Summarize daily sales, daily cash sales, and daily credit card sales by Truck 1.2. Summarize daily deposits by Truck 1.3. Prepare a reconciliation of daily receipts with daily deposits. Then, identify if there are any daily sales that do not match daily deposits. PAC 2.3 Financial Accounting: Create Analyses of Sales You are preparing the first quarter sales results for Pizza My Heart. 1. Create a PivotTable that summarizes sales by Truck 1 and show the total sales for each month in the first quarter (January, February, March).2. Create a PivotTable that summaries sales by product for the first quarter for Truck 1. Sort the data from highest sales to lowest sales. PAC 2.4 Managerial Accounting: Create Analyses to Understand Costs per Product | You are a managerial accountant asked to prepare an analysis of costs. Use the purchases data file to answer the following questions with PivotTables: 1. What is the average of total costs per raw material ingredient? (Hint: use total costs, do not consider units).3. Are there vendors that are charging higher than average costs for ingredients? PAC 2.5 Tax Accounting: Create Analyses to Plan for Expansion Florida population and sales tax by city data files to create a visualization that shows which cities have the largest populations and which also shows the tax rates by city. 1. What are the top ten most populated cities in Florida? 2. Use a PivotTable to determine the cities with the ten lowest tax rates. 3. Pizza My Heart is considering Tallahassee as a potential city for a new truck. Sal estimates that sales in the first year will be $150,000. How much sales tax will be collected?