/*
select * from DEPTO
select * from DISCIPLINA
select * from PREREQ
select * from TURMA
select * from PREDIO
select * from SALA
select * from HORARIO
select * from TITULACAO 
select * from PROFESSOR
select * from PROFTURMA
*/

INSERT INTO DEPTO VALUES ('INF01', 'Informatica');
INSERT INTO DEPTO VALUES ('RED01', 'Redes');
INSERT INTO DEPTO VALUES ('COM01', 'Comercio Exterior');
INSERT INTO DEPTO VALUES ('MOD01', 'Moda');

INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC01', 4, 'Matematica Aplicada');
INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC02', 4, 'Banco de Dados I');
INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC03', 4, 'Banco de Dados II');
INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC04', 4, 'Sistemas Operacionais');
INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC05', 4, 'Engenharia de Software I');
INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC06', 4, 'Engenharia de Software II');
INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC07', 4, 'Engenharia de Software III');
INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC08', 2, 'Web Design');
INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC09', 2, 'Ingles');
INSERT INTO DISCIPLINA VALUES ('INF01', 'DISC10', 2, 'Informatica e Sociedade');
INSERT INTO DISCIPLINA VALUES ('RED01', 'DISC11', 4, 'Redes I');
INSERT INTO DISCIPLINA VALUES ('RED01', 'DISC12', 4, 'Redes II');
INSERT INTO DISCIPLINA VALUES ('RED01', 'DISC13', 4, 'Lab de Redes I');
INSERT INTO DISCIPLINA VALUES ('RED01', 'DISC14', 4, 'Lab de Redes II');
INSERT INTO DISCIPLINA VALUES ('RED01', 'DISC15', 4, 'Segurança');
INSERT INTO DISCIPLINA VALUES ('RED01', 'DISC16', 2, 'Redes sem Fio');

INSERT INTO PREREQ VALUES ('INF01', 'DISC03', 'DISC02', 'INF01');
INSERT INTO PREREQ VALUES ('INF01', 'DISC06', 'DISC05', 'INF01');
INSERT INTO PREREQ VALUES ('INF01', 'DISC07', 'DISC05', 'INF01');
INSERT INTO PREREQ VALUES ('INF01', 'DISC07', 'DISC06', 'INF01');
INSERT INTO PREREQ VALUES ('RED01', 'DISC12', 'DISC11', 'RED01');
INSERT INTO PREREQ VALUES ('RED01', 'DISC14', 'DISC13', 'RED01');
INSERT INTO PREREQ VALUES ('RED01', 'DISC16', 'DISC11', 'RED01');
INSERT INTO PREREQ VALUES ('RED01', 'DISC16', 'DISC12', 'RED01');

INSERT INTO TURMA VALUES ('2002/1', 'INF01', 'DISC01', 'INF-T01', 35);
INSERT INTO TURMA VALUES ('2002/1', 'INF01', 'DISC02', 'INF-T01', 35);
INSERT INTO TURMA VALUES ('2002/1', 'INF01', 'DISC05', 'INF-T01', 35);
INSERT INTO TURMA VALUES ('2002/2', 'INF01', 'DISC04', 'INF-T02', 25);
INSERT INTO TURMA VALUES ('2002/2', 'INF01', 'DISC03', 'INF-T02', 25);
INSERT INTO TURMA VALUES ('2002/2', 'INF01', 'DISC06', 'INF-T02', 25);
INSERT INTO TURMA VALUES ('2003/1', 'INF01', 'DISC07', 'INF-T03', 30);
INSERT INTO TURMA VALUES ('2003/1', 'INF01', 'DISC08', 'INF-T03', 30);
INSERT INTO TURMA VALUES ('2002/1', 'RED01', 'DISC11', 'RED-T01', 35);
INSERT INTO TURMA VALUES ('2002/1', 'RED01', 'DISC13', 'RED-T01', 35);
INSERT INTO TURMA VALUES ('2002/1', 'RED01', 'DISC15', 'RED-T01', 35);
INSERT INTO TURMA VALUES ('2002/2', 'RED01', 'DISC12', 'RED-T02', 25);
INSERT INTO TURMA VALUES ('2002/2', 'RED01', 'DISC14', 'RED-T02', 25);
INSERT INTO TURMA VALUES ('2003/1', 'RED01', 'DISC16', 'RED-T03', 30);

