(See related pages)
This chapter describes underlying concepts for views and demonstrates usage of views in forms and reports. After this chapter, the student should have acquired the following knowledge and skills:
|
|
|
Write CREATE VIEW statements. |
|
|
|
Write queries that use views. |
|
|
|
Understand basic ideas about the modification and materialization approaches for processing queries with views. |
|
|
|
Apply rules to determine if single-table and multiple-table views are updatable. |
|
|
|
Determine data requirements for hierarchical forms. |
|
|
|
Write queries that provide data for hierarchical forms. |
|
|
|
Formulate queries that provide input for hierarchical reports. |