Diferentiate btw d flwn:Database and Data Warehouse, Data

p>1)Compare and contrast OLTP and OLAP
2)What are the differences between the following main types of data warehouse usage
(i) Information processing
(ii) Analytical processing
(iii) Data Mining
B)What is the role of information visualization in data mining?
C)Describe two challenges to data mining regarding performance issues.
D)Present an example where data mining is crucial to the success of a business.
E)Discuss the current trends in data mining
3)Design a data warehouse for a regional weather bureau.The weather bureau has about 1000 probes, which are scattered throughout various land and ocean locations in the region to collect basic weather data including air pressure, temperature and precipitation at each hour. AlI data are sent to the central station, which has collected such data for over
10 years. Your design should facilitate querying and online analytical processing.