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., both for each sensor location as well as for a city, state, region, etc.
Design an efficient data warehouse star schema that satisfies the above business scenario. Draw it on a piece of paper. Clearly identify the fact table(s), dimension table(s), primary key(s) and foreign key(s). [25]
