Please study the table and write out a data base and see how they are related with each other OrderDate Region Rep Item Units Unit Price Total 4 Jul 14 East Richard Pen Set 62 4 99 309 38 12 Jul 14 East Nick Binder 29 1 99 57 71 21 Jul 14 Central Morgan Pen Set 55 12 49 686 95 29 Jul 14 East Susan Binder 81 19 99 1619 19 7 Aug 14 Central Matthew Pen Set 42 23 95 1005 9 15 Aug 14 East Richard Pencil 35 4 99 174 65 24 Aug 14 West James Desk 3 275 825 1 Sep 14 Central Smith Desk 2 125 250 10 Sep 14 Central Bill Pencil 7 1 29 9 03 18 Sep 14 East Richard Pen Set 16 15 99 255 84 27 Sep 14 West James Pen 76 1 99 151 24 5 Oct 14 Central Morgan Binder 28 8 99 251 72 14 Oct 14 West Thomas Binder 57 19 99 1139 43 22 Oct 14 East Richard Pen 64 8 99 575 36 31 Oct 14 Central Rachel Pencil 14 1 29 18 06 8 Nov 14 East Susan Pen 15 19 99 299 85 17 Nov 14 Central Alex Binder 11 4 99 54 89 25 Nov 14 Central Matthew Pen Set 96 4 99 479 04 4 Dec 14 Central Alex Binder 94 19 99 1879 06 12 Dec 14 Central Smith Pencil 67 1 29 86 43 21 Dec 14 Central Rachel Binder 28 4 99 139 72 29 Dec 14 East Susan Pen Set 74 15 99 1183 26 6 Jan 15 East Richard Pencil 95 1 99 189 05 15 Jan 15 Central Bill Binder 46 8 99 413 54 23 Jan 15 Central Matthew Binder 50 19 99 999 5 1 Feb 15 Central Smith Binder 87 15 1305 9 Feb 15 Central Alex Pencil 36 4 99 179 64 18 Feb 15 East Richard Binder 4 4 99 19 96 26 Feb 15 Central Bill Pen 27 19 99 539 73 7 Mar 15 West James Binder 7 19 99 139 93 15 Mar 15 West James Pencil 56 2 99 167 44 24 Mar 15 Central Alex Pen Set 50 4 99 249 5 1 Apr 15 East Richard Binder 60 4 99 299 4 10 Apr 15 Central Rachel Pencil 66 1 99 131 34 18 Apr 15 Central Rachel Pencil 75 1 99 149 25 27 Apr 15 East Nick Pen 96 4 99 479 04 5 May 15 Central Alex Pencil 90 4 99 449 1 14 May 15 Central Bill Pencil 53 1 29 68 37 22 May 15 West Thomas Pencil 32 1 99 63 68 31 May 15 Central Bill Binder 80 8 99 719 2 8 Jun 15 East Richard Binder 60 8 99 539 4 17 Jun 15 Central Matthew Desk 5 125 625 25 Jun 15 Central Morgan Pencil 90 4 99 449 1

The Answer is in the image, click to view ...

Question: Please study the table and write out a data base and see how they are related with each other OrderDate Region Rep Item Units Unit

Please study the table and write out a data base and see how they are related with each other

