A teacher sends her students on a treasure hunt. She gives t…

A teacher sends her students on a treasure hunt. She gives the following instructions: 1. f6g1q27g1.gifWalk 300 m north 2. f6g1q27g2.gifWalk 400 m northwest (450 North of West)3. f6g1q27g3.gifWalk 700 m east-southeast (22.50 South of East)  and the treasure is buried there. As all the other students walk off following the instructions, Joe physics student quickly adds the displacements and walks in a straight line to find the treasure. How far and in what direction does Joe need to walk?

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?    

Given this trigger:  CREATE TRIGGER RoundPriceBEFORE INSERT…

Given this trigger:  CREATE TRIGGER RoundPriceBEFORE INSERT ON SellsFOR EACH ROWSET NEW.price = ROUND(NEW.price);     A User attempts to execute the following statement on Sells (Bar, Beer, Price):     INSERT INTO Sells (bar, beer, price) VALUES (‘Joe”s Bar’, ‘Corona’, 4.75); What will happen to the price value inserted into the Sells table?