A wildlife park has a database table, called LIVESTOCK, to classify and record its animal species. Part of the database table is shown. | Species | Classification | Diet | Legs | | :--- | :--- | :--- | :--- | | Giraffe | Mammal | Herbivore | 4 | | Elephant | Mammal | Herbivore | 4 | | Crocodile | Reptile | Carnivore | 4 | | Ostrich | Bird | Omnivore | 2 | | Gorilla | Mammal | Herbivore | 2 | | Bear | Mammal | Omnivore | 4 | | Rhinoceros | Mammal | Herbivore | 4 | | Hippopotamus | Mammal | Herbivore | 4 | | Flamingo | Bird | Omnivore | 2 | | Lion | Mammal | Carnivore | 4 | | Turtle | Reptile | Omnivore | 4 | | Penguin | Bird | Carnivore | 2 | (a) Suggest another appropriate field that could be added to this database by stating its name and data type. State its purpose and give an example of the data it could contain. Field name \_\_\_\_ Data Type \_\_\_\_ Purpose \_\_\_\_ \_\_\_\_ Example of data \_\_\_\_ [2] (b)Use the query-by-example grid below to provide a list of all four legged mammals that are herbivores, sorted alphabetically by species, with only the species displayed. | Field: | | | | | | | :--- | :--- | :--- | :--- | :--- | :--- | | Table: | | | | | | | Sort: | | | | | | | Show: | □ | □ | □ | □ | □ | | Criteria: | | | | | | | or: | | | | | | [4]

2017 - O/N - 0478/21 | Q6

0/6

0 correct · 0 wrong

A wildlife park has a database table, called LIVESTOCK, t...