A D E G 1 OrderDate Region Rep Item Units Unit Cost Total 2 1/6/2019 Pencil Binder East Jones 95 1.99 189.05 3 1/23/2019 4 2/9/2019 5 2/26/2019 Central Kivell 50 19.99 999.5 Central Jardine Pencil 36 4.99 179.64 Central Gill Pen 27 19.99 539.73 6 3/15/2019 7 4/1/2019 8 4/18/2019 9 5/5/2019 10 5/22/2019 11 6/8/2019 12 6/25/2019 13 7/12/2019 14 7/29/2019 15 8/15/2019 16 9/1/2019 17 9/18/2019 18 10/5/2019 19 10/22/2019 West Sorvino Pencil 56 2.99 167.44 Binder Pencil Pencil East Jones 60 4.99 299.4 Central Andrews Jardine 75 1.99 149.25 Central 90 4.99 449.1 Thompson Pencil Binder Pencil Binder Binder Pencil Desk West 32 1.99 63.68 East Jones 60 8.99 539.4 Central 90 4.99 449.1 Morgan Howard East 29 1.99 57.71 East Parent 81 19.99 1619.19 East Jones 35 4.99 174.65 Central Smith 2 125 250 East Jones Pen Set 16 15.99 255.84 Central Morgan Binder 28 8.99 251.72 East Jones Pen 64 8.99 575.36 20 11/8/2019 Parent Kivell East Pen 15 19.99 299.85 21 11/25/2019 22 12/12/2019 23 12/29/2019 24 1/15/2020 25 2/1/2020 26 2/18/2020 27 3/7/2020 28 3/24/2020 29 4/10/2020 Central Pen Set 96 4.99 479.04 Central Smith Pencil 67 1.29 86.43 East Parent Pen Set 74 15.99 1183.26 Central Gill Binder 46 8.99 413.54 Central Smith Binder 87 15 1305 East Jones Binder 4 4.99 19.9E West Sorvino Binder 7 19.99 139.93 Central Jardine Pen Set 50 4.99 249.5 Central Andrews Pencil 66 1.99 131.34 30 4/27/2020 31 5/14/2020 32 5/31/2020 East Howard Pen 96 4.99 479.04 Central Gill Pencil 53 1.29 68.37 Central Gill Binder 80 8.99 719.2 33 6/17/2020 34 7/4/2020 35 7/21/2020 36 8/7/2020 37 8/24/2020 38 9/10/2020 Central 625 Kivell Jones Morgan Kivell Desk 5 125 East Pen Set 62 4.99 309.38 Central Pen Set 55 12.49 686.95 Central Pen Set 42 23.95 1005.9 West Sorvino Desk 3 275 825 Central Gill Pencil 7 1.29 9.03 39 9/27/2020 40 10/14/2020 41 10/31/2020 West Sorvino Pen 76 1.99 151.24 Thompson Binder Andrews West 57 19.99 1139.43 Central Pencil 14 1.29 18.06 42 11/17/2020 43 12/4/2020 44 12/21/2020 Binder Binder Central Jardine 11 4.99 54.89 Central Jardine 94 19.99 1879.06 Central Andrews Binder 28 4.99 139.72

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
3. Explain briefly full reporting.
A
C
F
G
Rep
Jones
Total
189.05
1
OrderDate
Region
Item
Units
Unit Cost
2 1/6/2019
East
Pencil
95
1.99
1/23/2019
999.5
Kivell
Jardine
Central
Binder
50
19.99
2/9/2019
Central
Pencil
36
4.99
179.64
5 2/26/2019
6 3/15/2019
7 4/1/2019
Central
Gill
Pen
27
19.99
539.73
Pencil
Binder
West
Sorvino
56
2.99
167.44
East
Jones
60
4.99
299.4
8
4/18/2019
Central
Andrews
Pencil
75
1.99
149.25
9
5/5/2019
Central
Jardine
Pencil
90
4.99
449.1
Thompson Pencil
Jones
10 5/22/2019
West
32
1.99
63.68
11 6/8/2019
East
Binder
60
8.99
539.4
12 6/25/2019
13 7/12/2019
14 7/29/2019
15 8/15/2019
16 9/1/2019
17 9/18/2019
18 10/5/2019
19 10/22/2019
20 11/8/2019
21 11/25/2019
22 12/12/2019
Central
Pencil
90
4.99
449.1
Morgan
Howard
Binder
Binder
East
29
1.99
57.71
East
Parent
81
19.99
1619.19
East
Jones
Pencil
35
4.99
174.65
Central
Smith
Desk
2
125
250
East
Jones
Pen Set
16
15.99
255.84
Central
Morgan
Binder
28
8.99
251.72
East
Jones
Pen
64
8.99
575.36
East
Parent
Pen
15
19.99
299.85
Central
Kivell
Pen Set
96
4.99
479.04
Central
Smith
Pencil
67
1.29
86.43
23 12/29/2019
24 1/15/2020
25 2/1/2020
26 2/18/2020
27 3/7/2020
28 3/24/2020
15.99
1183.26
East
Central
Pen Set
Binder
Parent
74
Gill
46
8.99
413.54
Central
Smith
Binder
87
15
1305
East
Jones
Binder
4
4.99
19.96
West
Sorvino
Binder
7
19.99
139.93
Central
Jardine
Pen Set
50
4.99
249.5
29 4/10/2020
30 4/27/2020
31 5/14/2020
32 5/31/2020
33 6/17/2020
34 7/4/2020
Central
Andrews
Pencil
66
1.99
131.34
East
Howard
Pen
96
4.99
479.04
Central
Gill
Pencil
53
1.29
68.37
Central
Gill
Binder
80
8.99
719.2
Central
Kivell
Desk
125
625
East
Jones
Pen Set
62
4.99
309.38
35 7/21/2020
Central
Pen Set
55
12.49
686.95
Morgan
Kivell
36 8/7/2020
37 8/24/2020
38 9/10/2020
39 9/27/2020
Central
Pen Set
42
23.95
1005.9
West
Sorvino
Desk
3
275
825
Central
Gill
Pencil
7
1.29
9.03
Pen
Thompson Binder
Pencil
West
Sorvino
76
1.99
151.24
40 10/14/2020
41 10/31/2020
42 11/17/2020
West
57
19.99
1139.43
Central
Andrews
14
1.29
18.06
Central
Jardine
Binder
11
4.99
54.89
43 12/4/2020
Central
94
1879.06
Jardine
Andrews
Binder
19.99
44 12/21/2020
Central
Binder
28
4.99
139.72
45
Transcribed Image Text:A C F G Rep Jones Total 189.05 1 OrderDate Region Item Units Unit Cost 2 1/6/2019 East Pencil 95 1.99 1/23/2019 999.5 Kivell Jardine Central Binder 50 19.99 2/9/2019 Central Pencil 36 4.99 179.64 5 2/26/2019 6 3/15/2019 7 4/1/2019 Central Gill Pen 27 19.99 539.73 Pencil Binder West Sorvino 56 2.99 167.44 East Jones 60 4.99 299.4 8 4/18/2019 Central Andrews Pencil 75 1.99 149.25 9 5/5/2019 Central Jardine Pencil 90 4.99 449.1 Thompson Pencil Jones 10 5/22/2019 West 32 1.99 63.68 11 6/8/2019 East Binder 60 8.99 539.4 12 6/25/2019 13 7/12/2019 14 7/29/2019 15 8/15/2019 16 9/1/2019 17 9/18/2019 18 10/5/2019 19 10/22/2019 20 11/8/2019 21 11/25/2019 22 12/12/2019 Central Pencil 90 4.99 449.1 Morgan Howard Binder Binder East 29 1.99 57.71 East Parent 81 19.99 1619.19 East Jones Pencil 35 4.99 174.65 Central Smith Desk 2 125 250 East Jones Pen Set 16 15.99 255.84 Central Morgan Binder 28 8.99 251.72 East Jones Pen 64 8.99 575.36 East Parent Pen 15 19.99 299.85 Central Kivell Pen Set 96 4.99 479.04 Central Smith Pencil 67 1.29 86.43 23 12/29/2019 24 1/15/2020 25 2/1/2020 26 2/18/2020 27 3/7/2020 28 3/24/2020 15.99 1183.26 East Central Pen Set Binder Parent 74 Gill 46 8.99 413.54 Central Smith Binder 87 15 1305 East Jones Binder 4 4.99 19.96 West Sorvino Binder 7 19.99 139.93 Central Jardine Pen Set 50 4.99 249.5 29 4/10/2020 30 4/27/2020 31 5/14/2020 32 5/31/2020 33 6/17/2020 34 7/4/2020 Central Andrews Pencil 66 1.99 131.34 East Howard Pen 96 4.99 479.04 Central Gill Pencil 53 1.29 68.37 Central Gill Binder 80 8.99 719.2 Central Kivell Desk 125 625 East Jones Pen Set 62 4.99 309.38 35 7/21/2020 Central Pen Set 55 12.49 686.95 Morgan Kivell 36 8/7/2020 37 8/24/2020 38 9/10/2020 39 9/27/2020 Central Pen Set 42 23.95 1005.9 West Sorvino Desk 3 275 825 Central Gill Pencil 7 1.29 9.03 Pen Thompson Binder Pencil West Sorvino 76 1.99 151.24 40 10/14/2020 41 10/31/2020 42 11/17/2020 West 57 19.99 1139.43 Central Andrews 14 1.29 18.06 Central Jardine Binder 11 4.99 54.89 43 12/4/2020 Central 94 1879.06 Jardine Andrews Binder 19.99 44 12/21/2020 Central Binder 28 4.99 139.72 45
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Types of Database
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education