Can you please respond with the SQL code for all of the below and also display how it will look in Microsft Access.

Create in SQL a table for Suppliers that contains fields for the following data: Supplier ID, first name, last name, address, city, state, zip.Be sure to set the correct primary key.

Create in SQL a table for Products: Product ID, Product Name.Be sure to set the correct primary key.

Tie the two tables together by using a foreign key (Supplier ID) in Product Table and cascade the foreign key.

Enter the following data into the supplier table:

Supplier ID	First Name	Last Name	Address	City	Zip
SUP_001	John	Smith	Oak Ave	Mount Olive	28365
SUP_002	Bill	Williams	Chestnut St	Mount Olive	28365

Enter the following data into the product table:

Product ID	Product Name
Pro_001	Widget_1
Pro_002	Widget_2

Create a Customer table that has 2 customers and the fields CustomerID, Customer Name, Customer Phone. Be sure to set the correct primary key.

Create a Purchases table that includes 4 sample purchases (2 from each supplier and customer). Use primary and foreign keys as necessary, also use cascading.