Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started