to answer, refer to previous parts i posted and do them all 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 5

13. Write SQL statement to display all data in ITEM table. Screenshot the output. 14. Start a transaction. Write SQL statements to insert ONE (1) new item. Display all data in ITEM. Screenshot the output. Do look at the ID, the number skipped a few due to the ROLLBACK statement 15. Write SQL statement to buy item ID = 1. We are not doing any validations. Just make sure you are buying item that is still in stock. Display your PURCHASE table. Screenshot the output