Module Objective $2\mathrm{.}2$: Compare and Contrast the design and purpose of OLIP vs

OLAP databases:

How and why do the designs differ? What business functions do each $($OLTP and OLAP$)$ support? $(5$pts$)$

What are the similarities and differences between the star and snowflake schemas? $(5$pts$)$

How does normalization affect these designs $($OLTP and OLAP$)?(5$pts$)$