Filter
Top Products
ITMNO:
This column lists the code numbers assigned to the products.
PRODUCT:
This column lists the product names.
STOCKQTY:
This column lists the quantities of stock for the products.
WHCODE:
This column lists the numbers of the warehouses in which the products are stored.
ORDER table
Figure: Inventory management data base b) shows the contents of the ORDER table. The ORDER table contains the
following four columns:
CUSTOMER:
This column lists the customers' company numbers.
PRODNO:
This column lists the code numbers assigned to the products.
PRICE:
This column lists the prices of the products.
ORDERQTY:
This column lists the quantities of products ordered.
COMPANY table
Figure: Inventory management data base c) shows the contents of the COMPANY table. The COMPANY table
contains the following four columns:
COMPNO:
This column lists the code numbers assigned to the companies.
COMPANY:
This column lists the names of the companies.
PHONE:
This column lists the telephone numbers of the companies.
ADDRESS:
This column lists the addresses of the companies.
In this manual, unless otherwise stated, when the preceding table or column names are used in examples of SQL
statements, the tables and columns in Figure: Inventory management data base are specified. Refer to Figure:
Inventory management data base when necessary. Fictitious data is used in the tables in Figure: Inventory
management data base.
4