Happy Cruise Lines data warehouse:

a. Design a multidimensional database using a star schema for a data warehouse for the Happy Cruise Lines business environment described in Minicase 2.1. The subject will be ‘‘passage,’’ which represents a particular passenger booking on a particular cruise.

As stated in Minicase 2.1, be sure to keep track of the fare that the passenger paid for the cruise and the passenger’s satisfaction rating of the cruise.

b. Describe three OLAP uses of this data warehouse.

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