Consider the relation Sells (bar, beer, price) and the follo…

Consider the relation Sells (bar, beer, price) and the following view that has been created to list beers sold in specific bars:   CREATE VIEW BeersView AS SELECT beer, price FROM Sells WHERE beer IN (SELECT beer FROM Sells WHERE bar = ‘Joe”s Bar’);   Why might this view not allow updates or inserts?      

Suppose we have Sells (bar, beer, price) relation and a view…

Suppose we have Sells (bar, beer, price) relation and a view is created to show all beers priced below $5:   CREATE VIEW AffordableBeers AS SELECT beer, price FROM Sells WHERE price < 5; A user attempts to insert the following record through the view:   INSERT INTO AffordableBeers (beer, price) VALUES ('Corona', 6.00); What will happen in this case?