Super Baseball League data warehouse:

a. Design a multidimensional database using a star schema for a data warehouse for the Super Baseball League business environment described in Minicase 2.2. The subject will be ‘‘affiliation,’’ which represents a particular player having played on a particular team. As stated in Minicase 2.2, be sure to keep track of the number of years that the player played on the team and the batting average he compiled on it.

b. Describe three OLAP uses of this data warehouse.

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