Design a MultiDim schema for the train application: A data warehouse of a train company contains information about train segments. It consists of six dimensions, namely, departure station, arrival...

Extracted text: Design a MultiDim schema for the train application: A data warehouse of a train company contains information about train segments. It consists of six dimensions, namely, departure station, arrival station, trip, train, arrival time, and departure time, and three measures, namely, number of passengers, duration, and number of kilometers.Define the OLAP operations to be performed in order to answer the following queries. Propose the dimension hierarchies when needed