Task 3.b.
- Explanation of the methods/keywords/concept and logic in your own words
- Client side Java code with proper format
- Server side Java code with proper format
- Client side output screen with screenshot
- Sever side output screen with screenshot
use task 2 information
be careful about plagiarism
Task 3: Client / Server application with database connectivity a) Create a database in Access or in SQL server or in any other RDBMS: Based on the feedback from customers, the owner decided to include additional facilities to some of the rooms. As a result, each room type can now be classified as regular or deluxe, and having different rate, thus doubling the number of room rates (from 3 to 6). This number can continue to grow as more customer feedback comes in So, to simplify the software maintenance, the room rates have to be kept in a database (see table below). Create a small database based on the attributes and values given below. Use appropriate data type and field properties. roomType roomName roomRate Single Bed Regular 15.000 Single Bed Deluxe Twin Bed Regular 20.000 Twin Bed Deluxe 20.000 SBR SBD TBR TBD 25.000 MEC_AMO_TEM_035_02 Page 2 of 16 Advanced Programming (COMP 20014.1) - Fall-21 - CW3 (Assignment) - All - QP DBR Double Bed Regular 25.000 DBD Double Bed Deluxe 30.000 (10 Marks) b) Implement database connectivity and Multithreading: Modify the program in Task 2 so to make use of the database created. Create a thread using extending thread dass or implementing runnable interface and implement a run method with explanations of the method used. 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 (ratelor rate2 or rate3) b. Using the room type, connect to the database and retrieve the appropriate room rate ii. 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. Task 2: Client /Server application 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 Develop the software using socket programming concept (graphical user interface is not required) that will allow the receptionist (client side) to enter all the required information. The room type and number of days from the client side will then be forwarded to the server where they will be used to calculate the invoice. The server will then do the necessary calculations and then send the calculated expected invoice (without discount), the room rate used, any discount given, and the final invoice after discount back to the client for display. (35 Marks)
