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

Ask smart questions

Week 19 · 2.3 Creating databases · 3 lessons
Answers are for parents and teachers.
1
The Boats table is shown. A query shows Boat and Price, with the criteria Type = "Rowing" and Free = "Yes" in the same row, sorted by Price ascending. List the results.
Boat_IDBoatTypePriceFree
1SwanRowing6.00Yes
2HeronRowing5.50No
3KiteSail9.00Yes
4LarkRowing4.50Yes
5WrenRowing5.00Yes
2
Using the Boats table of the first task, how many records does the query find if Type = "Sail" is in the Criteria row and Price < 5 is in the or row? Name them.
Boat_IDBoatTypePriceFree
1SwanRowing6.00Yes
2HeronRowing5.50No
3KiteSail9.00Yes
4LarkRowing4.50Yes
5WrenRowing5.00Yes
3
Explain, with one example from a school sports table, the difference between putting two conditions in the same row and putting them in different rows.
4
A weather company keeps temperature readings from 2 000 stations every 10 seconds. How many readings is that in one minute? Which of the five Vs does it show?
5
Design a short database for a library’s book clubs. List two tables with a primary key for each, a foreign key to link them, and write one query with an OR in words.