Using the following purchase order for Espresso Coffee, answer the following questions.

1. Name the database tables that Espresso Coffee 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 thetables.

Transcribed Image Text:

Crente Purchae Ordes Pit - Qtmal - nd ling Hiony Or Cutomian verder Template Pree rev Te a Tradng Compay Coffe Caton Paha Dete Purchase Order ed Ja Tadng Compy he rcent Pe se ante De Cntme Amount e tct nd A a terte a 200.0 200.0 Tabe peg abrened Oed Revert