? Ford furniture is a local furniture store in acts, and they as CS graduate students to implement a software system to generate various reports for them at the end of each month. You are given four files: salesperson.txt id, name

furniture.txt id, name, description, room, price

customers.txt id, name, phone, address(use _ to concat)

sales.txt customerId, salespersonId, furnitureId, discount(0.2 means 20% off the price)

The management use the following rules to compute the commissions for each sales person. For high end furniture(those original price is at or over 5000), the sales person will get 60% of the value above half price. For example, if a luxury bed is priced at 6000, and was sold at 30% discount, the sales person will get 60%(6000(1-30%) - 6000 50%) = 720. For low end furniture(those original price is below 5000), the sales person will get 50% of the value above half price. For example, if a dining set is priced at 3000, and was sold at 30% discount, the sales person will get 50%(3000(1-30%) - 3000 50%) = 300.

Step 1: Generate a report listing the sales person ordered by the commission with the following info: name, id, total sales, total commission

Step 2: Generate a report listing the furniture ordered by the total number of sales with the following info: name, id, total number of sales, total sales, total original price

Step 3: Generate a report listing the customers ordered by the highest markup(paid price - 50% of original price) for all the orders in the month: name, id, total paid, total original price, total markup