A database table, DEVICE, has been set up to record the electronic equipment used in a small business. | Device ID | Device Type | User | Purchase Date | Purchase Price (\$) | Portable | | :--- | :--- | :--- | :--- | :--- | :--- | | 3 | Desktop | Alan Swales | 14/02/2017 | 1350.00 | N | | 4 | Laptop | Chantel Law | 01/02/2016 | 1460.00 | Y | | 5 | Tablet | Abdula Saud | 31/12/2016 | 1000.00 | Y | | 6 | Desktop | Abdula Saud | 14/03/2017 | 1000.00 | N | | 7 | Laptop | Alan Swales | 15/03/2016 | 1700.00 | Y | | 8 | Tablet | Taona Jaji | 16/12/2016 | 470.00 | Y | (a)The query-by-example grid below selects certain records. | Field: | User | Portable | Purchase Price (\$) | | :--- | :--- | :--- | :--- | | Table: | DEVICE | DEVICE | DEVICE | | Sort: | Ascending | | | | Show: | ✓ | □ | □ | | Criteria: | | Y | >1000 | | or: | | | | Show what would be the output from the query-by-example. \_\_\_\_ \_\_\_\_ \_\_\_\_ [2] (b) Complete the query-by-example grid below to select all Desktop devices that were either purchased before 31/12/2016 or cost under \$1000. Only show the Device ID and Device Type. Field: □ Table: □ Sort: □ Show: □ Criteria: □ or: □ [4]

2017 - F/M - 0478/22 | Q6

0/6

0 correct · 0 wrong

A database table, DEVICE, has been set up to record the e...