IT 261

profilehelloworld
it261r2_normalization_data.xls
Home>Computer Science homework help>IT 261

Invoice

Date Customer No Customer Name Employee ID Sales person Part No Description Quanitity Price
6/1/07 3 Customer 3 5 Employee 5 13 Part 13 71 256.79
6/8/07 3 Customer 3 6 Employee 6 24 Part 24 34 258.75
6/18/07 6 Customer 6 5 Employee 5 25 Part 25 71 16.24
6/28/07 8 Customer 8 6 Employee 6 21 Part 21 34 420.6
7/4/07 5 Customer 5 1 Employee 1 10 Part 10 30 86.68
7/6/07 7 Customer 7 3 Employee 3 13 Part 13 30 256.79
7/14/07 3 Customer 3 5 Employee 5 14 Part 14 8 344.35
7/15/07 4 Customer 4 9 Employee 9 19 Part 19 14 241.36
7/24/07 7 Customer 7 1 Employee 1 16 Part 16 4 248.92
7/25/07 7 Customer 7 8 Employee 8 3 Part 3 14 32.14
7/31/07 2 Customer 2 8 Employee 8 24 Part 24 44 258.75
7/31/07 2 Customer 2 5 Employee 5 22 Part 22 66 212.44
8/1/07 7 Customer 7 8 Employee 8 15 Part 15 22 184.69
8/9/07 8 Customer 8 4 Employee 4 19 Part 19 74 241.36
8/13/07 2 Customer 2 1 Employee 1 26 Part 26 33 16.24
8/17/07 7 Customer 7 3 Employee 3 7 Part 7 74 149.94
8/25/07 6 Customer 6 1 Employee 1 23 Part 23 63 167.75
8/26/07 6 Customer 6 4 Employee 4 8 Part 8 3 81.66
9/1/07 6 Customer 6 9 Employee 9 5 Part 5 29 147.63
9/8/07 6 Customer 6 8 Employee 8 21 Part 21 62 420.6
9/15/07 7 Customer 7 6 Employee 6 26 Part 26 17 16.24
9/18/07 5 Customer 5 4 Employee 4 11 Part 11 36 7.66
9/23/07 4 Customer 4 5 Employee 5 20 Part 20 75 362.87
9/25/07 3 Customer 3 3 Employee 3 3 Part 3 69 32.14
9/30/07 9 Customer 9 2 Employee 2 18 Part 18 49 334.39
10/8/07 6 Customer 6 6 Employee 6 19 Part 19 27 241.36
10/9/07 10 Customer 10 1 Employee 1 20 Part 20 43 362.87
10/17/07 3 Customer 3 9 Employee 9 2 Part 2 60 5.83
10/20/07 2 Customer 2 1 Employee 1 3 Part 3 5 32.14
10/27/07 8 Customer 8 8 Employee 8 6 Part 6 13 95.62
10/31/07 4 Customer 4 9 Employee 9 25 Part 25 76 16.24
11/8/07 6 Customer 6 7 Employee 7 14 Part 14 21 344.35
11/14/07 8 Customer 8 2 Employee 2 23 Part 23 42 167.75
11/17/07 3 Customer 3 5 Employee 5 4 Part 4 29 237.55
11/26/07 4 Customer 4 2 Employee 2 3 Part 3 81 32.14
11/29/07 7 Customer 7 5 Employee 5 23 Part 23 33 167.75
12/6/07 2 Customer 2 10 Employee 10 22 Part 22 51 212.44
12/16/07 2 Customer 2 6 Employee 6 10 Part 10 73 86.68
12/24/07 2 Customer 2 9 Employee 9 2 Part 2 2 5.83
1/2/08 5 Customer 5 9 Employee 9 14 Part 14 26 344.35
1/5/08 7 Customer 7 3 Employee 3 24 Part 24 17 258.75
1/8/08 10 Customer 10 5 Employee 5 23 Part 23 19 167.75
1/10/08 1 Customer 1 5 Employee 5 5 Part 5 15 147.63
1/14/08 3 Customer 3 5 Employee 5 23 Part 23 75 167.75
1/17/08 7 Customer 7 8 Employee 8 23 Part 23 6 167.75
1/22/08 4 Customer 4 4 Employee 4 10 Part 10 3 86.68
1/31/08 8 Customer 8 9 Employee 9 14 Part 14 32 344.35
2/3/08 2 Customer 2 5 Employee 5 15 Part 15 29 184.69
2/10/08 7 Customer 7 4 Employee 4 10 Part 10 75 86.68
2/14/08 1 Customer 1 7 Employee 7 25 Part 25 47 16.24
2/18/08 9 Customer 9 6 Employee 6 11 Part 11 43 7.66
2/18/08 8 Customer 8 7 Employee 7 9 Part 9 80 470.11
2/21/08 1 Customer 1 5 Employee 5 25 Part 25 76 16.24
2/24/08 2 Customer 2 5 Employee 5 6 Part 6 9 95.62
3/2/08 4 Customer 4 2 Employee 2 25 Part 25 15 16.24
3/8/08 6 Customer 6 8 Employee 8 25 Part 25 24 16.24
3/18/08 9 Customer 9 7 Employee 7 14 Part 14 55 344.35
3/25/08 1 Customer 1 7 Employee 7 13 Part 13 78 256.79
3/31/08 8 Customer 8 9 Employee 9 22 Part 22 37 212.44
4/2/08 2 Customer 2 8 Employee 8 4 Part 4 44 237.55
4/9/08 5 Customer 5 5 Employee 5 17 Part 17 71 230.36
4/10/08 10 Customer 10 10 Employee 10 18 Part 18 37 334.39
4/18/08 8 Customer 8 5 Employee 5 14 Part 14 31 344.35
4/23/08 5 Customer 5 8 Employee 8 14 Part 14 80 344.35
4/24/08 8 Customer 8 3 Employee 3 9 Part 9 43 470.11
5/3/08 3 Customer 3 9 Employee 9 12 Part 12 46 25.06
5/7/08 9 Customer 9 8 Employee 8 14 Part 14 50 344.35
5/12/08 9 Customer 9 7 Employee 7 22 Part 22 28 212.44
5/14/08 3 Customer 3 9 Employee 9 5 Part 5 47 147.63
5/15/08 9 Customer 9 5 Employee 5 24 Part 24 78 258.75
5/21/08 6 Customer 6 1 Employee 1 3 Part 3 42 32.14
5/30/08 2 Customer 2 2 Employee 2 17 Part 17 24 230.36
6/7/08 2 Customer 2 9 Employee 9 7 Part 7 3 149.94
6/15/08 2 Customer 2 7 Employee 7 3 Part 3 17 32.14
6/20/08 5 Customer 5 5 Employee 5 8 Part 8 39 81.66
6/26/08 8 Customer 8 4 Employee 4 4 Part 4 76 237.55
7/5/08 1 Customer 1 3 Employee 3 8 Part 8 54 81.66
7/7/08 2 Customer 2 8 Employee 8 24 Part 24 17 258.75
7/15/08 6 Customer 6 7 Employee 7 22 Part 22 78 212.44
7/21/08 5 Customer 5 6 Employee 6 21 Part 21 31 420.6
7/26/08 1 Customer 1 3 Employee 3 21 Part 21 71 420.6
7/31/08 4 Customer 4 2 Employee 2 22 Part 22 46 212.44
8/6/08 4 Customer 4 3 Employee 3 13 Part 13 22 256.79
8/10/08 9 Customer 9 3 Employee 3 8 Part 8 63 81.66
8/13/08 8 Customer 8 7 Employee 7 2 Part 2 63 5.83
8/15/08 8 Customer 8 6 Employee 6 20 Part 20 43 362.87
8/15/08 8 Customer 8 4 Employee 4 23 Part 23 15 167.75
8/23/08 3 Customer 3 9 Employee 9 23 Part 23 1 167.75
9/1/08 2 Customer 2 4 Employee 4 11 Part 11 6 7.66
9/9/08 6 Customer 6 4 Employee 4 4 Part 4 47 237.55
9/15/08 4 Customer 4 10 Employee 10 16 Part 16 60 248.92
9/18/08 3 Customer 3 3 Employee 3 15 Part 15 45 184.69
9/26/08 6 Customer 6 1 Employee 1 8 Part 8 17 81.66
10/3/08 8 Customer 8 8 Employee 8 8 Part 8 24 81.66
10/6/08 8 Customer 8 2 Employee 2 2 Part 2 9 5.83
10/13/08 3 Customer 3 1 Employee 1 16 Part 16 21 248.92
10/16/08 5 Customer 5 3 Employee 3 9 Part 9 36 470.11
10/25/08 4 Customer 4 8 Employee 8 15 Part 15 77 184.69
10/26/08 7 Customer 7 9 Employee 9 5 Part 5 37 147.63
10/31/08 7 Customer 7 6 Employee 6 15 Part 15 34 184.69
11/9/08 4 Customer 4 6 Employee 6 4 Part 4 41 237.55
11/16/08 9 Customer 9 8 Employee 8 20 Part 20 79 362.87
11/22/08 2 Customer 2 6 Employee 6 3 Part 3 30 32.14
11/29/08 4 Customer 4 4 Employee 4 23 Part 23 33 167.75
12/6/08 5 Customer 5 9 Employee 9 16 Part 16 55 248.92
12/9/08 2 Customer 2 4 Employee 4 7 Part 7 30 149.94
12/14/08 3 Customer 3 3 Employee 3 2 Part 2 20 5.83
12/14/08 4 Customer 4 9 Employee 9 4 Part 4 11 237.55
12/24/08 9 Customer 9 6 Employee 6 6 Part 6 45 95.62
12/26/08 10 Customer 10 8 Employee 8 2 Part 2 31 5.83
1/5/09 2 Customer 2 8 Employee 8 4 Part 4 4 237.55
1/7/09 6 Customer 6 9 Employee 9 18 Part 18 16 334.39
1/11/09 9 Customer 9 5 Employee 5 11 Part 11 80 7.66
1/12/09 7 Customer 7 3 Employee 3 24 Part 24 4 258.75
1/18/09 8 Customer 8 9 Employee 9 9 Part 9 15 470.11
1/21/09 9 Customer 9 8 Employee 8 15 Part 15 5 184.69
1/24/09 9 Customer 9 2 Employee 2 22 Part 22 11 212.44
1/27/09 8 Customer 8 4 Employee 4 7 Part 7 14 149.94
1/29/09 4 Customer 4 5 Employee 5 9 Part 9 78 470.11

