for guests family who want to rooms reservationsin hotel. there is discount if single room will cost 1000, double:1500 , twin:1200 with how many day will be there you can estmiate the day from your mind please anwer the question I will give you great comment and like

this is the senario I need to answer just the previus qeustion

b) Implement database connectivity and Multithreading: Modify the program in Task 2 so to make use of the database created. i. Create a thread using extending thread class or implementing runnable interface and implement a run method with explanations of the method used. ii. After receiving the room type and number of days from the client side, the server should the following: a. Using the number of days, determine which discount rate should be used (ratel or rate2 or rate3) b. Using the room type, connect to the database and retrieve the appropriate room rate ili. Use the retrieved room rate and the determined discount rate to calculate the invoice iv. Then send the calculated expected invoice (before discount), the room rate used, any discount given, and the final invoice (after discount) back to the client Close the connection with the database once done (20 Marks) V. A newly established family guesthouse wants to have its customer invoices calculated and prepared automatically. As a software developer, you have been asked to develop that software. The software will be based on a client-server architecture where the receptionist will be able to enter the request of the customer which should include the customer ID, customer name, customer phone number, room type, and number of days. The room type, and number of days will then be sent the server for the invoice calculations as it holds the room rate and calculating algorithms. The room rates will be different for the single bed, twin bed and double bed. Customers can get a discount according to the number of days s/he is planning to stay. The discounting scheme is given below. If the number of days is 2 or less, then no discount will be given . If the number of days is more than 2 but less than 5, then a 5% discount will be given . If the number of days is 5 or more, then a 10 % discount will be given