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?    

Suppose we have two relations Sells (bar, beer, price) Beers…

Suppose we have two relations Sells (bar, beer, price) Beers (name, manf) And the Sells table includes a foreign key constraint on beer, referencing the Beers table. The foreign key is defined as: FOREIGN KEY (beer) REFERENCES Beers (name) ON DELETE SET NULL ON UPDATE CASCADE; What happens when a record in the Sells table with beer =’Budweiser’ is updated to beer =’Bud Light’? Assuming we have a record in the Beers relation with name =’Budweiser’