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.
5. Print the table relationships.
6. Populate the tables with at least three records of test data.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.