use escola;

insert into Alunos Values 
(NULL,"Ana Carla","1980-03-20","f","Almada"),
(NULL,"Bruno Vale","1981-02-01","m","Almada"),
(NULL,"Carlos Santos","1982-07-22","m","Caparica"),
(NULL,"Dario Pena","1982-09-11","m","Almada"),
(NULL,"Eliana Guimarães","1982-08-18","f","Caparica"),
(NULL,"Filipa Alves","1982-03-06","f","Almada"),
(NULL,"Guilherme Silva","1982-01-30","m","Trafaria"),
(NULL,"Hugo Marques","1981-11-28","m","Almada"),
(NULL,"Isabel Santos","1982-09-05","f","Trafaria"),
(NULL,"Jose Carlos","1982-06-21","m","Almada"),
(NULL,"Luisa Alves","1981-12-05","f","Caparica"),
(NULL,"Luis Pedro","1980-03-20","m","Almada"),
(NULL,"Miguel Carmo","1982-02-03","m","Caparica"),
(NULL,"Marta Franco","1980-03-18","f","Almada"),
(NULL,"Nuno Borges","1982-01-14","m","Almada"),
(NULL,"Paula Silva","1982-10-22","f","Almada"),
(NULL,"Pedro Amaral","1981-06-05","m","Lisboa"),
(NULL,"Rui Lima","1981-09-20","m","Almada"),
(NULL,"Rute Marques","1982-04-07","f","Almada"),
(NULL,"Sandra Sousa","1981-05-29","f","Lisboa"),
(NULL,"Tania Louro","1981-01-01","f","Almada"),
(NULL,"Teresa Rego","1981-04-21","f","Lisboa"),
(NULL,"Vania Semedo","1981-08-04","f","Almada"),
(NULL,"Vitor Branco","1981-07-11","m","Caparica"),
(NULL,"Ana Castro","1982-06-12","f","Almada"),
(NULL,"Belisa Capucho","1981-02-14","f","Almada"),
(NULL,"Helena Vaz","1982-09-10","f","Lisboa"),
(NULL,"Andre Lago","1982-11-15","m","Almada");

insert into Cursos values
(NULL,"Ciencias"),
(NULL,"Economia"),
(NULL,"Artes"),
(NULL,"Letras");

insert into Disciplinas values
(NULL,"Portugues-B",10,3),
(NULL,"Portugues-B",11,3),
(NULL,"Portugues-B",12,3),
(NULL,"Portugues-A",10,5),
(NULL,"Portugues-A",11,5),
(NULL,"Portugues-A",12,5),
(NULL,"Filosofia",10,3),
(NULL,"Filosofia",11,3),
(NULL,"Matematica",10,4),
(NULL,"Matematica",11,4),
(NULL,"Matematica",12,5),
(NULL,"Fisico-Quimica",10,4),
(NULL,"Fisico-Quimica",11,4),
(NULL,"Fisica",12,4),
(NULL,"Quimica",12,4),
(NULL,"Economia",10,3),
(NULL,"Economia",11,3),
(NULL,"Geografia",10,4),
(NULL,"Geografia",11,4),
(NULL,"Desenho",10,3),
(NULL,"Desenho",11,3),
(NULL,"Desenho",12,3),
(NULL,"Geometria Descritiva",10,4),
(NULL,"Geometria Descritiva",11,4),
(NULL,"Historia",10,4),
(NULL,"Historia",11,4),
(NULL,"Historia",12,5);

insert into Professores Values 
(NULL,"Antónia Campos","1960-05-20","f"),
(NULL,"Bruno Pires","1971-12-21","m"),
(NULL,"Carlos Silva","1972-07-12","m"),
(NULL,"Duarte Santos","1962-05-01","m"),
(NULL,"Eliana Vaz","1952-02-28","f"),
(NULL,"Filipa Peres","1966-06-16","f"),
(NULL,"Guilherme Vasco","1971-11-21","m"),
(NULL,"Hugo Veloso","1974-10-08","m"),
(NULL,"Isabel Santos","1962-05-15","f"),
(NULL,"Jose Antonio","1972-04-11","m"),
(NULL,"Manuela Damas","1959-09-12","f"),
(NULL,"Luzia Lourenco","1961-06-12","f"),
(NULL,"Julio Reis","1963-03-07","m");

