# Database: Example: Aviation

Name __________________________________________

## The Aviation Database

These questions all apply to the Aviation database whose relationship diagram is below.
MS Access relationship diagrams have some peculiarities. Note that the PILOT table is duplicated because Access doesn't allow more than one relationship between the same tables; the CHAR_PILOT and CHAR_COPILOT fields are both keys to the PILOT table. The optional zero isn't shown with relationships, so you can't tell from this diagram that every pilot is an employee, but not every employee is a pilot.