$|$NFO $1620$: DATA WAREHOUSES

Introduction to Database Design

This assignment will address the following unit objectives:

List two major reasons most organizations today need data warehousing.

Explain the various forms of data transformations needed to prepare data for a data warehouse

Grading:

The assignment is worth $20$ points. Point values are noted with each task.

Task $1(2pts)$

$($abjective $1)$

List two major reasons most organizations today need data warehousing.

Data Integration: Data warehousing enables businesses to combine and integrate data from severa

sources into a single, cohesive perspective. Having a thorough and consistent perspective of the data

makes it possible to make better decisions and conduct better analyses. Historical Analysis: Data

warehousing keeps track of historical data across time, enabling businesses to analyze trends, spot

patterns, and draw conclusions about present$-$day behavior and performance.

Task pts$)$

Match the letter of the term in the list below, to the appropriate term definition of associated phrase. If a

definition or phrase does not match a term on the list, enter I to indicate you found no match. Your answers

will appear in red, which is to help your instructor when grading.

Task $3(6$ pts$)$

$($abjective $2)$

Complete the case using the information and instructions below.

You have been hired to construct a star schema for Geico. The relevant dimensions, attributes and sizes are

as follows: