Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem: Haggling ElectronicsHaggling Electronics is a new store that just opened where customers can haggle to get the best deal possible for each item they
Problem: Haggling ElectronicsHaggling Electronics is a new store that just opened where customers can haggle to get the best deal possible for each item they buy.The owner of the store, which just opened this year, heard you are taking a course on foundations in computing, and asks you to assist with some inquiries they have.The store sells electronics and they have the list of all items they sell in a file calledtransactionsProducts.csvwhere each line in the file consists of product ID name of the product and price per unit in dollars separated by a comma. The first line of this file is the header of the three columns mentioned above respectively. Here is a sample from the file:transactionsProducts.csvProductIDProductName,PricePin Laptop,PGame Laptop,PTitan Laptop, Each time a customer comes to the store they can haggle and obtain a special discount.The store keeps another file calledtransactionsSales.csvto record transactions. Each line in this file consists of the transaction ID a date for the transaction, a product ID the number of items, and the obtained percentage of discount after haggling, all separated by a comma. The first line of this file is the header of these five columns. Here is a sample from the file:transactionsSales.csvtransactioniddate,productidquantity,discountPPP The store has a policy of full refund if a purchased item is returned. In this case, all items under the transaction ID are returned, meaning the entire transaction is cancelled and refunded. To keep track of the returns, the store keeps a third file calledtransactionsReturns.csv Each line in this file consists of the transaction ID that was cancelled, and the date of the return, separated by a comma. The first line of this file is the header of these two columns. Here is a sample of the file:transactionsReturns.csvtransactioniddate The owner oftableProductIDProductName,PricePin Laptop,PGame Laptop,PTitan Laptop,PFolding Smartphone,PSmart Smartphone,PT headphones,PCordless Headphones,P Tablet,Peink Tablet,P Tablet,PColour Printer,PLaser Printer,PMega MPPFlat screen,PGaming Monitor,
tabletransactioniddate
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started