An online fruit tree specialist sells fruit trees in various sizes. A database table, TREETAB, shows the tree type and, for each size, the price and whether they are in stock. | Tree Type | Size1 | Size1 In | Size2 | Size2 In | Size3 | Size3 In | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | Apple | 10.95 | Yes | 14.95 | Yes | 29.95 | Yes | | Apple | 12.95 | Yes | 14.95 | Yes | 29.95 | Yes | | Cherry | 24.95 | No | 34.95 | No | 59.95 | Yes | | Fig | 19.95 | Yes | 29.95 | No | 49.95 | Yes | | Guava | 19.95 | No | 29.95 | No | 59.95 | No | | Nectarine | 8.50 | Yes | 11.95 | Yes | 19.95 | Yes | | Olive | 19.95 | No | 39.95 | Yes | 59.95 | Yes | | Peach | 9.25 | No | 11.95 | Yes | 19.95 | Yes | | Pear | 10.95 | Yes | 14.95 | Yes | 29.95 | Yes | | Plum | 8.95 | Yes | 11.95 | Yes | 19.95 | Yes | | Pomegranate | 12.95 | No | 18.95 | Yes | 34.95 | No | | Quince | 34.95 | Yes | 44.95 | Yes | 84.95 | No | (a) State whether any of the fields shown would be suitable as a primary key. \_\_\_\_ Explain your answer \_\_\_\_ \_\_\_\_ \_\_\_\_ (b)Complete the table to show the most appropriate data type for each of the fields based on the data shown in the table at the start of question 6. | Field | Data type | | :--- | :--- | | Tree Type | | | Size3 | | | Size2 In | | [3] (c)Show the output that would be given by this query-by-example. | Field: | Tree Type | Size1 | Size1 In | | | | :--- | :--- | :--- | :--- | :--- | :--- | | Table: | TREETAB | TREETAB | TREETAB | | | | Sort: | | Descending | | | | | Show: | ⊠ | ⊠ | ⊠ | □ | □ | | Criteria: | | <10.00 | | | | | or: | | | | | | \_\_\_\_ \_\_\_\_ \_\_\_\_ \_\_\_\_ [4] (d) Using the following query-by-example grid, write a query to identify all types of the fruit trees that are out of stock for all three sizes. Make sure the type of the tree and the various 'in stock' fields are shown. The trees should be listed in alphabetical order by type. Field: □ Table: □ Sort: □ Show: □ Criteria: □ or: □ [4]

2018 - O/N - 0478/23 | Q6

0/6

0 correct · 0 wrong

An online fruit tree specialist sells fruit trees in vari...