The AirlineBrokers database will be used to study XML data access. This database can be created using the SqlServer Enterprise Manager and the airlinebroker.sql script found in the Databases directory of this chapter. The AirlineBrokers database represents another service that the Acme reservation system uses. Acme customers can make airline reservations to the places they wish to go.
The database has several tables:
Airlines: information about the various airlines in the database.
PlaneType: the various planes that the airlines use.
Flights: information about the various airlines' flights.
Customers: information about customers. ...