A database table, JEWEL, is used to keep a record of jewellery for sale in a shop. Each item of jewellery can be made of silver, platinum or gold metal. The shop stocks rings, bracelets and necklaces. The number in stock and the price is also stored. (a) Identify the four fields required for the database. Give each field a suitable name and data type. Explain why you chose the data type for each field. Field 1 Name \_\_\_\_ Data type \_\_\_\_ Explanation \_\_\_\_ \_\_\_\_ Field 2 Name \_\_\_\_ Data type \_\_\_\_ Explanation \_\_\_\_ \_\_\_\_ Field 3 Name \_\_\_\_ Data type \_\_\_\_ Explanation \_\_\_\_ \_\_\_\_ Field 4 Name \_\_\_\_ Data type \_\_\_\_ Explanation \_\_\_\_ \_\_\_\_ [8] (b) Explain why none of these fields could be used as a primary key. \_\_\_\_ \_\_\_\_ [1] (c)Using the query-by-example grid below, write a query to identify the silver bracelets. Only display the number in stock and the price. | Field: | | | | | | :--- | :--- | :--- | :--- | :--- | | Table: | | | | | | Sort: | | | | | | Show: | □ | □ | □ | □ | | Criteria: | | | | | | or: | | | | | [3]

2018 - F/M - 0478/22 | Q6

0/6

0 correct · 0 wrong

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