Chapter 12

  1. You can refer to a view as a virtual table because it draws data from base tables rather than storing data on its own.

  2. Views are valuable for the following reasons:

    a. You can use them to work with data from multiple tables simultaneously.

    b. They reflect the most current information.

    c. You can customize them to the specific needs of an individual or group of individuals.

    d. You can use them to help enforce data integrity.

    e. You can use them for security or confidentiality purposes.

  3. The types of views you can define as you design the logical structure of the database are data, aggregate, and validation.

  4. Each time you access a view, your RDBMS will rebuild and repopulate it using the most current data from the view's base tables. ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.