Q-3. The manager of a car rental uses a database to store data about the cars for rent. This is part of the database. (see attachment Q3) (8 Marks)

1. Write down the most suitable data type for each item of data in the table.(2)
2. How many records are there in this part of the database? (2)
3. If the records shown are to be sorted in ascending order of Day/Month/Year manufacture. What will be the registration number of the car which will be the first record in the database after it has been sorted? (2)
4. Give one example where you would use a spreadsheet program (e.g. Excel) and one example where you would use database to store and process data.

Doors Registration number KAC 758F Day/Month/Year of manufacture 12/10/1991 Air conditioning (Y/N) Y 4 KAR 815P 03/06/2005 5 N 5 N KAB 179A KAP 613Y 05/08/1990 11/08/2004 3 N