TABLE OF CONTENT

1. Introduction………………………………………………………………………………………1

1.1 Introduction to the projects………………………………………………………………….2

1.2 Teams Members and team roles………………………………………………………….2

2. Problem Statement………………………………………………………….…………………..3

3. Objective………………………………………………………………………………………….3

4. Flow of Application …………………………………………………………………………….4

4.1 Create………………………………………………………………………………………….4

4.1.1 Create a form for admins to login…………………………………………………….4

4.1.2 Create a form for the admin to register a first time user…………………………4

4.1.3 Create a form for admins to create bookings………………………………………6

4.2 Read …………………………………………………………………………………………..6

4.2.1 Display the homepage of the Zimmer Booking System………………………….6

4.2.2 Display the recent bookings…………………………………………………………..7

4.2.3 Display the bed availability ……………………………………………………………7

4.3 Update…………………………………………………………………………………………8

4.3.1 Update Bed Status………………………………………………………………………8

4.3.2 Reset Password………………………………………………………………………….9

4.3.3 Price………………………………………………………………….…………………….9

4.4 Delete………………………………………………………………………………………….9

4.4.1 Remove cancel booking record from guest ………………………………………..9

4.4.2 Remove current unavailable bed……………………………………………..……..10

4.4.3 Delete duplicate booking records…………………………………………..……….11

5. Dashboard ……………………………………………………………………………..………..12

6. Database Design……………………………………………………………………..…………13
1. INTRODUCTION

Zimmer Hostel Booking was established on May 6, 2020. This company is a

partnership company run by 2 friends, (Ainur and Balqis). It is a form of low-cost, short-
term shared sociable lodging where guests can rent a bed, usually a bunk bed in a
dormitory, with shared use of a lounge and sometimes a kitchen. Rooms can be mixed
or single-sex and have private or shared bathrooms. This company is an establishment
which provides bed and lodging for a specific group of people, such as students,
workers, or travellers. Starting in Kuala Lumpur, now after 3 years, the Zimmer Hostel
company has expanded the business by having 4 branches around Malaysia, in Kuala
Lumpur, Johor, Perlis and Melaka.

1
1.1 Introduction to the Project

Before they came up with the idea of creating this website, they often had troubles in
managing data as they did everything manually and all data are kept in file-based
approach. The admins receive booking through phone call either Whatsapp application
and write the booking details on books. They tend to lose lots of information and
sometimes the data are not tally with the sales. For example, sometimes the room was
‘booked’ but due to inaccurate data taken, it was written as ‘available’. And sometimes
guest details are not properly kept and hard to track back. Admins also face some
problems to update new bed price. Hence, by creating this website hostel owners and
managers can easily track reservations, manage room inventory, and automate guest
check-in and check-out procedures with the aid of a booking management system. As a
result, the booking process is streamlined and made more effective, which enhances the
guest experience.

1.2 Team member and role of members

Description in developing project

The system that will be developed includes the entire process required in booking a
bed, from registration to the payment process. For admin who have already registered,
they can directly log in to the system, while those who haven't, they need to sign up first.
After entering the system, they will be displayed with the company dashboard. Here,
they can see the slot vacancy to key in guest details such as full name, number of
guests, phone number, date to check-in and check-out and also the time when do they
want to check-in or check-out. Then, the admins can see whether there are any
available bed for them on the chosen date. After that, the system will display the bed
availability on that date. Only then date and time will be confirmed and system will
proceed to submit the bookings details. Finally, the system will generate a confirmation
email which will be sent to the guest email.

2
2. PROBLEM STATEMENT
Hostels frequently contain a large number of beds, which can make managing their
availability and ensuring that they are constantly clean and ready for guests difficult. It might
be extremely challenging to keep track of which rooms are available and when, especially
during busy periods. Also, hostel managers need to have a clear picture of how their hostel
is performing in terms of occupancy rates, revenue, and guest satisfaction and collecting
payments from guests can be a time-consuming and error-prone operation, especially when
done manually. Similarly, hostels have an enormous number of guests, making it difficult to
keep track of guest information and booking details.

OBJECTIVE

● Assist in managing real-time room availability, allowing guests to reserve rooms

and hostel employees to keep track of which rooms are occupied and when.
● Assist in the management of guest information, such as personal information,
booking history, and payment details.
● help to provide real-time reporting and analytics, allowing managers to make
data-driven decisions and identify areas for improvement.
● Help automate payment processing by allowing guests to pay online and
ensuring that payments are appropriately recorded.

3
3. FLOW OF APPLICATION

Our Zimmer Hostel Booking Management System included four important operations
which are create, read, update and delete (CRUD).

