Filter
Top Products
STOCK table:
Contains information about products handled and quantities of those products in stock
ORDER table:
Contains information related to products, quantities ordered, and purchase prices for each customer.
COMPANY table:
Contains information about company names, telephone numbers, and addresses for each customer
The usage examples use the inventory management database mainly to explain database creation and data
manipulations. The table and column names above are used in usage examples throughout the remainder of the
section. Refer to them as necessary.
STOCK table
Figure: Contents of the inventory management database a) shows the contents of the STOCK table, which consists of
these four columns:
ITMNO:
Column of code number data assigned to products
PRODUCT:
Column of product type data
STOCKQTY:
Column of data indicating the quantity of the product in stock
WHCODE:
Column of number data for warehouses where the products are stored
ORDER table
Figure: Contents of the inventory management database b) shows the contents of the ORDER table, which consists of
these four columns:
CUSTOMER:
Column of company number data for customers
PRODNO:
Column of code numbers assigned to products (corresponds to the ITMNO column of the STOCK table)
PRICE:
Column of data indicating product purchase prices
ORDERQTY:
Column of data indicating quantities of products ordered
COMPANY table
Figure: Contents of the inventory management database c) shows the contents of the COMPANY table, which
consists of these four columns:
COMPNO:
Column of code number data assigned to companies (corresponds to the CUSTOMER column of the ORDER
table)
COMPANY:
Column of company name data
PHONE:
Column of company telephone number data
ADDRESS:
Column of company address data
17