More Data Types

When we store data in a database we first have to let the computer know the type of data that it can expect. Look at this diagram to see the different types of data listed with examples.  You may wish to print or copy this diagram.

DataDiag.jpg (19246 bytes)

 

Using the diagram and its examples to guide you, try this quiz to decide about the correct data type in each question.  Please note that number is now divided up into 3 different types of number: integer, currency and decimal.  You may also read explanations of text and date and time if you wish.

1. This data type contains letters and numbers e.g. A car registration number,  P545 BON Number -integer

Text

Date

2. Someone's height in metres: 1.67 Number - Integer

Number - Currency

Number - Decimal

3. The price of a new car, £16,700 Number - Integer

Number - Currency

Number - Decimal

4. How long it took to run a race in minutes and seconds, 23:07 Number - Decimal

Text

Time

5. The number of children in your family, e.g. 2 Number - Integer

Number - Currency

Number - Decimal

6. The name of your favourite performers, e.g. All Saints Number -integer

Text

Date

7. Today's temperature in degrees Celcius, e.g. 23 Number - Integer

Number - Currency

Number - Decimal

8. The name of your form, e.g. 8FG Number - Integer

Text

Date

9. The amount of money that you have in the bank, e.g. £25.67 Number - Integer

Number - Currency

Number - Decimal

10. When the summer holidays begin, e.g. 17 July 2000 Number -integer

Text

Date