A database table, PORTRAIT, is used to keep a record of the portraits available from a photographic studio. Each portrait has a unique reference number PICnnn, where n is a single digit, for example PIC123. The studio keeps a record of the size (for example 20 × 15), the type (black and white or colour), and the price in dollars. (a)Complete the table to show the most appropriate data type for each of the fields. | Field | Data type | | :--- | :--- | | Reference Number | | | Size | | | Type | | | Price in \$ | | [4] (b)The results from the query-by-example grid should show the reference number, price, type and size of all portraits under \$50. Identify the three errors in the query-by-example grid. | Field: | Reference No | Price in \$ | Type | Size | | :--- | :--- | :--- | :--- | :--- | | Table: | PORTRAIT | PORTRAIT | PORTRAIT | PORTRAIT | | Sort: | | | | | | Show: | ✓ | ✓ | □ | ✓ | | Criteria: | | >50.00 | | | | or: | | | | | Error 1 \_\_\_\_ \_\_\_\_ Error 2 \_\_\_\_ \_\_\_\_ Error 3 \_\_\_\_ \_\_\_\_ [3]

2018 - O/N - 0478/22 | Q6

0/6

0 correct · 0 wrong

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