Images

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. ...

Get Database Design for Mere Mortals: 25th Anniversary Edition, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.