CREATE TABLE SPJ
(SNO CHAR(2),
PNO CHAR(2),
JNO CHAR(2),
QTY SMALLINT,
PRIMARY KEY(SN0,PNO,JNO),
FOREIGN KEY(SNO)REFERENCES S(SNO)
FOREIGN KEY(PNO)REFERENCES P(PNO)
FOREING KEY(JNO)REFERENCES J(JNO)
);
CREATE TABLE SPJ
(SNO CHAR(2),
PNO CHAR(2),
JNO CHAR(2),
QTY SMALLINT,
PRIMARY KEY(SN0,PNO,JNO),
FOREIGN KEY(SNO)REFERENCES S(SNO)
FOREIGN KEY(PNO)REFERENCES P(PNO)
FOREING KEY(JNO)REFERENCES J(JNO)
);