Databases Reference
In-Depth Information
SALESPERSON
Salesperson
Salesperson
Commission
Year
Number
Name
Percentage
of Hire
137
Baker
10
1995
186
Adams
15
2001
204
Dickens
10
1998
361
Carlyle
20
2001
PRODUCT
Product
Product
Unit
Number
Name
Price
16386
Wrench
12.95
19440
Hammer
17.50
21765
Drill
32.99
24013
Saw
26.25
26722
Pliers
11.50
TIME PERIOD
Time
Period
Number
Year
Quarter
Month
Week
001
1997
1
1
1
002
1997
1
1
2
003
1997
1
1
3
101
1998
4
3
1
102
1998
4
3
2
103
1998
4
3
3
104
1998
4
3
4
329
2003
2
2
1
330
2003
2
2
2
F IGURE 13.7
General Hardware Company data
warehouse sample data
331
2003
2
2
3
(Continues)
given the Time Period Number value of 001. The week after that was given the
Time Period Number value of 002, and so on to the latest week stored. Now, look
at the SALE table. Row 10 indicates that salesperson 137 sold 59 units of product
24013 during time period 103, which according to the TIME PERIOD table was
the second week of the third month of the fourth quarter of 1998 (i.e. the second
week of December, 1998). Row 17 of the SALE table shows that salesperson 204
sold 44 units of product 16386 during time period 331, which was the third week
of May, 2003. Overall, as you look at the SALE table from row 1 down to row 20,
you can see the historic nature of the data and the steady, forward time progression
as the Time Period Number attribute starts with time period 001 in the first couple
of records and steadily increases to time period 331 in the last batch of records.
Search WWH ::
Custom Search