Filter
Top Products
Column attributes of each table of the inventory management database
Table: Column attributes of each table of the inventory management database shows the column attributes of each
table.
[Table: Column attributes of each table of the inventory management database]
Relationships among the STOCK table, ORDER table, and COMPANY table
Figure: Relationships among the STOCK table, ORDER table, and COMPANY table shows the relationships among
the three tables. The STOCK table and ORDER table are related according to ITMNO and PRODNO. In addition, the
ORDER table and COMPANY table are related according to CUSTOMER and COMPNO. For example, the product
having ITMNO 123 in the STOCK table is the PRODUCT named REFRIGERATOR. Further, the STOCKQTY is 60,
and the number of the warehouse in which this product is stored is 1. From the row of the ORDER table in which
PRODNO is 123, the PRICE and ORDERQTY of this product are 48000 and 60, respectively. Moreover, since the
company number of the CUSTOMER is 61, the following data can be gleaned from the COMPANY table row in which
COMPNO is 61. Users can learn the company name, telephone number, and address of the CUSTOMER of that
product.
20