Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. before you start add the following constraint to t

Before you start add the following constraint to the movies table Limit the range of...

90.2K

Verified Solution

Question

Accounting

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

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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students