A database table, TRAIN, is to be set up for a railway company to keep a record of the 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. (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. Field 1 Name \_\_\_\_ Data type \_\_\_\_ Data sample \_\_\_\_ Field 2 Name \_\_\_\_ Data type \_\_\_\_ Data sample \_\_\_\_ Field 3 Name \_\_\_\_ Data type \_\_\_\_ Data sample \_\_\_\_ [6] (b) State the field that you should choose as the primary key. \_\_\_\_ [1] (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. Field: | | | | | | :--- | :--- | :--- | :--- | | | | | | | | | | | | □ | □ | □ | □ | | | | | | [3]

2017 - O/N - 0478/22 | Q6

0/6

0 correct · 0 wrong

A database table, TRAIN, is to be set up for a railway co...