The Building Toolscompany sells various tools. It has sales offices and warehouses all over Australia. The company developed a data warehouse to store information about sales, customers and products. These data are stored in the AppliedProject2 Access file provided for you.The database consists of 6 tables:OfficeDim with the sales office address, state and emailProductDim product information

WarehouseDim warehouse locationsCustomerDim information about customersDateDim sales datesSaleFacts information about salesPlease notice that all data (customers, sales, dates, warehouses and products) are randomly generated. Table and field names are self-explanatory.The Building Toolscompany wants to retrieve information from the database for reporting and data analysis.You must do the following tasks1.In the MS Word document:a.Analyse and describe the tables(fields, field datatypes, recordsetc.).b.Identifydimension and fact tables. (You need to remember that the databasestructure is a database star schema).c.For each table, identify and describe primary and foreign(if any)keys.d.Draw the database diagram. e.Copy from the database all queries to the Word document and explain them.

2.In the SQLite Browser, you need to write, save and run the following SQL queries:a.Create all primary and foreign keys.b.Insert a new sale date. Devise your own data for this record.c.Create a new sale fact related to the new date. You can choose any existing product, warehouse, customerand sales office.d.Display all productnames, brandsand prices.e.Display all customer names from New South Wales.f.Display the total amount of all company sales in the first quarter of 2016.g.Display total amount of sales for each customerseparately.h.Display total amount of sales for each product andwarehouseseparately, i.e. the output should contain 3 columns: product, warehousedivisionand total amount for this product and warehouse.i.Display products sold from officeslocated in Victoria.j.For each sale, display a customer name and a purchase dateand a quarter.k.Display a total number of sales (NOT AMOUNT!) for each product.l.For each sales office (branch), display: branchKey, branch state, a customer name (a customer purchased in this office), a product name purchased by this customer, and a month number of the purchase.Your submission should consist of the following documents: MS Word document containing answers to the Task 1SQLite Browserfile with stored SQL queriesfrom Task 2