Home | Previous Page | Next Page   Appendix A. The stores_demo Database >

The stores_demo Database Map

Figure 6 displays the joins in the stores_demo database. The gray shading that connects a column in one table to a column with the same name in another table indicates the relationships, or joins, between tables.

Figure 6. Joins in the stores_demo Database
begin figure description -- This figure shows join columns among the nine tables in the stores_demo database. The call_type table is joined to the cust_calls table by the call_code column in both tables. The cust_calls table is also joined to both the customer table and to the orders table by the customer_num column in all three tables. The customer table is also joined to the state table by the state column of the customer table, which joins to the code column of the state table. The orders table is also joined to the items table by the order_num column in both tables. The items table is also joined to both the stock table and to the catalog table by the stock_num column and by the manu_code column in all three tables, which also join the stock table to the catalog table. The manufact table is joined to the items table, to the stock table, and to the catalog table by the manu_code column in all four tables. -- end figure description
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]