Given the following two tables, Product & Category, respectively:

Product ID Product Name Category ID Color ID

$1$ Green Tea $13$

$2$ Matcha $13$

$3$ Americano $21$

Category ID Category Name

$1$ Tea

$2$ Coffee

$3$ Water

a$)$ identify the primary key in each table

b$)$ identify the foreign key

c$)$ create outline notations for each table

d$)$ Create entity$-$ relationship diagram

Please answer the parts.