INSERT INTO PREDIO VALUES (01, 'Informática - Salas de Aula');
INSERT INTO PREDIO VALUES (02, 'Redes - Salas de Aula');
INSERT INTO PREDIO VALUES (03, 'Biblioteca');

INSERT INTO SALA VALUES (01, 604, 25);
INSERT INTO SALA VALUES (01, 704, 30);
INSERT INTO SALA VALUES (01, 804, 35);
INSERT INTO SALA VALUES (02, 204, 25);
INSERT INTO SALA VALUES (02, 304, 30);
INSERT INTO SALA VALUES (02, 404, 35);

INSERT INTO TITULACAO VALUES (1, 'Tecnologo');
INSERT INTO TITULACAO VALUES (2, 'Bacharel');
INSERT INTO TITULACAO VALUES (3, 'Mestre');
INSERT INTO TITULACAO VALUES (4, 'Doutor');

INSERT INTO PROFESSOR VALUES ('PROF01', 1, 'INF01', 'Amanda');
INSERT INTO PROFESSOR VALUES ('PROF02', 1, 'INF01', 'Bruna Surfistinha');
INSERT INTO PROFESSOR VALUES ('PROF03', 2, 'INF01', 'Carlos');
INSERT INTO PROFESSOR VALUES ('PROF04', 2, 'INF01', 'Manuela');
INSERT INTO PROFESSOR VALUES ('PROF05', 3, 'INF01', 'Tati Quebra Barraro');
INSERT INTO PROFESSOR VALUES ('PROF06', 3, 'INF01', 'Bianca');
INSERT INTO PROFESSOR VALUES ('PROF07', 3, 'INF01', 'Paulo');
INSERT INTO PROFESSOR VALUES ('PROF08', 4, 'INF01', 'Joao do Pe de Feijao');
INSERT INTO PROFESSOR VALUES ('PROF09', 4, 'INF01', 'Bob Lee');
INSERT INTO PROFESSOR VALUES ('PROF10', 3, 'RED01', 'Renata Ingrata');
INSERT INTO PROFESSOR VALUES ('PROF11', 3, 'RED01', 'Rogerio');
INSERT INTO PROFESSOR VALUES ('PROF12', 4, 'RED01', 'Thomas Turbando');
INSERT INTO PROFESSOR VALUES ('PROF13', 1, 'RED01', 'Rose');
INSERT INTO PROFESSOR VALUES ('PROF14', 2, 'RED01', 'Gertrudes');

INSERT INTO HORARIO VALUES ('2002/1', 'INF01', 'DISC01', 'INF-T01', 2, '19h', 01, 804, '72h');
INSERT INTO HORARIO VALUES ('2002/1', 'INF01', 'DISC02', 'INF-T01', 3, '19h', 01, 804, '72h');
INSERT INTO HORARIO VALUES ('2002/1', 'INF01', 'DISC05', 'INF-T01', 4, '19h', 01, 804, '72h');
INSERT INTO HORARIO VALUES ('2002/2', 'INF01', 'DISC04', 'INF-T02', 2, '19h', 01, 604, '72h');
INSERT INTO HORARIO VALUES ('2002/2', 'INF01', 'DISC03', 'INF-T02', 3, '19h', 01, 604, '72h');
INSERT INTO HORARIO VALUES ('2002/2', 'INF01', 'DISC06', 'INF-T02', 4, '19h', 01, 604, '72h');
INSERT INTO HORARIO VALUES ('2003/1', 'INF01', 'DISC07', 'INF-T03', 2, '19h', 01, 704, '72h');
INSERT INTO HORARIO VALUES ('2003/1', 'INF01', 'DISC08', 'INF-T03', 3, '19h', 01, 704, '36h');
INSERT INTO HORARIO VALUES ('2002/1', 'RED01', 'DISC11', 'RED-T01', 2, '19h', 02, 404, '72h');
INSERT INTO HORARIO VALUES ('2002/1', 'RED01', 'DISC13', 'RED-T01', 3, '19h', 02, 404, '72h');
INSERT INTO HORARIO VALUES ('2002/1', 'RED01', 'DISC15', 'RED-T01', 4, '19h', 02, 404, '72h');
INSERT INTO HORARIO VALUES ('2002/2', 'RED01', 'DISC12', 'RED-T02', 2, '19h', 02, 204, '72h');
INSERT INTO HORARIO VALUES ('2002/2', 'RED01', 'DISC14', 'RED-T02', 3, '19h', 02, 204, '72h');
INSERT INTO HORARIO VALUES ('2003/1', 'RED01', 'DISC16', 'RED-T03', 2, '19h', 02, 304, '36h');

