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 snow?ake 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 datawarehouse.
Goal of the above is:
Data warehousing presents a distinct set of challenges. Many companies have delved into data warehousing without knowing the required parameters, only to find they must back away from the project and seek outside sources for guidance. A relative challenge is the building and maintaining of a data dictionary - and ensuring that everyone who needs it understands what is in it and has access to it.
Please provide a step-by-step progression toward the desired product.
Though detailing, try to limit your product to within one to three pages.
If you choose to use outside research, please cite your source.