Analysis section for database project based on a hotel booking system

1. Luxury Hotel requires lots of information about their Rooms, Bookings and about their guests to be stored and a computer can store large amount of information.
2. The Staff working at Luxury Hotel encounter a lot of problem and wastes a lot of time searching through paper files for information and if a computer is used, information stored in it can be searched very quickly, saving time and reducing stress.
3. The problem of loss of information logged in paper is avoided by having this information saved in a computer and also having a backup of it in other computer using removal medium like an external hard drive, a USB or CD-Writer.
4. There are currently lots of Cabinets occupying space at the offices of Luxury Hotel, replacing the contents of these cabinets into a PC will reduce and free these spaces and would present the company’s image positively.

I have also decided to carry on this project using a relational database software package. This is because of the below reasons:

1. Database application packages are specifically designed to create computer-based files to store and process information in place of manual filling systems such as the one in use at Luxury Hotel.
2.  It can be customized to suit the needs of the users and they contain tailor-made solutions that are almost as good as writing a special computer program.
3. Due to it customized nature, it is found to be very user friendly
4. Database allows the use of tables to present the list of all information such as; list of guests and their details, lists of rooms and their details and lists of all the bookings that have taken place with the dates and by whom.
5. Database allows queries to be used to search for any particular sort of information across the whole database tables such as; the contact details of any particular guest residing at Luxury Hotel, or the facilities of any available room at any date or even it could search for the list of rooms that are booked by any guest at any given date and time.
6. Database application programs make use of a very simple but straightforward user interface with forms. The user do not need to be bothered with the data in tables or see the criteria set for these queries, instead, he/she will only need to click command buttons represented in a form to either carry out a stated command or to open up another sub-form for him/her to input some data and get a response by the click of another button. This would really makes management of rooms and bookings at Luxury Hotel very simple and a straightforward process.
7. Database application program serves the purpose of getting any required data or information ready for prints with the use of report. For example, if the manager of Luxury Hotel wants to know the list of all the that are booked since the last two days in the Hotel, the user can easily perform this task by clicking on the associated command button in the form (which are bounded to the related query) and getting the response as a list in a report which would them be printed out for the manager to view.
8. The database application package I will use for this project is Microsoft Access. This is because I have had lots of experience using this application package and also, it is the one available for me to use in school to carry out this project.
9. Finally, I will have to design a new Logo for Luxury Hotel to boost the image of the Hotel and to give it a professional feel. This logo will be used on all letterheads to members. I will use paint/fireworks (Choose only one software you are already familiar with pls.) program for the design of this logo

Reusability of relational database:

E.G.

Another great advantage of using a relational database is the because of it ability to be reused. For example, there is the ability to modify and update for example, a customer’s address of phone number if it is changed. There is the ability to change or update a Van’s identity for example if it is involved in an accident and is written off or if a new Van is added to the stock, it updates automatically. These are possible because these command buttons presented in the forms are all joined up with the tables via the queries; they all work together to make the system reusable. Also, the package it self could be reused by another company or by Mr. Patel if he decides to change from Van hiring to just cars as long as it is still a hiring or rental business.

Scope, Objectives and Performance Indicators.

The following pages has all the input and outputs needed for each process

Task 1- Add a guest  

 Task 2- Find a returning guest

Task 3- Unavailable rooms

Task 4- checking room availability

Task 5- Make bookings

Task 6-Main Menu