Database Reference
In-Depth Information
Figure 11.19
The data view of the model.
The diagram view of the model shows the tables and relationships between
the tables in the model.
Figure 11.20
shows the tables in the diagram view;
no relationships are defined between the tables yet. To toggle between the
views, click the icons in the View area of the Home tab.
Figure 11.20
The diagram view of the model.
Now that the tables and data have been imported into the model, you need
to establish relationships between the tables in the model.
Updating the Model
To establish relationships between the tables in the model complete the
following steps:
1. In the diagram view, drag the carrier_cd field from the flight_dept and
drop it on the Code field in the Carriers table.
2. Repeat the procedure in step 1 to create a relationship between the
airport_cd field in the flight_dept table and the code field in the
US_Airports table.
