Question

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.


$1.99
Sales0
Views135
Comments0
  • CreatedFebruary 20, 2015
  • Files Included
Post your question
5000