Consider the following scenario.
A weather monitoring agency (WMA) has installed different sensors in different parts of a country. Each sensor captures temperature and pressure of the location it is deployed and sends the data to a server where a data warehouse is maintained. The WMA needs to know the temperature and pressure at every sensor location at every second. Their analysis requirements include getting to know the average, maximum, minimum, etc., values of these parameters over a minute, hour, day, week, month, season, year, etc., for each sensor location as well as for a city, state, region, etc.
Design an efficient data warehouse schema that satisfies the above business scenario. Draw it on the piece of paper provided. Clearly identify the fact table(s), dimension table(s), primary key(s) and foreign key(s). Design an OLAP cube in Oracle AWM containing various combinations of dimensions. [25+25=50]
Through Moodle, against separate links, submit the scanned copy of your star schema and screenshots of your OLAP cube. (Name it as Lab7_<Roll_no> with appropriate extensions). Submit only pdf/jpeg/png format files. Do not submit Zip files.
