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
FIGURE 2.21
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?
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.
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.