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.

Previous slide

Next slide

Back to first slide

View graphic version