Trajectory Data Warehouses - Data Warehouse Systems: Design and Implementation - page 495

Fig. 12.10 A multidimensional schema for analyzing air quality
The conceptual multidimensional schema of this application is given in
Fig. 12.10 . Translate the schema into a logical schema.
12.5 Write in SQL the following queries on the relational schema obtained
in Ex. 12.4 :
(a) For pollutants belonging to the organic category, give the maximum
value by station and month.
(b) For stations located on the Autostrada del Sole, give the average
values of lead registered in the last quarter of 2010.
(c) For stations located at a distance of at most 1km of the Autostrada
del Sole, give the average values of lead registered in the last quarter
of 2010.
(d) For zones with at least 20% of industrial land use, give the average
value for carbon monoxide on February 1, 2012.
(e) Roads located in industrial zones, such that the average tempera-
ture in 2012 along the road was higher than 20 ◦ C.
(f) Maximum temperatures by land use type in 2012.
(g) Maximum temperatures in 2012 in stations where organic pollu-
tants were over the limit more than five times.