create table empleado( numemp VARCHAR2(3), nombre VARCHAR2(100), edad INTEGER, oficina INTEGER, titulo VARCHAR2(100), contrato DATE, jefe VARCHAR2(3), cuotas numeric(8,2), ventas numeric(8,2), PRIMARY KEY (numemp) ); INSERT INTO empleado VALUES ('101','Antonio Viguer',45,12,'representante','20/10 /1986','104',300000,305000); INSERT INTO empleado VALUES ('102','Alvaro Jaumes',48,21,'representante','10/12/ 1986','108',350000,474000); INSERT INTO empleado VALUES ('103','Juan Rovira',29,12,'representante','01/03/19 87','104',275000,286000); INSERT INTO empleado VALUES ('104','José Gonzáles',33,12,'dir ventas','19/05/1987',' 106',200000,143000); INSERT INTO empleado VALUES ('105','Vicente Pantalla',37,13,'representante','12/ 02/1988',104,350000,368000); INSERT INTO empleado VALUES ('106','Luis Antonio',52,11,'dir general','14/06/198 8','',275000,299000); INSERT INTO empleado VALUES ('107','Jorge Gutiérrez',49,22,'representante','14/11/ 1988','108',300000,186000); INSERT INTO empleado VALUES ('108','Ana Bustamante',62,21,'dir ventas','12/10/19 89','106',350000,361000); INSERT INTO empleado VALUES ('109','Mariá Sunta',31,11,'representante','12/10/1999 ','106',300000,392000); INSERT INTO empleado VALUES ('110','Juan Victor',41,0,'representante','13/01/199 0','104',0,76000); create table oficina( oficina INTEGER, ciudad VARCHAR2(100), region VARCHAR2(20), dir VARCHAR2(3), objetivo numeric(8,2), ventas numeric(8,2), PRIMARY KEY (oficina) ); INSERT INSERT INSERT INSERT INSERT
INTO INTO INTO INTO INTO
oficina oficina oficina oficina oficina
VALUES VALUES VALUES VALUES VALUES
(11,'Valencia','este','106',575000,693000); (12,'Alicante','este','104',800000,735000); (13,'Castellon','este','105',350000,368000); (21,'Babajoz','oeste','108',725000,836000); (22,'A Coruña','oeste','108',300000,186000);
INSERT INSERT INSERT INSERT
INTO INTO INTO INTO
oficina oficina oficina oficina
VALUES VALUES VALUES VALUES
(23,'Madrid','centro','108',0,0); (24,'Madrid','centro','108',250000,150000); (26,'Pamplona','norte','',0,0); (28,'Valencia','este','',900000,0);
create table cliente( numcliente INTEGER, nombre VARCHAR2(100), repclie VARCHAR2(3), limitecredito numeric(8,2), PRIMARY KEY (numcliente), FOREIGN KEY (repclie) REFERENCES empleado(numemp) ); INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT
INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO
cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente cliente
VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES
(2101,'Luis García Antón','106',65000); (2102,'Alvaro Rodríguez','101',65000); (2103,'Jaime Llorens','105',50000); (2105,'Antonio Canales','101',45000); (2106,'Juan Suárez','102',65000); (2107,'Julian López','110',35000); (2108,'Julia Antequera','109',55000); (2109,'Alberto Juanes','103',25000); (2111,'Cristóbal García','103',50000); (2112,'María Silva','108',50000); (2113,'Luisa Maron','104',20000); (2114,'Cristina Bulini','102',20000); (2115,'Vicente Martínez','101',20000); (2117,'Carlos Tena','106',35000); (2118,'Junípero Alvarez','108',60000); (2119,'Salomom Bueno','109',25000); (2120,'Juan Malo','102',50000); (2121,'Vicente Ríos','103',45000); (2122,'José Marchante','105',30000); (2123,'José Libros','102',40000); (2124,'Juan Bolto','107',40000);
create table producto( idfab VARCHAR2(3), idproducto VARCHAR2(5), descripcion VARCHAR2(50), precio numeric(8,2), existencia INTEGER, PRIMARY KEY (idfab,idproducto) ); INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT
INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO
producto producto producto producto producto producto producto producto producto producto producto producto producto producto
VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES
('aci','41001','arandela',58,277); ('aci','41002','bisagra',80,167); ('aci','41003','art t3',112,207); ('aci','41004','art t4',123,139); ('aci','4100x','junta',26,37); ('aci','4100y','extractor',2888,35); ('aci','4100z','mont',2625,28); ('bic','41003','manivela',652,3); ('bic','41089','rodamiento',225,78); ('bic','41672','plato',180,0); ('fea','112','cubo',148,115); ('fea','114','cubo',243,15); ('imm','773c','reostato',975,28); ('imm','775c','reostato 2',1425,5);
INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT INSERT
INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO INTO
producto producto producto producto producto producto producto producto producto producto producto
VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES VALUES
('imm','779c','reostato 3',1875,0); ('imm','887h','caja clavos',54,223); ('imm','887p','perno',25,24); ('imm','887x','manivela',475,32); ('qsa','xk47','red',355,38); ('qsa','xk48','red',134,203); ('qsa','xk48a','red',117,37); ('rei','2a44g','pas',350,14); ('rei','2a44l','bomba 1',4500,12); ('rei','2a44r','bomba r',4500,12); ('rei','2a45c','junta',79,210);
create table pedido( codigo INTEGER, numpedido LONG, fechapedido DATE, clie INTEGER, rep VARCHAR2(3), fab VARCHAR2(3), producto VARCHAR2(5), cant INTEGER, importe numeric(8,2), Primary key (codigo) ); INSERT 0); INSERT 0); INSERT 6); INSERT 8); INSERT ); INSERT 0); INSERT ; INSERT 00); INSERT INSERT 0); INSERT 96); INSERT ); INSERT ); INSERT ); INSERT 45); INSERT ); INSERT 0); INSERT 04);
INTO pedido VALUES (1,110036,'02/01/1997',2107,'110','aci','4100z',9,2250 INTO pedido VALUES (2,110036,'02/01/1997',2117,'106','rei','2a44l',7,3150 INTO pedido VALUES (3,112963,'10/05/1997',2103,'105','aci','41004',28,327 INTO pedido VALUES (4,112968,'11/01/1990',2102,'101','aci','41004',34,397 INTO pedido VALUES (5,112975,'11/02,1997',2111,'103','rei','2a44g',6,2100 INTO pedido VALUES (6,112979,'12/10/1989',2114,'108','aci','4100z',6,1500 INTO pedido VALUES (7,112983,'10/05/1997',2103,'105','aci','41004',6,702) INTO pedido VALUES (8,112987,'01/01/1997',2103,'105','aci','4100y',11,275 INTO pedido VALUES (9,112989,'10/12/1997',2101,'106','fea','114',6,1458); INTO pedido VALUES (10,112992,'15/04/1990',2118,'108','aci','41002',10,76 INTO pedido VALUES (11,112992,'10/03/1997',2106,'102','rei','2a45c',24,18 INTO pedido VALUES (12,112997,'04/04/1997',2124,'107','bic','41003',1,652 INTO pedido VALUES (13,113003,'05/02/1997',2108,'109','imm','779c',3,5625 INTO pedido VALUES (14,113007,'01/01/1997',2112,'108','imm','773c',3,2925 INTO pedido VALUES (15,113012,'05/05/1997',2111,'105','aci','41003',35,37 INTO pedido VALUES (16,113013,'06/08/1997',2118,'108','bic','41003',1,652 INTO pedido VALUES (17,113024,'04/07/1997',2114,'108','qsa','xk47',20,710 INTO pedido VALUES (18,113027,'05/02/1997',2103,'105','aci','41002',54,41
INSERT ); INSERT 00); INSERT 000); INSERT ); INSERT ; INSERT ); INSERT ); INSERT 0); INSERT ); INSERT 30); INSERT ); INSERT 50);
INTO pedido VALUES (19,113034,'05/11/1997',2107,'110','rei','2a45c',8,632 INTO pedido VALUES (20,113042,'01/01/1997',2113,'101','rei','2a44r',5,225 INTO pedido VALUES (21,113045,'02/07/1997',2112,'108','rei','2a44r',10,45 INTO pedido VALUES (22,113048,'02/02/1997',2120,'102','imm','779c',2,3750 INTO pedido VALUES (23,113049,'04/04/1997',2118,'108','qsa','xk47',2,776) INTO pedido VALUES (24,113051,'06/07/1997',2118,'108','qsa','xk47',4,1420 INTO pedido VALUES (25,113055,'01/04/2009',2108,'101','aci','4100x',6,150 INTO pedido VALUES (26,113037,'01/11/1997',2111,'103','aci','4100x',24,60 INTO pedido VALUES (27,113058,'04/07/1989',2108,'109','fea','112',10,1480 INTO pedido VALUES (28,113062,'04/07/1997',2124,'107','bic','41003',10,24 INTO pedido VALUES (29,113065,'03/06/1997',2106,'102','qsa','xk47',6,2130 INTO pedido VALUES (30,113069,'01/08/1997',2109,'107','imm','773c',22,313
