The file Foodmart.mdb contains many transactions at a supermarket chain. Open this file in Access, click on Database Tools and select Relationships to see the relationships diagram. This type of relationship diagram is called a "star schema." The Facts table includes a record for each line item purchased by any customer at any store on any date. The other tables are called "dimensions" that facts can be broken down by. This type of database is set up perfectly for pivot tables, where you can break down facts (Revenue or Units-Sold) by dimensions. In Microsoft Query, develop a query that uses all of the tables. It should have the following fields: Revenue and Items-Sold from Facts; all fields except Date-ID from Dates; all fields except Product-ID from Products; City, Region, State-Province, Country, Marital-Status, and Gender from Customers; and City, Region, State-Province, and Country from Stores. Note that City, Region, State-Province, and Country have the same names in the Customers and Stores tables, which can be confusing. Therefore, for each of these, use the Add Column menu item from the Records menu to select these fields and give them names like Customer City and Store City. Return the data to a pivot table in Excel. Then create an interesting pivot table, where you break down Revenue or Items-Sold by any of the various dimensions?