INSERT INTO j VALUES ('J1','Жесткий диск','Париж');
INSERT INTO j VALUES ('J2','Перфоратор','Рим');
INSERT INTO j VALUES ('J3','Cчитыватель','Афины');
INSERT INTO j VALUES ('J4','Принтер','Афины');
INSERT INTO j VALUES ('J5','Флоппи-диск','Лондон');
INSERT INTO j VALUES ('J6','Терминал','Осло');
INSERT INTO j VALUES ('J7','Лента','Лондон');

------------- ТАБЛИЦА P – Детали (Piece)
INSERT INTO p VALUES ('P1','Гайка','Красный',12,'Лондон');
INSERT INTO p VALUES ('P2','Болт','Зеленый',17,'Париж ');
INSERT INTO p VALUES ('P3','Винт','Голубой',17,'Рим');
INSERT INTO p VALUES ('P4','Винт','Красный',14,'Лондон');
INSERT INTO p VALUES ('P5','Кулачок','Голубой',12,'Париж ');
INSERT INTO p VALUES ('P6','Блюм','Красный',19,'Лондон');

------------- ТАБЛИЦА S – Поставщики (Suppliers)
INSERT INTO s VALUES('S1','Cмит ',20,'Лондон');
INSERT INTO s VALUES ('S2','Джонс',10,'Париж ');
INSERT INTO s VALUES ('S3','Блейк',30,'Париж ');
INSERT INTO s VALUES ('S4','Кларк',20,'Лондон');
INSERT INTO s VALUES ('S5','Адамс',30,'Афины ');

