Advertisement
xNatural

22 06 2017

Jun 22nd, 2017
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. CREATE TABLE EMPLEADO (
  2. ID_EMPLEADO NUMBER(5) NOT NULL,
  3. PNOMBRE VARCHAR2(20) NOT NULL,
  4. SNOMBRE VARCHAR2(20) NOT NULL,
  5. APPATENO VARCHAR2(20) NOT NULL,
  6. APMATERNO VARCHAR2(20) NOT NULL,
  7. FECHA_CONTRATO DATE NOT NULL,
  8. SUELDO_BASE NUMBER(7) NOT NULL,
  9. CONSTRAINT PK_EMPLEADO PRIMARY KEY (ID_EMPLEADO)
  10. );
  11.  
  12. --TABLA VENTAS
  13. CREATE TABLE VENTAS(
  14. NRO_BOLETAS NUMBER(8) NOT NULL,
  15. ID_EMPLEADO NUMBER(5) NOT NULL,
  16. FECHA_BOLETA DATE NOT NULL,
  17. MONTO_TOTAL NUMBER(8) NOT NULL,
  18. -- ASIGNADO LA PRIMARY KEY
  19. CONSTRAINT PK_VENTAS PRIMARY KEY (NRO_BOLETAS),
  20. --ESTAMOS LLAMANDO LA LLAVE FORANIA
  21. CONSTRAINT PK_EMPLEADO_VENTAS FOREIGN KEY (ID_EMPLEADO) REFERENCES EMPLEADO(ID_EMPLEADO)
  22. );
  23.  
  24. -- TABLA COMISION_VENTAS
  25. CREATE TABLE COMISION_VENTAS(
  26. NRO_BOLETAS NUMBER(8) NOT NULL,
  27. ID_EMPLEADO NUMBER(5) NOT NULL UNIQUE,
  28. MONTO_COMISION NUMBER(8) NOT NULL,
  29. CONSTRAINT PK_COMISION_VENTAS PRIMARY KEY (NRO_BOLETAS),
  30. CONSTRAINT PK_COMISION_VENTAS_VENTAS FOREIGN KEY (NRO_BOLETAS) REFERENCES VENTAS (NRO_BOLETAS),
  31. CONSTRAINT FK_COMISION_VENTAS_EMPLEADO FOREIGN KEY (ID_EMPLEADO) REFERENCES EMPLEADO (ID_EMPLEADO)
  32. );
  33.  
  34. SELECT * FROM COMISION_VENTAS
  35. DROP TABLE VENTAS;
  36.  
  37. INSERT INTO EMPLEADO VALUES (SQ_EMPLEADO,2222222,'PABLO',NULL,'PEREZ','SOTO','01/03/2010','300000');
  38. INSERT INTO EMPLEADO VALUES (
  39.  
  40.  
  41.  
  42. CREATE SEQUENCE SQ_EMPLEADO
  43. INCREMENT BY 1
  44. START WITH 1
  45. MAXVALUE 999999
  46. NOCACHE
  47. NOCYCLE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement