Computer Science · May / June 2023 · Paper 21 · Question 10

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

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