INSERT INTO PROFTURMA VALUES ('PROF01', 'DISC01', 'INF-T01', '2002/1', 'INF01');
INSERT INTO PROFTURMA VALUES ('PROF02', 'DISC02', 'INF-T01', '2002/1', 'INF01');
INSERT INTO PROFTURMA VALUES ('PROF03', 'DISC05', 'INF-T01', '2002/1', 'INF01');
INSERT INTO PROFTURMA VALUES ('PROF04', 'DISC04', 'INF-T02', '2002/2', 'INF01');
INSERT INTO PROFTURMA VALUES ('PROF05', 'DISC03', 'INF-T02', '2002/2', 'INF01');
INSERT INTO PROFTURMA VALUES ('PROF06', 'DISC06', 'INF-T02', '2002/2', 'INF01');
INSERT INTO PROFTURMA VALUES ('PROF07', 'DISC07', 'INF-T03', '2003/1', 'INF01');
INSERT INTO PROFTURMA VALUES ('PROF08', 'DISC08', 'INF-T03', '2003/1', 'INF01');
INSERT INTO PROFTURMA VALUES ('PROF09', 'DISC11', 'RED-T01', '2002/1', 'RED01');
INSERT INTO PROFTURMA VALUES ('PROF10', 'DISC13', 'RED-T01', '2002/1', 'RED01');
INSERT INTO PROFTURMA VALUES ('PROF11', 'DISC15', 'RED-T01', '2002/1', 'RED01');
INSERT INTO PROFTURMA VALUES ('PROF12', 'DISC12', 'RED-T02', '2002/2', 'RED01');
INSERT INTO PROFTURMA VALUES ('PROF13', 'DISC14', 'RED-T02', '2002/2', 'RED01');
INSERT INTO PROFTURMA VALUES ('PROF14', 'DISC16', 'RED-T03', '2003/1', 'RED01');

---------------------------------------------------------------------------
-- 06

INSERT INTO TURMA VALUES ('2002/1', 'INF01', 'DISC09', 'INF-T01', 35);
INSERT INTO TURMA VALUES ('2002/1', 'INF01', 'DISC10', 'INF-T01', 35);

INSERT INTO PROFESSOR VALUES ('PROF15', 4, 'COM01', 'Lady Gaga');
INSERT INTO PROFESSOR VALUES ('PROF16', 3, 'MOD01', 'Madame Tussauds');

INSERT INTO HORARIO VALUES ('2002/1', 'INF01', 'DISC09', 'INF-T01', 5, '19h', 01, 804, '72h');
INSERT INTO HORARIO VALUES ('2002/1', 'INF01', 'DISC10', 'INF-T01', 6, '19h', 01, 804, '72h');

INSERT INTO PROFTURMA VALUES ('PROF15', 'DISC09', 'INF-T01', '2002/1', 'INF01');
INSERT INTO PROFTURMA VALUES ('PROF16', 'DISC10', 'INF-T01', '2002/1', 'INF01');

---------------------------------------------------------------------------

