The database table, PCSTOCK, is a part of the database in an electronics shop, showing some of the desktop (DT), tablet (TB) and laptop (LT) computers they have in stock. | PCID | ScreenSize | RAM | Type | HDD(GB) | Price | | :--- | :--- | :--- | :--- | :--- | :--- | | DT303240 | 30 | 32 | DT | 4000 | \$5000.00 | | DT303220 | 30 | 32 | DT | 2000 | \$4500.00 | | DT301620 | 30 | 16 | DT | 2000 | \$4000.00 | | DT231610 | 23 | 16 | DT | 1000 | \$3000.00 | | LT191620 | 19 | 16 | LT | 2000 | \$3000.00 | | LT171610 | 17 | 16 | LT | 1000 | \$2500.00 | | DT230820 | 23 | 8 | DT | 2000 | \$2000.00 | | DT190810 | 19 | 8 | DT | 1000 | \$1500.00 | | LT190810 | 19 | 8 | LT | 1000 | \$1500.00 | | LT170805 | 17 | 8 | LT | 500 | \$1200.00 | | DT230420 | 23 | 4 | DT | 2000 | \$1000.00 | | DT190410 | 19 | 4 | DT | 1000 | \$750.00 | | LT190410 | 19 | 4 | LT | 1000 | \$950.00 | | TB100206 | 10 | 2 | TB | 64 | \$200.00 | (a)Complete the table to show the most appropriate data type for each field based on the data shown in the table at the start of question 6. | Field | Data type | | :--- | :--- | | PCID | | | ScreenSize | | | Type | | | Price | | [2] (b)Using the query-by-example grid, write a query to identify all the desktop computers with a hard drive larger than 1000 GB. All fields in the table should be shown, sorted in descending order by price. Field: | | | | | | | | :--- | :--- | :--- | :--- | :--- | :--- | | | | | | | | | | | | | | | | □ | □ | □ | □ | □ | □ | | | | | | | | [4]

2018 - O/N - 0478/21 | Q6

0/6

0 correct · 0 wrong

The database table, PCSTOCK, is a part of the database in...