Create the CreateDynamicTripAd Stored Procedure

Assignment Help Database Management System

Reference no: EM132250982

Assignment -

Using the Colonial database, create the following Stored Procedure - CreateDynamicTripAd.

This procedure will take in a Trip Id as a parameter and perform the following:

It will return a result set with the following info

Trip Id
Trip Name
Season
Average Reservation Price
Number of Reservations
Most positive review note

Reviews are stored in a table called Trip reviews. The table contains the columns

Trip Id, rating from 1 to 5 , date of review and a review Note.

Assuming all columns are filled with data.

The procedure will also update a new table named TripAds which keeps track of the ad count generate for this trip, the trip Id and last time it was updated.

Note: For this exercise, create the following tables:

TripReviews

TripId
rating
reviewNote
dateofreview

TripAds

TripID
ad count
dateof generation

Complete the assignment Using Microsoft Server SQL Server Management Studio 17 And MySQL (php my Admin).

Attachment:- Assignment Files.rar

Reference no: EM132250982

Questions Cloud

Discuss the proposed food label changes outlined : Outline how the 5/20 rule would be applied to at least two chronic diseases. For the diseases mentioned which nutrients should be reduced or increased?

What specific examples of christian character : What specific examples of Christian character can you see in our government today? Where do you see the opposite occurring?

What is the cost of the disease to the us : In your words, explain why you believe the relationship you discovered inquestion #7 exists. Be sure to site specific reasons for your position.

Diversified company that operates in multiple markets : Altria is a diversified company that operates in multiple markets – Tobacco, Beer, Processed Food and Financial Services.

Create the CreateDynamicTripAd Stored Procedure : Using the Colonial database, create the following Stored Procedure - CreateDynamicTripAd. Assuming all columns are filled with data

Supports the needs of product layout : briefly describe how it is done and supports the needs of product layout.

Change management consultation : You have been hired as change management consultant for manufacturing company. The leadership of the company currently uses top-down management approach.

Where are the hidden calories in typical fast food menus : Where are the "hidden calories" in typical fast food menus? What options exist at fast food restaurants for making healthier choices?

Why in your opinion is this an example of misrepresentation : Give some background for context and answer; why, in your opinion is this an example of misrepresentation and why is it egregious?

User Account

All Pages