Studierende stehen vor dem LC und blicken lächelnd einer Kollegin mit einer Mappe in der Hand nach.

Exercise No. 37: Sixt Car Rental Service (log)

This is an example about the Sixt car rental service.

Sixt cars are rent to customers who can be classified into customer groups (private, business, etc.). There's an option to rent a driver for the car as well. The car is serviced by a garage and belongs to a branch of the Sixt car rental service. This branch is responsible for a certain "renting" area and also belongs to the nationalwide operating Sixt car rental service (parallel hierarchy).

We have five dimensions with the following hierarchical structure (the third dimension features a parallel hierarchy at level 1):

Table L.E.22.1 - the Sixt car rental service

"Fee", "driven miles" and "no. of rents" are the key figures. Each customer has an additional attribute "C_cu_add", the customer's address and each driver has an additional attribute "D_dr_dob", the driver's date of birth.

Please draw the Classic Star Schema for this example, create the dimension tables "customer" , then build the Fact Constellation Schema. Also draw the example's dimension tables partitioned and use them to build a Snowflake Schema.

Solution

Exercises List