Document page
Computer Science IGCSEPDF 127
142 pagesrevision 46930
PDF 127
Page image rendered from the stored file at 110 dpi; it sharpens as you zoom. Outlines are placed from each region’s stored position on the page (612 × 792 pt).
readable
Source of this text: embedded text layer. The better of the embedded text and OCR is kept.
Q1.
b)
a) Identify the three fields required for the database. Give each field a
suitable name and data type. Provide a sample of data that you could
expect to see in the field.
c) Using the query-by-example grid below, write a query to identify all
passenger engines that have not been serviced in the past 12 months.
Only display the engine numbers.
Adatabase table, TRAIN, is to be set up for a railway company to keep a record
ofthe engines available for use. Each engine has a unique number made up of 5
digits, nnnnn. The engines are classified as freight (F) or passenger (P) together
with a power classification that is a whole number between 0 and 9, for example
F8. The railway company keeps a record of the date of the last service for each
engine.