where flight_crew.flight_id = 34 order by ‘last name’, (Disney web site)
where flight_crew.flight_id = 34 order by ‘last name’, ‘first name’ The results are sorted by last name and first name; note the “type” column that indicates whether this person is a passenger or a crew member. Summary From the study of a few documents about an airline system, we listed the possible data elements that become columns grouped into tables. We carefully chose the primary key or keys for each table and built relations between these tables, verifying that all potential data elements were included in at least one table.