Database Reference
In-Depth Information
Figure 12.3. Base tables for the CLASS ROSTER view
Now you define the CLASS ROSTER view by using the C
LASS
N
AME
field from the
CLASSES table and the S
TUD
F
IRST
N
AME
and S
TUD
L
AST
N
AME
fields from the
STUDENTS table. The appropriate student names will appear for each class because
CLASSES and STUDENTS are related (and therefore connected) through the STUDENT
CLASSES linking table.
Figure 12.4
shows the diagram for the CLASS ROSTER view.
Note that no changes have been made to any of the base tables.
