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

Database design

Extracts from this document...


Detailed Analysis The data which is likely to be required to be entered in each of the three categories, which are cottages, customers and booking, include the following: Cottages: * Cottage No/name * Type of cottage * Number of room in the cottage * Cottage price- by size of cottage * Peak/ off peak * Cottage location Customer: * Customer name * Customer address * Customer contact No * Customer email address if required * Customer D.O.B * Cottage type selected * Total amount to be paid * Number of weeks staying Booking: * Cottage model No * Payment method by credit card of debid card * Booking payment * Cottage type * Date booked * Arrival date * Departure date * No of days The validation checks which are likely to be required on this data are: 1 Data type 2 Input mask 3 Presence check 4 Range check 5 Format The invoices will be produced for booking which have been accepted. The content of a typical invoice will include: * Name of customer * Customer personal information such as address * Cottage booking information * Duration of stay ...read more.


This will enable staff to respond quickly to telephone enquiries. They will also be able to process incoming cottage booking more quickly- so as to provide much increased customer satisfaction with the service, as well as reducing administration costs. At the same time it is expected the system will be much better at providing management information. SYSTEM SCOPE The new system will replace the existing system (which only records Cottages information and prints these on reports to the management) so as to include all processing of a customer's booking through to recording it's its cottage number, time and date. The system should provide full management information about renting. The new system will not allow users to see which cottages are available (empty) and who allocated to the cottage (landlord). However if possible the system should be built so that this can be done in the future. The system will perform various validation checks on most of the documents, such as the entry of data regarding customer, cottages and bookings. The computer will detect and therefore output error messages, so that the user can then correct any errors he/she has made. ...read more.


Ideally allow postcode look-ups of addresses. 5 Allow look up of available cottage 6 Record money received from customers in finance OUTPUT 7 Create invoices for cottage booking which are available. 8 Provide reports on best customers and landlords - over varying periods of time. 9 Allow the creation of future reports on booking which are not yet specified 10 Provide weekly, monthly and quarterly letting lists 11 Print out of reports which provide information to Qualcotts management about the booking that they have taken. PROCESSING 1 Automatically price booking - including discounts available The system should be developed to use the standard colours and logos throughout. Most users of the system should be able to use the system without extra software training (for example in ACCESS) although they will obviously need training to use the system itself. The user was interested in providing a capability for customers to order directly onto a Qualcotts web site on the Internet. Although this is not part of the scope of the proposed project, in the future it is expected that this will be required so the project should try to ensure that the project work can be used as the basis for this future capability. Input specification Output specification ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Smarts Leisure Park Database Booking System

    database because It allows the whole operation to be more efficient booking. I will design and create a booking system using MS Access 2003. User Needs Mr Starr of Smarts Leisure Park has set the following user needs: * Must be able to add, edit and store customer details *

  2. System requirements analysis

    as details such as name, age, birthday as well as the things that they have been operated against. This shows how much money the patient has cost them and the treatments that they have had as well previously as well as how much it has cost them as well as the equipment that they had used for that patient.

  1. Database Design Guideline

    Form doctors form: Patient ID, ward and illness Query Design - this is what the 2nd query will look like in my Microsoft access database document: Field: Doctor ID Forename Surname Patients ID Ward Tables: doctors doctors doctors patient patient Sort: Show: ?

  2. System administration report

    It operates in small area and aims to dominate the market in the area they operate. The hotel is busy through out the week, especially on Friday's and the weekends where it is fully booked. The hotel is an ideal place for weddings, parties and conferences with numerous halls and conference rooms.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    Each representing one day. When ever a book is borrowed the book card is put inside the issuing tray in that pocket when the book has to be returned. The book card contains the call number which determines the location of the book, the author's or publisher's name, and the

  2. GCSE Book DataBase Project

    Using ICT Advantages Disadvantages It easy to save data as it will not get lost unless I forget where I saved the file. The data will not be altered if I leave the file alone for a while. If you don't know how to use the database it can be useless and therefore pointless in producing the database at first.

  1. Organising the database at Costsloadsless.

    Over due loans This is very important to have just in case a worker forgets to look up a customer or forget to check if all the DVD'S are back Set up a query to search for all members that have overdue videos/DVD.

  2. Database design.

    * Show the employee how to send e-mail. * To make letter for the customers, mail merge. Explanation of the entities and attributes Entities An entity is a thing or object of importance about which data must be captured. All things aren't entities - only those about which information should be captured.

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