Video Centers of Europe, Ltd. data warehouse:

a. Design a multidimensional database using a star schema for a data warehouse for the Video Centers of Europe, Ltd. business environment described in the diagram associated with Exercise 2.2. The subject will be ‘‘rental,’’ which represents a particular tape or DVD being rented by a particular customer. As stated in Exercise 2.2, be sure to keep track of the rental date and the price paid. Include a snowflake feature based on the actor, movie, and tape/DVD entities.

b. Describe three OLAP uses of this data warehouse.

c. Describe one data mining use of this data warehouse.