Question 1
1 markAn animal rescue centre stores details of its dogs in a database. The figure shows the Dog table.
The data stored about Luna (D102, Luna, Collie, 7, TRUE) is an example of which of the following?
Choose your answer.
- A field
- A record
- A primary key
- A data type
Model answer
A record
Explanation
A record is one row of a table: all the data about one entity, here one dog. A field is one column, such as Breed, which holds one item of data for every record. The primary key is just the DogID field, not the whole row.
Mark scheme
-
1 mark
A record
Mark is for AO2 (apply). If more than one option is given, 0 marks.