Using the following purchase order for Espresso Coffee answer the
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.
Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
Relevant Tutors available to help