Product Supplier table (PRODUCTSUPPLIER)

The product supplier table describes the relationship between a product and its supplier.

The product supplier table is created with the following CREATE TABLE statement:

CREATE TABLE PRODUCTSUPPLIER
           ( PID         VARCHAR(10) NOT NULL, 
             SID         VARCHAR(10) NOT NULL, 
             PRIMARY KEY (PID, SID) )