Using the following purchase order for EspressoCoffee, answer the following questions.1. N...

Using the following purchase order for EspressoCoffee, answer the following questions.

1. Name the database tables that EspressoCoffee should use to record its purchase transactions.

2. Identify the primary key(s) for each table that would uniquely identify each record in the table.

3. Identify the relationships among the tables as one-to-one, one-to-many, or many-to-many.

4. Identify the intersection table that should be used to remove any many-to-many relationships.

5. Identify foreign keys used to connect the tables.