------------- ТАБЛИЦА SPJ1 – Поставки (Supply)
INSERT INTO SPJ1 VALUES ('N1','S2','P3','J4',500,to_date('06-02-2011','dd-mm-yyyy'),15);
INSERT INTO SPJ1 VALUES ('N2','S1','P1','J1',200,to_date('09-02-2011','dd-mm-yyyy'),7);
INSERT INTO SPJ1 VALUES ('N3','S2','P3','J5',600,to_date('10-02-2011','dd-mm-yyyy'),15);
INSERT INTO SPJ1 VALUES ('N4','S2','P3','J6',400,to_date('18-02-2011','dd-mm-yyyy'),16);
INSERT INTO SPJ1 VALUES ('N5','S2','P3','J1',400,to_date('01-02-2011','dd-mm-yyyy'),15);
INSERT INTO SPJ1 VALUES ('N6','S2','P3','J2',200,to_date('28-02-2011','dd-mm-yyyy'),15);
INSERT INTO SPJ1 VALUES ('N7','S2','P3','J7',800,to_date('28-02-2011','dd-mm-yyyy'),16);
INSERT INTO SPJ1 VALUES ('N8','S2','P3','J3',200,to_date('28-02-2011','dd-mm-yyyy'),15);
INSERT INTO SPJ1 VALUES ('N9','S2','P5','J2',100,to_date('02-03-2011','dd-mm-yyyy'),9);
INSERT INTO SPJ1 VALUES ('N10','S3','P4','J2',500,to_date('03-03-2011','dd-mm-yyyy'),4);
INSERT INTO SPJ1 VALUES ('N11','S4','P6','J3',300,to_date('10-03-2011','dd-mm-yyyy'),13);
INSERT INTO SPJ1 VALUES ('N12','S1','P1','J4',700,to_date('16-03-2011','dd-mm-yyyy'),7);
INSERT INTO SPJ1 VALUES ('N13','S4','P6','J7',300,to_date('18-03-2011','dd-mm-yyyy'),13);
INSERT INTO SPJ1 VALUES ('N14','S5','P2','J2',200,to_date('26-03-2011','dd-mm-yyyy'),6);
INSERT INTO SPJ1 VALUES ('N15','S5','P5','J5',500,to_date('04-04-2011','dd-mm-yyyy'),9);
INSERT INTO SPJ1 VALUES ('N16','S5','P5','J7',100,to_date('12-04-2011','dd-mm-yyyy'),10);
INSERT INTO SPJ1 VALUES ('N17','S5','P6','J2',200,to_date('15-04-2011','dd-mm-yyyy'),14);
INSERT INTO SPJ1 VALUES ('N18','S5','P4','J4',800,to_date('04-05-2011','dd-mm-yyyy'),5);
INSERT INTO SPJ1 VALUES ('N19','S5','P5','J4',400,to_date('10-05-2011','dd-mm-yyyy'),10);
INSERT INTO SPJ1 VALUES ('N20','S5','P6','J4',500,to_date('16-05-2011','dd-mm-yyyy'),14);
INSERT INTO SPJ1 VALUES ('N21','S3','P3','J1',100,to_date('19-05-2011','dd-mm-yyyy'),16);
INSERT INTO SPJ1 VALUES ('N22','S3','P1','J1',300,to_date('21-05-2011','dd-mm-yyyy'),16);
INSERT INTO SPJ1 VALUES ('N23','S1','P1','J1',200,to_date('22-05-2011','dd-mm-yyyy'),7);
INSERT INTO SPJ1 VALUES ('N24','S1','P1','J4',700,to_date('26-05-2011','dd-mm-yyyy'),8);
INSERT INTO SPJ1 VALUES ('N25','S5','P2','J4',100,to_date('31-05-2011','dd-mm-yyyy'),6);
INSERT INTO SPJ1 VALUES ('N26','S2','P3','J1',400,to_date('02-06-2011','dd-mm-yyyy'),15);
INSERT INTO SPJ1 VALUES ('N27','S2','P3','J2',200,to_date('06-06-2011','dd-mm-yyyy'),16);
INSERT INTO SPJ1 VALUES ('N28','S2','P3','J4',500,to_date('17-06-2011','dd-mm-yyyy'),16);
INSERT INTO SPJ1 VALUES ('N29','S2','P3','J5',750,to_date('25-06-2011','dd-mm-yyyy'),16);
INSERT INTO SPJ1 VALUES ('N30','S5','P3','J3',200,to_date('01-07-2011','dd-mm-yyyy'),16);
INSERT INTO SPJ1 VALUES ('N31','S2','P5','J2',300,to_date('06-07-2011','dd-mm-yyyy'),9);
INSERT INTO SPJ1 VALUES ('N32','S3','P5','J2',500,to_date('08-07-2011','dd-mm-yyyy'),4);
INSERT INTO SPJ1 VALUES ('N33','S5','P2','J2',200,to_date('19-07-2011','dd-mm-yyyy'),6);
INSERT INTO SPJ1 VALUES ('N34','S3','P4','J2',200,to_date('25-07-2011','dd-mm-yyyy'),5);
INSERT INTO SPJ1 VALUES ('N35','S5','P2','J4',100,to_date('26-07-2011','dd-mm-yyyy'),6);
INSERT INTO SPJ1 VALUES ('N36','S5','P5','J5',600,to_date('27-07-2011','dd-mm-yyyy'),10);
INSERT INTO SPJ1 VALUES ('N37','S5','P1','J4',100,to_date('07-08-2011','dd-mm-yyyy'),9);
INSERT INTO SPJ1 VALUES ('N38','S5','P3','J4',200,to_date('09-08-2011','dd-mm-yyyy'),14);
INSERT INTO SPJ1 VALUES ('N39','S5','P4','J4',800,to_date('14-08-2011','dd-mm-yyyy'),5);
INSERT INTO SPJ1 VALUES ('N40','S5','P5','J4',400,to_date('15-08-2011','dd-mm-yyyy'),11);
INSERT INTO SPJ1 VALUES ('N41','S5','P6','J4',500,to_date('16-08-2011','dd-mm-yyyy'),13);
INSERT INTO SPJ1 VALUES ('N42','S2','P3','J7',1000,to_date('04-10-2011','dd-mm-yyyy'),17);
INSERT INTO SPJ1 VALUES ('N43','S2','P5','J7',50,to_date('04-10-2011','dd-mm-yyyy'),10);
INSERT INTO SPJ1 VALUES ('N44','S4','P6','J7',150,to_date('04-10-2011','dd-mm-yyyy'),12);
INSERT INTO SPJ1 VALUES ('N45','S2','P3','J3',450,to_date('10-01-2012','dd-mm-yyyy'),18);
INSERT INTO SPJ1 VALUES ('N46','S5','P1','J4',100,to_date('20-01-2012','dd-mm-yyyy'),8);
INSERT INTO SPJ1 VALUES ('N47','S4','P6','J7',700,to_date('17-02-2012','dd-mm-yyyy'),13);
INSERT INTO SPJ1 VALUES ('N48','S5','P4','J2',200,to_date('05-03-2012','dd-mm-yyyy'),6);
INSERT INTO SPJ1 VALUES ('N49','S2','P3','J6',700,to_date('02-04-2012','dd-mm-yyyy'),17);
INSERT INTO SPJ1 VALUES ('N50','S5','P5','J7',400,to_date('04-04-2012','dd-mm-yyyy'),11);
INSERT INTO SPJ1 VALUES ('N51','S5','P3','J4',200,to_date('29-04-2012','dd-mm-yyyy'),14);
INSERT INTO SPJ1 VALUES ('N52','S1','P2','J4',200,to_date('10-05-2012','dd-mm-yyyy'),8);
INSERT INTO SPJ1 VALUES ('N53','S4','P6','J3',600,to_date('12-07-2012','dd-mm-yyyy'),13);

