SQLite-Tutorial-Startup

CREATE TABLE descontos
(
escalao NUMBER(2) PRIMARY KEY ,
salinf NUMBER(7) NOT NULL,
salsup NUMBER(7) NOT NULL
);


CREATE TABLE dep
(
ndep NUMBER(2) PRIMARY KEY ,
nome VARCHAR2(15) NOT NULL,
local VARCHAR2(15) NOT NULL
);


CREATE TABLE emp
(
nemp NUMBER(4) PRIMARY KEY,
ndep NUMBER(2) NOT NULL,
nome VARCHAR2(20) NOT NULL ,
funcao VARCHAR2(12) NOT NULL ,
encar NUMBER,
data_entrada DATE DEFAULT SYSDATE NOT NULL ,
sal NUMBER(7) NOT NULL ,
premios NUMBER(7) DEFAULT NULL 
);



INSERT INTO dep VALUES (10, 'Contabilidade', 'Condeixa');
INSERT INTO dep VALUES (20, 'Investigação', 'Mealhada');
INSERT INTO dep VALUES (30, 'Vendas', 'Coimbra');
INSERT INTO dep VALUES (40, 'Planeamento', 'Montemor');

INSERT INTO descontos VALUES (1, 55000, 99999);
INSERT INTO descontos VALUES (2, 100000, 210000);
INSERT INTO descontos VALUES (3, 210001, 350000);
INSERT INTO descontos VALUES (4, 350001, 550000);
INSERT INTO descontos VALUES (5, 550001, 9999999);

INSERT INTO emp VALUES(1839, 10, 'Jorge Sampaio', 'Presidente' ,null, '84.02.11', 890000, null);
INSERT INTO emp VALUES(1566, 20, 'Augusto Reis', 'Encarregado' ,1839, '85.02.13', 450975, null);
INSERT INTO emp VALUES(1698, 30, 'Duarte Guedes', 'Encarregado' ,1839, '91.11.25', 380850, null);
INSERT INTO emp VALUES(1782, 10, 'Silvia Teles', 'Encarregado' ,1839, '86.11.03', 279450, null);
INSERT INTO emp VALUES(1788, 20, 'Maria Dias', 'Analista' ,1566, '82.11.07', 565000, null);
INSERT INTO emp VALUES(1902, 20, 'Catarina Silva', 'Analista' ,1566, '93.04.13', 435000, null);
INSERT INTO emp VALUES(1499, 30, 'Joana Mendes', 'Vendedor' ,1698, '84.10.04', 145600, 56300);
INSERT INTO emp VALUES(1521, 30, 'Nelson Neves', 'Vendedor' ,1698, '83.02.27', 212250, 98500);
INSERT INTO emp VALUES(1654, 30, 'Ana Rodrigues', 'Vendedor' ,1698, '90.12.17', 221250, 81400);
INSERT INTO emp VALUES(1844, 30, 'Manuel Madeira', 'Vendedor' ,1698, '85.04.21', 157800, 0);
INSERT INTO emp VALUES(1900, 30, 'Tome Ribeiro', 'Continuo' ,1698, '94.03.05', 56950, null);
INSERT INTO emp VALUES(1876, 20, 'Rita Pereira', 'Continuo' ,1788, '96.02.07', 65100, null);
INSERT INTO emp VALUES(1934, 10, 'Olga Costa', 'Continuo' ,1782, '86.06.22', 68300, null);
INSERT INTO emp VALUES(1369, 20, 'Antonio Silva', 'Continuo' ,1902, '96.12.22', 70800, null);