2.38 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 2.21, 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.