Consider the relations Sells (bar, beer,price) and Beers (na…

Consider the relations Sells (bar, beer,price) and Beers (name, manf) 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 name FROM Beers WHERE manf = ‘Anheuser-Busch’);   Is this view updatable?       

Consider two tables, Sells and Beers, with the following sch…

Consider two tables, Sells and Beers, with the following schema:   CREATE TABLE Beers (    name VARCHAR(50) PRIMARY KEY,    manf VARCHAR(50));   CREATE TABLE Sells (    bar VARCHAR(50),    beer VARCHAR(50),    price DECIMAL(5,2),    FOREIGN KEY (beer) REFERENCES Beers(name));   What happens if the following INSERT statement is executed? INSERT INTO Beers(name, manf) VALUES (‘Bud Light’, ‘Anheuser’);