Question: 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

 Question 3 The file named Product Info.txt includes information about products

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

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 Databases Questions!