Question: The company would like to implement a data warehouse that can be used to implement the following applications. (i) find the total number of kilometers

The company would like to implement a data warehouse that can be used to implement the following applications. (i) find the total number of kilometers travelled by each bus per year, per month per day. (ii) find the total number of trips performed per bus, per driver, per year, per month, per day. (iii) find the total number of drivers per trip. (iv) find the total number travels per a trip segment, per trip, per bus, per year, per month per day. (v) find an average duration of bus travel per trip segment, per trip, per year, per month per day. (vi) find the total fuel consumption per trip segment, per trip, per bus model, per manufacturer, per year, per month, per day. (vii) find the total number of trips per bus, per depot, per city (viii) find the total number of passengers per segment, per trip, per year, per month per day. (ix) find the largest number of passengers per bus, per trip, (x) find an average number of passengers per trip. (1) Use a short explanation of a database domain and a conceptual schema given above, to find a data cube, that should be implemented by the bus

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!