Site MapHelpFeedbackApplication Development with Views
Application Development with Views


Chapters 3, 4, and 9 provided the foundation for understanding relational databases and formulating queries in SQL. Most importantly, you gained practice with a large number of examples, acquired problem-solving skills for query formulation, and learned different parts of SQL. This chapter shows you how to apply your query formulation skills to building applications with views.

This chapter emphasizes views as the foundation for building database applications. Before discussing the link between views and database applications, essential background is provided. You will learn the motivation for views, the CREATE VIEW statement, and usage of views in SELECT and data manipulation (INSERT, UPDATE, and DELETE) statements. Most view examples in Sections 10.2 and 10.3 are supported in Microsoft Access as stored queries and in Oracle as views. After this background, you will learn to use views for hierarchical forms and reports. You will learn the steps for analyzing data requirements culminating in views to support the data requirements.

The presentation in Sections 10.1 and 10.2 covers features in Core SQL:2003 that were part of SQL-92. Some of the features of updatable views in Sections 10.3 and 10.4 are specific to Microsoft Access due to the varying support among DBMSs and the strong support available in Access.








To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 10