Your Status: Logged out Log in

Database design

Member rating: No Rating | Words: 17000 | Submitted: Fri May 25 2007

Page Preview
Preview
Previous 1 of 5 Next

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

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

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 149,430 others
Register Now