Database design
Member rating: No Rating | Words: 17000 | Submitted: Fri May 25 2007
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...

