Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 3 The file named Product Info.txt includes information about products sold at a home improvement store. Each row of information represents a transaction from

image text in transcribed

Question 3 The file named Product Info.txt includes information about products sold at a home improvement store. Each row of information represents a transaction from a unique customer. The first element of a row is the name of the product sold, the second is the price of the product and the third is the number of that product sold during the transaction. Note that you may not use arrays on this assignment. a. Create a directory in your IntelliJ project folder named input_data and place the Product Info.txt file in that directory. b. Create a class named H3_Q3.java and write code that reads the data from the file (hint: perhaps more than once) and determines the following: 1. How many unique customers purchased each item? 2. How much total revenue did the store make on each item in the file? Note that you may assume that only the following products are in the file: Saw, Table, Flashlight, Battery and Clamp. c. Create an output .txt file named Q3cOutput.txt in the output_files directory that prints a summary table with the following format. Product Name Toal Revenue Saw Table Flashlight Battery Clamp Unique Customers XXXX XXXX XXXX XXXX XXXX YYYY YYYY YYYY YYYY YYYY Specific alignment of each element in the table is not necessary, nor are the lines separating the rows. However, column headings should be included. Also, XXXX should be formatted as US Currency ($XX.XX)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 24th International Conference Dexa 2013 Prague Czech Republic August 2013 Proceedings Part 1 Lncs 8055

Authors: Hendrik Decker ,Lenka Lhotska ,Sebastian Link ,Josef Basl ,A Min Tjoa

2013 Edition

3642402844, 978-3642402845

More Books

Students also viewed these Databases questions

Question

1. Who should participate and how will participants be recruited?

Answered: 1 week ago