View updating and relational theory v413hav
That means they should be updatable, just as "real" or base tables are.
In fact, view updatability isn’t just desirable, it’s crucial, for practical reasons as well as theoretical ones.
First I need to say something about the structure of the chapter.
Let be a set of base relvars and a set of views, respectively.
It could be made more obvious why the choice of which relations are base and which are not matters.
The proposed scheme is 100% consistent with the relational model, but rather different from the way updating works in SQL products today. This Learning Path will give you a deep and thorough understanding of SQL and relational databases.