Suppose you have two tables: Table Product:

PROD_ID	PROD_NAME	PROD_PRICE	PROD_VENDOR
1101	Table	100	2
1102	Chair	80	3
1103	Armchair	90	2
1104	Nightstand	110	1
1105	Bed	200	3
1106	Dresser	150	3
1107	Daybed	190	2

Table Vendor:

VEND_ID	VEND_NAME	VEND_ST
1	Green Way Inc	GA
2	Forrest LLC	NC
3	AmeriMart	NC

Please

1. Identify primary and foreign keys for each table
2. Create tables using SQL. Please provide your code and screenshot.
3. Insert data into the tables. Please provide SQL code and screenshot of select statements after insertion.
4. Find all products that are cheaper than or equal to $150. Please provide SQL code and the screenshot of the result.
5. Update table Products. Change the name of #1101 to Cherry Table. Please provide SQL code and screenshot of select statement after updating