Sample Essay on SQL Server Business Intelligence

According to Bog et. al., (321-32), the main difference between a dimensional data model and a 3rd normal form schema is that the dimensional model is mostly applied in data warehousing systems while the 3rd normal form is often used in online transaction processing (OLTP) system types.