creation of a table design to support data warehouse usage. You need to identify

creation of a table design to support data warehouse usage. You need to identify

creation of a table design to support data warehouse usage. You need to identify dimensions and measures, identify summarizability problems, and create a table design using transformations..follow the files Assiginement integration files has the question please go though it it should be enough. the solution file should be helpful.
it should consist the ERD diagrams and tables