AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Computing

Ask the database

Week 19 · Unit 7.4: The power of data · 3 lessons
Answers are for parents and teachers.
1
A teacher wants a form to collect each child’s first name, class and favourite sport. Plan the fields: give each a data type and a character limit.
2
Use the Books table. Write the design table row for ‘the titles and pages of all Adventure books’, and list the results.
BookIDTitleGenrePagesYearOnLoan
1River MapsAdventure2102018Yes
2The Quiet KiteStory962020No
3Space AtlasScience3202021Yes
4Tiny MachinesScience1482019No
5Desert WindAdventure2752016No
6The Baking ClubStory1842022Yes
7Rock and RainScience4122015No
8Night TrainAdventure3502020Yes
3
Use the Books table. Is the condition Year >= 2021 TRUE for exactly two records? Name the books it selects.
BookIDTitleGenrePagesYearOnLoan
1River MapsAdventure2102018Yes
2The Quiet KiteStory962020No
3Space AtlasScience3202021Yes
4Tiny MachinesScience1482019No
5Desert WindAdventure2752016No
6The Baking ClubStory1842022Yes
7Rock and RainScience4122015No
8Night TrainAdventure3502020Yes
4
A library keeps a list of books and their borrowers. Why should a query that lists overdue books not show the borrower’s phone number, and why should a password never be stored in a table that anyone can search?
5
Design a conditional formatting rule for a table of plants so that plants costing less than 3 are highlighted. Which of the prices 5, 2, 3, 1, 4 are highlighted?