language of the coding will be java

Harinesvari Cafe - a newly re-branded and re-named traditional meets contemporary Indian restaurant located in the mid of Kuala Lumpur Serving around 220 covers at capacity, the restaurant serves traditional Indian classics. When Harinesvari Cafe upgraded their menu and interior it became clear that their service also needed an upgrade. Providing a great front-of-house and customer experience is a crucial factor for remaining competitive in Kuala Lumpur's increasingly crowd. Obviously, the major limitations are using pen and paper to take bookings. Management of Harinesvari Cafe had realized that the Digital reservation systems have a huge impact on restaurant customer service apart from using pen and paper. Following are the functions that were requested by Harinesvari Cafe for their reservation system. Customer must login into the system to reserve a table All customer must register into the system (required data to register: name, address) The system should be able to check the availability of table at the time requested by customer. One customer can make multiple bookings a) b) Suggest the database design (ERD diagram) for Harinesvari Caf Reservation System. (Submission method: Copy the ERD diagram) (20 marks) Create the reservation form and reservation process coding for the booking made hy customer. (Hint: Include the database connection coding) (Submission Method: Copy the form coding, processing coding and screenshot the output). (15 marks) c) Create generate report coding where the management able to generate report of reservation made for a day. The management should select the date and press submit. This action should retrieve a record of reservation from the database and display in a form of report. (Submission Method: Copy the form coding, processing coding and screenshot the output). (15 marks) Harinesvari Cafe - a newly re-branded and re-named traditional meets contemporary Indian restaurant located in the mid of Kuala Lumpur Serving around 220 covers at capacity, the restaurant serves traditional Indian classics. When Harinesvari Cafe upgraded their menu and interior it became clear that their service also needed an upgrade. Providing a great front-of-house and customer experience is a crucial factor for remaining competitive in Kuala Lumpur's increasingly crowd. Obviously, the major limitations are using pen and paper to take bookings. Management of Harinesvari Cafe had realized that the Digital reservation systems have a huge impact on restaurant customer service apart from using pen and paper. Following are the functions that were requested by Harinesvari Cafe for their reservation system. Customer must login into the system to reserve a table All customer must register into the system (required data to register: name, address) The system should be able to check the availability of table at the time requested by customer. One customer can make multiple bookings a) b) Suggest the database design (ERD diagram) for Harinesvari Caf Reservation System. (Submission method: Copy the ERD diagram) (20 marks) Create the reservation form and reservation process coding for the booking made hy customer. (Hint: Include the database connection coding) (Submission Method: Copy the form coding, processing coding and screenshot the output). (15 marks) c) Create generate report coding where the management able to generate report of reservation made for a day. The management should select the date and press submit. This action should retrieve a record of reservation from the database and display in a form of report. (Submission Method: Copy the form coding, processing coding and screenshot the output). (15 marks)