Question

the manager of a car showroom uses a database to store data about cars he sells
part of the database.
Make
Model SIZE OF ENGINE REGISTRATION
OPEL
Vectra
1.8
VSF 485
VOLKSWAGEN
Zafira
2.0
BFK 297
RENAULT
Golf
1.4
SB A5526
RENAULT
polo
DD B4978
) The records shown are to be sorted in descending order size of engine. What
egistration of the first record in the database after it has been sorted.
Give the name of a field that contains numeric data.
Identify the field type of the model' field
which field could be made the key field or the primary key?
​

Answer 1

Car showroom database details

Explanation:

The Manager of a car showroom uses a database. The databases comprise the following fields:

Make

Model

SIZE OF ENGINE

REGISTRATION

As in the given data size of the engine are 1.8, 2.0, 1.4 & <Null>

The records shown are to be sorted in descending order size of the engine.

• So the Registration of the first record in the database after it has been sorted in descending order is BFK 297 which has 2.0 as engine size.
• SIZE OF ENGINE is the name of a field that contains numeric data
• Character/Alphanumeric is the field type of the model' field
• REGISTRATION field could be made the key field or the primary key