Question
Before you start add the following constraint to the movies table Limit the range of IMBD _score form 10 to 10 You are going to
Before you start add the following constraint to the movies table Limit the range of IMBD _score form 10 to 10
You are going to create a transaction that will update the imbd_score to Movie_ID 2 and 3 to a score you are going to pass to it Increase movie_facebook_Likes by 10% Insert another movie see below
Movie to insert
Movie_id = 9999 Genres=apocalypse Movie_title = Children of Men Cast total facebooks likes 25000 Imbd_score = 10 Movie_facebook likes 1000000
Call the procedure twice. Once passing the imbd_score of 1 and the second time a score of 15
If any one of the above fails, then rollback the transaction
Can you identify the statement that failed? If so, comment the statement
Upload your code in a text document Take screenshots of success and failure
|
Automatic context help is disabled. Use the toolbar t manually get help for the current caret position or t toggle automatic help. Automatic context help is disabled. Use the toolbar t manually get help for the current caret position or t toggle automatic help
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