A database table called TVRange shows the main features and prices of a range of televisions. | TVCode | ScreenSize | Satellite | SmartTV | SoundBar | Price$ | |------------|------------|-----------|---------|----------|----------| | TV90SaSmSd | 90 | YES | YES | YES | 9750.00 | | TV75SaSmSd | 75 | YES | YES | YES | 8500.00 | | TV75SaSd | 75 | YES | NO | YES | 8000.00 | | TV65SaSmSd | 65 | YES | YES | YES | 6000.00 | | TV65SmSd | 65 | NO | YES | YES | 5000.00 | | TV65SaSd | 65 | YES | NO | YES | 5000.00 | | TV55SaSmSd | 55 | YES | YES | YES | 4000.00 | | TV55SaSd | 55 | YES | NO | YES | 3500.00 | | TV55SmSd | 55 | NO | YES | YES | 3500.00 | | TV50SaSmSd | 50 | YES | YES | YES | 2500.00 | | TV50Sa | 50 | YES | NO | NO | 1750.00 | | TV50Sm | 50 | NO | YES | NO | 1750.00 | | TV40Sa | 40 | YES | NO | NO | 1200.00 | | TV40 | 40 | NO | NO | NO | 950.00 | | TV32 | 32 | NO | NO | NO | 650.00 |

1. (a)Give the name of the field that is most suitable to be the primary key. State the reason for this choice. Field Reason[2]
2. (b)The database uses the data types: • text • character • Boolean • integer • real • date/time. Complete the table to show the most appropriate data type for each field. Each data type must be different. Field | Data type -----------|----------- TVCode | ScreenSize | SmartTV | Price$ | [2]
3. (c)Complete the structured query language (SQL) query to return the television (TV) code, screen size and price of all Smart TVs in the database table. SELECT TVCode, FROM TVRange WHERE SmartTV = [4]