OrderDate	Region	Rep	Item	Units	Unit Price	Total
4-Jul-14	East	Richard	Pen Set	62	4.99	309.38
12-Jul-14	East	Nick	Binder	29	1.99	57.71
21-Jul-14	Central	Morgan	Pen Set	55	12.49	686.95
29-Jul-14	East	Susan	Binder	81	19.99	1619.19
7-Aug-14	Central	Matthew	Pen Set	42	23.95	1005.9
15-Aug-14	East	Richard	Pencil	35	4.99	174.65
24-Aug-14	West	James	Desk	3	275	825
1-Sep-14	Central	Smith	Desk	2	125	250
10-Sep-14	Central	Bill	Pencil	7	1.29	9.03
18-Sep-14	East	Richard	Pen Set	16	15.99	255.84
27-Sep-14	West	James	Pen	76	1.99	151.24
5-Oct-14	Central	Morgan	Binder	28	8.99	251.72
14-Oct-14	West	Thomas	Binder	57	19.99	1139.43
22-Oct-14	East	Richard	Pen	64	8.99	575.36
31-Oct-14	Central	Rachel	Pencil	14	1.29	18.06
8-Nov-14	East	Susan	Pen	15	19.99	299.85
17-Nov-14	Central	Alex	Binder	11	4.99	54.89
25-Nov-14	Central	Matthew	Pen Set	96	4.99	479.04
4-Dec-14	Central	Alex	Binder	94	19.99	1879.06
12-Dec-14	Central	Smith	Pencil	67	1.29	86.43
21-Dec-14	Central	Rachel	Binder	28	4.99	139.72
29-Dec-14	East	Susan	Pen Set	74	15.99	1183.26
6-Jan-15	East	Richard	Pencil	95	1.99	189.05
15-Jan-15	Central	Bill	Binder	46	8.99	413.54
23-Jan-15	Central	Matthew	Binder	50	19.99	999.5
1-Feb-15	Central	Smith	Binder	87	15	1305
9-Feb-15	Central	Alex	Pencil	36	4.99	179.64
18-Feb-15	East	Richard	Binder	4	4.99	19.96
26-Feb-15	Central	Bill	Pen	27	19.99	539.73
7-Mar-15	West	James	Binder	7	19.99	139.93
15-Mar-15	West	James	Pencil	56	2.99	167.44
24-Mar-15	Central	Alex	Pen Set	50	4.99	249.5
1-Apr-15	East	Richard	Binder	60	4.99	299.4
10-Apr-15	Central	Rachel	Pencil	66	1.99	131.34
18-Apr-15	Central	Rachel	Pencil	75	1.99	149.25
27-Apr-15	East	Nick	Pen	96	4.99	479.04
5-May-15	Central	Alex	Pencil	90	4.99	449.1
14-May-15	Central	Bill	Pencil	53	1.29	68.37
22-May-15	West	Thomas	Pencil	32	1.99	63.68
31-May-15	Central	Bill	Binder	80	8.99	719.2
8-Jun-15	East	Richard	Binder	60	8.99	539.4
17-Jun-15	Central	Matthew	Desk	5	125	625
25-Jun-15	Central	Morgan	Pencil	90	4.99	449.1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

OrderDate Region Rep Item Units Unit Price Total 4-Jul-14 East Richard Pen Set 62 4.99 309.38 12-Jul-14 East Nick Binder 29 1.99 57.71 21-Jul-14 Central Morgan Pen Set 55 12.49 686.95 29-Jul-14 East...

OrderDate Region Rep Item Units UnitCost Total 6/1/2020 East Jones Eraser 95 1.99 189.05 1/23/2020 Central Kivell Binder 50 19.99 999.5 9/2/2020 Central Jardine Eraser 36 4.99 179.64 2/26/2020...

please help me on the following questions : 1. Add the $ sign to the Unit Cost column; 2. Determine the Total Sales for each item (multiply Units Sold times Unit Price); 3. Highlight in bold the...

Write a function, sortedSales(ifile) which takes the OfficeSupplies.csv file and uses a dictionary to calculate and store the total sales of each sales person. This function prints the salesperson...

1. Open Tableau. 2. Open the Microsoft Excel Worksheet titled Car Sales. 3. Click on the Data Source Tab. 4. Take a screenshot of the Data Source Tab showing the data. Make sure to save ALL...

1. Casel Ivana's Ice Cream just finished its first six months of manufacturing and selling ice cream. The company has two main product lines, Ice cream cups and ice cream bars, both of which are...

From 1998-2006 there were four large, well-funded competitors in the regional theme park industry. In order: Six Flags, Cedar Fair, Paramount Parks, and Busch Entertainment. Of these, Cedar Fair was...

Cedar Fair CaseCompanion Case to Six Flags CaseFrom 1998-2006 there were four large, well-funded competitors in the regional theme park industry. Inorder: Six Flags, Cedar Fair, Paramount Parks, and...

can someone help me with this please let me know if you need more info Required information [The following information applies to the questions displayed below.) This Applying Excel worksheet...

Card, D., Krueger, A.B. (1994). Minimum wages and employment: a case study of the fast-food industry in New Jersey and Pennsylvania. American Economic Review, 84(4), 772-93. Once you have read your...

Decorator Plus Imports recently reported the following stockholders' equity: Suppose Decorator Plus split its common stock 2-for-1 in order to decrease the market price per share of its stock. The...

Frank Inc. is trying to decide whether to lease or purchase a piece of equipment needed for the next ten years. The equipment would cost $45,000 to purchase, and maintenance costs would be $5,000 per...

14.68 When a dummy variable is included in a regression model that has one numerical independent variable, what assumption do you need to make concerning the slope between the dependent variable, Y,...

what is a APA citation style?

3. To learn more about how emotions influence your thinking and behavior, complete each of the following sentences. Once you have completed them all, reflect on your written responses.

1. Danny Meyer believes that his philosophy of customer service is applicable to any business or organization. Do you agree? Explain.

2. All of the managers working for Danny Meyer are encouraged to hire employees that display natural warmth, optimism, empathy, a strong work ethic, and integrity. What interview methods would help a...