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

Designing a computer system for the Enfield hotel.

Extracts from this document...

Introduction

THE ENFIELD HOTEL Background The company is called the Enfield hotel. It is located in north London. The Enfield hotel is a well established local hotel accommodating business and leisure needs. It has an excellent well earned reputation for the food served in the restaurant. The Etruscan restaurant is for evening meals and breakfast. Style and d�cor of the restaurant provides a very special dining experience. The restaurant is capable of holding 40 seated people, and the ratio of people staying in the hotel and eating for evening meals is 3:1. The hotel is conveniently located in a quiet residential area, offering a peaceful retreat from the hustle and bustle of London life. The hotel is currently classed as a 2 star and is open all year round. There are currently 8 people employed: These consist of secretaries, waiters, chiefs, cleaners and management * Owner (Mrs Bond) - looks after accounts. * Manager (Mark)- looks after the running of the hotel. * Main Secretary (Karen) - who takes care of bookings and admin. * Head chief (nick) - prepares the food. * Cleaner (Stephen) - cleans the rooms and other facilities. * And 3 waiters The current system for booking rooms and restaurant tables are manual systems. There are currently a total of 12 rooms on site. Each room is furnished to a very high standard, and are well presented and tastefully decorated. All bedrooms are en-suite with shower, remote control colour TV and other facilities. Types of bedroom; * Twin - 2 beds - 5 available * Double - 1 bed - 3 available * Single - 1 bed - 4 available RATES Room Type Monday - Thursday Friday - Sunday Single �65.00 �50.00 Double �75.00 �65.00 Twin �85.00 �85.00 All room rates quoted above are inclusive of breakfast and V.A.T. Monday - Thursday rates reflect the fact that mainly business people use the hotel during the week. ...read more.

Middle

Due to this some information will be restricted to the secretary. To do this access levels will have to be used. Access levels will prevent others to change/ delete data or even view the information. The firm currently uses ICT to perform operations, such as: Word processor - used to write letters and information sheets. But use a manual method to book rooms and tables for the restaurant. Requirements analysis: The users requirements is the most important element of the analysis, therefore I have to find out exactly what is wanted from the system as the first step in producing a solution to the problem.( the information was gathered by an interview) Tasks The system should be able to do; Quantitative * Mail - merge letters * Edit/create customer details * Record booked rooms * Record payed rooms * Add/delete customers * Show which rooms are booked and which are free. * Show customer status e.g. arriving, checked in/out. * Calculate price for a customers stay. * Add on the bill from the restaurant to the price of the customers stay. * Calculate a total price for a customers stay. Qualitative * Be quick to load up * Easy to use * Clear fonts * Use navigation buttons * Clear and easy to use manual with diagrams. * Consistent layout * Use colours in helpful ways * Require minimum IT training * Be secure - passwords/access levels Choices of Software There are 2main choices of software these are Excel a spreadsheet, Access a database. All have advantages and disadvantages. Excel Excel has many advantages, which include the following points and features: - � Excel allows you to insert buttons or macros these allow you to open and close forms at the click of a button. They also allow you to do things like run a query or calculation. � Excel allows you to highlight different cells in colour and fill effects. ...read more.

Conclusion

None of the staff has experience in databases and so great amount of effort is necessary in making the system simplistic. Evaluation criteria Qualitative * Edit/create customer details * Record booked rooms * Record payed rooms * Add/delete customers * Show which rooms are booked and which are free. * Show customer status e.g. arriving, checked in/out. * Calculate price for a customers stay. * Add on the bill from the restaurant to the price of the customers stay. * Calculate a total price for a customers stay. * Be secure - passwords/access levels Quantitative * Should take 45 seconds to book a room. * It should take no longer than 20 seconds to find a free room. * It should take at most 10 seconds to calculate a guest's stay including restaurant bill. * It should take 10 seconds to create a guests details Schedule I will follow a plan of work for my project. This will enable me to meet deadlines, and complete the system well. Data Flow Diagram To help me design an effective and structured database system I have drawn a data flow diagram to show the logical movement of the data through a system, however it does not show how the data is stored. There are different levels of data flow diagrams; I have drawn a level 1 diagram that can also be known as a context diagram. A data flow diagram has many symbols, which mean specific things the symbols I have used are: - * External Entities - can also be known as a data source or destination. In the following diagram the Customer is the External Entity. * Processes - are operations performed on the data. In the following diagram there are five processes each named P1, P2 ...etc. * Data Stores - are logical stores for data, which are not physical in the following data, flow table they are labelled D1 and D2. There are many different levels of DFD's the DFD below is a level 0 and the DFD on the following page is an example of a level 1 DFD Luigi Girandola ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    When creating a new program, for example, the software engineer can indicate what kind of application it should be, such as a console application, a program with a graphical user interface or one that is database-driven. The IDE will then generate a base template of code which the programmer takes as a starting point for his or her own work.

  2. Peer reviewed

    HCI shortened for Human Computer Interaction is the study of the human and computer ...

    3 star(s)

    It allows you to call other people using face time and there are downloadable app available, either educational, social or for personal use. Impact it has on economy; The iphone has impacted economy is many ways, one of which, many people, spend a huge amount of capital just to purchase the phone.

  1. Visual basic

    = True sp2 = False Exit Sub End If End Sub Private Sub Form_Load() 'Set Player1 Playing sp1 = True sp2 = False 'Make All Fields Invisible X1.Visible = False X2.Visible = False X3.Visible = False X4.Visible = False X5.Visible = False X6.Visible = False X7.Visible = False X8.Visible =

  2. Computing Project

    The measures I am putting in place to prevent data loss or corruption is that I will be outlining to the user to make regular backups so that if in any circumstance the data becomes corrupt or lost he can retrieve the data from a backup.

  1. Identify the constituent parts of a total computer system.

    Generic software can be used in a variety of ways for different purposes. A word processor program could be used to produce posters, prepare legal documents or write a school assignment. Nearly all applications programs can be customised. This allows the user to set up the application in a way that suits them.

  2. Explain the component parts of a computer system - Include both hardware, software and ...

    Floppy Disk - Floppy disks come in two sizes, 3.5 inch (known as a diskette) and 5.25 inch. Although the smaller floppy disk is in a hard case the disk inside is floppy. Both disks store binary data as a magnetic pattern on the disks surface.

  1. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    where [logo ID]='" & LogoID & "'" The above code works with no problem even though it took a while to get the syntax correct. When you book out an item this code is run and a default Access verification box pops up double-checking that you want the order to go ahead.

  2. The Global Positioning System

    General relativity time dilation speeds the clock on the satellite up, whereas special relativity time dilation slows it down.

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