A television (TV) store has a database table, TVSTOCK, for its new range of televisions. The table stores the screen size of each TV, whether it will show 3D, whether the screen is curved or flat, if the internet is available on the TV, if it has a built-in hard disk drive and the price. Part of the database table is shown below. Table: TVSTOCK | TVID | ScreenSize | 3D | CurvedFlat | Internet | HDD | Price | |:----------|:----------:|:--:|:----------:|:--------:|:---:|:----------| | TV80CVINT | 80 | YES| CV | YES | YES | $7,000.00 | | TV65CVINT | 65 | YES| CV | YES | YES | $5,000.00 | | TV60CVINT | 60 | YES| CV | YES | YES | $4,500.00 | | TV60FTINT | 60 | YES| FT | YES | YES | $4,000.00 | | TV55CVINT | 55 | YES| CV | YES | NO | $3,000.00 | | TV55FTINT | 55 | YES| FT | YES | NO | $3,500.00 | | TV55FTNIN | 55 | YES| FT | NO | NO | $3,000.00 | | TV50CVINT | 50 | YES| CV | YES | NO | $2,500.00 | | TV50FTINT | 50 | YES| FT | YES | NO | $2,000.00 | | TV50FTNIN | 50 | YES| FT | NO | NO | $1,750.00 | | TV42FTINT | 42 | YES| FT | YES | NO | $1,500.00 | | TV37FTINT | 37 | NO | FT | YES | NO | $1,200.00 | | TV20FTNIN | 20 | NO | FT | NO | NO | $800.00 | | TV15FTNIN | 15 | NO | FT | NO | NO | $400.00 |

1. (a)State the type of the field TVID and give a reason for your choice.[1]
2. (b)Complete the table with the most appropriate data type for each field. | Field name | Data type | |:-----------|:----------| | ScreenSize | | | 3D | | | CurvedFlat | | | Internet | | | HDD | | | Price | |[3]
3. (c)Use the query-by-example grid below to provide a list of all of the curved screen TVs that have a built-in hard disk drive. Make sure the list only displays the TVID, the price and the screen size in ascending order of price. Query-by-example grid with columns for Field, Table, Sort, Show, Criteria, or.[5]