• 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...

Introduction

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.

Middle

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.

Conclusion

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. The aim of my project is to make the task of the allocation of ...

    Excel will automatically change the cell's formula (if there is one) to apply to its new position. Displaying to 2 decimal places This is used for money. Since the sheet is mostly in calculation for money it has been used a lot, it has been used for cost of putting on selected shows and for its income.

  2. 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

  1. What is a computer registry?

    String Value REG_SZ A fixed-length text string. Binary Value REG_RESOURCE_LIST A series of nested arrays that is designed to store a resource list that is used by a hardware device driver or one of the physical devices it controls. This data is detected and written in the \ResourceMap tree by the system and is displayed in Registry Editor in hexadecimal format as a Binary Value.

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

    Step 8 After I had completed that, I inserted the target grades for each child under the column heading, "Target Grade." I did this so that I could later make a formula to tell me if the student had exceeded or met their target or if I had to inform their parents.

  1. 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.

  2. bookings database

    Other command button should be on the bottom/side- the main menu's command buttons are in the same place. This is because they are in a chronological order and are placed in order of use. This is so it is easier and more effective for the user when a guest books a room.

  1. ICT BTEC UNIT 2 - REPORT

    going for it and that is that it is free to use online with no installation needed which can save valuable space on your computer and you wouldn't have to worry about accidentally deleting your work neither would you have to worry about losing it if your system crashes or goes down.

  2. Powerpoint review project

    You can also use hyperlinks to shortcut to certain topics of slides by clicking on them whilst the slideshow is running. Sound effects can be added by going to insert and movies and sounds then you can click to add from file or from clip organiser.

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