MYSQL QUESTION

! Exercise 8.5.3: This exercise explores materialized views that are based on aggregation of data. Suppose we build a materialized view on the base tables Classes (class, type, country, numGuns, bore, displacement) Ships (name, class, launched) from our running battleships exercise, as follows: CREATE MATERIALIZED VIEW ShipStats AS SELECT country, AVG(displacement), cOUNT (*) FROM Classes, Ships WHERE Classes.class = Ships.class GROUP BY country; 366 CHAPTER 8. VIEWS AND INDEXES What modifications to the base tables Classes and Ships would require a modification of the materialized view? How would you implement those modi- fications incrementally? ! Exercise 8.5.3: This exercise explores materialized views that are based on aggregation of data. Suppose we build a materialized view on the base tables Classes (class, type, country, numGuns, bore, displacement) Ships (name, class, launched) from our running battleships exercise, as follows: CREATE MATERIALIZED VIEW ShipStats AS SELECT country, AVG(displacement), cOUNT (*) FROM Classes, Ships WHERE Classes.class = Ships.class GROUP BY country; 366 CHAPTER 8. VIEWS AND INDEXES What modifications to the base tables Classes and Ships would require a modification of the materialized view? How would you implement those modi- fications incrementally