insert into Professores_Disciplinas values
(1,1,2006),
(1,2,2006),
(2,3,2006),
(2,4,2006),
(2,5,2006),
(3,6,2006),
(4,7,2006),
(4,8,2006),
(5,9,2006),
(5,10,2006),
(6,11,2006),
(7,12,2006),
(7,13,2006),
(7,14,2006),
(8,15,2006),
(9,16,2006),
(9,17,2006),
(10,18,2006),
(10,19,2006),
(12,20,2006),
(12,21,2006),
(13,22,2006),
(13,23,2006),
(12,24,2006),
(11,25,2006),
(11,26,2006),
(11,27,2006);

insert into Cursos_Disciplinas values
(1,1),
(1,2),
(1,3),
(2,1),
(2,2),
(2,3),
(3,1),
(3,2),
(3,3),
(4,4),
(4,5),
(4,6),
(1,7),
(1,8),
(2,7),
(2,8),
(3,7),
(3,8),
(4,7),
(4,8),
(1,9),
(1,10),
(1,11),
(2,9),
(2,10),
(2,11),
(1,12),
(1,13),
(3,12),
(3,13),
(1,14),
(1,15),
(2,16),
(2,17),
(3,18),
(3,19),
(4,18),
(4,19),
(3,20),
(3,21),
(3,22),
(3,23),
(3,24),
(4,25),
(4,26),
(4,27),
(2,27);

insert into Matriculas values
(1,1,2006,0),
(1,7,2006,0),
(1,9,2006,0),
(1,12,2006,0),
(2,1,2006,0),
(2,7,2006,0),
(2,9,2006,0),
(2,12,2006,0),
(3,2,2006,0),
(3,8,2006,0),
(3,10,2006,0),
(3,13,2006,0),
(4,2,2006,0),
(4,8,2006,0),
(4,10,2006,0),
(4,13,2006,0),
(5,2,2006,0),
(5,8,2006,0),
(5,10,2006,0),
(5,13,2006,0),
(6,3,2006,0),
(6,11,2006,0),
(6,14,2006,0),
(6,15,2006,0),
(7,3,2006,0),
(7,11,2006,0),
(7,14,2006,0),
(7,15,2006,0),
(8,1,2006,0),
(8,7,2006,0),
(8,16,2006,0),
(8,18,2006,0),
(9,1,2006,0),
(9,7,2006,0),
(9,16,2006,0),
(9,18,2006,0),
(10,1,2006,0),
(10,7,2006,0),
(10,16,2006,0),
(10,18,2006,0),
(11,2,2006,0),
(11,8,2006,0),
(11,17,2006,0),
(11,19,2006,0),
(12,2,2006,0),
(12,8,2006,0),
(12,17,2006,0),
(12,19,2006,0),
(13,2,2006,0),
(13,8,2006,0),
(13,17,2006,0),
(13,19,2006,0),
(14,3,2006,0),
(14,11,2006,0),
(14,27,2006,0),
(15,3,2006,0),
(15,11,2006,0),
(15,27,2006,0),
(16,3,2006,0),
(16,11,2006,0),
(16,27,2006,0),
(17,1,2006,0),
(17,7,2006,0),
(17,20,2006,0),
(17,23,2006,0),
(18,1,2006,0),
(18,7,2006,0),
(18,20,2006,0),
(18,23,2006,0),
(19,2,2006,0),
(19,8,2006,0),
(19,21,2006,0),
(19,24,2006,0),
(20,2,2006,0),
(20,8,2006,0),
(20,21,2006,0),
(20,24,2006,0),
(21,2,2006,0),
(21,8,2006,0),
(21,21,2006,0),
(21,24,2006,0),
(22,3,2006,0),
(22,19,2006,0),
(23,4,2006,0),
(23,7,2006,0),
(23,18,2006,0),
(23,22,2006,0),
(24,4,2006,0),
(24,7,2006,0),
(24,18,2006,0),
(24,22,2006,0),
(25,4,2006,0),
(25,7,2006,0),
(25,18,2006,0),
(25,22,2006,0),
(26,5,2006,0),
(26,8,2006,0),
(26,19,2006,0),
(26,23,2006,0),
(27,5,2006,0),
(27,8,2006,0),
(27,19,2006,0),
(27,23,2006,0),
(28,6,2006,0),
(28,24,2006,0);