Database Design for Mere Mortals: 25th Anniversary Edition, 4th Edition

12

Views

There is no object on earth which cannot be looked at from a cosmic point of view.

—FYODOR MIKHAYLOVICH DOSTOYEVSKY

Topics Covered in This Chapter

What Are Views?

Anatomy of a View

Determining and Defining Views

Example: Determining and Defining Views

Summary

Review Questions

What Are Views?

As you learned in Chapter 3, “Terminology,” a view is a virtual table composed of fields from one or more tables in the database; it can also include fields from other views. The tables that comprise a given view are known as the view’s base tables. A view is “virtual” because it draws data from base tables rather than storing data on its own. ...