2.40 Tech Tool: Database Software Software Videos: Database Tables, Database Table Relationships Complete the following:

1. Select an authentic enterprise of your choice. Using Microsoft Access database software, develop the following tables for the enterprise, identify appropriate fields, and select the primary keys.

2. ■ CUSTOMER table

■ SALES ORDER table

■ SALES ORDER LINE table

■ ITEM table 3. Identify the relationships between the tables as one-to-one, one-to-many, or many-to-many.

4. Use Microsoft Access database software to create the database table relationships.
S. Print the table relationships.
6. Populate the tables with at least three records of test data.