Ex2: Complex Sorting

Johnstone High School

Introduction to Databases

Exercise 2: COMPLEX SORTING

	Computerised databases can also be sorted on more than one field at the same time.
	Changing the sort order on more than one field is known as a COMPLEX SORT.

Press the Tab key to move easily from field to field

TO DO - In the Flights database

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

1.	Sort the flights in order of country and then city in ascending order. Look at the list carefully to see sort order. Write down the flight number 37th on the list.
2.	Sort the flights in order of city and then country in ascending order. Look carefully at the sort order. Do you see any difference compared to your previous sort. Write down the flight number 28th on the list.
3.	Sort the countries followed by the price, both in ascending order. Write down the flight number 67th on the list.
4.	Sort the available seats followed by the ticket price, both in ascending order. Write down the flight number 71st on the list.
5.	Sort the flight dates followed by the flight times, both in ascending order. Write down the flight number 56th on the list.
6.	Sort the cities in ascending order followed by available seats in descending order. Write down the flight number 37th on the list.
7.	Sort the flight times in descending order followed by the cities, both in ascending order. Write down the flight number 44th on the list.
8.	Sort the flight number followed by flight date, both in ascending order. Write down the number 1st on the list.
9	Sort the flight number followed by country, both in ascending order. Write down the flight number 1st on the list.
10.	Why is there no point in doing a double sort, when the first sort item is flight number,.


Once all questions have been answered, make sure you

Mark off Exercise 2 in your progress Grids

'HOW DO I' MOVIES