The distributor carries 41 types of sporting goods from various manufacturers. More than one manufacturer can supply an item. For example, the distributor offers racing goggles from two manufacturers and running shoes from six manufacturers.
The stock table is a catalog of the items sold by the distributor. Table 19 shows the columns of the stock table.
| Column Name | Data Type | Description |
|---|---|---|
| stock_num | SMALLINT | Stock number that identifies type of item |
| manu_code | CHAR(3) | Manufacturer code (foreign key to manufact table) |
| description | CHAR(15) | Description of item |
| unit_price | MONEY(6,2) | Unit price |
| unit | CHAR(4) | Unit by which item is ordered:
|
| unit_descr | CHAR(15) | Description of unit |