Question: Create a table Top 5 Restaurants restaurants in the database as: Create table Top 5 Restaurants ( rID int ) Top 5 Restaurants holds the
Create a table TopRestaurants restaurants in the database as:
Create table TopRestaurantsrID int
TopRestaurants holds the rIDs of top restaurants in Chicago. Write a statement or rowlevel trigger on the Rating table that computes top restaurants and populates the TopRestaurants table. This trigger is fired every time a restaurant receives a new rating. Test your procedure and trigger in SQL Developer to insert the following four strings:
Jade CourtSarah M
Shanghai TerraceCameron J
RangoliVivek T
Shanghai InnAudrey M;
CuminCameron J
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
