Terminology - Database Design for Mere Mortals - page 42

Figure 3.10. An example of a typical view
There are three major reasons that views are important.
1. They enable you to work with data from multiple tables simultaneously. (In order
for a view to do this, the tables must have connections, or relationships, to one an-
other.)
2. They enable you to prevent certain users from viewing or manipulating specific
fields within a table or group of tables. This capability can be very advantageous in
terms of security.
3. You can use them to implement data integrity. A view you use for this purpose is
known as a validation view.
You'll learn more about designing and using views in Chapter 12 , “ Views . ”