A database coursework to complete some specific functions about simple hotel management system.

1.Room Booking Requirements with guest and staff mode. (Hotel room layout has been provided by a picture.)

2.Food Service Requirements. (Chefs' list with workdays and dishes have been provided by a table.)

1.If you log in this system as a guest, you can use 3 default accounts.

2.Guests can first choose 3 operations.

3.Guests can choose 7 specific operations.

1.If you log in this system as a staff, you can use 1 default account.

2.Staffs can first choose 3 operations.

3.Staffs can choose 2 specific operations.

• Use java and mysql.
• For the reasonable screening of most illegal input, the code uses a large number of do…while statements.
• Design 2 classes: staff and guest, when you login with one identity the system will create a real object to do.
• Design 2 classes: chef and room to operate database so that main() function only focus on the real logic.
• Clear instructions, detailed logical steps and helpful user manual.