mby

CREATE TABLE EMPLEADO(
ID_EMPLEADO NUMBER(5) NOT NULL PRIMARY KEY,
NUMRUT NUMBER(10) NOT NULL,
DVRUT VARCHAR2(1) NOT NULL,
PRIMER_NOMBRE  VARCHAR2(20) NOT NULL,
SNOMBRE VARCHAR2(20) NULL,
APPATERNO VARCHAR2(20) NOT NULL,
APPMATERNO VARCHAR(20) NOT NULL,
FECHA_CONTRADO DATE NOT NULL,
SUELDO_BASE NUMBER(7) NOT NULL
);


CREATE TABLE VENTAS(
NRO_BOLETA NUMBER(8) NOT NULL PRIMARY KEY,
ID_EMPLEADO NUMBER(5) NOT NULL,
FECHA_BOLETA DATE NOT NULL,
MONTO_TOTAL NUMBER(8),
CONSTRAINT FK_ID_EMPLEADO foreign key (ID_EMPLEADO)references EMPLEADO(ID_EMPLEADO)
);

CREATE TABLE COMISION_VENTAS(
NRO_BOLETA NUMBER(8) PRIMARY KEY,
ID_EMPLEADO NUMBER(5) NOT NULL,
MONTO_COMISION NUMBER(8) NOT NULL,
CONSTRAINT FK__ID_EMPLEADO FOREIGN KEY(ID_EMPLEADO) REFERENCES EMPLEADO(ID_EMPLEADO),
CONSTRAINT FK_NRO_BOLETA FOREIGN KEY(NRO_BOLETA) REFERENCES VENTAS(NRO_BOLETA)
);

SELECT*FROM EMPLEADO;


INSERT INTO EMPLEADO VALUES(1,222222,2,'PABLO',NULL,'PEREZ','SOTO','01-03-2010',300000);
INSERT INTO EMPLEADO VALUES(2,333333,3,'PEDRO','JOSE','TORRES','TRONCOSO','14-03-2011',280000);
INSERT INTO EMPLEADO VALUES(3,444444,4,'FRANCISO','ALEJANDRO','TAPIA','SOTO','01-06-2011',250000);
INSERT INTO EMPLEADO VALUES(4,555555,5,'MARIA',NULL,'TOLEDO','ARANCIBIA','01-03-2014',180000);



INSERT INTO VENTAS VALUES(90,3,'02-02-2014',75000);
INSERT INTO VENTAS VALUES(100,1,'01-03-2014',200000);
INSERT INTO VENTAS VALUES(101,1,'02-03-2014',100000);
INSERT INTO VENTAS VALUES(102,2,'02-03-2014',75000);
INSERT INTO VENTAS VALUES(103,3,'02-03-2014',45200);


SELECT*FROM COMISION_VENTAS;


INSERT INTO COMISION_VENTAS VALUES(90,3,9750);
INSERT INTO COMISION_VENTAS VALUES(100,1,26000);
INSERT INTO COMISION_VENTAS VALUES(101,1,13000);
INSERT INTO COMISION_VENTAS VALUES(102,2,9750);
INSERT INTO COMISION_VENTAS VALUES(103,3,5876);