A database table, COMPUTER, is used to keep a record of computers available for sale. The following data is stored for each computer: - CATEGORY - desktop, laptop or tablet - WEIGHT - weight in kilograms - MANUFACTURER - ICN, Linoldo, Pear or JoeSing - PRICE - price in \$ - CODE - a unique code allocated by the manufacturer, e.g. P771 - STOCK - quantity in stock. A database management system uses these data types: Text Number Currency Boolean The CATEGORY field and MANUFACTURER field have a data type of text. (a) Select the most appropriate data type for each field from the four types shown. State the reason why you chose the data type. WEIGHT data type \_\_\_\_ Reason \_\_\_\_ \_\_\_\_ PRICE data type \_\_\_\_ Reason \_\_\_\_ \_\_\_\_ CODE data type \_\_\_\_ Reason \_\_\_\_ \_\_\_\_ STOCK data type \_\_\_\_ Reason \_\_\_\_ \_\_\_\_ (b)Complete the query-by-example grid to display only the category, manufacturer, price and code of the computers with weight of less than 2.5 kilograms. Field: | | | | | | | :--- | :--- | :--- | :--- | :--- | | | | | | | | □ | □ | □ | □ | □ | | | | | | | | | | | | |

2021 - O/N - 0478/23 | Q5

0/5

0 correct · 0 wrong

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