A database table, APPLIANCE, is used to keep a record of kitchen appliances available for sale. The following data is stored for each appliance: - CATEGORY - washer, dishwasher, fridge or freezer - ECONOMYRATING - A, B, C or D - MANUFACTURER - Baku or ABC - PRICE - price in \$ - CODE - a unique code allocated by the manufacturer e.g. B982 - STOCK - number in stock. The database management system uses these data types: Text Number Currency Boolean The ECONOMYRATING field and MANUFACTURER field have a data type of text. (a) Identify the most appropriate data type for each field from the four types shown. State the reason why you chose each data type. CATEGORY 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 and code of the appliances with an economy rating of A. Field: □ Table: □ Sort: □ Show: □ Criteria: □ or: □ [3]

2021 - O/N - 0478/21 | Q5

0/5

0 correct · 0 wrong

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