• 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


    ID Surname Address - 1st Line Medical History Last Check up Prescriptions Subscribed Final design ID Title Surname Other names Date of Birth Gender ID Surname Address - 1st Line Address - 2nd Line Here is my new and improved design, as you can see I have added an ID


    525W 1TB SATA 3.0Gb/s,7200 RPM Hard Drive with 16MB DataBurst Cache 2GB, 800MHz, DDR2 SDRAM Memory, ECC (2 DIMMS) Dual PCIe x16 nVidia Quadro FX1700, Dual Monitor DVI Cable 16XDVD AND 16XDVD+/-RW, w/ Cyberlink PowerDVD and Roxio Creator CONCLUSION In conclusion I have found there are many things I like

  1. What is a computer registry?

    Editor in hexadecimal format as a Binary Value Link REG_LINK A Unicode string naming a symbolic link. QWORD Value REG_QWORD Data represented by a number that is a 64-bit integer. This data is displayed in Registry Editor as a Binary Value and was introduced in Windows 2000.

  2. Documentation of a database for a sports centre.

    Date Of Birth 21/05/90 Time/Date 6 _ _/_ _/_ _ To allow us to change them to adult when they +turn 18 Postcode IG2 0ED Text 6 Mix of number and letters Shows where they live if we want to send a letter Member Type premium Text - Either "Standard"

  1. spreadsheet project

    The alternative of using the computer to make spreadsheets is to hand write them, this isn't as affective as it takes a very long time to write it up and work out all the calculations.

  2. Evaluating a relational database solution

    I had to work out what the short date was, whether it was '<' or '>' sign, and where the boundaries where for different years. 'And', 'or' and 'not' searches were easy to do as I only had to type 'and', 'or' or 'not' in from or between the information I was searching for.

  1. The aim of my project is to make the task of the allocation of ...

    Data collection The requirements which Mr. Brown requested were that the spreadsheet be easy to modify in case of any change in price for any calculation. That it is easy to understand from "buttons" and that the seating be colour coded to understand easily where people sit.

  2. Setting up a database in microsoft access.

    I then selected whether I wanted to go to 'Next', 'Previous', 'First' or 'Last' record. I had to use a Macro for doing this is the end because the 'Record Navigations' did not work.. I could then use this macro when creating my buttons to go from one record to the next and to refer back to the welcome page.

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