4.1 Create

1. Create a form for admins to login.

This is a form for the admins to login to the website. This interface will appear
for the non-first-time users which means that they only need to key in their name
and password before proceeding to register a guest in. If the staff is a new
employed staff, they will need to click the register button first to register their
information before continue to register a guest in.

2. Create a form for the admin to register a first-time user.

This is a form for the first-time user, which is new employed staff. They first need
to key in their details before they can proceed to log in to register a guest in. This
form will require some information of the staff such as email address, full name,
username, age, gender, phone number, password and repeat password for
confirmation. This form will only be required once. After that, they can proceed to
register a guest in by logging in.

4
3. Create a form for admins to create bookings.

Once done with staff logging in, they will be able to register a guest in by keying
in their full name, number of guests, phone number, check-in and check-out
dates and also time of check-in and check-out to create booking. They can check
the bed availability after to ensure that there is bed available on the date and
time chosen.

5
4.2 Read

1. Display the homepage of the Zimmer Booking System.

This is the homepage of the website. This interface will be displayed once they
click on the website.

6
2. Display the recent booking

This is the display of the recent bookings that was keyed in by the staff. This will
help the admins track and see the guests details that recently registered. This
page will display all information such as booking ID that is auto-generated by the
system, customer name, total guest, phone number, check-in date, check-in
time, check-out date, check-out time and also bed-ID.

3. Display the bed availability

This is the display of bed availability where it will display if the bed is available to
book or vice versa. This includes the details such as date, time, bed_ID, date,
status, and action whether to book or not.

7
4.3 Update

1. Update bed status

This will aid the staffs to update bed status once the guests checked-in or
checked-out of the hostel to help them track the bookings and identify any
available bed.

2. Reset Password

This interface is made to in case the staffs forgot their password to log in, hence
they can update their new password by creating a new password and reset it.

8
 3. Update bed price

Allows the admins to update new price in case they want to increase or decrease
the price of the service by setting in the desired price in the column and simply
clicks the update button afterwards.

4.4 Delete

1. Remove cancel booking record from guest

Allows admins to remove any beds from the booking status that were canceled
by guests. This will then cause the system to appear to indicate that the canceled
rooms are available for the next bookings.

9
2. Remove the current unavailable bed

This will allow the administrators to remove the currently unavailable beds due to
some maintenance, such as renovations or beds that need to be replaced. They
will be deleted temporarily from the system until renovations are done.

10
 3. Delete the duplicate booking record

Allows admins to delete booking histories. If there are duplicate or incorrect

booking records in the system, the administrator can delete the extra or incorrect
records to maintain accurate booking records.

4. DASHBOARD

11
 The admin dashboard for a Zimmer Hostel Booking Management System is intended to
provide a quick and simple overview of critical information and capabilities relevant to managing
and monitoring bookings, rooms, guests, and employees. This dashboard typically includes
several elements, including a booking overview that provides a summary of current and
upcoming bookings, room availability that provides an overview of room occupancy and
availability, guest information that summarizes guest information and booking history, and staff
management that provides an overview of staff information, roles and responsibilities, and work
schedule. Furthermore, the dashboard may include reporting and analytics features that enable
the administrator to generate and analyze various reports, such as occupancy rates, revenue,
and guest satisfaction.

Furthermore, the dashboard may include reporting and analytics features that allow the
administrator to generate and analyze various reports, such as occupancy rates, revenue, and
guest satisfaction, to help the administrator make informed decisions and optimize the hostel's
operations. The dashboard is a necessary tool for the administrator to oversee and monitor the
hostel's activity in order to guarantee that everything operates smoothly and properly.

12
 5. DATABASE DESIGN

According to the ERD above, we had five entities which is Guests, Booking, Staff, Payment,
and Bed. In the Guests entity, we have Guest_ID as the primary key, full_name, email and
phone_number.In the booking entity, we have booking_ID as primary key, guest_id as foreign
key 1, staff_ID as the foreign key 2, bed_ID as the foreign key 3, check_in_date,
check_out_date, and total_price. In the payment entity, we have payment_id as primary key,
booking_id as the foreign key 1, payment_date and amount. In the staff entity, we have staff_ID
as a foreign key, full_name, username, password, phone_number, and email. For the last entity,
which is the bed entity, we have bed_id as the primary key, bed_number, and price.

The relationship between the entities is as follows:

1. One guest can have one booking.

2. One booking was booked by one guest.
3. One customer made a payment.
4. A payment made by one guest.
5. One staff member can manage many bookings.
6. One booking is managed by one staff member.
7. One booking can get one bed that is available.
8. One bed booked by the guest.

13