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) 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 SBR Single Bed Regular 15.000 SBD Single Bed Deluxe 20.000 Twin Bed Regular 20.000 TBD Twin Bed Deluxe 25.000 TBR MEC_AMO TEM_035_02 Page 2 of 16