This simplified E$/$R schema shows a Video Rental Streaming System.

Each movie is rented by a customer and access to it concludes on the Due Date. The time dimension consists of day, week and quarter.

Please identify the fact of interest and build the attribute tree. Prune attributes if necessary and identify an any attributes that cannot be aggregated in a meaningful way. Those should be tagged as non$-$dimension attributes in the fact schema.

Then derive the fact schema from the tree by defining dimensions, fact attributes and hierarchies and build a glossary for the fact attributes if there are any.

Please include additional fact attributes counting the number of rentals and number of rental days.

$1.$ Identify fact of interest, dimensions, and measures.

$2.$ For each fact:

a$.$ Produce the attribute tree

b$.$ Produce the fact schema.

c$.$ Design the star or snowflake schema.