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

    After successfully testing the software, it is delivered to the customer. Operations & Maintenance: This phase of "The Waterfall Model" is virtually never ending phase (Very long). Generally, problems with the system developed (which are not found during the development life cycle)

  2. Peer reviewed

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

    3 star(s)

    As a user of an interface, they way you would perceive a colour would be different, that is why it is important for developers to be considerate when creating an interface. Under perception there are colour, patterns and objects. * Colour: Colour is an extremely important fact in which a

  1. Peer reviewed

    Principles of Computer Networks

    3 star(s)

    For example 802.11a uses the same data link layer protocol and frame format as the original standard but it works in the 5 GHz ban and has a maximum net data rate of 54 Mbps. IEEE 802.11 This is the standard which handles Wi-Fi connections.

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

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

  2. AS ICT Corsework - Mr Brookes K-Fit Ltd

    as one call is registered but the customer doesn't order anything and proposes to get back in contact with K-Fit 9:30 Calls - 2 Kitchen Supply Ordered - 1 Fitting ordered - 0 Kitchens being supplied - 0 Fitting supplied - 0 Customer Visit - 0 Now fitting or supply

  1. Unit 6 - Advanced Spreadsheet Skills

    Lesco has a huge buying power and demand a special lower prices, a constant supply of produce and marketing information so that they can publish it on the website weekly. 5. Products: The company supplies boxes of organic fruit and vegetables in a range of boxes all retailing at different prices.

  2. Computing Project

    Also the laptop can be connected to a computer in the office via a USB cable meaning that the data could be backed up and if needed archived. IDENTIFICATION OF SUITABLE ALGORITHMS FOR DATA TRANSFER Process to calculate Total number of lessons so far = ([Student Lessons])*([Total])

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