Ex1: Simple Sorting

Johnstone High School

Introduction to Databases

Exercise 1: SIMPLE SORTING

	The ability to CHANGE the SORT ORDER is a big advantage computerised databases have over manual databases.
	Changing the sort order on one field is known as a SIMPLE SORT.

TO DO - In the Flights database

Watch the Simple Sorting Movie and practice simple sorting by answering the following questions in your Progress Grids.

Read each question carefully to see which field you have to sort on and in which order.

1.	Sort the flights in order of cost (i.e. the price field) with the cheapest flight first in the list. Write down the flight number 20th on the list.
2.	Sort the lights in order of cities alphabetically. Write down the flight number 82nd on the list.
3.	Sort the flights in order of flight numbers alphabetically. Write down the flight number 37th on the list
4.	Sort the flights in order of departure date. Write down the flight number 67th on the list.
5.	Sort the flights with countries in reverse alphabetical order i.e. starting with the Z's. Write down the flight number 79th on the list.
6.	Sort the flights in order of available seats, starting with the lowest number available. Write down the flight number 12th on the list.
7.	Sort the flights in order of available seats, starting with the highest number available. Write down the flight number 15th in the list.

Once all questions have been answered, make sure you

Mark off Exercise 1 in your progress Grids

'HOW DO I' MOVIES