$1.$ Apply the flatten transformation for a policy item fact table. the auto insurance database uses a two$-$level representation of policy transactions. the data warehouse schema should contain a single fact table with $1-$M relationships from dimension tables to the fact table. ignore the InsuredParty entity for this problem.

$2.$ design a time dimension table and one or more relationships to the fact table in problem $1.$

$3.$ design a star or snowflake schema to extend the schema from Problem $1.$ your schema should use resolutions to summarizability problems that you identified in earlier problems.