Chapter 7, Problem 43E

Program Plan Intro

 Materialized view:

• Materialized view is a database object that contains the result of a query.
• It is mainly used for increasing application performance.
• It is used for replicating data and to cache expensive queries in a data warehouse environment.

</PROGRAM-PLAN-INNTRO>

 Constraints on materialized views enforcing functional dependency:

• The constraints on materialized view helps for increasing execution speed.
• Materialized view is refreshed by the type of materialized view.
• The constraints under materialized view should be normalized.
• That means each dimension should be contained in one table.
• Also, the joins between tables must be normalized or partially normalized.
• Hence, there is a guarantee that each child side row joins with exactly one parent side row.
• Hence, constraints on materialized view can be used for enforcing functional dependency.