Updating Views

How can I insert a tuple into a table that doesn’t exist?

CREATE VIEW bon-purchase AS

SELECT store, seller, product

FROM Purchase

WHERE store = ‘The Bon Marche’

If we make the following insertion:

INSERT INTO bon-purchase

VALUES (‘the Bon Marche’, Joe, ‘Denby Mug’)

We can simply add a tuple

(‘the Bon Marche’, Joe, NULL, ‘Denby Mug’)

to relation Purchase.