Database task 1

Number 254    information: house number     knowledge: if between 200 and 300 deliver to address, data type integer, format text.

String 01874    information: telephone number    knowledge: add remaining digits on to make a mobile phone number.    data type string    format text

Colour Green    information: colour of text  Knowledge: if the colour of the text is green, it is above average    data type text    format text

Date 16/08/1974    information: date of birth    knowledge: if the date of birth is between 1951 and 1998.   data type date    format text

Number 89    information: age of a person    knowledge: if between 18 and 65 pay taxes    data type: integer    format: text