Star Schema

Assignment 3

Question 2: Explain the Data warehouse approach you will adopt if you are asked to build a data warehouse for Sales and Credit departments of a global Company? Explain the advantages of the approach you picked.

Question 3:What is the role of Surrogate keys in Fact and Dimension tables. Explain advantages and disadvantages of these keys in a Data Warehouse?

Review the schema and identify potential design Flaws. The business process is Billing; the grain should be one row per service line (phone number) on a bill.

Bill #

CUSTOMER #

SALES REP KEY

SALES REP ORG ID

RATE PLAN CODE

Rate plan Type Code

# Calls

# Total Minutes

#Roam Minutes

# Toll Minutes

Service Charge

Roam Charge

Toll Charge

YTD Service Charge

CUSTOMER #

Customer Name

Customer City

Customer State

Customer ZIP

Authorization Credit

SALES REP KEY

Sales Rep #

Sales Rep Name

Sales Rep Org ID

SALES REP ORG ID

Sales Rep Channel ID

BILL #

Bill Date

Service Line #

SERVICE LINE #

Service Line Area Code

Service Line Prefix

Service Line Active Dt

RATE PLAN CODE

Rate plan Desc