Q.PARTS

This table provides information about parts.

The columns are as follows:

SUPPNO: Number of the supplier
PARTNAME: Name of the part
PRODUCT: Product for which the part is needed
PRODNO: Number of the product
PROJNO: Number of the project

The Q.PARTS table is shown in the following figure:

Figure 1. The Q.PARTS table

SUPPNO  PARTNAME    PRODUCT      PRODNO  PROJNO
------  ----------  -----------  ------  ------
1100P   PLASTIC     RELAY            30  1501  
1100P   STEEL       WRENCHSET       509  1520  
1200S   WIRE        GENERATOR        10  1401  
1200S   BEARINGS    MOTOR            50  1402  
1300S   COPPER      RELAY            30  1501  
1300S   BLADES      SAW             205  1510  
1400P   MAGNETS     GENERATOR        10  1409  
1400P   VALVES      MOTOR            50  1407  
1400P   OIL         GEAR            160  1405