Consider the following scenario involving Big Z Inc., an automotive products wholesaler. Big Z Inc. wants to
Fantastic news! We've Found the answer you've been seeking!
Question:
- Consider the following scenario involving Big Z Inc., an automotive products wholesaler.
Big Z Inc. wants to create an analytical database (data warehouse) to analyze its order quantities. The two available data sources, Source 1 and Source 2 are described below.
- Source 1 The Big Z Inc. Orders Database, shown in Figure 8.43.
- Source 2 The Big Z Inc. Human Resources Department Table, shown in Figure 8.44.
The data warehouse has to enable an analysis of order quantities by:
- • date, including:
- • full date
- • day of week
- • day of the month
- • month
- • quarter
- • year
- • time
- • product, including:
- • Product ID
- • product name
- • product type
- • product supplier name
Figure 8.43
Figure 8.44 Source 2: The Big Z Inc. Human Resources Department Table
- • customer, including:
- • customer ID
- • customer name
- • customer type
- • customer zip
- • depot, including:
- • Depot ID
- • depot size
- • depot zip
- • order clerk, including:
- • order clerk ID
- • order clerk name
- • order clerk title
- • order clerk education level
- • order clerk year of hire
- Based on the sources and requirements listed above, create an ER model and a mapped relational model for the normalized data warehouse for Big Z Inc.
- Using data from Figures 8.43 and 8.44 illustrate how the tables in the relational model created in E8.3c would be populated.
Related Book For
Introduction To Corporate Finance
ISBN: 9781118300763
3rd Edition
Authors: Laurence Booth, Sean Cleary
Posted Date: