Povoameto de BD 2

USE IchibaSuperMarket;

-- inserindo valores para curso

INSERT INTO curso VALUES

( '7070', 12 , 'entregas'),
( '1010' , 20, 'libras'),
( '2276' , 5 , 'marketing'),
( '9085' , 13 , 'informatica'),
( '7324' , 7 , 'financas'),
( '8012'  , 60 , 'ingles'),
( '3390', 30 , 'relacoes humanas'),
( '8344' , 30 , 'estatistica'),
( '5793' , 40 , 'circuitos'),
( '3333' , 20 , 'ginastica laboral'),
( '5449', 40 , 'mecanica'),
( '7573' , 20, 'administracao'),
( '9090' , 40 , 'programacao'),
( '2101' , 40 , 'espanhol');

-- inserindo valores para funcionario


INSERT INTO funcionario (CPF, id_jornada, seq_filial, cnpj_matriz, data_admissao, sex, estado_civil, login, senha, RG, nome, situacao, endereco) VALUES
('77491222226' , '0598', '9903' ,  '08351501000124' , '2005-04-12' , 'F', 'solteiro' , 'helo.12' , '123' , '1259312' , 'Heloisa Macedo de Souza' , 'ativo' , 'Rua Eloy Monteiro Nunes'),
( '98243208909' , '0012' , '9903' ,'08351501000124' , '2007-07-25' , 'M' , 'casado' , 'Garza2019' , 'E3221' , '3654296' , 'Elias ChateauBriand Gomes' , 'inativo' , 'Avenida Paraíba'),
('57325297050' , '3232' , '1100' , '32164472000176', '2003-09-02', 'F', 'viuva' , 'Riggs642' , 'YM' , '4563573' , 'Maria Helena Rosendo' , 'ativo', 'Rua Pedro Viana Neto'),
('16565525749' , '5749' , '1100' , '32164472000176' , '2000-01-07', 'F', 'solteiro' , 'Eugene759' , 'XX133' , '2144770', 'Afrodite Bezerra das Flores' , 'ativo', 'Rua Amelia'),
('57859332507', '9234' , '1876' ,  '50754767000184' , '2016-02-02' , 'M' , 'solteiro' , 'TM1' , '98UJ' , '1555582' , 'Mauricio de Souza Carvalho' , 'ativo' , ' Rua da Concordia'),
('96202875763' , '8872' , '1876' , '50754767000184' , '2012-09-11' , 'F' , 'solteiro' , 'Juli.Alves' , '8900' , '3494135' , 'Juliana Macedo Pinheiro' , 'inativo' , 'Rua Tucano'),
('02123011878' , '1363' , '9103' , '08351501000124' , '2012-08-10' , 'M' , 'solteiro' , 'ana.mari' , 'bb34' , '1783833' , 'Mariana Siqueira Jardim' , 'ativo' , 'Rua Lealberto Leal'),
('15141182894' , '4571' , '9103' , '08351501000124' , '2013-06-13' , 'F' , 'casado' , 'dudu.arda' , '1999' ,'2267700', 'Bernadete Maria da Silva' , 'ativo' , 'Rua Guajuvira'),
('33666472214' , '9811' , '1100' , '32164472000176' , '2012-03-01' , 'F' , 'solteiro', 'ana.belle' , 'AX6','4137799','Anabelle Cristina Leal de Figueiredo' , 'ativo', 'Rua Manuel de Medeiros'),
('32568071001', '3192' , '2034' ,  '39438485000135' , '2017-09-26' , 'F' , 'casado' , 'bee.a' , '134N' ,'4163131', 'Ana Beatriz Castanho Guedes' , 'ativo', 'Rua Jornalista Benedito Cunha'),
('45321186898' , '1306', '9675',   '86660421000164' , '2017-09-20', 'M' , 'solteiro' , 'alan.marq' , '0j7e' , '1557345','Allan Jose Malta de Souza' , 'inativo', ' Rua Projetada'),
('86147207504' , '9732' , '1153' , '01764804000120' , '2016-10-27' , 'F' , 'casado' , 'lelezinha' , '223d' ,' 3217467', 'Leticia Santana Rodrigues' , 'ativo' , 'Rua Felipe Guerra'),
('85902755239' , '7415' , '1153' , '01764804000120' , '2012-11-14' , 'F' , 'solteiro' , 'mwd2', '1332','2437550', 'Gabriela Amado Batista', 'ativo', 'Rua da Palma'),
('14073416260' , '2155' , '1153' , '01764804000120', '2015-02-14', 'M' , 'casado', 'mumu321', '9901',' 1190089','Jadiane Matoso dos Santos', 'ativo', 'Rua Real da Torre'),
('32970753502', '2856' , '1876' ,  '50754767000184' , '2013-01-10', 'F' , 'solteiro' , 'JH10' , '1132' , ' 2422874', 'Viviane Mendonca do Nascimento', 'ativo', 'Rua da Harmonia'),
('88356795591' , '0987' , '1153' , '01764804000120' , '2012-06-10', 'M' , 'casado', '991jj', '1233','1316411', 'Ronaldo Fagundes da Silva' , 'ativo', 'Rua da Praia');



-- inserindo valores para gerente

INSERT INTO gerente (CPF) VALUES

('96202875763'),
('02123011878'),
('15141182894'),
('57325297050');

-- inserindo valores para estoquista

INSERT INTO estoquista (CPF) VALUES
('77491222226'),
('98243208909'),
('57859332507'),
('16565525749');

-- inserindo valores para dba

INSERT INTO dba (CPF) VALUES
('45321186898');

-- inserindo valores na tabela entregador

INSERT INTO entregador (CPF) VALUES
('33666472214'),
('86147207504'),
('32970753502'),
('32568071001');

-- inserindo valotes na tabela supervisorestoque

INSERT INTO supervisorestoque (CPF) VALUES
('14073416260'),
('85902755239' ),
('88356795591');

-- inserindo valores na tabela de notificacao

INSERT INTO notificacao (id, cpf_fun, dia, descricao) VALUES
('2946' , '76264084700' , '2014-02-13' , NULL);

INSERT INTO notif_multa (id, pontos, valor, cep, complemento) VALUES
('2946' , 3 , 198.50 , 50789123 , Rua da Aurora);

INSERT INTO notif_advertencia (id) VALUES