Lesson on the theme "Database management systems. Sorting. Requests to select data"

The article presents one of the lessons of the "Databases" section of the ninth grade informatics course. This lesson explores such concepts as "DBMS", "sorting", "filter", "selection", "request". Methods of sorting information in a database are considered, as well as methods of searching for information in a database using filters and requests. The content of the lesson corresponds to the teaching materials on informatics for the ninth grade of L. L. Bosova, A. Yu. Bosova. A feature of the presented lesson is that it is intended for students studying at a cadet school (cadets), therefore a military component has been added to it — the examples of databases considered in the lesson are related to aviation. The databases, on the example of which the educational material of the lesson is considered, is a database containing information about the characteristics of aircraft of the USSR and Russia, and a database containing information about flights that are operated from Moscow Domodedovo and Sheremetyevo airports.