Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Wiley Federal Government Auditing Laws Regulations Standards Practices And Sarbanes Oxley

Authors: Cornelius E. Tierney, Edward F. Kearney, Roldan Fernandez, Jeffrey W. Green, Kearney & Company

1st Edition

0471740489, 978-0471740483

More Books

Students also viewed these Accounting questions