Views - Database Design for Mere Mortals - page 368

Data View
You use this type of view to examine and manipulate data from a single base table or mul-
tiple base tables.
Single-Table Data View
Althoughyou could useallofthefieldsfromthebasetabletobuildthistypeofview,you'll
usually just use selected fields. (Building a view using all of the base table's fields would
simply produce a virtual copy of the base table.) For example, say you want to make a list
of employee names and phone numbers available to everyone in the organization. You can
construct an EMPLOYEE PHONE LIST view based on the EMPLOYEES table using just
the E MPLOYEE ID, E MP F IRST N AME , E MP L AST N AME , and E MP P HONE N UMBER fields. Fig-
ure 12.1 shows a diagram of this particular view. (Note the new symbol used to indicate a
view.)