------------- ТАБЛИЦА C – Заказчики (Client)
INSERT INTO c VALUES ('C1','Купер','Лондон ',7);
INSERT INTO C VALUES ('C2','Росси','Рим ',3);
INSERT INTO C VALUES ('C3','Эспозито','Рим ',0);
INSERT INTO C VALUES ('C4','Перакис ','Афины',5);
INSERT INTO C VALUES ('C5','Cвен ','Осло',10);
INSERT INTO C VALUES ('C6','Фишер','Берлин ',3);

------------- ТАБЛИЦА Q – Норма расхода деталей на одно изделие 
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J4','P5',2,'Q1');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J4','P2',1,'Q2');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J4','P6',2,'Q3');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J5','P3',4,'Q4');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J5','P5',3,'Q5');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J6','P3',6,'Q6');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J7','P3',5,'Q7');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J7','P6',3,'Q9');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J7','P5',1,'Q8');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J1','P1',3,'Q10');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J1','P3',4,'Q11');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J2','P2',5,'Q12');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J2','P3',2,'Q13');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J2','P4',9,'Q14');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J2','P5',4,'Q15');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J2','P6',2,'Q16');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J3','P3',4,'Q17');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J3','P6',3,'Q18');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J4','P1',6,'Q19');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J4','P3',1,'Q20');
INSERT INTO q (N_IZD,N_DET,KOL,N_Q) VALUES ('J4','P4',3,'Q21');

