2.42 Tech Tool: Database Software Software Videos: Database Tables, Database Table Relationships EspressoCoffee has asked for your assistance in building database tables to record purchase transactions. Use the following EspressoCoffee purchase order and MS Access database software to complete the following .

1. Build the database tables for EspressoCoffee purchase transactions. (Hint: You should have four tables.)
2. Enter the fields you think appropriate for each database table.
3. Select the primary key(s) for each database table.
4. Remove any many-to-many relationships using intersection tables.
S. Build the relationships among the tables and print.

Create Purchase Orders Previous Next Save Print E-mail Vendor Class Ship To Coffee B... EspressoBar Java Trading Company Purchase Order Venda Java Trading Company Find Spelling History Customize Template Print Preview Custom Purchase O... 0.0. No. Date 07/13/2014 62381 Ship To ExpressoBar Vincent Pico 58 Dente 43001 Pisa, Tuscany Item ARQ1 Description Qey Rate Customer UM Amount Revd Ced Pure Arabica from Colombia 4 and Africa 49.99992 Espressoar 200.000 Vendor 4 cases To be printed To be emailed Closed Total 200.00 Save & Close Save & New Revert