Instructions Based on the above information, your supervisor wants your team to provide the following deliverables to YNF. Part I. Prepare a prototype database for YNF. Forrest has agreed to provide financial data from his business for the 1st quarter of his fiscal year. That data will be in EXCEL format (you can download the Excel file from Canvas). You will load the data into Access, structure it appropriately. Make changes as necessary in file structures to implement efficient tables and eliminate duplication. Also, set relationships consistent with the UML data model for the database. Appendix B provides description of data in the EXCEL spreadsheet and guidance on appropriate treatments for these tables in Access. Part II. Prepare the income statements for YNF using your database. You will prepare queries as necessary to provide the following information for sales, cost of goods sold, and selling, general and administrative expenses. Then, prepare queries to prepare the income statements by store and for YNF. If you create any new variables whose values are in dollar amounts in the following queries, please format them as currency. Sales 1. Create a query to expand the sales and sales items table. It should include the order#, customer#, sale_date, truck_vin, cash_receipt#, store#, qty_sold, sale_price, and sale_amt, where sale_amt is the sales items amounts by multiplying the quantity sold times the sale price (sale_amt = qty_sold*sale_price). Remember to restrict transactions to the 1st quarter. Name this query "Sales Detail Q1". 2. Accumulate sales by store during the quarter. Name the sum variable as Revenue and name this query "Sales Revenue by Store". Cost of Goods Sold 1. Extend the flower purchase items by multiplying the quantity purchased times the purchase price (purch_amt= qty_purch* purchase_price). Also include purchase#, purchase_date, check#, store#, inventory#, qty_purch, purchase_price in the result. Restrict transactions to the 1st quarter. Name this query "Purchases Flowers Detail Q1". 2. Accumulate flower purchases as cost of goods sold by store during the quarter. Name the sum variable as COGS and name this query "Purchases (COGS) by Store". Selling, General, and Administrative Expenses 1. Extend the payroll records by adding gross pay plus employer FICA (Social Security) plus employer MC (Medicare payments) for each employee each month. Name this query