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 1

1. Write SQL statement to create a database named myShopDB. 2. Write SQL statement to 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 3. Write SQL statements to insert THREE (3) new items