
#-----------------------------------

INSERT INTO FORNECEDOR VALUES(1,'Smith',20,'Londres');
INSERT INTO FORNECEDOR VALUES(2,'Jones',10,'Paris');
INSERT INTO FORNECEDOR VALUES(3,'Blake',30,'Paris');
INSERT INTO FORNECEDOR VALUES(4,'Clark',20,'Londres');
INSERT INTO FORNECEDOR VALUES(5,'Adams',30,'Atenas');

INSERT INTO PECA VALUES(1,'Nut','Vermelho',12,'Londres');
INSERT INTO PECA VALUES(2,'Bolt','Verde',17,'Paris');
INSERT INTO PECA VALUES(3,'Screw','Azul',17,'Roma');
INSERT INTO PECA VALUES(4,'Screw','Vermelho',14,'Londres');
INSERT INTO PECA VALUES(5,'Cam','Azul',12,'Paris');
INSERT INTO PECA VALUES(6,'Cog','Vermelho',19,'Londres');

INSERT INTO FORNECIMENTO VALUES(1,1,200);
INSERT INTO FORNECIMENTO VALUES(2,3,400);
INSERT INTO FORNECIMENTO VALUES(2,5,100);
INSERT INTO FORNECIMENTO VALUES(3,3,200);
INSERT INTO FORNECIMENTO VALUES(3,4,500);
INSERT INTO FORNECIMENTO VALUES(4,6,300);
INSERT INTO FORNECIMENTO VALUES(5,2,200);
INSERT INTO FORNECIMENTO VALUES(5,5,500);
INSERT INTO FORNECIMENTO VALUES(5,6,200);
INSERT INTO FORNECIMENTO VALUES(5,1,100);
INSERT INTO FORNECIMENTO VALUES(5,3,200);
INSERT INTO FORNECIMENTO VALUES(5,4,800);



