Based on the Insurance Data Warehouse $/$ Dimensional Model below:

$1)$ identify the fact table

$2)$ identify the dimension tables

$3)$ for each dimension table, identify the attribute$($s$)$ that would be matched to an attribute in the fact table, and

$4)$ list four queries that could be produced from this data model.

For example, the queries from a data model of real estate sales that could typically be produced by matching a fact table to one or more dimension tables include: a$)$ list of properties sold by each real estate agent, b$)$ total properties sold by state, c$)$ types of properties sold by month and year, d$)$ dollar value of properties sold by each real estate company, e$)$ total homes sold by real estate agent by company by year.