------------- ТАБЛИЦА W – Выпуск изделий (Working) 
 insert into W values ('W1','J1',to_date('02-03-2011','dd-mm-yyyy'),40);
 insert into W values ('W2','J6',to_date('07-03-2011','dd-mm-yyyy'),35);
 insert into W values ('W3','J1',to_date('10-03-2011','dd-mm-yyyy'),20);
 insert into W values ('W4','J6',to_date('15-03-2011','dd-mm-yyyy'),30);
 insert into W values ('W5','J3',to_date('09-04-2011','dd-mm-yyyy'),25);
 insert into W values ('W6','J3',to_date('17-04-2011','dd-mm-yyyy'),20);
 insert into W values ('W7','J7',to_date('19-04-2011','dd-mm-yyyy'),75);
 insert into W values ('W8','J2',to_date('25-04-2011','dd-mm-yyyy'),20);
 insert into W values ('W9','J7',to_date('28-04-2011','dd-mm-yyyy'),25);
 insert into W values ('W10','J5',to_date('13-05-2011','dd-mm-yyyy'),40);
 insert into W values ('W11','J1',to_date('15-06-2011','dd-mm-yyyy'),30);
 insert into W values ('W12','J4',to_date('26-06-2011','dd-mm-yyyy'),40);
 insert into W values ('W13','J1',to_date('03-07-2011','dd-mm-yyyy'),60);
 insert into W values ('W14','J3',to_date('10-07-2011','dd-mm-yyyy'),40);
 insert into W values ('W15','J2',to_date('15-07-2011','dd-mm-yyyy'),10);
 insert into W values ('W16','J5',to_date('23-07-2011','dd-mm-yyyy'),75);
 insert into W values ('W17','J4',to_date('03-08-2011','dd-mm-yyyy'),60);
 insert into W values ('W18','J5',to_date('21-08-2011','dd-mm-yyyy'),50);
 insert into W values ('W19','J4',to_date('16-09-2011','dd-mm-yyyy'),100);
 insert into W values ('W20','J7',to_date('31-10-2011','dd-mm-yyyy'),50);
 insert into W values ('W21','J3',to_date('17-01-2012','dd-mm-yyyy'),10);
 insert into W values ('W22','J5',to_date('24-01-2012','dd-mm-yyyy'),130);
 insert into W values ('W23','J1',to_date('21-02-2012','dd-mm-yyyy'),25);
 insert into W values ('W24','J5',to_date('19-03-2012','dd-mm-yyyy'),40);
 insert into W values ('W25','J6',to_date('12-04-2012','dd-mm-yyyy'),90);
 insert into W values ('W26','J7',to_date('27-04-2012','dd-mm-yyyy'),200);
 insert into W values ('W27','J2',to_date('06-05-2012','dd-mm-yyyy'),30);
 insert into W values ('W28','J4',to_date('18-05-2012','dd-mm-yyyy'),60);
 insert into W values ('W29','J3',to_date('01-08-2012','dd-mm-yyyy'),100);
 insert into W values ('W30','J1',to_date('20-08-2012','dd-mm-yyyy'),50);
 insert into W values ('W31','J6',to_date('25-08-2012','dd-mm-yyyy'),25);

------------- ТАБЛИЦА Е – Издержки на производство 
insert into e values ('E1','J1',to_date('2011-01-01','YYYY-MM-DD'),190);
insert into e values ('E2','J1',to_date('2011-05-01','YYYY-MM-DD'),195);
insert into e values ('E3','J2',to_date('2011-04-01','YYYY-MM-DD'),220);
insert into e values ('E4','J3',to_date('2011-03-01','YYYY-MM-DD'),100);
insert into e values ('E5','J4',to_date('2011-06-01','YYYY-MM-DD'),130);
insert into e values ('E6','J4',to_date('2011-09-01','YYYY-MM-DD'),140);
insert into e values ('E7','J5',to_date('2011-05-01','YYYY-MM-DD'),85);
insert into e values ('E8','J5',to_date('2011-07-01','YYYY-MM-DD'),90);
insert into e values ('E9','J5',to_date('2011-08-01','YYYY-MM-DD'),95);
insert into e values ('E10','J6',to_date('2011-03-01','YYYY-MM-DD'),95);
insert into e values ('E11','J6',to_date('2011-07-01','YYYY-MM-DD'),105);
insert into e values ('E12','J7',to_date('2011-04-01','YYYY-MM-DD'),130);
insert into e values ('E13','J7',to_date('2011-08-01','YYYY-MM-DD'),135);

