Page 1087 - SUBSEC October 2017_Neat

- 7 -

DO NOT WRITE IN THIS AREA
3. DATABASE

(a) The following questions relate to database management.

The owner of a car dealership uses a stock card system to record the details of vehicles in
his inventory. A sample stock card is shown below.

Make Model Registration Number Colour

Audi A4 PCE 427 Silver
Audi S4 PCS 4 White

BMW X3 PBH 2340 Red
BMW X5 PCY 888 Blue
DO NOT WRITE IN THIS AREA
Mercedes C180 PBB 3962 Green

Mercedes E200 PBR 4747 Black
Mercedes E200 PCT 6531 Gold

Mercedes S500 PDM 1 Black

Design the structure of a database table to correspond to the stock card. Your table structure
should include appropriate field names, data types and field sizes.
(3 marks)

(b) Which field in the table is the MOST appropriate to use as a key field?

..............................................................................................................................................
(1 mark)

(c) Suggest ONE additional field which could be added to the table.
DO NOT WRITE IN THIS AREA
..............................................................................................................................................
(1 mark)

(d) Suggest ONE database feature that can be used by the dealer to simplify the entry of new
vehicles and their details into his inventory.

..............................................................................................................................................
(1 mark)

(e) Describe ONE validation check that could be used on the Registration Numbers as they
are entered.

..............................................................................................................................................

..............................................................................................................................................
(1 mark)
GO ON TO THE NEXT PAGE
01229032 SPEC/2017
‘‘*’’Barcode Area”*”
Sequential Bar Code