Construct database queries using Structured Query Language (SQL).

Construct database using phpmyadmin using MySQL. I will post questions in 3 sequential because they are related and must be functional altogether.

Part 6

16. Logically, once you have made a purchase, you will need to update the stock in hand. So, update your ITEM table. Display all in ITEM. 17. Permanently save all operations. 18. By now, you should understand transactions. All operations within a transaction should work perfectly when there is no error(s) during the operations. But say in the middle of making a purchase, but actually no payment have been done (I know we did not cater the price or payment attributes but just say) or all the sudden the power went off (say manage to insert Purchase but fail to update Item). Your data in between the tables will not tally anymore. These situations will notmake sense to the ACID properties of DBMS. Describe the ACID properties of DBMS