------------- ТАБЛИЦА V – Рекомендованная цена 
 insert into v values ('V1','J1',to_date('01-01-2011','dd-mm-yyyy'),280);
 insert into v values ('V2','J2',to_date('01-01-2011','dd-mm-yyyy'),420);
 insert into v values ('V3','J3',to_date('01-01-2011','dd-mm-yyyy'),300);
 insert into v values ('V4','J4',to_date('01-01-2011','dd-mm-yyyy'),330);
 insert into v values ('V5','J5',to_date('01-01-2011','dd-mm-yyyy'),290);
 insert into v values ('V6','J6',to_date('01-01-2011','dd-mm-yyyy'),295);
 insert into v values ('V7','J7',to_date('01-01-2011','dd-mm-yyyy'),330);
 insert into v values ('V8','J1',to_date('01-05-2011','dd-mm-yyyy'),300);
 insert into v values ('V9','J2',to_date('01-05-2011','dd-mm-yyyy'),440);
 insert into v values ('V10','J3',to_date('01-05-2011','dd-mm-yyyy'),295);
 insert into v values ('V11','J4',to_date('01-05-2011','dd-mm-yyyy'),440);
 insert into v values ('V12','J5',to_date('01-05-2011','dd-mm-yyyy'),285);
 insert into v values ('V13','J6',to_date('01-05-2011','dd-mm-yyyy'),305);
 insert into v values ('V14','J7',to_date('01-05-2011','dd-mm-yyyy'),350);
 insert into v values ('V15','J1',to_date('01-11-2011','dd-mm-yyyy'),360);
 insert into v values ('V16','J2',to_date('01-11-2011','dd-mm-yyyy'),500);
 insert into v values ('V17','J3',to_date('01-11-2011','dd-mm-yyyy'),350);
 insert into v values ('V18','J4',to_date('01-11-2011','dd-mm-yyyy'),510);
 insert into v values ('V19','J5',to_date('01-11-2011','dd-mm-yyyy'),340);
 insert into v values ('V20','J6',to_date('01-11-2011','dd-mm-yyyy'),360);
 insert into v values ('V21','J7',to_date('01-11-2011','dd-mm-yyyy'),420);

