Introduction to Modern Databases/

...

/

Practice Exercises on ACID

Practice Exercises on ACID

Test your understanding of this module with a few practice exercises.

We'll cover the following...

Problem 1

A new supplier, ‘Gadget Innovators’, needs to be added. Write a single transaction to insert ‘Gadget Innovators’ into the Suppliers table and then link this new supplier to the ‘Smartphone’ (ProductID = 2) in the Product_Suppliers table.

MySQL 8.0
-- write your code here

Problem 2

A customer wants to order a ‘Laptop’ (ProductID = 1) and a ‘Smartphone’ ( ...