Write a C program to solve the following problem. A company has 4 salespeople (1 to 4) who sell 5 different products (1 to 5). Every day the company maintains a CSV file for each product sold. A CSV file is a comma-separated values file. The CSV file contains the product, and the total dollar value of that product sold by each salesperson that day. An example CSV file has been provided with the assignment. Write a program that will read all this information for a day's sales and summarize the total sales by salesperson and by-product. After processing all the information for the day, display the results in a tabular format, with each column representing a salesperson and each row representing a particular product. Gross total each row to get the total sales of each product. Gross total each column to get the total sales by the salesperson. Your output should include these cross-totals to the right of the totaled rows and to the bottom of the totaled columns.

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
Topic Video
Question
Write a C program to solve the following problem.
A company has 4 salespeople (1 to 4) who sell 5 different products (1 to 5). Every day the company maintains a CSV file for each product sold. A CSV file is a
comma-separated values file. The CSV file contains the product, and the total dollar value of that product sold by each salesperson that day. An example
CSV file has been provided with the assignment.
Write a program that will read all this information for a day's sales and summarize the total sales by salesperson and by-product. After processing all the
information for the day, display the results in a tabular format, with each column representing a salesperson and each row representing a particular
product. Gross total each row to get the total sales of each product. Gross total each column to get the total sales by the salesperson. Your output should
include these cross-totals to the right of the totaled rows and to the bottom of the totaled columns.
For the sample data provided, the output could look like this
Selleri Seller2 Seller3
Seller4 Total
Product1
915
777
886
383
2961
Product2
492
386
335
793
2006
Product3
27
362
421
649
1459
Product4
926
763
59
690
2438
Product5
736
172
426
540
1874
Total
3096
2460
2127
3055
You may assume that each line in the CSV file is not larger than a number of your choice, say no larger than 256.
• You may assume that there are no spaces or other special characters in the names of the salespeople or products.
• You may assume that the names of salespeople and products are not larger than a number of your choice, say no larger than 20.
• You can use character arrays. You do not need to dynamically allocate memory.
Transcribed Image Text:Write a C program to solve the following problem. A company has 4 salespeople (1 to 4) who sell 5 different products (1 to 5). Every day the company maintains a CSV file for each product sold. A CSV file is a comma-separated values file. The CSV file contains the product, and the total dollar value of that product sold by each salesperson that day. An example CSV file has been provided with the assignment. Write a program that will read all this information for a day's sales and summarize the total sales by salesperson and by-product. After processing all the information for the day, display the results in a tabular format, with each column representing a salesperson and each row representing a particular product. Gross total each row to get the total sales of each product. Gross total each column to get the total sales by the salesperson. Your output should include these cross-totals to the right of the totaled rows and to the bottom of the totaled columns. For the sample data provided, the output could look like this Selleri Seller2 Seller3 Seller4 Total Product1 915 777 886 383 2961 Product2 492 386 335 793 2006 Product3 27 362 421 649 1459 Product4 926 763 59 690 2438 Product5 736 172 426 540 1874 Total 3096 2460 2127 3055 You may assume that each line in the CSV file is not larger than a number of your choice, say no larger than 256. • You may assume that there are no spaces or other special characters in the names of the salespeople or products. • You may assume that the names of salespeople and products are not larger than a number of your choice, say no larger than 20. • You can use character arrays. You do not need to dynamically allocate memory.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Instruction Format
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.
Similar questions
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