Customer

Customer No Customer Name Main Address Main Address 2 Main City Main State Main Zip Contact Name Contact Phone Pricing Tier
1 Customer 1 Main Street 2604 Main Street Dallas TX 16090 Contact 1 571-9915263- 2
2 Customer 2 Ruben Avenue 141 Ruben Avenue Baton Rouge LA 13641 Contact 2 129-6132869- 3
3 Customer 3 State Street 2854 State Street Suite 87 Miami FL 96752 Contact 3 838-8723073- 2
4 Customer 4 Lewiston Drive 2138 Lewiston Drive Boston MA 50007 Contact 4 877-6796692- 3
5 Customer 5 Anderson Place 380 Anderson Place Newport VT 56553 Contact 5 897-0493233- 3
6 Customer 6 Civic Boulevard 206 Civic Boulevard Suite 114 Helena MT 41809 Contact 6 958-1770191- 2
7 Customer 7 Bond Street 2483 Bond Street Provo UT 39292 Contact 7 624-9455249- 3
8 Customer 8 Park Place 233 Park Place San Francisco CA 14787 Contact 8 920-3530640- 2
9 Customer 9 Mountain Creek Drive 2253 Mountain Creek Drive Suite 87 Sisters OR 74794 Contact 9 588-4080875- 3
10 Customer 10 Wall Street 1246 Wall Street Suite 63 Peoria IL 64406 Contact 10 210-3946878- 3

