Database design

This essay hasn't yet been marked by one of our teachers

You can view 6 essays on ICT Systems and Application that have been Marked by Teachers

The first 200 words of this essay...

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