• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Analysis section for database project based on a hotel booking system

Extracts from this document...


Analysis Introduction The Hotel which I am going to make a computerised booking system for; replacing a manual system, is called Hotel Luxury. The Hotel is 5* and is situated in the town centre of Bolton. It consists of 60 rooms and is very busy throughout the year. . Project Name: Luxury Hotel INPUT PROCESS OUTPUT Guest details Look up guest details Guest details on screen Room details Add, edit and delete a guest detail Room Facility details Look up the Room details Room details on screen Add, edit and delete Room details Booking details Add and update bookings Booked rooms on report Produce guest ID Guest ID in prints (hard copy) Produce new hotel logo New Hotel logo What the Hotel needs The hotel allows the user to stay for a certain amount of days and nights. Within my analysis I have enclosed my brief. The minimum the system must have is: 1. Add a new guest to the database 2. Look through the guest database to find a returning guest. 3. Enable you to look at which rooms have already been booked on certain dates. 4. Enable you to look at which rooms are available on certain dates. 5. Make bookings The hotel wants its output on screen wherever it can. It really just wants the reports as printed when wanting to send confirmations. The computer bookings has to be easy to use so they don't need to offer training to the staff as the might not have IT skills. ...read more.


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. ...read more.


3- Unavailable rooms Quantitative performance indicators Screen title- Unavailable rooms Input- arrival date Input- Departure date Input- type of available room Output- unavailable room numbers in a table form Qualitative performance indicators Easy to read in a table Easy to return to menu Data to have valid ranges Data which is required must not be blank Easy to navigate Task 4- checking room availability Quantitative performance indicators Screen title- Available rooms Input- Arrival date Input- Departure date Output- Available room number Output- Room type Qualitative performance indicators Screen easy to read Easy to return to the main menu Data is protected from changes Task 5- Make bookings Quantitative performance indicators Screen title- making bookings Output will be (e.g. on screen) Screen title:- Input- Arrival date Input- Departure date Input- Type of room/ room number Input- Title Input- Initial Input- Surname Input- Address Input- Postcode Output- New record Qualitative performance indicators Easy to enter data Data to be entered must stand out Easy to save a record Easy to abandon Task 6-Main Menu Quantitative performance indicators Screen title:-Main menu Input- Command button 'adding a guest' Input- Command button 'returning guest' Input- Command button 'unavailable rooms' Input- Command button 'available rooms' Input- Command button 'Making bookings' Qualitative performance indicators Main menu should remain running Main menu should be centred on the screen Main menu should be clear to understand Main menu should appear when the database opens ?? ?? ?? ?? Faiyaz Patel Centre no.32105 Candidateno.4752 Page 1 of 5 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Documentation of a database for a sports centre.

    or "Premium" Email Jsmith@hotmaiil.com Text - if we want to send a send a letter via email Doctor Number 02085585675 Text 11 _ _ _ _ _ _ _ _ _ _ _ If there is an injury we must call their doctor Medical Problems None Text - Date Member

  2. What is a computer registry?

    This data is detected and written in the \HardwareDescription tree by the system and is displayed in Registry Editor in hexadecimal format as a Binary Value. None REG_NONE Data without any particular type. This data is written to the registry by the system or applications and is displayed in Registry

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    The formula said that if target grade and achieved grade were the same it would say "met, if the target grade was greater than the grade achieved it would say "inform parents," and if the grade achieved was greater than the target grade it would say "exceeded."

  2. Desktop Publishing - Analysis

    The hard drive will have a memory capacity of 80 GB, which will have enough space to store many backups. This is to make sure that if the original is somehow lost because of the computer crashing for example, then the backup could be used instead.

  1. bookings database

    Come on automatically when database opens/only thing to appear- this automatically opens because this is the first thing that the user uses. This is effective because it is hassle-free for the user and the user can easily book a guest.


    Web Design System Requirements Advantages/ Disadvantages Adobe Dreamweaver CS3 CPU = 2 GHz Intel Centrino HDD Space =1Gb Graphic Card = Inno 3D 880GTX Monitor Resolution =1024*768 RAM = 512 Mb Some features and advantages to Adobe Dreamweaver are it has a great learning resource which includes basic templates for

  1. Powerpoint review project

    It is better than traditional slideshows because you don't have to click to enter new slide and has more effects like sounds and slide timings. ICT is a sensible way of solving this problem because it is easy to use and is relevant to the task I am completing which

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    The real user: The real users are the customers who will be looking for the Asian cuisine. This will also benefit Mr. Hussaini's business. ANALYSE: The following are the features of the Microsoft publisher: Software: The following software can be used in the Microsoft publisher: * Columns can be created

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work