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

Introduction

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.

Middle

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.

Conclusion

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. ICT PROJECT

    Select add new student macro button To check if the user form loads without problem A user form should be open, new line should then be insert at row two. When user click ok button the number will be sorted in ascending order and then return to main menu 35.

  2. Database design.

    The line shows they are joined. Creating the forms To create the form you click new and this window will appear at this click form wizard and choose the table or query where the data comes from at the bottom of the window When you fill in the data's table or query this window will appear.

  1. Database Analysis and Database Design Project - DVD library for moving images.

    TITLE CUSTOMER TITLE (MR, MRS) TEXT (5) FOREIGN KEY (F.K) FROM TITLE TABLE F_NAME CUSTOMER FIRST NAME TEXT (15) M_NAME CUSTOMER MIDDLE NAME TEXT (15) L_NAME CUSTOMER LAST NAME TEXT (15) ADDRESS CUSTOMER ADDRESS TEXT (25) COUNTY LOCAL COUNTY TEXT (10) POST_CODE ADDRESS POST CODE TEXT (10)

  2. Computer project Alevels

    This includes all the sheduled appointments which can be printed and given to the patients when they arrive if they have booked it earlier. * APPOINTMENTS DOCTOR When you click on the button "APPOINTMENTS DOCTOR" on the MAIN MENU a screen appears where the user can check the appointments sheduled

  1. Producing a database and standard letters - difference between computerised and manual systems

    Especially when mistakes occur. It will save ink and make the letters look professional. Creating a letterhead by hand will not be as neat as it will on a computer. Writing reports at the end (User Guides) I can do this by hand by writing all different reports for different occasions.

  2. GCSE Database Project ICT

    Mail Merge is also available but can be quite had to control and set up. Also with excel formulae can be inserted to control and manipulate the data inserted. Links and macros to other workbooks and sheets increase versatility of this program.

  1. ICT Project 1A

    For this information I generally used the Tokio Hotel Homepage. When researching about the band on Google I had to be careful, there were many phoney sites that I came across that could have really done some damage. This site that I acme across was actually giving information about the Tokio Hotel Mobile game, not the actual band.

  2. GCSE Book DataBase Project

    It takes so long to find some ones file if your filing cabinet is not filed properly. Paper documents take up a lot of room up. You have no back up. You can't share the records because you only have one copy.

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