A database table, WAREHOUSE, is used to keep a record of items for sale. The table has these fields: - ItemCode - code to identify each type of item - Description - brief description of each item - Manufacturer - name of manufacturer - Level - number in stock - Price - price in dollars (\$). (a) State which field you would choose for the primary key. Give a reason for your choice. Field \_\_\_\_ Reason \_\_\_\_ \_\_\_\_ (b)Complete the query-by-example grid to display only the item code and the manufacturer where the number in stock is below 10. | Field: | | | | | | :--- | :--- | :--- | :--- | :--- | | Table: | | | | | | Sort: | | | | | | Show: | □ | □ | □ | □ | | Criteria: | | | | | | or: | | | | | [3]

2022 - O/N - 0478/21 | Q5

0/5

0 correct · 0 wrong

A database table, WAREHOUSE, is used to keep a record of ...