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 don’t have a record in the Beers relation with name =’Bud light’
Read Details