The structure of the view will decide if it is updatable or not. The manuals talk about "key preserved . . . "

I think of it as: If I can write an update such that ONE row of ONE table is updated, then that update is allowed and can be generalised to many rows. (Is that a ROT? Is there a flaw it it?)