Database Reference
In-Depth Information
Figure 12.14. View diagram for the CUSTOMER CALL LIST view
Using Calculated Fields Where Appropriate
Earlier in the database design process, you learned that tables couldn't contain
calculated
fields
foranumberofgoodreasons.Butoneofthecharacteristicsofaviewthatmakesitso
useful is that it
can
contain calculated fields. Recall that calculated fields will display the
result of a concatenation, expression, or aggregate function; this makes them an extremely
flexible structure to include in a view.
