lzfelix

insert into departamento(DNOME, DNUMERO, GERSSN, GERDATAINICIO) values
('Pesquisa', 5, null, '1988-05-22'),
('Administração', 4, null, '1995-01-01'),
('Sede administrativa', 1, null, '1981-06-19');

insert into empregado(PNOME, MINICIAL, UNOME, SSN, DATANASC, ENDERECO, SEXO, SALARIO, SUPERSSN, DNO) values
('James', 'E', 'Borg', 888665555, '1937-11-10', '450 Stone, Houston, TX',  'M', 55000, null, 4),
('Franklin', 'T', 'Wong', 333445555, '1955-12-08', '638 Voss, Houston, TX',  'M', 40000, 888665555, 5),
('John', 'B', 'Smith', 123456789, '1965-01-09', '731 Fondren, Houston, TX',  'M', 30000, 333445555, 5),
('Jennifer', 'S', 'Wallace', 987654321, '1941-06-20', '291 Berry, Houston, TX',  'F', 43000, 888665555, 4),

lzfelix

CREATE TABLE DEPARTAMENTO (
       DNUMERO              INTEGER NOT NULL,
       DNOME                VARCHAR(20) NULL,
       GERDATAINICIO        DATE NULL,
       GERSSN               INTEGER NULL
);


ALTER TABLE DEPARTAMENTO