A car manufacturer makes a range of car models named Pegasus, Apollo and Cupid. It keeps a database to store the records of its range and the different options for each car model. Within the table CAR_RANGE, the following data needs to be stored: 1. Car model 2. Body style - saloon, hatchback or estate 3. How many doors it has 4. Whether it uses petrol, diesel or batteries as fuel 5. An identifier for a specific car. (a)Complete the table to show suitable field names and an example of appropriate data for each field in the database table CAR_RANGE. | Field name | Example of data | | :--- | :--- | | | | | | | | | | | | | | | | [3] (b) State which of your fields would be most appropriate for a primary key and give a reason for your choice. \_\_\_\_ \_\_\_\_ \_\_\_\_ [2] (c) Complete the query-by-example grid to provide a list of car models using petrol and the number of doors these cars have, in alphabetical order of car model. Display only the car models and the number of doors. Field: □ Table: □ Sort: □ Show: □ Criteria: □ or: □ [3]

2019 - O/N - 0478/21 | Q5

0/5

0 correct · 0 wrong

A car manufacturer makes a range of car models named Pega...