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
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
[ Previous Page | Next Page | Contents | Index ]