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

    Principles of Computer Networks

    3 star(s)

    It is restricted to networks which are carrying variable-size packets. It works with to lower layer of the OSI model. The data link layer and the physical layer. It further splits the data link layer into Logical Link Control and Media Access Control.

  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. Identify the constituent parts of a total computer system.

    In addition it can take a months or even years for software to be developed. Once the software has been produced it is likely to have a number of bugs that will need to be sorted out. OPERATING SYSTEMS ON A MICROCOMPUTER An operating system is a program that controls and organises the general operation of the computer.

  2. Computing Project

    anything inappropriate from being entered into the system which will help in increasing the integrity of the data entered.. I will also use input masks for things like the post code or telephone of a member as there all the post codes and telephone numbers are in one standard form for all members so this will also improve integrity.

  1. Smart Card System

    damaged in transmit, or it could send a message to the wrong place. It is both more efficient and safer to have TCP compute a separate checksum for the TCP header and data. IP addresses are used to deliver packets of data across a network and have what is termed end-to-end significance.

  2. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    At the receiving end, each group of incoming bits is checked to see if the group totals to an odd number. If the total is even, a transmission error has occurred and either the transmission is retried or the system halts and an error message is sent to the user.

  1. Computing Project

    This means that the system will not be lost easily as it is not a portable storage device but on a actual laptop, which would be looked after carefully. There is a large amount of space on the hard disk meaning that there will be available space for expansion if necessary.

  2. Describe the functions of each section within the shops and Head Office, paying particular ...

    on a database along with records of training courses attended by members of staff and any qualifications they obtain. * Determine what further training each staff member requires and how best to provide it * Book the member of staff on an external training course/ if many members require training organise for a trainer to deliver the course 'in house'.

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