Database Reference
In-Depth Information
Figure 12.13. Relationship diagram for the CUSTOMERS and ORDERS tables
After examining the relationship diagram, you determine you need to use five fields to
build this view: C
UST
F
IRST
N
AME
, C
UST
L
AST
N
AME
, C
UST
P
HONE
N
UMBER,
and C
UST
C
ITY
from the CUSTOMERS table, and O
RDER
D
ATE
from the ORDERS table. You now define
the CUSTOMER CALL LIST view by assigning the fields to the view and then recording
them in a view diagram. When you're finished, your diagram should look like the one in