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 Beer table had a record of Bud Light and the following Delete statement is executed? Delete from Sells Where beer = ‘ Bud Light’
Read Details