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

Tech Tool: Database Software

Software Videos: Database Tables, Database Table Relationships

EspressoCoffee asked for your assistance in building database tables to record sales transactions.

1. Using Microsoft Access database software and information in Figure, build the following database tables. Identify the primary key for each table.

---

■ Customer table

■ Sales Order table

■ Sales Order LINE table

■ Item table

2. Identify the table relationships between the Customer, Sales Order, Sales Order Line, and Item tables. Use database software to create the database table relationships.

---

3. Print the table relationships.

Figure

MS Access Sales Transaction Database Tables for EspressoCoffee

Can you imagine what the diagram of all the database tables for the entire accounting system looks like, instead of only four tables?