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

Required:
a. Identify primary and foreign keys for each table
b. Create tables using SQL.