Anatomy of a View
There are three types of views (data, aggregate, validation) that you can define as you design the logical structure of the database and two types of views (materialized and partitioned) that you can define as you implement your database within an RDBMS. The ability to define the latter two types of views and the manner in which you do so are highly dependent upon your RDBMS, so they are beyond the scope of this book. We will, therefore, focus our attention on the first three types of views.
You use this type of view to examine and manipulate data from a single base table or multiple base tables.
Single-Table Data View
Although you could use all of the fields from the base table to build this type of view, ...