Show using pseudocode how you would break on the category field to produce a report like the attached here

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

Show using pseudocode how you would break on the category field to produce a report like the attached here 

SampleReport
Bikes
Category Subcategory Product Name
Order Number Order Date
Sales Amount
Bikes
Road Bikes
Road-150 Red, 62
S043713
2011-01-09
3,578.27
Bikes
Road Bikes
Road-150 Red, 62
S043758
2011-01-20
3,578.27
Bikes
Road Bikes
Road-150 Red, 62
S043784
2011-01-26
3,578.27
Bikes
Road Bikes
Road-150 Red, 62
S043821
3,578.27
2011-02-01
Bikes
Road Bikes
Road-150 Red, 62
S043829
2011-02-02
3,578.27
Clothing
Category
Subcategory
Product Name
Order Number Order Date Sales Amount
Clothing
Caps
AWC Logo Cap
SO68952
2013-10-30
8.99
Clothing
Caps
AWC Logo Cap
S069103
2013-11-01
8.99
Clothing
Clothing
Caps
AWC Logo Cap
S069245
2013-11-03
8.99
Caps
AWC Logo Cap
S055967
2013-04-16
8 99
Clothing
Caps
AWC Logo Cap
S052215
2013-02-11
8 99
Notes
98
Transcribed Image Text:SampleReport Bikes Category Subcategory Product Name Order Number Order Date Sales Amount Bikes Road Bikes Road-150 Red, 62 S043713 2011-01-09 3,578.27 Bikes Road Bikes Road-150 Red, 62 S043758 2011-01-20 3,578.27 Bikes Road Bikes Road-150 Red, 62 S043784 2011-01-26 3,578.27 Bikes Road Bikes Road-150 Red, 62 S043821 3,578.27 2011-02-01 Bikes Road Bikes Road-150 Red, 62 S043829 2011-02-02 3,578.27 Clothing Category Subcategory Product Name Order Number Order Date Sales Amount Clothing Caps AWC Logo Cap SO68952 2013-10-30 8.99 Clothing Caps AWC Logo Cap S069103 2013-11-01 8.99 Clothing Clothing Caps AWC Logo Cap S069245 2013-11-03 8.99 Caps AWC Logo Cap S055967 2013-04-16 8 99 Clothing Caps AWC Logo Cap S052215 2013-02-11 8 99 Notes 98
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Managing System
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