S-P-J CREATE

<--------------------------------------------------------- TABLE S ------------------------------------------------------------------------>

1)

 create table S(S# varchar2(2),SNAME varchar2(15),STATUS number(3),CITY varchar2(15));

2)

INSERT INTO S VALUES('S1', 'Smith',20,'London');
INSERT INTO S VALUES('S2', 'Jones',10,'Paris');
INSERT INTO S VALUES('S3', 'Blake',30,'Paris');
INSERT INTO S VALUES('S4', 'Clark',20,'London');
INSERT INTO S VALUES('S5', 'Adams',30,'Athens');

<--------------------------------------------------------- TABLE P ------------------------------------------------------------------------>
1)

 create table P(P# varchar2(2),PNAME varchar2(15),COLOR varchar2(15),WEIGHT number(3,1),CITY varchar2(15));

2)

INSERT INTO P VALUES('P1', 'Nut','Red',12.0,'London');
INSERT INTO P VALUES('P2', 'Bolt','Green',17.0,'Paris');
INSERT INTO P VALUES('P3', 'Screw','Blue',17.0,'Osio');
INSERT INTO P VALUES('P4', 'Screw','Red',14.0,'London');
INSERT INTO P VALUES('P5', 'Cam','Blue',12.0,'Paris');
INSERT INTO P VALUES('P6', 'Cog','Red',19.0,'London');


<--------------------------------------------------------- TABLE J ------------------------------------------------------------------------>
create table J(J# varchar2(2),JNAME varchar2(15),CITY varchar2(15));

INSERT INTO J VALUES('J1','Sorter','Paris');
INSERT INTO J VALUES('J2','Display','Rome');
INSERT INTO J VALUES('J3','OCR','Athens');
INSERT INTO J VALUES('J4','Console','Athens');
INSERT INTO J VALUES('J5','RAID','London');
INSERT INTO J VALUES('J6','EDS','Osio');
INSERT INTO J VALUES('J7','Tape','London');

<--------------------------------------------------------- TABLE SPJ ------------------------------------------------------------------------>
create table SPJ(S# varchar2(2),P# varchar2(2),J# varchar2(2),QTY number(4));



INSERT INTO customer (first_name, last_name) VALUES('', ''),('Jed', 'Tomlinson'),('Margie', 'Escobar'),('Harriette', 'Mejia'),('Francis', 'Little');


INSERT INTO SPJ (S#,P#,J#,QTY)
    SELECT 'S1', 'P1','J1',200 FROM DUAL UNION ALL
	SELECT 'S1', 'P1','J4',700 FROM DUAL UNION ALL
	SELECT 'S2', 'P3','J1',400 FROM DUAL UNION ALL
	SELECT 'S2', 'P3','J2',200 FROM DUAL UNION ALL
	SELECT 'S2', 'P3','J3',200 FROM DUAL UNION ALL
	SELECT 'S2', 'P3','J4',500 FROM DUAL;



INSERT INTO SPJ (S#,P#,J#,QTY)
	SELECT 'S2', 'P3','J5',600 FROM DUAL UNION ALL
	SELECT 'S2', 'P3','J6',400 FROM DUAL UNION ALL
	SELECT 'S2', 'P3','J7',800 FROM DUAL UNION ALL
	SELECT 'S2', 'P5','J2',100 FROM DUAL UNION ALL
	SELECT 'S3', 'P3','J1',200 FROM DUAL UNION ALL
	SELECT 'S3', 'P4','J2',500 FROM DUAL;

INSERT INTO SPJ (S#,P#,J#,QTY)
	SELECT 'S4', 'P6','J3',300 FROM DUAL UNION ALL
	SELECT 'S4', 'P6','J7',300 FROM DUAL UNION ALL
	SELECT 'S5', 'P2','J2',200 FROM DUAL UNION ALL
	SELECT 'S5', 'P2','J4',100 FROM DUAL UNION ALL
	SELECT 'S5', 'P5','J5',500 FROM DUAL UNION ALL
	SELECT 'S5', 'P5','J7',100 FROM DUAL;

INSERT INTO SPJ (S#,P#,J#,QTY)
	SELECT 'S5', 'P6','J2',200 FROM DUAL UNION ALL
	SELECT 'S5', 'P1','J4',100 FROM DUAL UNION ALL
	SELECT 'S5', 'P3','J4',200 FROM DUAL UNION ALL
	SELECT 'S5', 'P4','J4',800 FROM DUAL UNION ALL
	SELECT 'S5', 'P5','J4',400 FROM DUAL UNION ALL
	SELECT 'S5', 'P6','J4',500 FROM DUAL;