Murach's MySQL 3. Write a script that creates and calls a stored procedure named test. This procedure should use a transaction that includes the statements necessary to combine two musicians. These statements should do the following: Select a row from the Musicians table for the musician with a musician_id value of 6. This statement should lock the row so other transactions can’t read or modify it until the transaction commits, and it should fail immediately if the row is locked from another session. Update the Orders table so any orders for the selected musician are assigned to the musician with a musician_id value of 3. Update the Addresses table so any addresses for the selected musician are assigned to the musician with a musician_id value of 3. Delete the selected musician from the Musicians table. If these statements execute successfully, commit the changes. Otherwise, rollback the changes

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Murach's MySQL

3. Write a script that creates and calls a stored procedure named test. This procedure

should use a transaction that includes the statements necessary to combine two

musicians. These statements should do the following:

Select a row from the Musicians table for the musician with a musician_id value of 6.

This statement should lock the row so other transactions can’t read or modify it until

the transaction commits, and it should fail immediately if the row is locked from

another session.

Update the Orders table so any orders for the selected musician are assigned to the

musician with a musician_id value of 3.

Update the Addresses table so any addresses for the selected musician are assigned to

the musician with a musician_id value of 3.

Delete the selected musician from the Musicians table.

If these statements execute successfully, commit the changes. Otherwise, rollback the

changes.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education