Filter
Top Products
[Table: Attributes of table columns in the inventory management data base]
Relationship between STOCK table, ORDER table, and COMPANY table
Figure: Relationship between STOCK table, ORDER table, and COMPANY table shows the relationship between the
three tables. The STOCK table and the ORDER table are joined through ITMNO and PRODNO. The ORDER table
and the COMPANY table are joined through CUSTOMER and COMPNO. For example, the product with PRODNO
123 in the STOCK table is listed as REFRIGERATOR under PRODUCT. STOCKQTY of the product is 60 and the
product is in warehouse number 1. The row for PRODNO 123 in the ORDER table provides information on PRICE and
ORDERQTY for this product, which is 48,000 and 60, respectively. Finally, COMPNO of CUSTOMER is 61. So, from
the row for COMPNO 61 in the COMPANY table, CUSTOMER for the product and COMPANY, PHONE, and
ADDRESS of the company can be ascertained.
6