Question: Consider a materialized view create materialized view Vas select name from Student where name in (select name from Registers where course = Database Systems-I') on

 Consider a materialized view create materialized view Vas select name from

Consider a materialized view create materialized view Vas select name from Student where name in (select name from Registers where course = Database Systems-I') on the following tables: Student(name,regno,contactno) Registers(name,course, semester) For each of the following modifications, would it cause a change to V? i. update to Student.contactno ii. deletion from Registers iii. update to Registers.semester iv. insertion into Student v. update to Registers.course

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!