Given the purchases Database with the four tables below, complete the next tables. 

Customer Table
Primary Key
Candidate Keys
Foreign Keys
Non-key columns

Item Table
Primary Key
Candidate Keys
Foreign Keys
Non-key columns

Purchase Table
Primary Key
Candidate Keys
Foreign Keys
Non-key columns

Purchase_Item Table
Primary Key
Candidate Keys
Foreign Keys
Non-key columns

1 Stanley CUSTOMER CustomerID LastName FirstName Phone Elizabeth 555-236-7789 Elizabeth.Stanley@somewhere.com Email 2 Price Fred 3 Becky Linda 555-236-0091 555-236-0392 Linda.Becky@somewhere.com Fred.Price@somewhere.com 4 Birch Pamela 555-236-4493 Pamela.Birch@somewhere.com 5 6 Romez Ricardo Jackson Samantha 555-236-1095 Samantha. Jackson@somewhere.com 555-236-3334 Ricardo.Romez@somewhere.com