The SimpleDB basic update planner assumes that the table mentioned in an update command is a stored table. Standard SQL also allows the table to be the name of a view, provided that the view is...

The SimpleDB basic update planner assumes that the table mentioned in an update command is a stored table. Standard SQL also allows the table to be the name of a view, provided that the view is updatable.

(a) Revise the update planner so that views can be updated. The planner doesn’t need to check for non-updatable views. It should just try to perform the update and throw an exception if something goes wrong. Note that you will need to modify Project Scan to implement Update Scan interface, as in Exercise 8.12.

(b) Explain what the planner would have to do to verify that the view definition was updatable.