$2.$ Use the sample data file to design a dimensional model.

a$.1.$ Define the dimension tables and the fact table $(2$pts$).$

$2.$ Name the dimensional tables, the fact table, and the fields in the table $(3$pts$).$

$3.$ Determine the data type, and field length $(2$pts$).$

b$.$ Draw a star schema $(4$pts$).$

c$.$ Design two analytical questions based on the sample data and explain what decision each question can make $(4$pts$).$