Question Details

(Solved) Customers, Contacts and Reps Customer ID Customer Name 1001 Segal Inc. 1001 Segal Inc. 1002 Fair Weather Enterprises 1002 Fair Weather Enterprises...


All of the data you need for this project have been created for you, in an Excel workbook file named FINAL PROJECT DATA.XLS. This Excel file is one of the files you have downloaded from the server.

There are four worksheets in the workbook file:

Customers, Contacts & Reps
Territories
Products
Orders

But be careful: The layout of the sheets of data in the Excel file is not necessarily the organization that will work for your tables. In fact, you can bet it isn't. (Things don't work that easily when we're designing databases). You'll need to look at the data carefully and decide how they should be separated out for your tables. Spend some time on this.

As you begin this project, your first step (and this is a critical step) is to decide how your tables are going to be organized. Specifically:

  • Which fields will go in which table?
  • What will be the primary key field in each table?
  • What will be the foreign key field in each table?
  • How will each table be related to the other tables in the database, and what type of relationship will it be?

Customers, Contacts and Reps Customer
ID
Customer Name
1001 Segal Inc.
1001 Segal Inc.
1002 Fair Weather Enterprises
1002 Fair Weather Enterprises
1002 Fair Weather Enterprises
1003 Halston & Co.
1004 MMB Holdings
1004 MMB Holdings
1005 Ward Co.
1006 Bakertime Mobile
1006 Bakertime Mobile
1007 Classic Accents
1007 Classic Accents
1007 Classic Accents
1008 Summit Supply
1008 Summit Supply
1009 Harper & Ronick
1010 Professional Supply
1010 Professional Supply
1010 Professional Supply
1011 Silver Cloud
1012 Ryssell Bros.
1012 Ryssell Bros.
1012 Ryssell Bros.
1013 Omega Distributions
1013 Omega Distributions
1014 J&J Ltd.
1015 Dalhousie Inc. Contact First
Contact ID
Name
100 Harry
200 Mary Ann
335 Karen
336 Mark
337 Benjamin
600 Dianne
125 Pablo
126 Naomi
900 Jim
850 Tom
851 Ruth
1200 Dave
1201 Connie
1202 Teresa
1500 Gary
1501 John
1700 Lee
250 Ann
251 Bob
252 Aaron
2100 Maria
490 Maxine
487 Rachel
444 Jonathan
2500 Paul
2505 David
1780 Patty
2800 Jackie Contact Last
Name
Segal
Waters
Harper-Willis
Stevenson
Yang
Lorenzo
Diaz
Mirada
Shelby
DiBono
Schroeder
Burley
Burley
Perry
Giovanetti
Kim
Panetti
Zankoski
Zankoski
Zankoski
Shimano
Garrison
Pappas
Reusche
Tomazewski
Tonelli
Glico
Soupe Page 1 of 10 Contact Position
Vice President
CFO
Marketing Manager
CEO
CFO
CEO
CEO
CFO
COO
Vice President
CEO
CEO
Vice President
Marketing Manager
CFO
CEO
CEO
Marketing Manager
Vice President
CFO
President & CEO
Marketing Manager
Vice President
CEO
President & CEO
CFO
Marketing Manager
President & CEO Contact Phone
(603) 555-0987
(603) 555-0988
(617) 354-1234
(617) 354-1235
(617) 354-1236
(631) 757-3344
(703) 222-5678
(703) 222-5679
(617) 344-6677
(201) 455-8765
(201) 455-8766
(781) 566-2233
(781) 566-2234
(781) 566-2235
(304) 555-6677
(304) 555-6678
(206) 333-4455
(207) 354-0099
(207) 354-0100
(207) 354-0101
(704) 566-7889
(802) 455-1122
(802) 455-1123
(802) 455-1124
(305) 455-6778
(305) 455-6779
(603) 233-0099
(203) 456-7790 Customers, Contacts and Reps Customer
ID
Customer Name
1016 Larkspur Corp.
1017 Pro-Dist Co.
1017 Pro-Dist Co.
1017 Pro-Dist Co.
1018 De Palma Supply
1019 Cameron-Best
1020 MPM Inc. Contact First
Contact ID
Name
950 Jason
331 Gary
332 Brian
333 Michael
2750 Timothy
3400 Harriet
1510 Marvin Contact Last
Name
Monte
Twomey
Ross
Jackson
Warren
Billingsley
Gardens Page 2 of 10 Contact Position
CFO
Vice President
CEO
CFO
President
CFO
President & CEO Contact Phone
(201) 233-4567
(805) 999-1090
(805) 999-1091
(805) 999-1092
(806) 333-4556
(703) 233-5876
(508) 433-6543 Customers, Contacts and Reps Company Address
#11 - Hwy 16
#11 - Hwy 16
345 Wiltshire Avenue
345 Wiltshire Avenue
345 Wiltshire Avenue
387 Roper Place
4090 Lethbridge Street
4090 Lethbridge Street
35-9087 14th Street
759 East 31 Ave
759 East 31 Ave
324 Main Street
324 Main Street
324 Main Street
Ridgeway Connector
Ridgeway Connector
288 Landsdowne Drive
7241 South Drive
7241 South Drive
7241 South Drive
111 Rand Avenue
1255 Vollrath St
1255 Vollrath St
1255 Vollrath St
32 Merrit Ave
32 Merrit Ave
675 Cinnamon Ridge Road
2233 Southgate Avenue City
Nashua
Nashua
Cambridge
Cambridge
Cambridge
Northport
Vienna
Vienna
Boston
Trenton
Trenton
Burlington
Burlington
Burlington
Stoney Bluff
Stoney Bluff
Nicola
Thomaston
Thomaston
Thomaston
Baltimore
South Glenn
South Glenn
South Glenn
Orlando
Orlando
Manchester
Southgate State
NH
NH
MA
MA
MA
NY
VA
VA
MA
NJ
NJ
MA
MA
MA
WV
WV
CT
ME
ME
ME
MD
VT
VT
VT
FL
FL
NH
CT Sales
ZIP Territory Active? Rep ID
03060
2
Yes
C09
03060
2
Yes
C09
02139
1
Yes
A02
02139
1
Yes
A02
02139
1
Yes
A02
11768
5
Yes
B02
33067
7
Yes
B05
33067
7
Yes
B05
02115
1
Yes
A02
07882
5
Yes
B02
07882
5
Yes
B02
01803
1
Yes
A02
01803
1
Yes
A02
01803
1
Yes
A02
35666
7
No
B05
35666
7
No
B05
23445
3
Yes
A14
04778
4
Yes
C02
04778
4
Yes
C02
04778
4
Yes
C02
22777
6
Yes
A05
45668
4
Yes
C02
45668
4
Yes
C02
45668
4
Yes
C02
35667
8
No
C11
35667
8
No
C11
03101
2
Yes
C09
23555
3
Yes
A14 Page 3 of 10 Sales Rep Last
Name
Bocelli
Bocelli
Duke
Duke
Duke
Bose
van der Ham
van der Ham
Duke
Bose
Bose
Duke
Duke
Duke
van der Ham
van der Ham
Fink
Bonham
Bonham
Bonham
Louis-Hawkins
Bonham
Bonham
Bonham
Masterson
Masterson
Bocelli
Fink Sales Rep
First Name
Carl
Carl
Arthur
Arthur
Arthur
Sally
Lawrence
Lawrence
Arthur
Sally
Sally
Arthur
Arthur
Arthur
Lawrence
Lawrence
Peter
Earl
Earl
Earl
Brenda
Earl
Earl
Earl
Janet
Janet
Carlos
Peter Sales Rep Sales Rep
Phone
Hours
(603) 522-6487
38
(603) 522-6487
38
(617) 336-5547
40
(617) 336-5547
40
(617) 336-5547
40
(207) 422-7411
38
(202) 844-6033
35
(202) 844-6033
35
(617) 336-5547
40
(207) 422-7411
38
(207) 422-7411
38
(617) 336-5547
40
(617) 336-5547
40
(617) 336-5547
40
(202) 844-6033
35
(202) 844-6033
35
(860) 545-9823
30
(802) 455-9070
38
(802) 455-9070
38
(802) 455-9070
38
(212) 224-3322
35
(802) 455-9070
38
(802) 455-9070
38
(802) 455-9070
38
(703) 342-4392
40
(703) 342-4392
40
(603) 522-6487
38
(860) 545-9823
30 Customers, Contacts and Reps Company Address
4949 Douglas Road
1121 Lorne Drive
1121 Lorne Drive
1121 Lorne Drive
988 Laval Crescent
429 Mt Ida Drive
3535 Bank Road City
Princeton
Montrose
Montrose
Montrose
Pemberton
East Gardom
Gardner State
NJ
NC
NC
NC
SC
VA
MA Sales
ZIP Territory Active? Rep ID
12234
5
Yes
B02
46777
8
No
C11
46777
8
No
C11
46777
8
No
C11
53488
8
Yes
C11
33068
7
Yes
B05
01440
1
Yes
A02 Page 4 of 10 Sales Rep Last
Name
Bose
Masterson
Masterson
Masterson
Masterson
van der Ham
Duke Sales Rep
First Name
Sally
Janet
Janet
Janet
Janet
Lawrence
Arthur Sales Rep Sales Rep
Phone
Hours
(207) 422-7411
38
(703) 342-4392
40
(703) 342-4392
40
(703) 342-4392
40
(703) 342-4392
40
(202) 844-6033
35
(617) 336-5547
40 Customers, Contacts and Reps Sales Rep
Date Hired
9/20/2001
9/20/2001
6/25/2002
6/25/2002
6/25/2002
4/10/2000
6/30/2001
6/30/2001
6/25/2002
4/10/2000
4/10/2000
6/25/2002
6/25/2002
6/25/2002
6/30/2001
6/30/2001
10/25/1999
2/15/2000
2/15/2000
2/15/2000
7/15/1999
2/15/2000
2/15/2000
2/15/2000
11/30/1998
11/30/1998
9/20/2001
10/25/1999 Page 5 of 10 Customers, Contacts and Reps Sales Rep
Date Hired
4/10/2000
11/30/1998
11/30/1998
11/30/1998
11/30/1998
6/30/2001
6/25/2002 Page 6 of 10 Territory Code Territory Name
1 Massachusetts
2 New Hampshire
3 Connecticut
4 Maine / Vermont
5 New York / New Jersey
6 Washington DC / Maryland
7 Virginia / West Virginia
8 Southeast Sales Rep
Duke, Arthur
Bocelli, Carl
Fink, Peter
Bonham, Earl
Bose, Sally
Louis-Hawkins, Brenda
van der Ham, Lawrence
Masterson, Janet Product Code
B12
DF14
DF16
DF210S
DF242
DF24S
DF24U
DF26
DF28
O12
O38
P12
P12U
P14
P34
P34T
P38
P58
P58T
P58U
SP14
SP14R
SP16
SP18
SP210
SP212
SP242
SP243
SP24U
SP26S
SP28S
W12
W14
WP110
WP13
WP14
WP16
WP18
YP210
YP242
YP243
YP24R
YP24RG
YP24S
YP24U
YP262
YP26R
YP26S
YP28S Description
Cab. Lumber
Ungraded lumber
Ungraded lumber
Standard lumber
2+ Oak
Standard lumber
Utility Pine
Standard lumber
Standard lumber
Cab. Lumber
Cab. Lumber
Constr. Lumber
Utility Pine
Constr. Lumber
Constr. Lumber
Constr. Lumber
Constr. Lumber
Constr. Lumber
Constr. Lumber
Utility Pine
Ungraded lumber
Ungraded lumber
Ungraded lumber
Ungraded lumber
Standard lumber
Standard lumber
2+ Oak
3+ Ash
Utility Pine
Standard lumber
Standard lumber
Cab. Lumber
Cab. Lumber
Utility Pine
Utility Pine
Utility Pine
Utility Pine
Utility Pine
Standard lumber
2+ Oak
3+ Ash
Ungraded lumber
Ungraded lumber
Standard lumber
Utility Pine
2+ Oak
Ungraded lumber
Standard lumber
Standard lumber Category
Plywood
Board
Board
Dim.
Dim.
Dim.
Dim.
Dim.
Dim.
Plywood
Plywood
Plywood
Plywood
Plywood
Plywood
Plywood
Plywood
Plywood
Plywood
Plywood
Board
Board
Board
Board
Dim.
Dim.
Dim.
Dim.
Dim.
Dim.
Dim.
Plywood
Plywood
Board
Board
Board
Board
Board
Dim.
Dim.
Dim.
Dim.
Dim.
Dim.
Dim.
Dim.
Dim.
Dim.
Dim. Size
0.5
1X4
1X6
2 X 10
2X4
2X4
2X4
2X6
2X8
0.5
0.375
0.50
0.5
0.25
0.75
0.75
0.375
0.625
0.675
0.625
1X4
1X4
1X6
1X8
2 X 10
2 X 12
2X4
2X4
2X4
2X4
2X8
0.5
0.25
1 X 10
1X3
1X4
1X6
1X8
2 X 10
2X4
2X4
2X4
2X4
2X4
2X4
2X6
2X6
2X6
2X8 Finish
G2S
RGH
RGH
S4S
S4S
S4S
S4S
S4S
S4S
G2S
G2S
G1S
RGH
G1S
G1S
T&G
G1S
G1S
T&G
RGH
RGH
RGH
RGH
RGH
S4S
S4S
S4S
S4S
S4S
S4S
S4S
G2S
G2S
RGH
RGH
RGH
RGH
RGH
S4S
S4S
S4S
RGH
RGH
S4S
S4S
S4S
RGH
S4S
S4S List Price Discount
$2.45
3.0%
$1.90
2.5%
$1.85
2.5%
$2.10
3.5%
$2.85
4.0%
$2.10
3.5%
$1.75
4.0%
$2.10
3.5%
$2.10
3.5%
$1.19
3.0%
$1.25
3.0%
$1.32
3.0%
$1.75
4.0%
$2.10
3.0%
$2.19
3.0%
$2.17
3.0%
$1.99
3.0%
$1.88
3.0%
$1.75
3.0%
$1.75
4.0%
$1.85
2.5%
$1.64
2.5%
$1.52
2.5%
$1.85
2.5%
$2.10
3.5%
$2.10
3.5%
$2.85
4.0%
$1.90
2.0%
$1.75
4.0%
$2.10
3.5%
$2.10
3.5%
$2.45
3.0%
$2.45
3.0%
$1.75
4.0%
$1.62
4.0%
$1.55
4.0%
$1.80
4.0%
$1.92
4.0%
$2.10
3.5%
$2.85
4.0%
$1.98
4.0%
$1.18
2.5%
$1.23
2.5%
$2.10
3.5%
$1.95
3.0%
$2.85
4.0%
$1.19
2.5%
$2.10
3.5%
$2.10
3.5% Product Code
B12
DF14
DF16
DF210S
DF242
DF24S
DF28
O12
O38
P12
P14
P34
P34T
P38
P58
P58
P58
SP16
SP210
SP212
SP243
P58
SP26S
SP28S
W12
WP13
WP18
YP210
YP242
YP243
YP24R
YP24RG Customer ID
1016
1003
1020
1019
1005
1006
1009
1010
1011
1012
1014
1003
1012
1005
1001
1019
1020
1004
1019
1002
1015
1007
1005
1016
1010
1018
1019
1005
1020
1009
1010
1005 Rep ID
B02
B02
A02
B05
A02
B02
A14
C02
A05
C02
C09
B02
C02
A02
C09
B05
A02
B05
B05
A02
A14
A02
A02
B02
C02
C11
B05
A02
A02
A14
C02
A02 Quantity Ordered Date of Order Date Filled
300
2/5/2002
2/10/2002
250
4/7/2002
4/17/2002
175
3/12/2002
3/15/2002
150
7/18/2002
7/21/2002
2,000
8/1/2002
8/10/2002
380
5/16/2002
5/20/2002
400
10/1/2002
10/9/2002
250
11/30/2002
12/4/2002
1,800
1/3/2003
1,750
1/10/2003
1,200
6/19/2002
6/24/2002
1,150
7/18/2002
7/21/2002
980
8/1/2002
8/10/2002
650
8/20/2002
9/3/2002
500
6/7/2002
6/17/2002
975
1/20/2003
600
2/5/2002
2/10/2002
1,100
4/7/2002
4/17/2002
1,265
12/10/2002 12/15/2002
1,100
1/23/2003
1,400
1/25/2003
475
1/29/2003
550
6/19/2002
6/24/2002
880
7/1/2002
7/11/2002
900
7/18/2002
7/21/2002
400
8/1/2002
8/10/2002
345
2/5/2002
2/10/2002
282
4/7/2002
4/17/2002
190
3/12/2002
3/15/2002
875
7/18/2002
7/21/2002
740
5/17/2002
5/24/2002
550
1/29/2003 Order Complete?
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $18

Solution~000200069656.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now