Computer Science · May / June 2017 · Paper 21 · Question 7

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. 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

Read automatically from the paper; the printed page above is exact.