Each part should have screenshot and SQL code

Part 1: Identify primary and foreign keys. Create tables. Do not forget about primary and foreign keys. Provide SQL code and screenshot of DESC statements.

Part 2: Insert data. Provide SQL code and screenshot of select statements.

Part 3: Suppose you wanted quick lookup capability to get a listing of all products supplied by a given vendor. Which table would be the basis for the INDEX table, and what would be the index key? Create the index. Provide SQL code.

Suppose you have two tables: Table Product: PROD ID PROD NAME PROD PRICE PROD PROD DATE PROD VENDOR 1101 Table 1102 Chair 1103 Armchair 1104 | Nightstand 1105 Bed 1106 Dresser 1107 Daybed 100 80 90 110 200 150 190 1-Jan-18 3-Mar-18 6-May-18 4-Apr-18 3-Mar-18 5-May-18 10-Feb-18 2 2 2 Table Vendor VEND ID VEND NAME VEND ST 1 Green Way IncGA 2 Forrest LLC 3 AmeriMart NC NC