Inventory

Part No Description Last Received Date Retail Price Last Sold Price Cost Units in Stock
1 Part 1 7/2/08 337.59 261.56 253.67 643
2 Part 2 9/1/08 6.77 5.83 5.21 18
3 Part 3 11/21/07 35.65 32.14 27.56 52
4 Part 4 11/24/07 299.36 237.55 152.47 257
5 Part 5 12/17/07 162.91 147.63 128.46 177
6 Part 6 7/29/08 119.37 95.62 57.17 907
7 Part 7 1/25/08 153.81 149.94 88.89 187
8 Part 8 2/28/08 108.32 81.66 70.23 251
9 Part 9 9/1/08 558.55 470.11 409.94 393
10 Part 10 6/25/08 101.51 86.68 60.46 493
11 Part 11 1/9/08 9.56 7.66 5.77 468
12 Part 12 5/31/08 27.65 25.06 19.3 634
13 Part 13 3/10/08 279.38 256.79 170.02 133
14 Part 14 5/28/08 346.42 344.35 188.4 778
15 Part 15 9/3/08 211.98 184.69 120.38 656
16 Part 16 11/20/07 258.46 248.92 248.72 490
17 Part 17 6/13/08 294.9 230.36 212.32 351
18 Part 18 6/6/08 439.04 334.39 220.85 702
19 Part 19 1/12/08 311.49 241.36 214.02 131
20 Part 20 1/3/08 413.74 362.87 208.82 389
21 Part 21 6/12/08 525.57 420.6 387.86 990
22 Part 22 8/9/08 233.16 212.44 184 184
23 Part 23 2/27/08 180.05 167.75 154.15 734
24 Part 24 4/15/08 282.5 258.75 207.48 125
25 Part 25 5/26/08 20.88 16.24 14.64 967
11/15/07

Employee

Employee ID Name Region State Hire Date
1 Employee 1 West ID 9/30/04
2 Employee 2 North IL 8/30/04
3 Employee 3 East MA 11/1/06
4 Employee 4 South TX 10/24/04
5 Employee 5 West CA 8/12/05
6 Employee 6 North MT 9/26/06
7 Employee 7 East NY 2/15/05
8 Employee 8 South LA 2/15/06
9 Employee 9 West OR 8/24/06
10 Employee 10 East NJ 6/17/04
1/1/04

Region

Region Name State Sales Totals
West ID 58350.1
West UT 23950.72
West WA 67537.3
West OR 40732.94
West CA 88440.42
West NV 51312.49
East NY 90590.47
East NJ 52527.62
East PA 60797.62
East ME 73622.97
East MA 18737.06
East VT 63255.12
North MT 66190.26
North WA 46865.09
North ND 88586.6
North MN 58958.89
North SD 99976.08
North IL 57752.21
South FL 60782.78
South AR 14126.99
South TX 41968.4
South NM 90386.58
South LA 73263.92
South GA 65593.47