------------- ТАБЛИЦА R –Заказы 
 insert into r values ('R1','J1','C1',to_date('10-02-2011','dd-mm-yyyy'),to_date('13-02-2011','dd-mm-yyyy'),to_date('03-03-2011','dd-mm-yyyy'),15,275);
 insert into r values ('R2','J6','C2',to_date('01-03-2011','dd-mm-yyyy'),to_date('06-03-2011','dd-mm-yyyy'),to_date('13-03-2011','dd-mm-yyyy'),30,300);
 insert into r values ('R3','J1','C3',to_date('05-03-2011','dd-mm-yyyy'),to_date('07-03-2011','dd-mm-yyyy'),to_date('10-03-2011','dd-mm-yyyy'),30,280);
 insert into r values ('R4','J3','C2',to_date('03-04-2011','dd-mm-yyyy'),to_date('07-04-2011','dd-mm-yyyy'),to_date('09-04-2011','dd-mm-yyyy'),25,300);
 insert into r values ('R5','J2','C5',to_date('22-04-2011','dd-mm-yyyy'),to_date('24-04-2011','dd-mm-yyyy'),to_date('26-04-2011','dd-mm-yyyy'),15,400);
 insert into r values ('R6','J7','C5',to_date('08-05-2011','dd-mm-yyyy'),to_date('11-05-2011','dd-mm-yyyy'),to_date('13-05-2011','dd-mm-yyyy'),70,325);
 insert into r values ('R7','J5','C2',to_date('15-05-2011','dd-mm-yyyy'),to_date('19-05-2011','dd-mm-yyyy'),to_date('22-05-2011','dd-mm-yyyy'),40,290);
 insert into r values ('R8','J3','C4',to_date('20-05-2011','dd-mm-yyyy'),to_date('23-05-2011','dd-mm-yyyy'),to_date('24-05-2011','dd-mm-yyyy'),15,290);
 insert into r values ('R9','J1','C6',to_date('09-06-2011','dd-mm-yyyy'),to_date('15-06-2011','dd-mm-yyyy'),to_date('20-06-2011','dd-mm-yyyy'),45,285);
 insert into r values ('R10','J6','C2',to_date('15-06-2011','dd-mm-yyyy'),to_date('16-06-2011','dd-mm-yyyy'),to_date('16-06-2011','dd-mm-yyyy'),20,300);
 insert into r values ('R11','J4','C3',to_date('19-06-2011','dd-mm-yyyy'),to_date('27-06-2011','dd-mm-yyyy'),to_date('27-06-2011','dd-mm-yyyy'),30,445);
 insert into r values ('R12','J1','C5',to_date('01-07-2011','dd-mm-yyyy'),to_date('03-07-2011','dd-mm-yyyy'),to_date('05-07-2011','dd-mm-yyyy'),50,277);
 insert into r values ('R13','J5','C1',to_date('01-09-2011','dd-mm-yyyy'),to_date('04-09-2011','dd-mm-yyyy'),to_date('04-09-2011','dd-mm-yyyy'),100,285);
 insert into r values ('R14','J4','C4',to_date('20-09-2011','dd-mm-yyyy'),to_date('21-09-2011','dd-mm-yyyy'),to_date('21-09-2011','dd-mm-yyyy'),120,420);
 insert into r values ('R15','J3','C2',to_date('20-10-2011','dd-mm-yyyy'),to_date('23-10-2011','dd-mm-yyyy'),to_date('24-10-2011','dd-mm-yyyy'),25,295);
 insert into r values ('R16','J7','C6',to_date('01-11-2011','dd-mm-yyyy'),to_date('03-11-2011','dd-mm-yyyy'),to_date('06-11-2011','dd-mm-yyyy'),80,415);
 insert into r values ('R17','J1','C1',to_date('11-01-2012','dd-mm-yyyy'),to_date('13-01-2012','dd-mm-yyyy'),to_date('15-01-2012','dd-mm-yyyy'),10,280);
 insert into r values ('R18','J6','C2',to_date('15-04-2012','dd-mm-yyyy'),to_date('22-04-2012','dd-mm-yyyy'),to_date('23-04-2012','dd-mm-yyyy'),60,350);
 insert into r values ('R19','J4','C6',to_date('13-05-2012','dd-mm-yyyy'),to_date('15-05-2012','dd-mm-yyyy'),to_date('20-05-2012','dd-mm-yyyy'),50,500);
 insert into r values ('R20','J2','C6',to_date('01-06-2012','dd-mm-yyyy'),to_date('05-06-2012','dd-mm-yyyy'),null,30,490);
 insert into r values ('R21','J7','C2',to_date('20-06-2012','dd-mm-yyyy'),to_date('21-06-2012','dd-mm-yyyy'),to_date('25-06-2012','dd-mm-yyyy'),150,415);
 insert into r values ('R22','J3','C4',to_date('10-08-2012','dd-mm-yyyy'),to_date('12-08-2012','dd-mm-yyyy'),to_date('13-08-2012','dd-mm-yyyy'),60,330);
 insert into r values ('R23','J5','C3',to_date('15-08-2012','dd-mm-yyyy'),to_date('19-08-2012','dd-mm-yyyy'),to_date('21-08-2012','dd-mm-yyyy'),120,350);
 insert into r values ('R24','J4','C3',to_date('20-08-2012','dd-mm-yyyy'),null,null,70,520);
 insert into r values ('R25','J3','C2',to_date('20-08-2012','dd-mm-yyyy'),to_date('22-08-2012','dd-mm-yyyy'),to_date('26-08-2012','dd-mm-yyyy'),45,340);
 insert into r values ('R26','J1','C3',to_date('25-08-2012','dd-mm-yyyy'),to_date('27-08-2012','dd-mm-yyyy'),null,50,290);
 insert into r values ('R27','J6','C2',to_date('15-09-2012','dd-mm-yyyy'),to_date('17-09-2012','dd-mm-yyyy'),null,70,350);