Tech Tool: Database SoftwareSoftware Videos: Database Tables, Database Table Relationships...

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.

5. Build the relationships among the tables and print.