CSE103代做、system代写、SQL语言代做、SQL程序设计调试

日期：2020-05-14 11:29

CSE103 Coursework: Hotel Management

System

Introduction

Sunny Isle is a small but famous hotel in the east region of Lukewarm Kingdom. People

from all over the world visit this place for a nice and comfortable holiday. Due to such

popularity, the owner of the hotel decided to expand his hotel and adopt a new hotel

management system (HMS) to ease the management process. You are the only one

chosen to design and implement this HMS because the manager is not willing to pay

more than one person. Apart from that, if you copy any code from others or let

someone else develop this HMS, the manager will be disappointed and immediately

report this to me. Plagiarism and collusion leads to a zero mark for this coursework.

The manager asked you to build a Java application that provides the following basic

functionalities:

1. Allow guests to book rooms or cancel room bookings.

2. Allow hotel staff to check the status of rooms, including current and future

bookings.

3. Allow guests to order meal during their stays in the hotel.

You will need to apply all the knowledge that you acquired throughout the course. The

deadline is 23:59 on Friday, the 5th of June. This assessment contributes 80% (50% +

30%) towards the overall module grade. Your submission will be marked on the

school’s csse-mysql server (http://csse-mysql.xjtlu.edu.cn/). Subsequently, your code

must work on the MySQL installations on csse-mysql. “It works on my machine” is not

a valid argument when defending your assessment. You will also need to include a

clear user manual of your application, describing all functionalities.

Room Booking Requirements

Below is the detailed description of the minimum functionality expected in the HMS.

You must use this specification to develop the functionality of the system. You may

make plausible assumptions to any unspecified details with sufficient justification in

your report.

This HMS application is designed for both hotel guests and staffs. When this

application is started, it should first prompt the user which mode it should work in. If

the user selects staff mode, room management options should be presented. If the

user selects guest mode, room booking options should be presented.

Guest Mode

The application must allow a guest to book rooms or cancel booked rooms. A

registered guest will have a username, guest’s real name, passport ID, telephone

number and email address. There is no current requirement for guests to update their

details, but you may add this functionality if you wish. To log in, a guest is required to

input his username and password correctly. Your application must also allow new

users to be registered.

Rooms in the Sunny Isle Hotel have four different types:

1. Large room with double beds.

2. Large room with a large single bed.

3. Small room with a single bed.

4. VIP room.

The plan view of the floors of the hotel is shown below. The room number starts from

the room in the top-left and increases clock-wise. For simplicity, all floors of this hotel

share the same plan view. The “X” in “Room X01” refers to the floor number. The hotel

has 10 floors in total. I used a table to represent this plan view, but you can use any

other methods to represent it in HMS when guests select their rooms.

Large double

To book a room, a guest needs to specify the check-in date, check-out date and room

type. If the room is not occupied in this period, he will be presented with an option

that allows him to choose the specific room to stay in. Note that choosing the room

number is not a required step for guests. If he chose to skip, an empty room of the

same type should automatically be arranged for him. A guest can book multiple rooms

for himself and his friends.

Staff Mode

Staffs can view the booking status of all rooms inside the Sunny Isle. Each staff account

is associated with a username, password, telephone number and staff ID. In HMS, you

need to clearly indicate the status of a room for guests and staffs. That is, whether a

room is booked or empty. The staff should be able to see all booked dates for a specific

room. For privacy issues, guests only know whether a specific room is available during

their intended stay period.

Food Service Requirements

The owner of the Sunny Isles Hotel also wants to provide for guests to book their meals.

A meal can be prepared at any time from 7:00 am to 10:00 pm and can only be booked

two days in advance. A meal contains a list of dishes that will be prepared by several

chefs. Each chef in Sunny Isle can only prepare a set of dishes he knows and only works

in certain days in each week. The weekly work schedule for each chef is fixed.

Here is the information about chefs:

1. Karen Adam: Monday to Friday

a. Dishes: shrimp soup, cauliflower and mushroom stew, spicy chicken

nuggets, steamed cod fish, turkey burger, veggie burger, fried egg.

2. Hari Philip: Wednesday to Sunday

a. Dishes: chicken curry, chicken masala, mutton Korma, keema curry,

mushroom tikka, fried egg, curry rice.

3. Thalia Hensley: Monday, Thursday and Saturday

a. Dishes: tofu teriyaki, shrimp tempura, yaki udon, chicken katsu, salmon

sashimi, fried egg, curry rice.

4. Nisha Moss: Tuesday, Saturday and Sunday.

a. Dishes: black pepper beef, pork chowmein, sweet & sour pork, gongbao

chicken, pork jiaozi, soy glazed pork chops, curry rice.

Your Task

You are asked to design a java console program for the hotel. It should interact with

users through text messages. For example, after a user has logged in, he will be

presented with a list of choices:

1. Book a new room

2. Book a meal

3. Cancel a room

4. …

The user selects a choice by typing a number and pressing enter. He will then be

presented with the next list of choices. The text messages of this program are totally

up to you and badly designed messages (unclear, wrong and misleading messages) will

lead to mark deduction.

The final program is for both assignment 1 and 2. Room booking functions are

considered as assignment 1. Staff mode and Food Service are considered as

assignment 2. If you can design a GUI program (Java AWT/Swing or JavaFX) for HMS,

you can have up to 5 bonus marks that will be added to your assignment 2. Your final

marks for each assignment, however, will not exceed their full marks.

You also need to provide a report for this project. In your report, provide the following

information:

1. The design of your database: Your Entity-Relationship Diagram. You should also

include your explanation of your own database design in the report.

2. A user guide of your HMS. For example, how to book a room, how to login and

how to book a meal. You also need to tell me critical information like the default

username and password for your HMS if you have any. But DO NOT GIVE ME

your password to your university account.

The format of CW Submission on ICE:

Everything should be packed in a zip file. The file name of the zip file should follow this

format: YourID_givenName_familyName.zip

For example: 123456_Jianjun_CHEN.zip

In the root folder of the zip file, you need to include:

1. A folder called “project”, storing all of your source code. You should put your

NetBeans project (or eclipse, IntelliJ IDEA project) in this folder. Your SQL scripts

(*.sql files) used to create your tables should also be placed in this folder unless

you use java code to create tables.

2. A document called “Reference.docx” or “Reference.pdf”, which is your

reference document.

Mark Distribution

Assignment 1 worth 50% of the total marks for this module:

Item Marks

Correct E/R diagram 15

SQL table design (SQL Script) matches the E/R diagram. 5

Java: Guest user account management 5

Java: Correct room booking mechanism 15

Java: User interface design is reasonable and clear. Users are well guided

throughout the process and the corresponding booking-related

information is provided.

10

Total 50

Assignment 2 worth 30% of the total marks for this module.

Item Marks

Correct E/R diagram and SQL table design 15

Staff functionalities 5

Meal booking functionalities 5

Java: User interface design is reasonable and clear. Users are well guided

throughout the process and the corresponding booking-related

information is provided.

5

Bonus marks for excellent designs. (but you will not have more than 30

marks for assignment 2)

5

Total 30