Complete problem #$8$ & #$9$ in Chapter $13$ of the Mannino text. $($NOTE: the diagram is FIGURE $13.$P$1).$ You can use a design tool, draw it by hand or any method that you choose. You can also demonstrate via video if you choose. Discuss why you chose one design over the other. Provide responses to the questions in the problems.

Question $8.$ Design a star or snowflake schema to extend the schema from Problem $3.$ Your schema should use resolutions to summarizability problems that you identified in earlier problems.

Question $9.$ For each dimension table in the schema for Problem $8,$ list the independent and hierarchical dimensions. Analyze each hierarchical dimension for summary problems. Propose alternative representations to resolve any summarizability problems.