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
Get step-by-step solutions from verified subject matter experts
