CREATE TABLE S(SNO VARCHAR(5) NOT NULL,SNAME VARCHAR(20) NOT NULL,STATUS VARCHAR(5),CITY VARCHAR(20),PRIMARY KEY(SNO);CREATE TABLE P(PNO VARCHAR(5),PNAME VARCHAR(20),COLOR VARCHAR(10),WEIGHT SMALLINT,PRIMARY KEY(PNO);CREATE TABLE J(JNO VARCHAR(5),JNAME VARCHAR(20),CITY VARCHAR(20),PRIMARY KEY(JNO);CREATE TABLE SPJ(SNO VARCHAR(5) NOT NULL,PNO VARCHAR(5),JNO VARCHAR(5),QTY VARCHAR(10),PRIMARY KEY(SNO,PNO,JNO),FOREIGN KEY(SNO)REFERENCE