Given relations Movies(title, year, length, genre. studioName. producer#). MovieExec(name. address. cert#). and Studio(name. address. presC#). Suppose we have the materialized view that finds the name -
ofthe producer of a given movie as follows:CREATE MATERIALIZED VIEW MovieProd AS
SELECT title, year, name
FROM Movies. MovieExec
WHERE producer# - cert#
Which of the following modification will affect the MovieProd materialized view?
[A]
Insert a new tuple into Studio
[B]
Delete a tuple from Studio
[C]
Insert a new tuple into Movies or delete a tuple from Movies
[D]
None of the others
Answer: C