CREATE A DATABASE FROM PHPMYADMIN(MYSQL) FROM THE 3 QUESTIONS GIVEN. PLEASE ANSWER ALL PROPERLY THANK YOU

Construct database queries using phpMyAdmin Structured Query Language (MySQL). Answer ALL questions in the answer sheet provided. 1. Write SQL statement to create a database named myShopDB, create two tables named ITEM and PURCHASE. The description of the tables is as below: ITEM id INT NOT NULL, AUTO INCREMENT, PRIMARY KEY name VARCHAR (35) PURCHASE id INT NOT NULL, AUTO INCREMENT, PRIMARY KEY FOREIGN KEY itemID quantity INT INT Write SQL statements to insert THREE (3) new items, to alter the ITEM table. Add a new column for quantityInStock, which belongs to an integer type, to display all data in ITEM = table. Screenshot the output, to update all quantities in the ITEM table, to display all data in ITEM table and display the output and then for the backbone for the database, Start a transaction, write SQL statements to insert ONE (1) new item, to remove item ID 1% to display all data in ITEM table and display the output. And then, revert all changes. After that, write SQL statement to display all data in ITEM table and display the output and start a transaction and Write SQL statements to insert ONE (1) new item, display all data in ITEM, display the output, also look at the ID, the number skipped a few due to the ROLLBACK statement. 2. 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. 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. Permanently save all operations 3. 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 not make sense to the ACID properties of DBMS. Describe the ACID properties of DBMS