-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Temps de generació: 06-10-2022 a les 14:00:52
-- Versió del servidor: 10.4.24-MariaDB
-- Versió de PHP: 8.1.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de dades: `universidad2`
--
CREATE DATABASE IF NOT EXISTS `universidad2` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `universidad2`;

DELIMITER $$
--
-- Procediments
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `profes2` (IN `genero` CHAR, OUT `n_profes` INT)   begin
select count(sexo) from persona WHERE sexo = genero and tipo = 'profesor' GROUP BY(sexo) into n_profes; 
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `profes_1_pr` (IN `genero` CHAR)   begin
select count(id) as profes from persona where sexo = genero and tipo = 'profesor' GROUP BY sexo;
end$$

DELIMITER ;

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

--
-- Estructura de la taula `alumno_se_matricula_asignatura`
--

CREATE TABLE `alumno_se_matricula_asignatura` (
  `id_alumno` int(10) UNSIGNED NOT NULL,
  `id_asignatura` int(10) UNSIGNED NOT NULL,
  `id_curso_escolar` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Bolcament de dades per a la taula `alumno_se_matricula_asignatura`
--

INSERT INTO `alumno_se_matricula_asignatura` (`id_alumno`, `id_asignatura`, `id_curso_escolar`) VALUES
(1, 1, 1),
(1, 2, 1),
(1, 3, 1),
(2, 1, 1),
(2, 2, 1),
(2, 3, 1),
(3, 16, 3),
(3, 16, 4),
(3, 16, 5),
(4, 1, 1),
(4, 2, 1),
(4, 3, 1),
(4, 16, 3),
(4, 16, 4),
(4, 16, 5),
(5, 16, 3),
(5, 16, 4),
(5, 16, 5),
(19, 1, 5),
(19, 2, 5),
(19, 3, 5),
(19, 4, 5),
(19, 5, 5),
(19, 6, 5),
(19, 7, 5),
(19, 8, 5),
(19, 9, 5),
(19, 10, 5),
(21, 16, 3),
(21, 16, 4),
(21, 16, 5),
(22, 16, 3),
(22, 16, 4),
(23, 1, 5),
(23, 2, 5),
(23, 3, 5),
(23, 4, 5),
(23, 5, 5),
(23, 6, 5),
(23, 7, 5),
(23, 8, 5),
(23, 9, 5),
(23, 10, 5),
(23, 16, 3),
(23, 16, 5),
(24, 1, 5),
(24, 2, 5),
(24, 3, 5),
(24, 4, 5),
(24, 5, 5),
(24, 6, 5),
(24, 7, 5),
(24, 8, 5),
(24, 9, 5),
(24, 10, 5),
(24, 16, 2),
(24, 16, 3),
(25, 4, 3),
(25, 7, 1),
(26, 25, 3),
(26, 3, 4),
(27, 25, 4),
(27, 1, 2),
(27, 5, 1),
(28, 14, 2),
(28, 8, 5),
(29, 25, 4),
(29, 1, 2),
(29, 12, 2),
(30, 23, 3),
(30, 19, 2),
(31, 7, 1),
(31, 5, 5),
(31, 2, 4),
(32, 10, 2),
(32, 20, 2),
(32, 6, 3),
(33, 25, 2),
(33, 21, 1),
(34, 19, 5),
(34, 9, 5),
(34, 6, 4),
(34, 13, 2),
(35, 10, 4),
(35, 19, 1),
(35, 14, 4),
(35, 4, 1),
(36, 15, 3),
(36, 10, 1),
(36, 20, 3),
(37, 6, 4),
(37, 16, 4),
(37, 22, 2),
(38, 1, 3),
(38, 21, 2),
(39, 1, 4),
(39, 13, 5),
(39, 18, 5),
(40, 5, 4),
(40, 3, 4),
(40, 14, 2),
(40, 6, 2),
(41, 5, 4),
(41, 24, 4),
(41, 8, 5),
(41, 6, 2),
(42, 15, 3),
(42, 23, 4),
(42, 21, 5),
(43, 25, 3),
(43, 5, 1),
(43, 13, 3),
(44, 14, 4),
(44, 4, 1),
(45, 10, 3),
(45, 5, 4),
(45, 24, 3),
(45, 5, 2),
(46, 6, 2),
(46, 7, 3),
(46, 17, 5),
(47, 11, 4),
(47, 22, 2),
(48, 17, 2),
(48, 25, 2),
(49, 11, 4),
(49, 22, 3),
(49, 13, 2),
(49, 16, 4),
(50, 13, 4),
(50, 15, 3),
(50, 4, 1),
(51, 19, 3),
(51, 12, 1),
(51, 8, 3),
(52, 8, 4),
(52, 23, 2),
(52, 1, 4),
(53, 15, 4),
(53, 11, 4),
(53, 25, 2),
(54, 2, 3),
(54, 9, 2),
(54, 22, 3),
(54, 2, 4),
(55, 9, 4),
(55, 12, 3),
(56, 25, 1),
(56, 5, 5),
(56, 18, 1),
(57, 19, 3),
(57, 5, 3),
(57, 6, 2),
(58, 24, 4),
(58, 4, 3),
(58, 20, 2),
(59, 12, 1),
(59, 9, 3),
(59, 4, 3),
(60, 5, 2),
(60, 11, 3),
(60, 11, 5),
(61, 19, 3),
(61, 6, 1),
(62, 4, 4),
(62, 10, 1),
(62, 22, 2),
(62, 3, 3),
(63, 2, 1),
(63, 7, 4),
(63, 24, 1),
(63, 24, 5),
(64, 6, 1),
(64, 23, 4),
(64, 3, 1),
(65, 24, 5),
(65, 2, 5),
(65, 8, 1),
(65, 9, 3),
(66, 19, 2),
(66, 25, 4),
(67, 20, 4),
(67, 17, 4),
(67, 3, 1),
(68, 14, 2),
(68, 7, 3),
(69, 7, 1),
(69, 7, 2),
(70, 15, 3),
(70, 14, 4),
(71, 16, 5),
(71, 18, 3),
(71, 22, 4),
(71, 5, 3),
(72, 6, 1),
(72, 6, 3),
(72, 19, 2),
(73, 2, 1),
(73, 4, 1),
(73, 2, 1),
(73, 23, 4),
(74, 6, 5),
(74, 14, 4),
(74, 18, 1),
(75, 15, 1),
(75, 25, 2),
(75, 13, 3),
(75, 5, 2),
(76, 7, 1),
(76, 8, 3),
(76, 2, 1),
(77, 1, 2),
(77, 7, 1),
(77, 3, 5),
(78, 7, 1),
(78, 11, 2),
(78, 9, 1),
(79, 21, 2),
(79, 18, 3),
(80, 11, 1),
(80, 17, 1),
(80, 1, 2),
(81, 10, 4),
(81, 16, 1),
(82, 1, 1),
(82, 11, 5),
(82, 18, 5),
(82, 6, 4),
(83, 15, 3),
(83, 11, 5),
(83, 13, 5),
(84, 22, 1),
(84, 5, 2),
(85, 18, 1),
(85, 1, 1),
(86, 1, 3),
(86, 2, 3),
(86, 22, 5),
(87, 13, 4),
(87, 25, 3),
(87, 20, 3),
(88, 4, 5),
(88, 15, 1),
(88, 16, 1),
(88, 20, 4),
(89, 7, 3),
(89, 11, 4),
(90, 16, 4),
(90, 6, 2),
(90, 18, 4),
(90, 23, 3),
(91, 1, 4),
(91, 3, 5),
(91, 5, 1),
(92, 1, 5),
(92, 4, 1),
(93, 2, 5),
(93, 3, 3),
(94, 6, 1),
(94, 2, 3),
(95, 17, 3),
(95, 20, 4),
(95, 10, 4),
(95, 14, 3),
(96, 25, 2),
(96, 25, 2),
(96, 8, 2),
(96, 19, 5),
(97, 6, 5),
(97, 10, 5),
(97, 23, 4),
(98, 4, 2),
(98, 10, 4),
(98, 5, 5),
(99, 11, 3),
(99, 6, 4),
(99, 13, 4),
(100, 22, 3),
(100, 21, 2),
(100, 21, 1),
(101, 7, 3),
(101, 19, 4),
(101, 10, 2),
(102, 14, 4),
(102, 16, 1),
(102, 12, 2),
(102, 4, 3),
(103, 10, 5),
(103, 11, 2),
(103, 22, 1),
(103, 11, 4),
(104, 15, 1),
(104, 13, 1),
(104, 8, 3),
(104, 4, 4),
(105, 3, 5),
(105, 6, 4),
(105, 10, 2),
(106, 14, 4),
(106, 2, 1),
(107, 7, 2),
(107, 2, 3),
(107, 9, 1),
(107, 1, 5),
(108, 18, 1),
(108, 4, 2),
(109, 15, 4),
(109, 8, 4),
(109, 12, 4),
(109, 25, 4),
(110, 18, 3),
(110, 23, 4),
(110, 19, 2),
(111, 3, 3),
(111, 19, 4),
(111, 17, 1),
(111, 4, 2),
(112, 7, 1),
(112, 24, 1),
(112, 21, 3),
(113, 7, 5),
(113, 9, 3),
(114, 25, 1),
(114, 3, 4),
(114, 21, 4),
(114, 2, 3),
(115, 16, 2),
(115, 23, 5),
(115, 5, 4),
(115, 10, 2),
(116, 12, 4),
(116, 15, 4),
(116, 23, 5),
(116, 4, 4),
(117, 22, 3),
(117, 8, 3),
(117, 24, 1),
(118, 19, 4),
(118, 18, 5),
(118, 22, 5),
(118, 6, 1),
(119, 13, 1),
(119, 19, 4),
(119, 9, 4),
(120, 2, 4),
(120, 1, 3),
(120, 7, 2),
(120, 1, 1),
(121, 6, 3),
(121, 6, 2),
(121, 6, 1),
(122, 7, 4),
(122, 8, 2),
(122, 20, 2),
(122, 11, 4),
(123, 20, 1),
(123, 6, 2),
(123, 19, 5),
(124, 23, 4),
(124, 6, 1),
(124, 18, 3),
(125, 4, 5),
(125, 10, 3),
(126, 24, 4),
(126, 3, 2),
(127, 3, 4),
(127, 22, 2),
(128, 22, 1),
(128, 25, 5),
(128, 11, 2),
(129, 23, 3),
(129, 23, 3),
(130, 11, 2),
(130, 1, 2),
(130, 6, 4),
(130, 17, 4),
(131, 5, 1),
(131, 13, 5),
(132, 10, 2),
(132, 15, 1),
(132, 25, 4),
(133, 18, 3),
(133, 22, 4),
(133, 17, 2),
(134, 25, 1),
(134, 6, 2),
(134, 9, 3),
(135, 7, 4),
(135, 18, 4),
(135, 19, 2),
(135, 25, 2),
(136, 11, 3),
(136, 1, 2),
(136, 7, 1),
(137, 12, 5),
(137, 6, 3),
(137, 5, 2),
(137, 22, 2),
(138, 21, 3),
(138, 13, 5),
(138, 3, 3),
(138, 5, 5),
(139, 5, 2),
(139, 19, 5),
(140, 4, 4),
(140, 15, 2),
(141, 9, 4),
(141, 18, 5),
(141, 19, 4),
(142, 17, 4),
(142, 16, 2),
(142, 4, 5),
(143, 13, 1),
(143, 1, 1),
(144, 6, 1),
(144, 11, 5),
(144, 12, 2),
(144, 3, 3),
(145, 22, 2),
(145, 1, 1),
(145, 25, 2),
(146, 3, 5),
(146, 8, 4),
(147, 13, 3),
(147, 25, 1),
(147, 12, 3),
(147, 5, 3),
(148, 8, 4),
(148, 16, 4),
(149, 17, 3),
(149, 5, 4),
(149, 18, 4),
(149, 1, 3),
(150, 24, 5),
(150, 14, 4),
(150, 11, 1),
(150, 17, 3),
(151, 1, 1),
(151, 16, 1),
(151, 20, 3),
(151, 9, 1),
(152, 23, 4),
(152, 24, 3),
(152, 11, 4),
(153, 13, 4),
(153, 15, 3),
(153, 13, 5),
(154, 21, 3),
(154, 11, 3),
(154, 8, 2),
(154, 11, 5),
(155, 4, 4),
(155, 18, 1),
(156, 6, 3),
(156, 14, 5),
(156, 23, 4),
(157, 25, 2),
(157, 25, 3),
(157, 19, 4),
(157, 16, 1),
(158, 22, 5),
(158, 1, 5),
(158, 21, 3),
(159, 18, 5),
(159, 22, 2),
(159, 9, 4),
(159, 24, 1),
(160, 18, 1),
(160, 8, 4),
(161, 16, 1),
(161, 20, 5),
(161, 18, 1),
(162, 15, 3),
(162, 21, 5),
(162, 22, 4),
(162, 7, 1),
(163, 24, 1),
(163, 10, 1),
(164, 5, 2),
(164, 21, 3),
(164, 15, 5),
(165, 14, 3),
(165, 2, 3),
(166, 2, 3),
(166, 21, 2),
(167, 5, 3),
(167, 10, 4),
(167, 23, 1),
(167, 14, 1),
(168, 4, 1),
(168, 23, 5),
(169, 21, 3),
(169, 2, 3),
(169, 4, 4),
(169, 10, 1),
(170, 4, 5),
(170, 2, 5),
(171, 7, 3),
(171, 23, 5),
(172, 19, 2),
(172, 18, 1),
(172, 18, 3),
(172, 4, 5),
(173, 17, 4),
(173, 20, 1),
(174, 3, 3),
(174, 2, 3),
(174, 7, 2),
(174, 20, 3),
(175, 3, 4),
(175, 25, 4),
(175, 14, 4),
(176, 21, 5),
(176, 7, 2),
(177, 4, 1),
(177, 3, 1),
(177, 4, 2),
(177, 19, 1),
(178, 8, 3),
(178, 2, 1),
(179, 8, 4),
(179, 21, 1),
(180, 25, 2),
(180, 11, 5),
(181, 21, 3),
(181, 1, 2),
(181, 11, 2),
(182, 25, 4),
(182, 2, 1),
(183, 7, 4),
(183, 3, 2),
(183, 15, 1),
(183, 10, 4),
(184, 21, 3),
(184, 22, 2),
(184, 7, 4),
(185, 24, 2),
(185, 19, 2),
(186, 2, 2),
(186, 4, 3),
(186, 1, 2),
(187, 21, 5),
(187, 14, 3),
(187, 4, 5),
(188, 10, 4),
(188, 12, 4),
(188, 22, 1),
(189, 19, 4),
(189, 21, 1),
(190, 13, 1),
(190, 1, 4),
(191, 5, 5),
(191, 6, 1),
(192, 15, 3),
(192, 20, 4),
(192, 17, 1),
(193, 18, 1),
(193, 23, 5),
(194, 9, 4),
(194, 21, 2),
(195, 3, 4),
(195, 2, 2),
(196, 25, 1),
(196, 4, 5),
(197, 19, 1),
(197, 7, 1),
(198, 16, 1),
(198, 19, 3),
(198, 9, 2),
(199, 13, 5),
(199, 22, 4),
(199, 22, 3),
(199, 22, 1),
(200, 19, 2),
(200, 7, 5),
(200, 17, 1),
(200, 16, 1),
(201, 24, 5),
(201, 22, 5),
(201, 4, 4),
(201, 4, 5),
(202, 4, 4),
(202, 23, 2),
(202, 25, 1),
(203, 22, 1),
(203, 23, 4),
(204, 24, 4),
(204, 7, 3),
(204, 10, 2),
(205, 2, 3),
(205, 23, 1),
(205, 15, 2),
(206, 18, 2),
(206, 2, 1),
(207, 19, 5),
(207, 22, 1),
(207, 5, 3),
(208, 1, 3),
(208, 13, 4),
(209, 14, 4),
(209, 10, 1),
(210, 24, 2),
(210, 11, 1),
(210, 19, 5),
(211, 3, 2),
(211, 10, 2),
(211, 15, 5),
(211, 4, 4),
(212, 5, 2),
(212, 24, 2),
(213, 11, 4),
(213, 22, 4),
(213, 1, 3),
(213, 11, 3),
(214, 18, 4),
(214, 8, 1),
(215, 11, 5),
(215, 4, 4),
(216, 2, 2),
(216, 17, 4),
(216, 15, 2),
(217, 16, 5),
(217, 9, 1),
(217, 13, 3),
(218, 13, 3),
(218, 25, 1),
(219, 5, 1),
(219, 10, 3),
(219, 23, 4),
(219, 21, 1),
(220, 25, 5),
(220, 3, 5),
(221, 16, 5),
(221, 7, 1),
(221, 9, 4),
(221, 20, 5),
(222, 9, 4),
(222, 8, 1),
(223, 5, 1),
(223, 8, 3),
(224, 24, 5),
(224, 21, 3),
(224, 1, 3),
(224, 11, 1),
(225, 17, 3),
(225, 9, 1),
(225, 17, 1),
(226, 17, 5),
(226, 20, 5),
(226, 23, 2),
(227, 10, 2),
(227, 11, 2),
(227, 8, 4),
(227, 7, 2),
(228, 2, 4),
(228, 22, 2),
(229, 9, 3),
(229, 19, 5),
(229, 21, 1),
(229, 21, 2),
(230, 4, 5),
(230, 5, 1),
(230, 16, 5),
(231, 7, 3),
(231, 12, 4),
(231, 3, 5),
(232, 11, 4),
(232, 17, 5),
(232, 12, 1),
(233, 12, 2),
(233, 12, 5),
(234, 23, 2),
(234, 20, 5),
(234, 1, 1),
(235, 23, 5),
(235, 8, 3),
(235, 3, 5),
(235, 9, 2),
(236, 9, 3),
(236, 15, 5),
(236, 19, 5),
(237, 4, 4),
(237, 23, 2),
(237, 10, 3),
(237, 22, 5),
(238, 11, 2),
(238, 11, 3),
(238, 16, 5),
(239, 4, 1),
(239, 21, 2),
(240, 22, 4),
(240, 1, 2),
(241, 8, 2),
(241, 14, 3),
(242, 23, 5),
(242, 17, 3),
(243, 16, 3),
(243, 21, 2),
(243, 21, 4),
(243, 16, 3),
(244, 21, 3),
(244, 24, 2),
(244, 5, 5),
(244, 9, 2),
(245, 15, 1),
(245, 10, 4),
(246, 23, 3),
(246, 7, 2),
(246, 8, 1),
(246, 10, 3),
(247, 10, 1),
(247, 12, 5),
(247, 3, 1),
(247, 17, 4),
(248, 10, 4),
(248, 20, 3),
(248, 3, 5),
(249, 12, 3),
(249, 24, 3),
(250, 11, 2),
(250, 3, 3),
(251, 8, 1),
(251, 14, 2),
(251, 13, 1),
(252, 9, 3),
(252, 2, 2),
(252, 8, 4),
(252, 11, 5),
(253, 18, 2),
(253, 24, 1),
(254, 20, 3),
(254, 7, 2),
(254, 23, 5),
(254, 21, 3),
(255, 22, 4),
(255, 12, 3),
(255, 4, 5),
(256, 14, 3),
(256, 1, 3),
(256, 13, 2),
(257, 15, 1),
(257, 2, 3),
(257, 10, 2),
(257, 9, 2),
(258, 7, 3),
(258, 18, 3),
(258, 16, 4),
(258, 19, 2),
(259, 4, 5),
(259, 4, 1),
(260, 11, 3),
(260, 5, 5),
(261, 18, 3),
(261, 2, 4),
(261, 12, 3),
(261, 21, 4),
(262, 3, 1),
(262, 21, 5),
(262, 5, 2),
(262, 14, 3),
(263, 9, 1),
(263, 12, 1),
(263, 13, 3),
(264, 22, 2),
(264, 20, 3),
(265, 5, 1),
(265, 11, 5),
(265, 9, 2),
(266, 24, 1),
(266, 6, 5),
(266, 4, 3),
(267, 25, 5),
(267, 11, 4),
(268, 15, 1),
(268, 14, 1),
(268, 12, 2),
(268, 20, 3),
(269, 3, 4),
(269, 3, 4),
(269, 19, 2),
(269, 6, 2),
(270, 23, 5),
(270, 24, 4),
(270, 16, 1),
(270, 5, 2),
(271, 11, 2),
(271, 6, 5),
(271, 22, 1),
(271, 14, 5),
(272, 21, 1),
(272, 6, 1),
(272, 13, 5),
(272, 5, 1),
(273, 8, 3),
(273, 9, 2),
(273, 2, 2),
(273, 16, 2),
(274, 7, 4),
(274, 14, 4),
(275, 12, 4),
(275, 22, 3),
(275, 3, 2),
(276, 3, 1),
(276, 4, 3),
(277, 14, 3),
(277, 8, 3),
(278, 22, 3),
(278, 18, 5),
(278, 3, 4),
(278, 8, 2),
(279, 12, 2),
(279, 14, 1),
(280, 21, 2),
(280, 22, 1),
(281, 20, 3),
(281, 6, 1),
(281, 10, 1),
(282, 10, 5),
(282, 3, 2),
(283, 17, 5),
(283, 9, 5),
(283, 3, 1),
(284, 24, 3),
(284, 5, 5),
(284, 6, 5),
(284, 22, 5),
(285, 16, 1),
(285, 16, 4),
(286, 1, 4),
(286, 18, 4),
(286, 14, 2),
(287, 12, 3),
(287, 12, 5),
(287, 5, 3),
(288, 22, 3),
(288, 18, 3),
(288, 6, 5),
(288, 19, 4),
(289, 1, 1),
(289, 13, 3),
(289, 13, 4),
(289, 25, 5),
(290, 18, 2),
(290, 14, 1),
(291, 1, 1),
(291, 14, 5),
(291, 8, 3),
(291, 11, 2),
(292, 18, 4),
(292, 23, 3),
(293, 25, 2),
(293, 24, 2),
(293, 25, 5),
(293, 7, 2),
(294, 22, 2),
(294, 6, 4),
(295, 24, 3),
(295, 14, 3),
(296, 20, 1),
(296, 25, 5),
(296, 19, 3),
(296, 19, 5),
(297, 21, 5),
(297, 2, 4),
(298, 12, 2),
(298, 25, 4),
(298, 15, 3),
(299, 11, 3),
(299, 3, 2),
(299, 14, 3),
(299, 2, 1),
(300, 16, 2),
(300, 21, 5),
(300, 18, 3),
(300, 20, 2),
(301, 13, 2),
(301, 18, 1),
(301, 11, 3),
(301, 20, 3),
(302, 14, 1),
(302, 16, 5),
(303, 7, 4),
(303, 23, 3),
(303, 4, 4),
(303, 25, 1),
(304, 20, 4),
(304, 25, 3),
(305, 25, 5),
(305, 5, 2),
(306, 19, 4),
(306, 13, 1),
(307, 8, 3),
(307, 12, 5),
(308, 20, 5),
(308, 25, 2),
(308, 1, 4),
(308, 21, 4),
(309, 7, 2),
(309, 11, 3),
(310, 6, 2),
(310, 23, 4),
(310, 18, 4),
(310, 7, 4),
(311, 22, 2),
(311, 16, 1),
(311, 22, 4),
(312, 8, 3),
(312, 7, 4),
(312, 18, 4),
(313, 18, 5),
(313, 24, 4),
(314, 23, 3),
(314, 13, 4),
(315, 16, 1),
(315, 13, 5),
(316, 12, 3),
(316, 6, 4),
(316, 5, 3),
(316, 4, 2),
(317, 7, 1),
(317, 4, 3),
(317, 17, 1),
(317, 5, 5),
(318, 23, 5),
(318, 15, 3),
(319, 14, 4),
(319, 18, 5),
(320, 15, 2),
(320, 18, 3),
(320, 13, 1),
(321, 16, 5),
(321, 4, 2),
(322, 9, 2),
(322, 22, 1),
(323, 22, 3),
(323, 3, 4),
(323, 11, 5),
(324, 19, 2),
(324, 5, 3),
(324, 22, 2),
(325, 10, 4),
(325, 5, 4),
(326, 25, 2),
(326, 17, 4),
(327, 7, 3),
(327, 3, 5),
(328, 23, 1),
(328, 7, 2),
(329, 18, 3),
(329, 22, 3),
(330, 9, 1),
(330, 21, 2),
(331, 19, 1),
(331, 2, 4),
(331, 6, 1),
(332, 13, 4),
(332, 21, 1),
(332, 22, 3),
(333, 1, 1),
(333, 14, 2),
(334, 9, 1),
(334, 6, 3),
(334, 20, 4),
(334, 6, 5),
(335, 25, 5),
(335, 11, 4),
(335, 7, 1),
(335, 24, 3),
(336, 23, 1),
(336, 7, 3),
(336, 13, 1),
(336, 23, 5),
(337, 2, 1),
(337, 22, 3),
(337, 18, 2),
(338, 6, 4),
(338, 10, 4),
(338, 13, 5),
(339, 11, 4),
(339, 24, 4),
(339, 12, 4),
(340, 8, 2),
(340, 11, 3),
(341, 5, 1),
(341, 2, 1),
(341, 3, 5),
(342, 23, 2),
(342, 24, 4),
(342, 14, 1),
(343, 24, 3),
(343, 7, 2),
(344, 20, 3),
(344, 25, 3),
(345, 1, 3),
(345, 16, 1),
(345, 7, 4),
(345, 21, 5),
(346, 1, 2),
(346, 20, 3),
(347, 18, 3),
(347, 1, 2),
(347, 15, 4),
(347, 19, 4),
(348, 5, 5),
(348, 19, 2),
(349, 14, 2),
(349, 18, 3),
(350, 11, 1),
(350, 10, 1),
(351, 19, 2),
(351, 15, 4),
(352, 22, 4),
(352, 14, 3),
(352, 1, 2),
(352, 16, 4),
(353, 24, 4),
(353, 3, 3),
(353, 4, 2),
(354, 24, 3),
(354, 18, 2),
(354, 19, 1),
(354, 16, 2),
(355, 24, 2),
(355, 5, 4),
(355, 24, 1),
(356, 16, 3),
(356, 3, 4),
(356, 15, 3),
(357, 6, 2),
(357, 22, 1),
(357, 2, 5),
(357, 20, 3),
(358, 1, 3),
(358, 13, 2),
(359, 22, 4),
(359, 12, 5),
(359, 10, 1),
(360, 21, 1),
(360, 19, 4),
(360, 15, 2),
(361, 4, 3),
(361, 11, 1),
(361, 20, 5),
(361, 14, 5),
(362, 17, 2),
(362, 8, 5),
(362, 9, 4),
(362, 5, 5),
(363, 24, 3),
(363, 11, 1),
(364, 22, 3),
(364, 4, 2),
(364, 22, 4),
(365, 13, 1),
(365, 20, 5),
(365, 8, 4),
(366, 17, 1),
(366, 20, 2),
(366, 12, 2),
(367, 5, 5),
(367, 12, 2),
(368, 16, 1),
(368, 13, 5),
(368, 7, 5),
(369, 14, 5),
(369, 11, 4),
(369, 22, 4),
(369, 22, 4),
(370, 15, 1),
(370, 1, 5),
(371, 18, 4),
(371, 9, 1),
(371, 25, 4),
(371, 3, 2),
(372, 2, 2),
(372, 19, 2),
(372, 25, 3),
(372, 23, 5),
(373, 23, 3),
(373, 1, 4),
(374, 18, 3),
(374, 6, 5),
(375, 9, 5),
(375, 24, 5),
(375, 20, 1),
(375, 7, 2),
(376, 19, 5),
(376, 23, 4),
(376, 10, 2),
(377, 6, 2),
(377, 11, 5),
(378, 1, 5),
(378, 13, 4),
(378, 5, 4),
(378, 3, 3),
(379, 9, 4),
(379, 16, 5),
(379, 4, 3),
(379, 13, 3),
(380, 14, 2),
(380, 22, 4),
(380, 20, 2),
(380, 4, 1),
(381, 23, 1),
(381, 21, 5),
(381, 3, 2),
(382, 21, 4),
(382, 15, 4),
(383, 19, 5),
(383, 11, 1),
(384, 11, 3),
(384, 8, 4),
(385, 25, 4),
(385, 1, 2),
(386, 18, 2),
(386, 7, 2),
(387, 11, 4),
(387, 12, 2),
(387, 17, 5),
(388, 10, 5),
(388, 2, 2),
(388, 13, 1),
(389, 7, 1),
(389, 4, 4),
(389, 14, 4),
(390, 16, 3),
(390, 22, 2),
(390, 6, 4),
(391, 7, 3),
(391, 3, 5),
(391, 10, 1),
(391, 8, 3),
(392, 4, 4),
(392, 5, 1),
(392, 18, 1),
(393, 11, 3),
(393, 6, 5),
(393, 12, 4),
(393, 1, 1),
(394, 8, 3),
(394, 5, 5),
(394, 1, 5),
(395, 2, 1),
(395, 6, 4),
(396, 20, 1),
(396, 21, 2),
(396, 24, 3),
(397, 8, 4),
(397, 3, 3),
(398, 12, 1),
(398, 18, 1),
(398, 20, 4),
(399, 14, 5),
(399, 2, 4),
(400, 4, 5),
(400, 12, 5),
(400, 6, 2),
(401, 6, 5),
(401, 1, 1),
(401, 7, 3),
(402, 14, 3),
(402, 18, 3),
(402, 4, 4),
(403, 17, 5),
(403, 7, 5),
(403, 1, 4),
(404, 23, 1),
(404, 6, 3),
(404, 6, 4),
(405, 12, 4),
(405, 8, 5),
(405, 12, 5),
(405, 19, 5),
(406, 21, 5),
(406, 11, 5),
(406, 1, 4),
(407, 17, 4),
(407, 6, 3),
(408, 17, 2),
(408, 4, 2),
(408, 9, 1),
(409, 10, 5),
(409, 21, 3),
(409, 11, 2),
(410, 12, 1),
(410, 15, 4),
(410, 20, 2),
(411, 24, 2),
(411, 13, 5),
(411, 5, 2),
(412, 21, 2),
(412, 18, 2),
(413, 1, 4),
(413, 7, 3),
(414, 6, 4),
(414, 6, 2),
(415, 22, 2),
(415, 24, 3),
(416, 2, 2),
(416, 10, 1),
(417, 20, 5),
(417, 8, 1),
(418, 10, 2),
(418, 15, 2),
(419, 24, 5),
(419, 12, 2),
(420, 13, 2),
(420, 10, 5),
(420, 23, 2),
(421, 5, 3),
(421, 5, 3),
(422, 8, 1),
(422, 8, 1),
(422, 8, 2),
(422, 3, 1),
(423, 5, 2),
(423, 21, 2),
(423, 20, 2),
(424, 19, 4),
(424, 7, 1),
(424, 2, 2),
(424, 4, 2),
(425, 12, 3),
(425, 5, 5),
(425, 22, 2),
(426, 24, 1),
(426, 22, 3),
(427, 25, 2),
(427, 24, 1),
(427, 21, 5),
(428, 13, 5),
(428, 20, 1),
(428, 23, 4),
(428, 20, 4),
(429, 24, 5),
(429, 24, 3),
(430, 17, 4),
(430, 4, 4),
(430, 22, 5),
(430, 20, 3),
(431, 9, 2),
(431, 4, 3),
(431, 3, 2),
(432, 9, 1),
(432, 17, 1),
(433, 2, 3),
(433, 24, 1),
(433, 5, 4),
(433, 20, 4),
(434, 18, 3),
(434, 23, 5),
(434, 5, 4),
(434, 20, 3),
(435, 17, 2),
(435, 20, 2),
(435, 11, 2),
(435, 6, 4),
(436, 25, 4),
(436, 3, 5),
(437, 11, 5),
(437, 23, 3),
(437, 6, 2),
(437, 25, 5),
(438, 12, 5),
(438, 15, 5),
(439, 13, 2),
(439, 17, 4),
(439, 24, 1),
(439, 18, 5),
(440, 6, 3),
(440, 12, 4),
(440, 10, 5),
(441, 5, 3),
(441, 19, 4),
(441, 6, 5),
(441, 16, 5),
(442, 21, 2),
(442, 4, 5),
(442, 15, 4),
(442, 2, 5),
(443, 18, 2),
(443, 6, 4),
(444, 12, 3),
(444, 3, 1),
(445, 15, 2),
(445, 9, 1),
(445, 11, 2),
(446, 20, 2),
(446, 21, 5),
(446, 14, 1),
(447, 14, 2),
(447, 10, 5),
(448, 9, 1),
(448, 4, 2),
(449, 10, 1),
(449, 6, 1),
(449, 12, 5),
(450, 20, 1),
(450, 19, 5),
(450, 16, 3),
(451, 1, 3),
(451, 14, 2),
(452, 9, 4),
(452, 13, 2),
(452, 20, 1),
(452, 25, 1),
(453, 22, 1),
(453, 15, 4),
(454, 20, 5),
(454, 4, 1),
(454, 1, 2),
(454, 19, 3),
(455, 12, 5),
(455, 15, 5),
(455, 22, 4),
(456, 3, 2),
(456, 7, 4),
(456, 2, 2),
(457, 11, 3),
(457, 25, 1),
(457, 19, 1),
(457, 23, 5),
(458, 16, 3),
(458, 3, 3),
(459, 6, 4),
(459, 6, 5),
(460, 6, 5),
(460, 13, 5),
(460, 19, 1),
(460, 22, 3),
(461, 7, 1),
(461, 25, 1),
(462, 18, 1),
(462, 11, 4),
(462, 19, 1),
(462, 17, 3),
(463, 11, 3),
(463, 25, 4),
(464, 5, 1),
(464, 12, 5),
(465, 3, 1),
(465, 20, 1),
(466, 15, 5),
(466, 11, 1),
(467, 5, 4),
(467, 14, 1),
(467, 12, 3),
(467, 13, 1),
(468, 25, 1),
(468, 16, 1),
(468, 19, 5),
(469, 21, 4),
(469, 23, 1),
(470, 14, 2),
(470, 18, 3),
(470, 25, 4),
(471, 8, 5),
(471, 5, 2),
(471, 12, 1),
(471, 20, 1),
(472, 24, 4),
(472, 4, 5),
(472, 19, 5),
(473, 4, 5),
(473, 14, 1),
(473, 6, 3),
(473, 8, 1),
(474, 10, 4),
(474, 18, 4),
(475, 15, 1),
(475, 4, 1),
(475, 18, 1),
(475, 20, 2),
(476, 17, 3),
(476, 7, 2),
(476, 14, 2),
(476, 1, 4),
(477, 22, 4),
(477, 3, 3),
(477, 24, 4),
(478, 14, 4),
(478, 21, 1),
(478, 3, 4),
(478, 4, 5),
(479, 20, 5),
(479, 5, 3),
(479, 9, 3),
(479, 15, 4),
(480, 22, 1),
(480, 2, 2),
(480, 24, 4),
(481, 20, 4),
(481, 2, 3),
(481, 13, 3),
(481, 12, 5),
(482, 5, 3),
(482, 24, 4),
(482, 15, 1),
(482, 7, 5),
(483, 5, 2),
(483, 3, 5),
(483, 5, 1),
(484, 25, 3),
(484, 21, 4),
(485, 22, 2),
(485, 11, 3),
(485, 2, 1),
(486, 3, 4),
(486, 25, 5),
(487, 9, 3),
(487, 21, 3),
(487, 21, 2),
(488, 11, 4),
(488, 11, 5),
(489, 5, 3),
(489, 7, 5),
(489, 9, 4),
(489, 19, 2),
(490, 6, 2),
(490, 24, 3),
(490, 2, 4),
(491, 8, 4),
(491, 9, 5),
(491, 12, 2),
(492, 12, 5),
(492, 15, 1),
(493, 14, 5),
(493, 23, 4),
(493, 12, 5),
(494, 16, 2),
(494, 3, 1),
(494, 1, 5),
(495, 14, 4),
(495, 7, 2),
(496, 13, 3),
(496, 5, 1),
(496, 4, 5),
(497, 21, 1),
(497, 8, 3),
(497, 11, 5),
(497, 5, 2),
(498, 7, 1),
(498, 3, 1),
(499, 25, 2),
(499, 16, 2),
(499, 21, 4),
(500, 14, 4),
(500, 17, 2),
(500, 7, 2),
(500, 22, 3),
(501, 21, 4),
(501, 19, 5),
(501, 24, 4),
(502, 4, 4),
(502, 21, 1),
(502, 15, 2),
(502, 21, 5),
(503, 24, 5),
(503, 9, 5),
(504, 14, 5),
(504, 20, 5),
(504, 17, 5),
(505, 1, 5),
(505, 12, 4),
(505, 4, 2),
(505, 7, 3),
(506, 14, 1),
(506, 2, 5),
(506, 19, 5),
(507, 8, 4),
(507, 15, 2),
(507, 2, 4),
(507, 21, 1),
(508, 17, 2),
(508, 1, 4),
(508, 13, 5),
(508, 17, 1),
(509, 8, 4),
(509, 20, 4),
(510, 14, 4),
(510, 7, 5),
(510, 11, 5),
(510, 10, 4),
(511, 13, 3),
(511, 6, 3),
(512, 17, 1),
(512, 24, 1),
(512, 2, 4),
(512, 19, 3),
(513, 24, 1),
(513, 21, 4),
(513, 4, 3),
(514, 16, 4),
(514, 8, 1),
(514, 19, 3),
(514, 16, 2),
(515, 21, 4),
(515, 14, 5),
(516, 6, 4),
(516, 20, 2),
(516, 3, 1),
(517, 10, 5),
(517, 14, 2),
(517, 19, 3),
(517, 17, 4),
(518, 18, 1),
(518, 23, 1),
(518, 6, 3),
(519, 18, 3),
(519, 17, 3),
(520, 24, 3),
(520, 21, 2),
(520, 23, 5),
(520, 2, 2),
(521, 18, 4),
(521, 17, 4),
(522, 9, 4),
(522, 15, 2),
(523, 21, 3),
(523, 20, 5),
(523, 19, 3),
(524, 12, 5),
(524, 6, 1),
(524, 2, 2),
(525, 21, 5),
(525, 8, 1),
(525, 23, 5),
(525, 9, 2),
(526, 22, 1),
(526, 3, 5),
(526, 17, 1),
(526, 5, 3),
(527, 20, 5),
(527, 16, 4),
(527, 19, 3),
(528, 15, 2),
(528, 24, 3),
(528, 15, 3),
(529, 3, 3),
(529, 21, 1),
(529, 16, 1),
(530, 24, 5),
(530, 8, 1),
(530, 22, 1),
(531, 23, 2),
(531, 21, 4),
(531, 19, 5),
(531, 24, 1),
(532, 23, 3),
(532, 24, 2),
(532, 22, 4),
(533, 2, 3),
(533, 13, 2),
(533, 20, 5),
(534, 24, 5),
(534, 9, 1),
(534, 11, 4),
(535, 11, 4),
(535, 18, 1),
(535, 18, 3),
(535, 2, 2),
(536, 4, 3),
(536, 17, 5),
(536, 7, 3),
(536, 9, 5),
(537, 12, 1),
(537, 18, 1),
(538, 25, 1),
(538, 23, 2),
(539, 9, 4),
(539, 1, 3),
(540, 9, 3),
(540, 15, 5),
(540, 23, 1),
(541, 8, 3),
(541, 20, 3),
(542, 11, 3),
(542, 7, 5),
(543, 8, 3),
(543, 19, 2),
(543, 8, 2),
(544, 17, 1),
(544, 3, 1),
(545, 12, 5),
(545, 4, 2),
(545, 24, 4),
(545, 21, 4),
(546, 4, 3),
(546, 3, 1),
(546, 17, 5),
(547, 23, 5),
(547, 24, 4),
(547, 16, 1),
(547, 2, 3),
(548, 8, 5),
(548, 1, 3),
(548, 20, 3),
(549, 16, 3),
(549, 15, 4),
(549, 7, 3),
(549, 18, 3),
(550, 23, 4),
(550, 22, 4),
(551, 16, 3),
(551, 14, 5),
(551, 3, 3),
(552, 25, 4),
(552, 15, 5),
(552, 13, 3),
(552, 25, 2),
(553, 9, 1),
(553, 6, 2),
(554, 8, 2),
(554, 19, 2),
(554, 4, 3),
(554, 8, 5),
(555, 6, 4),
(555, 24, 4),
(556, 5, 1),
(556, 5, 2),
(557, 24, 3),
(557, 12, 2),
(557, 2, 4),
(557, 20, 2),
(558, 4, 1),
(558, 21, 1),
(559, 11, 1),
(559, 9, 3),
(560, 14, 4),
(560, 20, 4),
(560, 4, 5),
(561, 15, 4),
(561, 6, 3),
(562, 10, 5),
(562, 20, 4),
(562, 14, 1),
(562, 12, 4),
(563, 23, 5),
(563, 18, 2),
(564, 11, 2),
(564, 2, 3),
(564, 19, 4),
(564, 15, 3),
(565, 11, 3),
(565, 5, 3),
(566, 25, 4),
(566, 8, 4),
(566, 2, 1),
(567, 2, 4),
(567, 16, 4),
(567, 19, 2),
(567, 2, 2),
(568, 17, 5),
(568, 14, 5),
(568, 18, 2),
(568, 13, 5),
(569, 15, 4),
(569, 16, 2),
(569, 25, 1),
(570, 21, 5),
(570, 1, 2),
(570, 9, 2),
(570, 9, 2),
(571, 16, 4),
(571, 17, 1),
(571, 25, 5),
(571, 7, 1),
(572, 1, 3),
(572, 25, 1),
(572, 19, 4),
(572, 9, 3),
(573, 7, 3),
(573, 25, 2),
(574, 9, 1),
(574, 17, 5),
(574, 22, 3),
(574, 2, 5),
(575, 4, 1),
(575, 11, 5),
(575, 19, 2),
(575, 22, 5),
(576, 15, 3),
(576, 19, 1),
(577, 16, 2),
(577, 16, 4),
(577, 6, 4),
(577, 22, 4),
(578, 12, 2),
(578, 21, 2),
(579, 3, 1),
(579, 16, 1),
(580, 18, 3),
(580, 16, 5),
(581, 14, 4),
(581, 4, 3),
(581, 8, 4),
(581, 21, 4),
(582, 19, 5),
(582, 21, 2),
(582, 19, 3),
(583, 15, 1),
(583, 7, 4),
(583, 5, 1),
(583, 18, 5),
(584, 24, 3),
(584, 25, 3),
(584, 18, 2),
(585, 1, 2),
(585, 8, 3),
(586, 17, 4),
(586, 6, 2),
(587, 6, 4),
(587, 8, 4),
(588, 22, 1),
(588, 9, 3),
(588, 7, 5),
(588, 14, 2),
(589, 21, 2),
(589, 5, 1),
(590, 8, 5),
(590, 6, 2),
(590, 6, 4),
(590, 1, 5),
(591, 13, 1),
(591, 10, 2),
(592, 13, 1),
(592, 2, 4),
(592, 8, 5),
(592, 10, 4),
(593, 16, 4),
(593, 9, 4),
(594, 2, 1),
(594, 6, 5);

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

--
-- Estructura de la taula `asignatura`
--

CREATE TABLE `asignatura` (
  `id` int(10) UNSIGNED NOT NULL,
  `nombre` varchar(100) NOT NULL,
  `creditos` float UNSIGNED NOT NULL,
  `tipo` int(3) DEFAULT NULL,
  `curso` tinyint(3) UNSIGNED NOT NULL,
  `cuatrimestre` tinyint(3) UNSIGNED NOT NULL,
  `id_profesor` int(10) UNSIGNED DEFAULT NULL,
  `id_grado` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Bolcament de dades per a la taula `asignatura`
--

INSERT INTO `asignatura` (`id`, `nombre`, `creditos`, `tipo`, `curso`, `cuatrimestre`, `id_profesor`, `id_grado`) VALUES
(1, 'Álgegra lineal y matemática discreta', 6, 1, 1, 1, 3, 4),
(2, 'Cálculo', 6, 1, 1, 1, 14, 4),
(3, 'Física para informática', 6, 1, 1, 1, 3, 4),
(4, 'Introducción a la programación', 6, 1, 1, 1, 14, 4),
(5, 'Organización y gestión de empresas', 6, 1, 1, 1, 3, 4),
(6, 'Estadística', 6, 1, 1, 2, 14, 4),
(7, 'Estructura y tecnología de computadores', 6, 1, 1, 2, 3, 4),
(8, 'Fundamentos de electrónica', 6, 1, 1, 2, 14, 4),
(9, 'Lógica y algorítmica', 6, 1, 1, 2, 3, 4),
(10, 'Metodología de la programación', 6, 1, 1, 2, 14, 4),
(11, 'Arquitectura de Computadores', 6, 1, 2, 1, 3, 4),
(12, 'Estructura de Datos y Algoritmos I', 6, 2, 2, 1, 3, 4),
(13, 'Ingeniería del Software', 6, 2, 2, 1, 14, 4),
(14, 'Sistemas Inteligentes', 6, 2, 2, 1, 3, 4),
(15, 'Sistemas Operativos', 6, 2, 2, 1, 14, 4),
(16, 'Bases de Datos', 6, 1, 2, 2, 14, 4),
(17, 'Estructura de Datos y Algoritmos II', 6, 2, 2, 2, 14, 4),
(18, 'Fundamentos de Redes de Computadores', 6, 2, 2, 2, 3, 4),
(19, 'Planificación y Gestión de Proyectos Informáticos', 6, 2, 2, 2, 3, 4),
(20, 'Programación de Servicios Software', 6, 2, 2, 2, 14, 4),
(21, 'Desarrollo de interfaces de usuario', 6, 2, 3, 1, 14, 4),
(22, 'Ingeniería de Requisitos', 6, 3, 3, 1, 12, 4),
(23, 'Integración de las Tecnologías de la Información en las Organizaciones', 6, 3, 3, 1, 6, 4),
(24, 'Modelado y Diseño del Software 1', 6, 3, 3, 1, 9, 4),
(25, 'Multiprocesadores', 6, 3, 3, 1, 4, 4),
(26, 'Seguridad y cumplimiento normativo', 6, 3, 3, 1, NULL, 4),
(27, 'Sistema de Información para las Organizaciones', 6, 3, 3, 1, NULL, 4),
(28, 'Tecnologías web', 6, 3, 3, 1, NULL, 4),
(29, 'Teoría de códigos y criptografía', 6, 3, 3, 1, NULL, 4),
(30, 'Administración de bases de datos', 6, 3, 3, 2, NULL, 4),
(31, 'Herramientas y Métodos de Ingeniería del Software', 6, 3, 3, 2, NULL, 4),
(32, 'Informática industrial y robótica', 6, 3, 3, 2, NULL, 4),
(33, 'Ingeniería de Sistemas de Información', 6, 3, 3, 2, NULL, 4),
(34, 'Modelado y Diseño del Software 2', 6, 3, 3, 2, NULL, 4),
(35, 'Negocio Electrónico', 6, 3, 3, 2, NULL, 4),
(36, 'Periféricos e interfaces', 6, 3, 3, 2, NULL, 4),
(37, 'Sistemas de tiempo real', 6, 3, 3, 2, NULL, 4),
(38, 'Tecnologías de acceso a red', 6, 3, 3, 2, NULL, 4),
(39, 'Tratamiento digital de imágenes', 6, 3, 3, 2, NULL, 4),
(40, 'Administración de redes y sistemas operativos', 6, 3, 4, 1, NULL, 4),
(41, 'Almacenes de Datos', 6, 3, 4, 1, NULL, 4),
(42, 'Fiabilidad y Gestión de Riesgos', 6, 3, 4, 1, NULL, 4),
(43, 'Líneas de Productos Software', 6, 3, 4, 1, NULL, 4),
(44, 'Procesos de Ingeniería del Software 1', 6, 3, 4, 1, NULL, 4),
(45, 'Tecnologías multimedia', 6, 3, 4, 1, NULL, 4),
(46, 'Análisis y planificación de las TI', 6, 3, 4, 2, NULL, 4),
(47, 'Desarrollo Rápido de Aplicaciones', 6, 3, 4, 2, NULL, 4),
(48, 'Gestión de la Calidad y de la Innovación Tecnológica', 6, 3, 4, 2, NULL, 4),
(49, 'Inteligencia del Negocio', 6, 3, 4, 2, NULL, 4),
(50, 'Procesos de Ingeniería del Software 2', 6, 3, 4, 2, NULL, 4),
(51, 'Seguridad Informática', 6, 3, 4, 2, NULL, 4),
(52, 'Biologia celular', 6, 1, 1, 1, NULL, 7),
(53, 'Física', 6, 1, 1, 1, NULL, 7),
(54, 'Matemáticas I', 6, 1, 1, 1, NULL, 7),
(55, 'Química general', 6, 1, 1, 1, NULL, 7),
(56, 'Química orgánica', 6, 1, 1, 1, NULL, 7),
(57, 'Biología vegetal y animal', 6, 1, 1, 2, NULL, 7),
(58, 'Bioquímica', 6, 1, 1, 2, NULL, 7),
(59, 'Genética', 6, 1, 1, 2, NULL, 7),
(60, 'Matemáticas II', 6, 1, 1, 2, NULL, 7),
(61, 'Microbiología', 6, 1, 1, 2, NULL, 7),
(62, 'Botánica agrícola', 6, 2, 2, 1, NULL, 7),
(63, 'Fisiología vegetal', 6, 2, 2, 1, NULL, 7),
(64, 'Genética molecular', 6, 2, 2, 1, NULL, 7),
(65, 'Ingeniería bioquímica', 6, 2, 2, 1, NULL, 7),
(66, 'Termodinámica y cinética química aplicada', 6, 2, 2, 1, NULL, 7),
(67, 'Biorreactores', 6, 2, 2, 2, NULL, 7),
(68, 'Biotecnología microbiana', 6, 2, 2, 2, NULL, 7),
(69, 'Ingeniería genética', 6, 2, 2, 2, NULL, 7),
(70, 'Inmunología', 6, 2, 2, 2, NULL, 7),
(71, 'Virología', 6, 2, 2, 2, NULL, 7),
(72, 'Bases moleculares del desarrollo vegetal', 4.5, 2, 3, 1, NULL, 7),
(73, 'Fisiología animal', 4.5, 2, 3, 1, NULL, 7),
(74, 'Metabolismo y biosíntesis de biomoléculas', 6, 2, 3, 1, NULL, 7),
(75, 'Operaciones de separación', 6, 2, 3, 1, NULL, 7),
(76, 'Patología molecular de plantas', 4.5, 2, 3, 1, NULL, 7),
(77, 'Técnicas instrumentales básicas', 4.5, 2, 3, 1, NULL, 7),
(78, 'Bioinformática', 4.5, 2, 3, 2, NULL, 7),
(79, 'Biotecnología de los productos hortofrutículas', 4.5, 2, 3, 2, NULL, 7),
(80, 'Biotecnología vegetal', 6, 2, 3, 2, NULL, 7),
(81, 'Genómica y proteómica', 4.5, 2, 3, 2, NULL, 7),
(82, 'Procesos biotecnológicos', 6, 2, 3, 2, NULL, 7),
(83, 'Técnicas instrumentales avanzadas', 4.5, 2, 3, 2, NULL, 7);

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

--
-- Estructura de la taula `curso_escolar`
--

CREATE TABLE `curso_escolar` (
  `id` int(10) UNSIGNED NOT NULL,
  `anyo_inicio` year(4) NOT NULL,
  `anyo_fin` year(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Bolcament de dades per a la taula `curso_escolar`
--

INSERT INTO `curso_escolar` (`id`, `anyo_inicio`, `anyo_fin`) VALUES
(1, 2014, 2015),
(2, 2015, 2016),
(3, 2016, 2017),
(4, 2017, 2018),
(5, 2018, 2019);

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

--
-- Estructura de la taula `departamento`
--

CREATE TABLE `departamento` (
  `id` int(10) UNSIGNED NOT NULL,
  `nombre` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Bolcament de dades per a la taula `departamento`
--

INSERT INTO `departamento` (`id`, `nombre`) VALUES
(1, 'Informática'),
(2, 'Matemáticas'),
(3, 'Economía y Empresa'),
(4, 'Educación'),
(5, 'Agronomía'),
(6, 'Química y Física'),
(7, 'Filología'),
(8, 'Derecho'),
(9, 'Biología y Geología');

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

--
-- Estructura de la taula `grado`
--

CREATE TABLE `grado` (
  `id` int(10) UNSIGNED NOT NULL,
  `nombre` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Bolcament de dades per a la taula `grado`
--

INSERT INTO `grado` (`id`, `nombre`) VALUES
(1, 'Grado en Ingeniería Agrícola (Plan 2015)'),
(2, 'Grado en Ingeniería Eléctrica (Plan 2014)'),
(3, 'Grado en Ingeniería Electrónica Industrial (Plan 2010)'),
(4, 'Grado en Ingeniería Informática (Plan 2015)'),
(5, 'Grado en Ingeniería Mecánica (Plan 2010)'),
(6, 'Grado en Ingeniería Química Industrial (Plan 2010)'),
(7, 'Grado en Biotecnología (Plan 2015)'),
(8, 'Grado en Ciencias Ambientales (Plan 2009)'),
(9, 'Grado en Matemáticas (Plan 2010)'),
(10, 'Grado en Química (Plan 2009)');

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

--
-- Estructura de la taula `persona`
--

CREATE TABLE `persona` (
  `id` int(10) UNSIGNED NOT NULL,
  `nif` varchar(9) DEFAULT NULL,
  `nombre` varchar(25) NOT NULL,
  `apellido1` varchar(50) NOT NULL,
  `ciudad` varchar(25) NOT NULL,
  `fecha_nacimiento` varchar(10) NOT NULL,
  `sexo` enum('H','M') NOT NULL,
  `casado` enum('N','S') NOT NULL DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Bolcament de dades per a la taula `persona`
--

INSERT INTO `persona` (`id`, `nif`, `nombre`, `apellido1`, `ciudad`, `fecha_nacimiento`, `sexo`, `casado`) VALUES
(1, '26902806', 'Salvador', 'Sánchez', 'Almería', '1991-03-28', 'H', 'N'),
(2, '89542419', 'Juan', 'Saez', 'Barcelona', '1992-08-08', 'H', 'N'),
(4, '17105885', 'Pedro', 'Heller', 'Barcelona', '2000-10-05', 'H', 'S'),
(6, '04233869', 'José', 'Koss', 'Bilbao', '1998-01-28', 'M', 'N'),
(7, '97258166', 'Ismael', 'Strosin', 'Almería', '1999-05-24', 'H', 'N'),
(9, '82842571', 'Ramón', 'Herzog', 'Bilbao', '1996-11-21', 'H', 'N'),
(11, '46900725', 'Daniel', 'Herman', 'Almería', '1997-04-26', 'H', 'N'),
(19, '11578526', 'Inma', 'Lakin', 'Almería', '1998-09-01', 'M', 'N'),
(21, '79089577', 'Juan', 'Gutiérrez', 'Bilbao', '1998-01-01', 'H', 'N'),
(22, '41491230', 'Antonio', 'Domínguez', 'Barcelona', '1999-02-11', 'H', 'N'),
(23, '64753215', 'Irene', 'Hernández', 'Almería', '1996-03-12', 'M', 'N'),
(24, '30096020', 'Sonia', 'Gea', 'Bilbao', '1995-09-04', 'M', 'S'),
(25, '66914430', 'MARY', 'SMITH', 'Madrid', '2000-01-07', 'H', 'N'),
(26, '11308328', 'PATRICIA', 'JOHNSON', 'Barcelona', '1999-05-08', 'H', 'N'),
(27, '14509365', 'LINDA', 'WILLIAMS', 'Bilbao', '1993-06-01', 'H', 'N'),
(28, '32217631', 'BARBARA', 'JONES', 'Barcelona', '1997-06-10', 'H', 'S'),
(29, '14932190', 'ELIZABETH', 'BROWN', 'New York', '2004-05-10', 'H', 'N'),
(30, '19688176', 'JENNIFER', 'DAVIS', 'Madrid', '2004-08-08', 'M', 'N'),
(31, '21542373', 'MARIA', 'MILLER', 'New York', '1992-11-09', 'H', 'N'),
(32, '65109286', 'SUSAN', 'WILSON', 'Barcelona', '2002-01-01', 'H', 'S'),
(33, '91939576', 'MARGARET', 'MOORE', 'Bilbao', '1997-09-02', 'H', 'N'),
(34, '31429423', 'DOROTHY', 'TAYLOR', 'Barcelona', '1998-09-01', 'H', 'N'),
(35, '35981138', 'LISA', 'ANDERSON', 'Madrid', '2000-03-12', 'H', 'N'),
(36, '30191694', 'NANCY', 'THOMAS', 'Bilbao', '1995-07-09', 'M', 'S'),
(37, '26034012', 'KAREN', 'JACKSON', 'Albacete', '2001-06-07', 'H', 'N'),
(38, '58781599', 'BETTY', 'WHITE', 'Barcelona', '1991-10-02', 'H', 'N'),
(39, '19697097', 'HELEN', 'HARRIS', 'Bilbao', '1999-05-07', 'H', 'N'),
(40, '76624773', 'SANDRA', 'MARTIN', 'Madrid', '2002-08-08', 'H', 'S'),
(41, '41715948', 'DONNA', 'THOMPSON', 'Soria', '2001-03-04', 'H', 'N'),
(42, '46069364', 'CAROL', 'GARCIA', 'Bilbao', '2002-04-01', 'M', 'N'),
(43, '69846792', 'RUTH', 'MARTINEZ', 'Mallorca', '1993-12-07', 'H', 'N'),
(44, '93667666', 'SHARON', 'ROBINSON', 'Barcelona', '1992-02-01', 'H', 'S'),
(45, '33463787', 'MICHELLE', 'CLARK', 'Madrid', '1992-02-04', 'H', 'N'),
(46, '32054112', 'LAURA', 'RODRIGUEZ', 'Barcelona', '2003-01-11', 'H', 'N'),
(47, '77023739', 'SARAH', 'LEWIS', 'Mollerussa', '1990-08-08', 'H', 'N'),
(48, '20311140', 'KIMBERLY', 'LEE', 'Bilbao', '1990-09-06', 'M', 'S'),
(49, '24332990', 'DEBORAH', 'WALKER', 'Huesca', '1994-12-07', 'H', 'N'),
(50, '67315160', 'JESSICA', 'HALL', 'Madrid', '1996-05-12', 'H', 'N'),
(51, '39723337', 'SHIRLEY', 'ALLEN', 'Bilbao', '1998-06-07', 'H', 'N'),
(52, '22424700', 'CYNTHIA', 'YOUNG', 'Barcelona', '1999-02-04', 'H', 'S'),
(53, '64086198', 'ANGELA', 'HERNANDEZ', 'París', '1990-07-04', 'H', 'N'),
(54, '41271511', 'MELISSA', 'KING', 'Bilbao', '1993-03-09', 'M', 'N'),
(55, '26793736', 'BRENDA', 'WRIGHT', 'Madrid', '1991-12-10', 'H', 'N'),
(56, '13713061', 'AMY', 'LOPEZ', 'Barcelona', '1996-02-07', 'H', 'S'),
(57, '70194538', 'ANNA', 'HILL', 'Bilbao', '1991-07-05', 'H', 'N'),
(58, '82265966', 'REBECCA', 'SCOTT', 'Barcelona', '1999-12-04', 'H', 'N'),
(59, '84207517', 'VIRGINIA', 'GREEN', 'Sabadell', '1999-10-10', 'H', 'N'),
(60, '89415465', 'KATHLEEN', 'ADAMS', 'Madrid', '1996-10-07', 'M', 'S'),
(61, '80727519', 'PAMELA', 'BAKER', 'Sabadell', '1994-12-10', 'H', 'N'),
(62, '63344460', 'MARTHA', 'GONZALEZ', 'Barcelona', '1990-01-04', 'H', 'N'),
(63, '57908881', 'DEBRA', 'NELSON', 'Bilbao', '1996-02-05', 'H', 'N'),
(64, '52239521', 'AMANDA', 'CARTER', 'Barcelona', '1998-08-01', 'H', 'S'),
(65, '29458598', 'STEPHANIE', 'MITCHELL', 'Madrid', '2002-03-08', 'H', 'N'),
(66, '52618067', 'CAROLYN', 'PEREZ', 'Bilbao', '1995-12-10', 'M', 'N'),
(67, '16416991', 'CHRISTINE', 'ROBERTS', 'Sabadell', '1992-12-10', 'H', 'N'),
(68, '28283827', 'MARIE', 'TURNER', 'Barcelona', '2003-09-11', 'H', 'S'),
(69, '43031573', 'JANET', 'PHILLIPS', 'Bilbao', '2000-07-06', 'H', 'N'),
(70, '99126955', 'CATHERINE', 'CAMPBELL', 'Madrid', '1993-01-06', 'H', 'N'),
(71, '11658554', 'FRANCES', 'PARKER', 'Sabadell', '1998-03-05', 'H', 'N'),
(72, '98464455', 'ANN', 'EVANS', 'Bilbao', '1997-08-11', 'M', 'S'),
(73, '66206920', 'JOYCE', 'EDWARDS', 'Sabadell', '2003-02-01', 'H', 'N'),
(74, '72152638', 'DIANE', 'COLLINS', 'Barcelona', '1997-06-10', 'H', 'N'),
(75, '22442564', 'ALICE', 'STEWART', 'Madrid', '2002-05-10', 'H', 'N'),
(76, '23482626', 'JULIE', 'SANCHEZ', 'Barcelona', '1992-10-06', 'H', 'S'),
(77, '25025373', 'HEATHER', 'MORRIS', 'Sabadell', '1996-03-08', 'H', 'N'),
(78, '85208887', 'TERESA', 'ROGERS', 'Bilbao', '2002-04-01', 'M', 'N'),
(79, '78184270', 'DORIS', 'REED', 'Sabadell', '2000-10-09', 'H', 'N'),
(80, '98485237', 'GLORIA', 'COOK', 'Madrid', '1998-06-08', 'H', 'S'),
(81, '90033686', 'EVELYN', 'MORGAN', 'Bilbao', '1992-02-11', 'H', 'N'),
(82, '35052751', 'JEAN', 'BELL', 'Barcelona', '2004-01-08', 'H', 'N'),
(83, '72761258', 'CHERYL', 'MURPHY', 'Sabadell', '1994-03-09', 'H', 'N'),
(84, '46721425', 'MILDRED', 'BAILEY', 'Bilbao', '1995-10-02', 'M', 'S'),
(85, '55125221', 'KATHERINE', 'RIVERA', 'Madrid', '1996-08-12', 'H', 'N'),
(86, '79275092', 'JOAN', 'COOPER', 'Barcelona', '1990-09-06', 'H', 'N'),
(87, '81232506', 'ASHLEY', 'RICHARDSON', 'Bilbao', '1998-09-06', 'H', 'N'),
(88, '32011813', 'JUDITH', 'COX', 'Barcelona', '1997-09-07', 'H', 'S'),
(89, '66253192', 'ROSE', 'HOWARD', 'Sabadell', '1996-04-06', 'H', 'N'),
(90, '92907235', 'JANICE', 'WARD', 'Madrid', '2002-05-07', 'M', 'N'),
(91, '97118827', 'KELLY', 'TORRES', 'Sabadell', '2001-09-08', 'H', 'N'),
(92, '34042416', 'NICOLE', 'PETERSON', 'Barcelona', '2004-09-12', 'H', 'S'),
(93, '74415223', 'JUDY', 'GRAY', 'Bilbao', '2004-01-07', 'H', 'N'),
(94, '46312037', 'CHRISTINA', 'RAMIREZ', 'Barcelona', '1998-07-06', 'H', 'N'),
(95, '12509613', 'KATHY', 'JAMES', 'Madrid', '1995-03-05', 'H', 'N'),
(96, '89578935', 'THERESA', 'WATSON', 'Bilbao', '1997-04-03', 'M', 'S'),
(97, '68652035', 'BEVERLY', 'BROOKS', 'Sabadell', '2004-09-12', 'H', 'N'),
(98, '62642147', 'DENISE', 'KELLY', 'Barcelona', '1997-06-08', 'H', 'N'),
(99, '68947194', 'TAMMY', 'SANDERS', 'Bilbao', '1990-01-07', 'H', 'N'),
(100, '43742447', 'IRENE', 'PRICE', 'Madrid', '1995-02-03', 'H', 'S'),
(103, '35433234', 'RACHEL', 'BARNES', 'Sabadell', '2004-12-02', 'H', 'N'),
(104, '98056009', 'MARILYN', 'ROSS', 'Barcelona', '1991-09-05', 'H', 'S'),
(105, '29326084', 'ANDREA', 'HENDERSON', 'Madrid', '1999-03-04', 'H', 'N'),
(106, '73048842', 'KATHRYN', 'COLEMAN', 'Barcelona', '1991-10-10', 'H', 'N'),
(107, '66999052', 'LOUISE', 'JENKINS', 'Sabadell', '1990-01-10', 'H', 'N'),
(108, '64277644', 'SARA', 'PERRY', 'Bilbao', '2001-08-07', 'M', 'S'),
(109, '26949315', 'ANNE', 'POWELL', 'Sabadell', '1994-11-08', 'H', 'N'),
(110, '37661523', 'JACQUELINE', 'LONG', 'Madrid', '1998-08-07', 'H', 'N'),
(111, '50749877', 'WANDA', 'PATTERSON', 'Bilbao', '2002-12-07', 'H', 'N'),
(112, '50033162', 'BONNIE', 'HUGHES', 'Barcelona', '1990-02-05', 'H', 'S'),
(113, '89919663', 'JULIA', 'FLORES', 'Sabadell', '1992-02-03', 'H', 'N'),
(114, '59747368', 'RUBY', 'WASHINGTON', 'Bilbao', '2000-03-12', 'M', 'N'),
(115, '31578741', 'LOIS', 'BUTLER', 'Madrid', '1993-05-04', 'H', 'N'),
(116, '56905939', 'TINA', 'SIMMONS', 'Barcelona', '1995-11-03', 'H', 'S'),
(117, '28146930', 'PHYLLIS', 'FOSTER', 'Bilbao', '1992-11-07', 'H', 'N'),
(118, '67899212', 'NORMA', 'GONZALES', 'Barcelona', '1999-12-04', 'H', 'N'),
(119, '97607155', 'PAULA', 'BRYANT', 'Sabadell', '1997-02-06', 'H', 'N'),
(120, '49782289', 'DIANA', 'ALEXANDER', 'Madrid', '1998-02-08', 'M', 'S'),
(121, '41307189', 'ANNIE', 'RUSSELL', 'Sabadell', '2002-11-04', 'H', 'N'),
(122, '50341629', 'LILLIAN', 'GRIFFIN', 'Barcelona', '2003-04-11', 'H', 'N'),
(123, '35569871', 'EMILY', 'DIAZ', 'Bilbao', '2002-09-11', 'H', 'N'),
(124, '72261417', 'ROBIN', 'HAYES', 'Barcelona', '2004-04-01', 'H', 'S'),
(125, '36958256', 'PEGGY', 'MYERS', 'Madrid', '1993-08-02', 'H', 'N'),
(126, '80476017', 'CRYSTAL', 'FORD', 'Bilbao', '2004-03-06', 'M', 'N'),
(127, '24938579', 'GLADYS', 'HAMILTON', 'Sabadell', '2002-12-09', 'H', 'N'),
(128, '19249749', 'RITA', 'GRAHAM', 'Barcelona', '2000-11-11', 'H', 'S'),
(129, '74016360', 'DAWN', 'SULLIVAN', 'Bilbao', '2001-01-09', 'H', 'N'),
(130, '83136424', 'CONNIE', 'WALLACE', 'Madrid', '1992-05-06', 'H', 'N'),
(131, '60389521', 'FLORENCE', 'WOODS', 'Sabadell', '2001-02-03', 'H', 'N'),
(132, '40755733', 'TRACY', 'COLE', 'Bilbao', '2004-06-04', 'M', 'S'),
(133, '89683073', 'EDNA', 'WEST', 'Sabadell', '1995-07-06', 'H', 'N'),
(134, '21636769', 'TIFFANY', 'JORDAN', 'Barcelona', '1997-09-01', 'H', 'N'),
(135, '42588619', 'CARMEN', 'OWENS', 'Madrid', '2003-12-06', 'H', 'N'),
(136, '23284091', 'ROSA', 'REYNOLDS', 'Barcelona', '1990-02-12', 'H', 'S'),
(137, '56369408', 'CINDY', 'FISHER', 'Sabadell', '1997-09-11', 'H', 'N'),
(138, '51173863', 'GRACE', 'ELLIS', 'Bilbao', '1991-02-01', 'M', 'N'),
(139, '38416465', 'WENDY', 'HARRISON', 'Sabadell', '1998-07-11', 'H', 'N'),
(140, '63794330', 'VICTORIA', 'GIBSON', 'Madrid', '1994-09-09', 'H', 'S'),
(141, '65097494', 'EDITH', 'MCDONALD', 'Bilbao', '1997-09-07', 'H', 'N'),
(142, '13303389', 'KIM', 'CRUZ', 'Barcelona', '1994-08-12', 'H', 'N'),
(143, '61312898', 'SHERRY', 'MARSHALL', 'Sabadell', '2001-12-03', 'H', 'N'),
(144, '60682874', 'SYLVIA', 'ORTIZ', 'Bilbao', '2001-01-01', 'M', 'S'),
(145, '88543695', 'JOSEPHINE', 'GOMEZ', 'Madrid', '1994-07-05', 'H', 'N'),
(146, '38138955', 'THELMA', 'MURRAY', 'Barcelona', '2003-03-10', 'H', 'N'),
(147, '73361991', 'SHANNON', 'FREEMAN', 'Bilbao', '1999-12-12', 'H', 'N'),
(148, '23019928', 'SHEILA', 'WELLS', 'Barcelona', '1992-10-04', 'H', 'S'),
(149, '85267740', 'ETHEL', 'WEBB', 'Sabadell', '1995-04-01', 'H', 'N'),
(150, '54843388', 'ELLEN', 'SIMPSON', 'Madrid', '2001-05-02', 'M', 'N'),
(151, '80308678', 'ELAINE', 'STEVENS', 'Sabadell', '2001-04-01', 'H', 'N'),
(152, '46764440', 'MARJORIE', 'TUCKER', 'Barcelona', '2004-04-04', 'H', 'S'),
(153, '23933076', 'CARRIE', 'PORTER', 'Bilbao', '1990-06-01', 'H', 'N'),
(154, '97494665', 'CHARLOTTE', 'HUNTER', 'Barcelona', '2000-12-12', 'H', 'N'),
(155, '78062083', 'MONICA', 'HICKS', 'Madrid', '2004-06-07', 'H', 'N'),
(156, '66591350', 'ESTHER', 'CRAWFORD', 'Bilbao', '2000-11-11', 'M', 'S'),
(157, '49741581', 'PAULINE', 'HENRY', 'Sabadell', '2000-10-04', 'H', 'N'),
(158, '41203407', 'EMMA', 'BOYD', 'Barcelona', '1997-08-09', 'H', 'N'),
(159, '86018172', 'JUANITA', 'MASON', 'Bilbao', '1999-12-06', 'H', 'N'),
(160, '64304028', 'ANITA', 'MORALES', 'Madrid', '1993-01-06', 'H', 'S'),
(161, '30159019', 'RHONDA', 'KENNEDY', 'Sabadell', '2004-07-11', 'H', 'N'),
(162, '11777628', 'HAZEL', 'WARREN', 'Bilbao', '1991-12-10', 'M', 'N'),
(163, '32375576', 'AMBER', 'DIXON', 'Sabadell', '1990-11-01', 'H', 'N'),
(164, '74869575', 'EVA', 'RAMOS', 'Barcelona', '1995-03-04', 'H', 'S'),
(165, '19204757', 'DEBBIE', 'REYES', 'Madrid', '2003-06-09', 'H', 'N'),
(166, '59638492', 'APRIL', 'BURNS', 'Barcelona', '1996-06-09', 'H', 'N'),
(167, '47631296', 'LESLIE', 'GORDON', 'Sabadell', '1994-05-08', 'H', 'N'),
(168, '34463165', 'CLARA', 'SHAW', 'Bilbao', '2002-05-06', 'M', 'S'),
(169, '84212054', 'LUCILLE', 'HOLMES', 'Sabadell', '1999-03-04', 'H', 'N'),
(170, '29708930', 'JAMIE', 'RICE', 'Madrid', '1991-09-01', 'H', 'N'),
(171, '91303230', 'JOANNE', 'ROBERTSON', 'Bilbao', '1991-12-10', 'H', 'N'),
(172, '24416279', 'ELEANOR', 'HUNT', 'Barcelona', '1998-03-12', 'H', 'S'),
(173, '83944607', 'VALERIE', 'BLACK', 'Sabadell', '1990-06-01', 'H', 'N'),
(174, '80927263', 'DANIELLE', 'DANIELS', 'Bilbao', '1995-11-11', 'M', 'N'),
(175, '21383099', 'MEGAN', 'PALMER', 'Madrid', '1990-03-09', 'H', 'N'),
(176, '87985062', 'ALICIA', 'MILLS', 'Barcelona', '2000-10-09', 'H', 'S'),
(177, '96795072', 'SUZANNE', 'NICHOLS', 'Bilbao', '1992-03-08', 'H', 'N'),
(178, '13382914', 'MICHELE', 'GRANT', 'Barcelona', '1993-11-11', 'H', 'N'),
(179, '56618186', 'GAIL', 'KNIGHT', 'Sabadell', '1991-11-11', 'H', 'N'),
(180, '24551112', 'BERTHA', 'FERGUSON', 'Madrid', '1999-08-06', 'M', 'S'),
(181, '11533354', 'DARLENE', 'ROSE', 'Sabadell', '1991-09-06', 'H', 'N'),
(182, '12429804', 'VERONICA', 'STONE', 'Barcelona', '1992-01-02', 'H', 'N'),
(183, '55044226', 'JILL', 'HAWKINS', 'Bilbao', '2004-11-01', 'H', 'N'),
(184, '14771359', 'ERIN', 'DUNN', 'Barcelona', '1993-03-09', 'H', 'S'),
(185, '27435088', 'GERALDINE', 'PERKINS', 'Madrid', '1990-07-06', 'H', 'N'),
(186, '71588194', 'LAUREN', 'HUDSON', 'Bilbao', '2004-12-04', 'M', 'N'),
(187, '21598613', 'CATHY', 'SPENCER', 'Sabadell', '1998-08-06', 'H', 'N'),
(188, '83804282', 'JOANN', 'GARDNER', 'Barcelona', '2003-04-11', 'H', 'S'),
(189, '74764386', 'LORRAINE', 'STEPHENS', 'Bilbao', '2003-10-11', 'H', 'N'),
(190, '31295384', 'LYNN', 'PAYNE', 'Madrid', '1991-10-04', 'H', 'N'),
(191, '78231263', 'SALLY', 'PIERCE', 'Sabadell', '1992-06-11', 'H', 'N'),
(192, '68083271', 'REGINA', 'BERRY', 'Bilbao', '1997-08-01', 'M', 'S'),
(193, '95319883', 'ERICA', 'MATTHEWS', 'Sabadell', '2004-11-09', 'H', 'N'),
(194, '87519213', 'BEATRICE', 'ARNOLD', 'Barcelona', '2000-05-12', 'H', 'N'),
(195, '35196518', 'DOLORES', 'WAGNER', 'Madrid', '1990-12-02', 'H', 'N'),
(196, '91289994', 'BERNICE', 'WILLIS', 'Barcelona', '1994-10-12', 'H', 'S'),
(197, '33726462', 'AUDREY', 'RAY', 'Sabadell', '1993-07-01', 'H', 'N'),
(198, '22112014', 'YVONNE', 'WATKINS', 'Bilbao', '1991-04-10', 'M', 'N'),
(199, '52765713', 'ANNETTE', 'OLSON', 'Sabadell', '1991-09-09', 'H', 'N'),
(204, '65206501', 'STACY', 'CUNNINGHAM', 'Bilbao', '1992-09-10', 'M', 'S'),
(205, '39427058', 'ANA', 'BRADLEY', 'Madrid', '1990-12-05', 'H', 'N'),
(206, '81878713', 'RENEE', 'LANE', 'Barcelona', '1994-09-02', 'H', 'N'),
(207, '45707959', 'IDA', 'ANDREWS', 'Bilbao', '1996-03-06', 'H', 'N'),
(208, '74505496', 'VIVIAN', 'RUIZ', 'Barcelona', '1999-05-10', 'H', 'S'),
(209, '33945513', 'ROBERTA', 'HARPER', 'Sabadell', '1999-06-09', 'H', 'N'),
(210, '85914721', 'HOLLY', 'FOX', 'Madrid', '2004-08-03', 'M', 'N'),
(211, '91118591', 'BRITTANY', 'RILEY', 'Sabadell', '1993-11-03', 'H', 'N'),
(212, '67697602', 'MELANIE', 'ARMSTRONG', 'Barcelona', '2000-07-02', 'H', 'S'),
(213, '58164771', 'LORETTA', 'CARPENTER', 'Bilbao', '2004-12-09', 'H', 'N'),
(214, '30063773', 'YOLANDA', 'WEAVER', 'Barcelona', '2002-03-07', 'H', 'N'),
(215, '45263284', 'JEANETTE', 'GREENE', 'Madrid', '2003-03-04', 'H', 'N'),
(216, '95814945', 'LAURIE', 'LAWRENCE', 'Bilbao', '2001-10-04', 'M', 'S'),
(217, '64699835', 'KATIE', 'ELLIOTT', 'Sabadell', '2002-06-12', 'H', 'N'),
(218, '12431964', 'KRISTEN', 'CHAVEZ', 'Barcelona', '1999-11-01', 'H', 'N'),
(219, '65123045', 'VANESSA', 'SIMS', 'Bilbao', '2001-12-05', 'H', 'N'),
(220, '41302857', 'ALMA', 'AUSTIN', 'Madrid', '2003-09-05', 'H', 'S'),
(221, '59113030', 'SUE', 'PETERS', 'Sabadell', '2000-03-11', 'H', 'N'),
(222, '49492400', 'ELSIE', 'KELLEY', 'Bilbao', '1992-09-04', 'M', 'N'),
(223, '12114208', 'BETH', 'FRANKLIN', 'Sabadell', '1992-07-03', 'H', 'N'),
(224, '23948045', 'JEANNE', 'LAWSON', 'Barcelona', '1999-09-10', 'H', 'S'),
(225, '91063038', 'VICKI', 'FIELDS', 'Madrid', '1999-05-08', 'H', 'N'),
(226, '98482754', 'CARLA', 'GUTIERREZ', 'Barcelona', '2002-02-02', 'H', 'N'),
(227, '87033455', 'TARA', 'RYAN', 'Sabadell', '1990-08-04', 'H', 'N'),
(228, '39407107', 'ROSEMARY', 'SCHMIDT', 'Bilbao', '2004-08-09', 'M', 'S'),
(229, '60527759', 'EILEEN', 'CARR', 'Sabadell', '1991-02-03', 'H', 'N'),
(230, '19779740', 'TERRI', 'VASQUEZ', 'Madrid', '2000-02-08', 'H', 'N'),
(231, '77017950', 'GERTRUDE', 'CASTILLO', 'Bilbao', '1990-12-05', 'H', 'N'),
(232, '46094547', 'LUCY', 'WHEELER', 'Barcelona', '2003-07-04', 'H', 'S'),
(233, '55276279', 'TONYA', 'CHAPMAN', 'Sabadell', '1997-09-08', 'H', 'N'),
(234, '66583650', 'ELLA', 'OLIVER', 'Bilbao', '1996-02-07', 'M', 'N'),
(235, '74424809', 'STACEY', 'MONTGOMERY', 'Madrid', '1996-06-02', 'H', 'N'),
(236, '14712201', 'WILMA', 'RICHARDS', 'Barcelona', '1991-04-02', 'H', 'S'),
(237, '52989173', 'GINA', 'WILLIAMSON', 'Bilbao', '1994-06-09', 'H', 'N'),
(238, '85931333', 'KRISTIN', 'JOHNSTON', 'Barcelona', '1995-11-03', 'H', 'N'),
(239, '44569854', 'JESSIE', 'BANKS', 'Sabadell', '2003-08-10', 'H', 'N'),
(240, '28216935', 'NATALIE', 'MEYER', 'Madrid', '1991-06-10', 'M', 'S'),
(241, '37562779', 'AGNES', 'BISHOP', 'Sabadell', '1992-12-10', 'H', 'N'),
(242, '89085901', 'VERA', 'MCCOY', 'Barcelona', '1992-12-11', 'H', 'N'),
(243, '36452991', 'WILLIE', 'HOWELL', 'Bilbao', '1998-09-01', 'H', 'N'),
(244, '44468207', 'CHARLENE', 'ALVAREZ', 'Barcelona', '1996-06-04', 'H', 'S'),
(245, '71075782', 'BESSIE', 'MORRISON', 'Madrid', '1996-04-08', 'H', 'N'),
(246, '54029901', 'DELORES', 'HANSEN', 'Bilbao', '1991-07-02', 'M', 'N'),
(247, '81282465', 'MELINDA', 'FERNANDEZ', 'Sabadell', '1991-08-06', 'H', 'N'),
(248, '93855432', 'PEARL', 'GARZA', 'Barcelona', '1991-04-06', 'H', 'S'),
(249, '44199167', 'ARLENE', 'HARVEY', 'Bilbao', '2000-03-10', 'H', 'N'),
(250, '77017787', 'MAUREEN', 'LITTLE', 'Madrid', '1997-03-05', 'H', 'N'),
(251, '60585217', 'COLLEEN', 'BURTON', 'Sabadell', '1991-08-04', 'H', 'N'),
(252, '63341598', 'ALLISON', 'STANLEY', 'Bilbao', '1999-01-08', 'M', 'S'),
(253, '44144078', 'TAMARA', 'NGUYEN', 'Sabadell', '1999-04-12', 'H', 'N'),
(254, '40617948', 'JOY', 'GEORGE', 'Barcelona', '2003-05-12', 'H', 'N'),
(255, '33005208', 'GEORGIA', 'JACOBS', 'Madrid', '1991-03-03', 'H', 'N'),
(256, '36388450', 'CONSTANCE', 'REID', 'Barcelona', '1992-05-06', 'H', 'S'),
(257, '23445821', 'LILLIE', 'KIM', 'Sabadell', '2003-04-10', 'H', 'N'),
(258, '99173537', 'CLAUDIA', 'FULLER', 'Bilbao', '1990-03-02', 'M', 'N'),
(259, '43359101', 'JACKIE', 'LYNCH', 'Sabadell', '1999-05-02', 'H', 'N'),
(260, '62315129', 'MARCIA', 'DEAN', 'Madrid', '2004-03-03', 'H', 'S'),
(261, '49548288', 'TANYA', 'GILBERT', 'Bilbao', '1992-01-06', 'H', 'N'),
(262, '84941523', 'NELLIE', 'GARRETT', 'Barcelona', '1996-01-02', 'H', 'N'),
(263, '50629635', 'MINNIE', 'ROMERO', 'Sabadell', '1997-08-03', 'H', 'N'),
(264, '29428308', 'MARLENE', 'WELCH', 'Bilbao', '1997-10-05', 'M', 'S'),
(265, '70962465', 'HEIDI', 'LARSON', 'Madrid', '1996-03-07', 'H', 'N'),
(266, '58762470', 'GLENDA', 'FRAZIER', 'Barcelona', '1999-01-05', 'H', 'N'),
(267, '52438217', 'LYDIA', 'BURKE', 'Bilbao', '2004-02-06', 'H', 'N'),
(268, '90622628', 'VIOLA', 'HANSON', 'Barcelona', '1998-05-04', 'H', 'S'),
(269, '98733046', 'COURTNEY', 'DAY', 'Sabadell', '1996-10-03', 'H', 'N'),
(270, '92572585', 'MARIAN', 'MENDOZA', 'Madrid', '1992-11-03', 'M', 'N'),
(271, '86063184', 'STELLA', 'MORENO', 'Sabadell', '1991-02-07', 'H', 'N'),
(272, '38254872', 'CAROLINE', 'BOWMAN', 'Barcelona', '1997-09-02', 'H', 'S'),
(273, '99207890', 'DORA', 'MEDINA', 'Bilbao', '1991-06-07', 'H', 'N'),
(274, '80112311', 'JO', 'FOWLER', 'Barcelona', '2004-06-07', 'H', 'N'),
(275, '53673231', 'VICKIE', 'BREWER', 'Madrid', '1995-01-04', 'H', 'N'),
(276, '47338774', 'MATTIE', 'HOFFMAN', 'Bilbao', '1994-01-07', 'M', 'S'),
(277, '23815575', 'TERRY', 'CARLSON', 'Sabadell', '1994-08-05', 'H', 'N'),
(278, '42118433', 'MAXINE', 'SILVA', 'Barcelona', '2000-05-10', 'H', 'N'),
(279, '25027362', 'IRMA', 'PEARSON', 'Bilbao', '1995-03-07', 'H', 'N'),
(280, '98979199', 'MABEL', 'HOLLAND', 'Madrid', '1995-12-09', 'H', 'S'),
(281, '22598264', 'MARSHA', 'DOUGLAS', 'Sabadell', '2002-09-10', 'H', 'N'),
(282, '19971737', 'MYRTLE', 'FLEMING', 'Bilbao', '1992-07-08', 'M', 'N'),
(283, '98269900', 'LENA', 'JENSEN', 'Sabadell', '1991-03-03', 'H', 'N'),
(284, '66724121', 'CHRISTY', 'VARGAS', 'Barcelona', '1992-05-03', 'H', 'S'),
(285, '87178296', 'DEANNA', 'BYRD', 'Madrid', '1998-01-12', 'H', 'N'),
(286, '23533320', 'PATSY', 'DAVIDSON', 'Barcelona', '2003-09-09', 'H', 'N'),
(287, '31881653', 'HILDA', 'HOPKINS', 'Sabadell', '1990-06-12', 'H', 'N'),
(288, '84157841', 'GWENDOLYN', 'MAY', 'Bilbao', '2003-04-12', 'M', 'S'),
(289, '41142642', 'JENNIE', 'TERRY', 'Sabadell', '2002-02-07', 'H', 'N'),
(290, '14347290', 'NORA', 'HERRERA', 'Madrid', '1994-08-04', 'H', 'N'),
(291, '13975993', 'MARGIE', 'WADE', 'Bilbao', '1998-11-10', 'H', 'N'),
(292, '57872925', 'NINA', 'SOTO', 'Barcelona', '1991-04-12', 'H', 'S'),
(293, '68939093', 'CASSANDRA', 'WALTERS', 'Sabadell', '2004-01-09', 'H', 'N'),
(294, '26648417', 'LEAH', 'CURTIS', 'Bilbao', '1993-02-10', 'M', 'N'),
(295, '19198629', 'PENNY', 'NEAL', 'Madrid', '1996-04-12', 'H', 'N'),
(296, '30612265', 'KAY', 'CALDWELL', 'Barcelona', '1990-05-08', 'H', 'S'),
(297, '73452256', 'PRISCILLA', 'LOWE', 'Bilbao', '1999-02-04', 'H', 'N'),
(298, '92864903', 'NAOMI', 'JENNINGS', 'Barcelona', '2001-03-11', 'H', 'N'),
(299, '88215329', 'CAROLE', 'BARNETT', 'Sabadell', '1992-07-09', 'H', 'N'),
(300, '80859982', 'BRANDY', 'GRAVES', 'Madrid', '2004-07-08', 'M', 'S'),
(301, '31862437', 'OLGA', 'JIMENEZ', 'Sabadell', '1997-08-10', 'H', 'N'),
(302, '94139740', 'BILLIE', 'HORTON', 'Barcelona', '1992-05-11', 'H', 'N'),
(303, '62467256', 'DIANNE', 'SHELTON', 'Bilbao', '1997-03-02', 'H', 'N'),
(304, '89425545', 'TRACEY', 'BARRETT', 'Barcelona', '2001-03-01', 'H', 'S'),
(305, '40365189', 'LEONA', 'OBRIEN', 'Madrid', '1995-07-01', 'H', 'N'),
(306, '86222801', 'JENNY', 'CASTRO', 'Bilbao', '1994-11-08', 'M', 'N'),
(307, '60091505', 'FELICIA', 'SUTTON', 'Sabadell', '2001-06-03', 'H', 'N'),
(308, '96231129', 'SONIA', 'GREGORY', 'Barcelona', '1992-08-11', 'H', 'S'),
(309, '47409989', 'MIRIAM', 'MCKINNEY', 'Bilbao', '1993-09-10', 'H', 'N'),
(310, '37269934', 'VELMA', 'LUCAS', 'Madrid', '1993-07-01', 'H', 'N'),
(311, '57708515', 'BECKY', 'MILES', 'Sabadell', '1998-08-07', 'H', 'N'),
(312, '44247699', 'BOBBIE', 'CRAIG', 'Bilbao', '1993-06-10', 'M', 'S'),
(313, '98652411', 'VIOLET', 'RODRIQUEZ', 'Sabadell', '1992-05-05', 'H', 'N'),
(314, '70953163', 'KRISTINA', 'CHAMBERS', 'Barcelona', '2000-01-11', 'H', 'N'),
(315, '21222298', 'TONI', 'HOLT', 'Madrid', '1999-06-05', 'H', 'N'),
(316, '66607248', 'MISTY', 'LAMBERT', 'Barcelona', '1991-10-08', 'H', 'S'),
(317, '29165041', 'MAE', 'FLETCHER', 'Sabadell', '1998-02-07', 'H', 'N'),
(318, '15028005', 'SHELLY', 'WATTS', 'Bilbao', '1993-05-11', 'M', 'N'),
(319, '18509942', 'DAISY', 'BATES', 'Sabadell', '2004-11-10', 'H', 'N'),
(320, '29165607', 'RAMONA', 'HALE', 'Madrid', '2000-01-04', 'H', 'S'),
(321, '20268728', 'SHERRI', 'RHODES', 'Bilbao', '1997-04-12', 'H', 'N'),
(322, '26106777', 'ERIKA', 'PENA', 'Barcelona', '1993-08-10', 'H', 'N'),
(323, '62036257', 'JAMES', 'GANNON', 'Sabadell', '2002-06-11', 'H', 'N'),
(324, '91532734', 'JOHN', 'FARNSWORTH', 'Bilbao', '1990-12-08', 'M', 'S'),
(325, '37196349', 'ROBERT', 'BAUGHMAN', 'Madrid', '1998-07-10', 'H', 'N'),
(326, '57889592', 'MICHAEL', 'SILVERMAN', 'Barcelona', '2003-01-10', 'H', 'N'),
(327, '52261391', 'WILLIAM', 'SATTERFIELD', 'Bilbao', '1991-10-09', 'H', 'N'),
(328, '35797571', 'DAVID', 'ROYAL', 'Barcelona', '1999-07-09', 'H', 'S'),
(329, '77713205', 'RICHARD', 'MCCRARY', 'Sabadell', '1997-01-02', 'H', 'N'),
(330, '62363957', 'CHARLES', 'KOWALSKI', 'Madrid', '1991-10-12', 'M', 'N'),
(331, '45473955', 'JOSEPH', 'JOY', 'Sabadell', '1991-04-03', 'H', 'N'),
(332, '32249302', 'THOMAS', 'GRIGSBY', 'Barcelona', '1997-07-07', 'H', 'S'),
(333, '42527093', 'CHRISTOPHER', 'GRECO', 'Bilbao', '1993-09-03', 'H', 'N'),
(334, '11703791', 'DANIEL', 'CABRAL', 'Barcelona', '1999-01-08', 'H', 'N'),
(335, '24609452', 'PAUL', 'TROUT', 'Madrid', '1991-10-11', 'H', 'N'),
(336, '13234938', 'MARK', 'RINEHART', 'Bilbao', '1998-11-08', 'M', 'S'),
(337, '16889111', 'DONALD', 'MAHON', 'Sabadell', '1992-03-12', 'H', 'N'),
(338, '28523187', 'GEORGE', 'LINTON', 'Barcelona', '2002-09-01', 'H', 'N'),
(339, '98977986', 'KENNETH', 'GOODEN', 'Bilbao', '1997-02-01', 'H', 'N'),
(340, '60106077', 'STEVEN', 'CURLEY', 'Madrid', '2004-07-09', 'H', 'S'),
(341, '43384044', 'EDWARD', 'BAUGH', 'Sabadell', '1995-01-05', 'H', 'N'),
(342, '59213801', 'BRIAN', 'WYMAN', 'Bilbao', '1995-05-12', 'M', 'N'),
(343, '43295173', 'RONALD', 'WEINER', 'Sabadell', '1991-09-02', 'H', 'N'),
(344, '36831271', 'ANTHONY', 'SCHWAB', 'Barcelona', '1990-07-08', 'H', 'S'),
(345, '93171842', 'KEVIN', 'SCHULER', 'Madrid', '1990-12-07', 'H', 'N'),
(346, '46233601', 'JASON', 'MORRISSEY', 'Barcelona', '1995-05-07', 'H', 'N'),
(347, '31685743', 'MATTHEW', 'MAHAN', 'Sabadell', '2003-09-11', 'H', 'N'),
(348, '70149217', 'GARY', 'COY', 'Bilbao', '1994-08-09', 'M', 'S'),
(349, '57167389', 'TIMOTHY', 'BUNN', 'Sabadell', '1996-07-03', 'H', 'N'),
(350, '28285229', 'JOSE', 'ANDREW', 'Madrid', '1999-06-03', 'H', 'N'),
(351, '34483540', 'LARRY', 'THRASHER', 'Bilbao', '1996-09-02', 'H', 'N'),
(352, '69073117', 'JEFFREY', 'SPEAR', 'Barcelona', '1997-08-03', 'H', 'S'),
(353, '54745900', 'FRANK', 'WAGGONER', 'Sabadell', '1995-01-11', 'H', 'N'),
(354, '70533436', 'SCOTT', 'SHELLEY', 'Bilbao', '2002-09-10', 'M', 'N'),
(355, '30471722', 'ERIC', 'ROBERT', 'Madrid', '2003-12-12', 'H', 'N'),
(356, '62277421', 'STEPHEN', 'QUALLS', 'Barcelona', '1992-10-12', 'H', 'S'),
(357, '42159657', 'ANDREW', 'PURDY', 'Bilbao', '1999-08-04', 'H', 'N'),
(358, '47504588', 'RAYMOND', 'MCWHORTER', 'Barcelona', '1997-08-06', 'H', 'N'),
(359, '78361929', 'GREGORY', 'MAULDIN', 'Sabadell', '1998-01-06', 'H', 'N'),
(360, '48929823', 'JOSHUA', 'MARK', 'Madrid', '1993-01-12', 'M', 'S'),
(361, '52165346', 'JERRY', 'JORDON', 'Sabadell', '1993-12-10', 'H', 'N'),
(362, '48096366', 'DENNIS', 'GILMAN', 'Barcelona', '1995-05-01', 'H', 'N'),
(363, '27502606', 'WALTER', 'PERRYMAN', 'Bilbao', '1997-11-02', 'H', 'N'),
(364, '60337940', 'PATRICK', 'NEWSOM', 'Barcelona', '1991-04-03', 'H', 'S'),
(365, '86425422', 'PETER', 'MENARD', 'Madrid', '2003-09-04', 'H', 'N'),
(366, '81684145', 'HAROLD', 'MARTINO', 'Bilbao', '1998-06-03', 'M', 'N'),
(367, '94092721', 'DOUGLAS', 'GRAF', 'Sabadell', '1999-01-04', 'H', 'N'),
(368, '95189622', 'HENRY', 'BILLINGSLEY', 'Barcelona', '1999-07-12', 'H', 'S'),
(369, '67026367', 'CARL', 'ARTIS', 'Bilbao', '1999-08-12', 'H', 'N'),
(370, '51314264', 'ARTHUR', 'SIMPKINS', 'Madrid', '1994-05-03', 'H', 'N'),
(371, '38859104', 'RYAN', 'SALISBURY', 'Sabadell', '2003-11-07', 'H', 'N'),
(372, '59899720', 'ROGER', 'QUINTANILLA', 'Bilbao', '1994-04-06', 'M', 'S'),
(373, '77643678', 'JOE', 'GILLILAND', 'Sabadell', '1992-01-06', 'H', 'N'),
(374, '28622912', 'JUAN', 'FRALEY', 'Barcelona', '1996-08-08', 'H', 'N'),
(375, '29366822', 'JACK', 'FOUST', 'Madrid', '1993-04-11', 'H', 'N'),
(376, '66757251', 'ALBERT', 'CROUSE', 'Barcelona', '2003-12-10', 'H', 'S'),
(377, '52462959', 'JONATHAN', 'SCARBOROUGH', 'Sabadell', '2003-11-08', 'H', 'N'),
(378, '60476748', 'JUSTIN', 'NGO', 'Bilbao', '1997-06-06', 'M', 'N'),
(379, '90196325', 'TERRY', 'GRISSOM', 'Sabadell', '1998-01-07', 'H', 'N'),
(380, '99165744', 'GERALD', 'FULTZ', 'Madrid', '2000-03-12', 'H', 'S'),
(381, '32213682', 'KEITH', 'RICO', 'Bilbao', '1994-03-12', 'H', 'N'),
(382, '53375489', 'SAMUEL', 'MARLOW', 'Barcelona', '1992-07-09', 'H', 'N'),
(383, '36934795', 'WILLIE', 'MARKHAM', 'Sabadell', '2000-08-12', 'H', 'N'),
(384, '67189116', 'RALPH', 'MADRIGAL', 'Bilbao', '1999-12-02', 'M', 'S'),
(385, '70908589', 'LAWRENCE', 'LAWTON', 'Madrid', '1999-02-10', 'H', 'N'),
(386, '16025377', 'NICHOLAS', 'BARFIELD', 'Barcelona', '2003-01-04', 'H', 'N'),
(387, '39357402', 'ROY', 'WHITING', 'Bilbao', '1993-03-02', 'H', 'N'),
(388, '98944002', 'BENJAMIN', 'VARNEY', 'Barcelona', '2002-05-11', 'H', 'S'),
(389, '95728676', 'BRUCE', 'SCHWARZ', 'Sabadell', '1994-10-05', 'H', 'N'),
(390, '28557778', 'BRANDON', 'HUEY', 'Madrid', '1996-03-08', 'M', 'N'),
(391, '98599450', 'ADAM', 'GOOCH', 'Sabadell', '2000-07-03', 'H', 'N'),
(392, '18435394', 'HARRY', 'ARCE', 'Barcelona', '1990-07-09', 'H', 'S'),
(393, '40217083', 'FRED', 'WHEAT', 'Bilbao', '1998-12-05', 'H', 'N'),
(394, '52924527', 'WAYNE', 'TRUONG', 'Barcelona', '1994-02-08', 'H', 'N'),
(395, '64222711', 'BILLY', 'POULIN', 'Madrid', '1993-11-04', 'H', 'N'),
(396, '34395655', 'STEVE', 'MACKENZIE', 'Bilbao', '2003-05-06', 'M', 'S'),
(397, '13185760', 'LOUIS', 'LEONE', 'Sabadell', '1999-08-11', 'H', 'N'),
(398, '76958452', 'JEREMY', 'HURTADO', 'Barcelona', '2001-07-01', 'H', 'N'),
(399, '59389719', 'AARON', 'SELBY', 'Bilbao', '2000-11-01', 'H', 'N'),
(400, '95353676', 'RANDY', 'GAITHER', 'Madrid', '1990-10-08', 'H', 'S'),
(401, '81488895', 'HOWARD', 'FORTNER', 'Sabadell', '2000-11-06', 'M', 'N'),
(402, '40693097', 'EUGENE', 'CULPEPPER', 'Bilbao', '1991-11-06', 'M', 'N'),
(403, '19386219', 'CARLOS', 'COUGHLIN', 'Sabadell', '1998-08-05', 'M', 'N'),
(404, '83817472', 'RUSSELL', 'BRINSON', 'Barcelona', '1999-12-01', 'M', 'S'),
(405, '39302937', 'BOBBY', 'BOUDREAU', 'Madrid', '1990-11-10', 'M', 'N'),
(406, '62479246', 'VICTOR', 'BARKLEY', 'Barcelona', '1999-09-06', 'M', 'N'),
(407, '88126482', 'MARTIN', 'BALES', 'Sabadell', '1992-02-10', 'M', 'N'),
(408, '48178531', 'ERNEST', 'STEPP', 'Bilbao', '1994-04-10', 'M', 'S'),
(409, '94319053', 'PHILLIP', 'HOLM', 'Sabadell', '1992-02-08', 'M', 'N'),
(410, '62912294', 'TODD', 'TAN', 'Madrid', '2001-08-11', 'M', 'N'),
(411, '28693350', 'JESSE', 'SCHILLING', 'Bilbao', '1999-09-07', 'M', 'N'),
(412, '18634196', 'CRAIG', 'MORRELL', 'Barcelona', '2000-03-06', 'M', 'S'),
(413, '34316412', 'ALAN', 'KAHN', 'Sabadell', '2002-01-08', 'M', 'N'),
(414, '71201917', 'SHAWN', 'HEATON', 'Bilbao', '2000-11-11', 'M', 'N'),
(415, '48175596', 'CLARENCE', 'GAMEZ', 'Madrid', '1993-09-07', 'M', 'N'),
(416, '71374972', 'SEAN', 'DOUGLASS', 'Barcelona', '1996-12-10', 'M', 'S'),
(417, '16536792', 'PHILIP', 'CAUSEY', 'Bilbao', '1997-12-12', 'M', 'N'),
(418, '86791553', 'CHRIS', 'BROTHERS', 'Barcelona', '1997-06-12', 'M', 'N'),
(419, '48505429', 'JOHNNY', 'TURPIN', 'Sabadell', '1990-08-12', 'M', 'N'),
(420, '15949347', 'EARL', 'SHANKS', 'Madrid', '1998-11-12', 'M', 'S'),
(421, '67245286', 'JIMMY', 'SCHRADER', 'Sabadell', '2001-08-12', 'M', 'N'),
(422, '24041152', 'ANTONIO', 'MEEK', 'Barcelona', '1996-12-06', 'M', 'N'),
(423, '88083998', 'DANNY', 'ISOM', 'Bilbao', '2003-08-12', 'M', 'N'),
(424, '73839448', 'BRYAN', 'HARDISON', 'Barcelona', '1990-10-09', 'M', 'S'),
(425, '55052581', 'TONY', 'CARRANZA', 'Madrid', '2002-05-07', 'M', 'N'),
(426, '65467058', 'LUIS', 'YANEZ', 'Bilbao', '2002-12-08', 'M', 'N'),
(427, '65403084', 'MIKE', 'WAY', 'Sabadell', '2000-06-11', 'M', 'N'),
(428, '81308685', 'STANLEY', 'SCROGGINS', 'Barcelona', '1992-04-04', 'M', 'S'),
(429, '49311519', 'LEONARD', 'SCHOFIELD', 'Bilbao', '1997-12-07', 'M', 'N'),
(430, '74608220', 'NATHAN', 'RUNYON', 'Madrid', '1993-03-05', 'M', 'N'),
(431, '53986574', 'DALE', 'RATCLIFF', 'Sabadell', '1998-01-04', 'M', 'N'),
(432, '28756942', 'MANUEL', 'MURRELL', 'Bilbao', '2002-04-12', 'M', 'S'),
(433, '62175236', 'RODNEY', 'MOELLER', 'Sabadell', '2000-10-10', 'M', 'N'),
(434, '12425625', 'CURTIS', 'IRBY', 'Barcelona', '1993-09-03', 'M', 'N'),
(435, '75737929', 'NORMAN', 'CURRIER', 'Madrid', '1995-12-03', 'M', 'N'),
(436, '11985305', 'ALLEN', 'BUTTERFIELD', 'Barcelona', '2001-07-11', 'M', 'S'),
(437, '45609419', 'MARVIN', 'YEE', 'Sabadell', '1990-02-04', 'M', 'N'),
(438, '47792734', 'VINCENT', 'RALSTON', 'Bilbao', '1990-11-09', 'M', 'N'),
(439, '47862418', 'GLENN', 'PULLEN', 'Sabadell', '1993-12-09', 'M', 'N'),
(440, '83672126', 'JEFFERY', 'PINSON', 'Madrid', '1994-08-07', 'M', 'S'),
(441, '59942709', 'TRAVIS', 'ESTEP', 'Bilbao', '1991-05-07', 'M', 'N'),
(442, '83542562', 'JEFF', 'EAST', 'Barcelona', '1998-03-11', 'M', 'N'),
(443, '78253307', 'CHAD', 'CARBONE', 'Sabadell', '2002-05-10', 'M', 'N'),
(444, '22836654', 'JACOB', 'LANCE', 'Bilbao', '2002-05-09', 'M', 'S'),
(445, '96485315', 'LEE', 'HAWKS', 'Madrid', '2001-07-02', 'M', 'N'),
(446, '64765686', 'MELVIN', 'ELLINGTON', 'Barcelona', '1990-07-01', 'M', 'N'),
(447, '72763385', 'ALFRED', 'CASILLAS', 'Bilbao', '1996-05-11', 'M', 'N'),
(448, '70808619', 'KYLE', 'SPURLOCK', 'Barcelona', '1995-04-07', 'M', 'S'),
(449, '40919794', 'FRANCIS', 'SIKES', 'Sabadell', '1997-10-07', 'M', 'N'),
(450, '67521529', 'BRADLEY', 'MOTLEY', 'Madrid', '1994-11-06', 'M', 'N'),
(451, '16259499', 'JESUS', 'MCCARTNEY', 'Sabadell', '2002-08-10', 'M', 'N'),
(452, '39988799', 'HERBERT', 'KRUGER', 'Barcelona', '2004-05-06', 'M', 'S'),
(453, '13298221', 'FREDERICK', 'ISBELL', 'Bilbao', '1992-05-10', 'M', 'N'),
(454, '83989704', 'RAY', 'HOULE', 'Barcelona', '2004-05-07', 'M', 'N'),
(455, '47555980', 'JOEL', 'FRANCISCO', 'Madrid', '1997-10-10', 'M', 'N'),
(456, '90123703', 'EDWIN', 'BURK', 'Bilbao', '1998-04-02', 'M', 'S'),
(457, '38117342', 'DON', 'BONE', 'Sabadell', '1993-12-01', 'M', 'N'),
(458, '13328231', 'EDDIE', 'TOMLIN', 'Barcelona', '2002-11-01', 'M', 'N'),
(459, '67296699', 'RICKY', 'SHELBY', 'Bilbao', '2000-07-04', 'M', 'N'),
(460, '98667976', 'TROY', 'QUIGLEY', 'Madrid', '2003-05-07', 'M', 'S'),
(461, '88817640', 'RANDALL', 'NEUMANN', 'Sabadell', '1997-07-07', 'M', 'N'),
(462, '40155851', 'BARRY', 'LOVELACE', 'Bilbao', '1995-04-02', 'M', 'N'),
(463, '27546831', 'ALEXANDER', 'FENNELL', 'Sabadell', '1994-04-09', 'M', 'N'),
(464, '49206939', 'BERNARD', 'COLBY', 'Barcelona', '1994-06-02', 'M', 'S'),
(465, '93411818', 'MARIO', 'CHEATHAM', 'Madrid', '1999-01-08', 'M', 'N'),
(466, '91117860', 'LEROY', 'BUSTAMANTE', 'Barcelona', '1992-06-08', 'M', 'N'),
(467, '52525797', 'FRANCISCO', 'SKIDMORE', 'Sabadell', '2001-01-01', 'M', 'N'),
(468, '40925256', 'MARCUS', 'HIDALGO', 'Bilbao', '1990-08-10', 'M', 'S'),
(469, '59977603', 'MICHEAL', 'FORMAN', 'Sabadell', '1995-01-06', 'M', 'N'),
(470, '71124940', 'THEODORE', 'CULP', 'Madrid', '1992-04-03', 'M', 'N'),
(471, '99705131', 'CLIFFORD', 'BOWENS', 'Bilbao', '1991-11-10', 'M', 'N'),
(472, '48365703', 'MIGUEL', 'BETANCOURT', 'Barcelona', '1994-01-09', 'M', 'S'),
(473, '11183084', 'OSCAR', 'AQUINO', 'Sabadell', '1997-07-05', 'M', 'N'),
(474, '48974356', 'JAY', 'ROBB', 'Bilbao', '1998-05-07', 'M', 'N'),
(475, '70215764', 'JIM', 'REA', 'Madrid', '1992-06-02', 'M', 'N'),
(476, '30543451', 'TOM', 'MILNER', 'Barcelona', '1997-06-01', 'M', 'S'),
(477, '27185865', 'CALVIN', 'MARTEL', 'Bilbao', '1990-10-01', 'M', 'N'),
(478, '64953216', 'ALEX', 'GRESHAM', 'Barcelona', '2000-01-08', 'M', 'N'),
(479, '51407740', 'JON', 'WILES', 'Sabadell', '1990-08-10', 'M', 'N'),
(480, '46841394', 'RONNIE', 'RICKETTS', 'Madrid', '1995-10-02', 'M', 'S'),
(481, '89925238', 'BILL', 'GAVIN', 'Sabadell', '1990-01-09', 'M', 'N'),
(482, '16957344', 'LLOYD', 'DOWD', 'Barcelona', '1992-06-08', 'M', 'N'),
(483, '33491815', 'TOMMY', 'COLLAZO', 'Bilbao', '2000-12-01', 'M', 'N'),
(484, '97479525', 'LEON', 'BOSTIC', 'Barcelona', '2002-12-10', 'M', 'S'),
(485, '65558652', 'DEREK', 'BLAKELY', 'Madrid', '1992-06-12', 'M', 'N'),
(486, '40415081', 'WARREN', 'SHERROD', 'Bilbao', '1998-07-02', 'M', 'N'),
(487, '12994484', 'DARRELL', 'POWER', 'Sabadell', '1993-12-08', 'M', 'N'),
(488, '12455611', 'JEROME', 'KENYON', 'Barcelona', '2002-11-02', 'M', 'S'),
(489, '54414180', 'FLOYD', 'GANDY', 'Bilbao', '1992-07-04', 'M', 'N'),
(490, '81628545', 'LEO', 'EBERT', 'Madrid', '1997-01-10', 'M', 'N'),
(491, '38905866', 'ALVIN', 'DELOACH', 'Sabadell', '1990-01-11', 'M', 'N'),
(492, '88653956', 'TIM', 'CARY', 'Bilbao', '1997-01-04', 'M', 'S'),
(493, '62491696', 'WESLEY', 'BULL', 'Sabadell', '1992-01-01', 'M', 'N'),
(494, '89588413', 'GORDON', 'ALLARD', 'Barcelona', '1995-08-11', 'M', 'N'),
(495, '16955705', 'DEAN', 'SAUER', 'Madrid', '1993-05-10', 'M', 'N'),
(496, '35465699', 'GREG', 'ROBINS', 'Barcelona', '1999-07-03', 'M', 'S'),
(497, '54902713', 'JORGE', 'OLIVARES', 'Sabadell', '1998-09-11', 'M', 'N'),
(498, '19063350', 'DUSTIN', 'GILLETTE', 'Bilbao', '1991-09-06', 'M', 'N'),
(499, '33454151', 'PEDRO', 'CHESTNUT', 'Sabadell', '1992-12-03', 'M', 'N'),
(500, '76562494', 'DERRICK', 'BOURQUE', 'Madrid', '1996-03-11', 'M', 'S'),
(501, '79889655', 'DAN', 'PAINE', 'Bilbao', '2002-03-09', 'M', 'N'),
(502, '54404323', 'LEWIS', 'LYMAN', 'Barcelona', '2000-07-02', 'M', 'N'),
(503, '46773161', 'ZACHARY', 'HITE', 'Sabadell', '2001-11-10', 'M', 'N'),
(504, '32807870', 'COREY', 'HAUSER', 'Bilbao', '1998-05-05', 'M', 'S'),
(505, '60463944', 'HERMAN', 'DEVORE', 'Madrid', '1994-03-02', 'M', 'N'),
(506, '31445840', 'MAURICE', 'CRAWLEY', 'Barcelona', '2000-03-07', 'M', 'N'),
(507, '90243957', 'VERNON', 'CHAPA', 'Bilbao', '2000-12-04', 'M', 'N'),
(508, '12297267', 'ROBERTO', 'VU', 'Barcelona', '1996-07-07', 'M', 'S'),
(509, '76274205', 'CLYDE', 'TOBIAS', 'Sabadell', '2004-01-11', 'M', 'N'),
(510, '24953093', 'GLEN', 'TALBERT', 'Madrid', '2004-05-07', 'M', 'N'),
(511, '44595009', 'HECTOR', 'POINDEXTER', 'Sabadell', '2002-09-05', 'M', 'N'),
(512, '58386225', 'SHANE', 'MILLARD', 'Barcelona', '2001-07-10', 'M', 'S'),
(513, '89167726', 'RICARDO', 'MEADOR', 'Bilbao', '1997-12-09', 'M', 'N'),
(514, '84324222', 'SAM', 'MCDUFFIE', 'Barcelona', '1991-01-03', 'M', 'N'),
(515, '98781973', 'RICK', 'MATTOX', 'Madrid', '2001-02-08', 'M', 'N'),
(516, '64985257', 'LESTER', 'KRAUS', 'Bilbao', '1998-01-03', 'M', 'S'),
(517, '11509262', 'BRENT', 'HARKINS', 'Sabadell', '2003-11-06', 'M', 'N'),
(518, '29751556', 'RAMON', 'CHOATE', 'Barcelona', '1998-12-12', 'M', 'N'),
(519, '34762428', 'CHARLIE', 'BESS', 'Bilbao', '2002-07-02', 'M', 'N'),
(520, '50602597', 'TYLER', 'WREN', 'Madrid', '1992-04-07', 'M', 'S'),
(521, '55565708', 'GILBERT', 'SLEDGE', 'Sabadell', '2002-09-07', 'M', 'N'),
(522, '16334534', 'GENE', 'SANBORN', 'Bilbao', '1990-07-12', 'M', 'N'),
(523, '31088442', 'MARC', 'OUTLAW', 'Sabadell', '1995-06-02', 'M', 'N'),
(524, '19311518', 'REGINALD', 'KINDER', 'Barcelona', '1997-09-11', 'M', 'S'),
(525, '11126692', 'RUBEN', 'GEARY', 'Madrid', '2002-03-09', 'M', 'N'),
(526, '97639362', 'BRETT', 'CORNWELL', 'Barcelona', '1992-02-10', 'M', 'N'),
(527, '74368400', 'ANGEL', 'BARCLAY', 'Sabadell', '1991-12-09', 'M', 'N'),
(528, '83922847', 'NATHANIEL', 'ADAM', 'Bilbao', '1991-01-03', 'M', 'S'),
(529, '90437256', 'RAFAEL', 'ABNEY', 'Sabadell', '2001-09-12', 'M', 'N'),
(530, '34113283', 'LESLIE', 'SEWARD', 'Madrid', '1997-01-04', 'M', 'N'),
(531, '60418429', 'EDGAR', 'RHOADS', 'Bilbao', '1992-08-12', 'M', 'N'),
(532, '92287446', 'MILTON', 'HOWLAND', 'Barcelona', '1994-01-11', 'M', 'S'),
(533, '25536248', 'RAUL', 'FORTIER', 'Sabadell', '1991-10-06', 'M', 'N'),
(534, '21015556', 'BEN', 'EASTER', 'Bilbao', '1990-05-01', 'M', 'N'),
(535, '48616287', 'CHESTER', 'BENNER', 'Madrid', '2001-08-06', 'M', 'N'),
(536, '85189752', 'CECIL', 'VINES', 'Barcelona', '1991-11-12', 'M', 'S'),
(537, '42779321', 'DUANE', 'TUBBS', 'Bilbao', '2003-07-06', 'M', 'N'),
(538, '34337234', 'FRANKLIN', 'TROUTMAN', 'Barcelona', '1998-08-08', 'M', 'N'),
(539, '87073887', 'ANDRE', 'RAPP', 'Sabadell', '2001-09-11', 'M', 'N'),
(540, '65317223', 'ELMER', 'NOE', 'Madrid', '2002-06-02', 'M', 'S'),
(541, '30479572', 'BRAD', 'MCCURDY', 'Sabadell', '1996-10-12', 'M', 'N'),
(542, '65454655', 'GABRIEL', 'HARDER', 'Barcelona', '1990-03-02', 'M', 'N'),
(543, '15611857', 'RON', 'DELUCA', 'Bilbao', '2000-02-07', 'M', 'N'),
(544, '86296087', 'MITCHELL', 'WESTMORELAND', 'Barcelona', '1990-08-05', 'M', 'S'),
(545, '62062951', 'ROLAND', 'SOUTH', 'Madrid', '1991-04-03', 'M', 'N'),
(546, '81612756', 'ARNOLD', 'HAVENS', 'Bilbao', '1996-04-04', 'M', 'N'),
(547, '52402856', 'HARVEY', 'GUAJARDO', 'Sabadell', '2001-06-12', 'M', 'N'),
(548, '17633931', 'JARED', 'ELY', 'Barcelona', '2001-01-08', 'M', 'S'),
(549, '54151833', 'ADRIAN', 'CLARY', 'Bilbao', '1993-04-09', 'M', 'N'),
(550, '94823037', 'KARL', 'SEAL', 'Madrid', '2002-09-02', 'M', 'N'),
(551, '67727844', 'CORY', 'MEEHAN', 'Sabadell', '1997-05-02', 'M', 'N'),
(552, '39795608', 'CLAUDE', 'HERZOG', 'Bilbao', '2001-01-08', 'M', 'S'),
(553, '14294365', 'ERIK', 'GUILLEN', 'Sabadell', '1998-01-08', 'M', 'N'),
(554, '72811697', 'DARRYL', 'ASHCRAFT', 'Barcelona', '1991-01-01', 'M', 'N'),
(555, '28248992', 'JAMIE', 'WAUGH', 'Madrid', '1990-08-09', 'M', 'N'),
(556, '64482929', 'NEIL', 'RENNER', 'Barcelona', '2003-12-06', 'M', 'S'),
(557, '33538429', 'JESSIE', 'MILAM', 'Sabadell', '1994-06-04', 'M', 'N'),
(558, '73241521', 'CHRISTIAN', 'JUNG', 'Bilbao', '1999-03-02', 'M', 'N'),
(559, '77818898', 'JAVIER', 'ELROD', 'Sabadell', '1996-05-07', 'M', 'N'),
(560, '88644050', 'FERNANDO', 'CHURCHILL', 'Madrid', '2003-01-09', 'M', 'S'),
(561, '77417078', 'CLINTON', 'BUFORD', 'Bilbao', '1992-03-12', 'M', 'N'),
(562, '53035039', 'TED', 'BREAUX', 'Barcelona', '1996-01-10', 'M', 'N'),
(563, '97916068', 'MATHEW', 'BOLIN', 'Sabadell', '1998-07-06', 'M', 'N'),
(564, '17236357', 'TYRONE', 'ASHER', 'Bilbao', '1997-07-12', 'M', 'S'),
(565, '77412719', 'DARREN', 'WINDHAM', 'Madrid', '1992-11-03', 'M', 'N'),
(566, '27293712', 'LONNIE', 'TIRADO', 'Barcelona', '1998-04-02', 'M', 'N'),
(567, '93478566', 'LANCE', 'PEMBERTON', 'Bilbao', '2001-03-08', 'M', 'N'),
(568, '66162520', 'CODY', 'NOLEN', 'Barcelona', '1997-09-09', 'M', 'S'),
(569, '99719856', 'JULIO', 'NOLAND', 'Sabadell', '2004-09-07', 'M', 'N'),
(570, '17124288', 'KELLY', 'KNOTT', 'Madrid', '1993-02-05', 'M', 'N'),
(571, '86673004', 'KURT', 'EMMONS', 'Sabadell', '1997-02-05', 'M', 'N'),
(572, '41127833', 'ALLAN', 'CORNISH', 'Barcelona', '2002-01-11', 'M', 'S'),
(573, '66486115', 'NELSON', 'CHRISTENSON', 'Bilbao', '1995-09-10', 'M', 'N'),
(574, '29204227', 'GUY', 'BROWNLEE', 'Barcelona', '2000-11-03', 'M', 'N'),
(575, '54127692', 'CLAYTON', 'BARBEE', 'Madrid', '2003-08-01', 'M', 'N'),
(576, '73933820', 'HUGH', 'WALDROP', 'Bilbao', '1991-09-05', 'M', 'S'),
(577, '27746128', 'MAX', 'PITT', 'Sabadell', '1991-10-04', 'M', 'N'),
(578, '64154584', 'DWAYNE', 'OLVERA', 'Barcelona', '1992-09-09', 'M', 'N'),
(579, '96592796', 'DWIGHT', 'LOMBARDI', 'Bilbao', '2004-03-12', 'M', 'N'),
(580, '75706525', 'ARMANDO', 'GRUBER', 'Madrid', '2003-02-12', 'M', 'S'),
(581, '39487574', 'FELIX', 'GAFFNEY', 'Sabadell', '1998-01-04', 'M', 'N'),
(582, '94385644', 'JIMMIE', 'EGGLESTON', 'Bilbao', '1991-10-01', 'M', 'N'),
(583, '48108492', 'EVERETT', 'BANDA', 'Sabadell', '1993-10-06', 'M', 'N'),
(584, '45237646', 'JORDAN', 'ARCHULETA', 'Barcelona', '2000-12-09', 'M', 'S'),
(585, '76168592', 'IAN', 'STILL', 'Madrid', '2001-11-06', 'M', 'N'),
(586, '58621617', 'WALLACE', 'SLONE', 'Barcelona', '1994-01-04', 'M', 'N'),
(587, '45872248', 'KEN', 'PREWITT', 'Sabadell', '1996-04-02', 'M', 'N'),
(588, '21572769', 'BOB', 'PFEIFFER', 'Bilbao', '2000-12-01', 'M', 'S'),
(589, '70349589', 'JAIME', 'NETTLES', 'Sabadell', '2003-11-02', 'M', 'N'),
(590, '19059165', 'CASEY', 'MENA', 'Madrid', '2004-03-02', 'M', 'N'),
(591, '53923756', 'ALFREDO', 'MCADAMS', 'Bilbao', '1996-09-12', 'M', 'N'),
(592, '17989291', 'ALBERTO', 'HENNING', 'Barcelona', '2000-02-02', 'M', 'S'),
(593, '80691417', 'DAVE', 'GARDINER', 'Sabadell', '2003-01-12', 'M', 'N'),
(594, '12321640', 'IVAN', 'CROMWELL', 'Bilbao', '1990-12-01', 'M', 'N'),
(595, '11111111A', 'JOHNNIE', 'CHISHOLM', 'Madrid', '0000-00-00', 'M', 'N'),
(596, '11111111A', 'SIDNEY', 'BURLESON', 'Barcelona', '0000-00-00', 'M', 'S'),
(597, '11111111A', 'BYRON', 'BOX', 'Bilbao', '0000-00-00', 'M', 'N'),
(598, '11111111A', 'JULIAN', 'VEST', 'Barcelona', '0000-00-00', 'M', 'N'),
(599, '11111111A', 'ISAAC', 'OGLESBY', 'Sabadell', '0000-00-00', 'M', 'N'),
(600, '11111111A', 'MORRIS', 'MCCARTER', 'Madrid', '0000-00-00', 'M', 'S'),
(601, '11111111A', 'CLIFTON', 'MALCOLM', 'Sabadell', '0000-00-00', 'M', 'N'),
(602, '11111111A', 'WILLARD', 'LUMPKIN', 'Barcelona', '0000-00-00', 'M', 'N'),
(603, '11111111A', 'DARYL', 'LARUE', 'Bilbao', '0000-00-00', 'M', 'N'),
(604, '11111111A', 'ROSS', 'GREY', 'Barcelona', '0000-00-00', 'M', 'S'),
(605, '11111111A', 'VIRGIL', 'WOFFORD', 'Madrid', '0000-00-00', 'M', 'N'),
(606, '11111111A', 'ANDY', 'VANHORN', 'Bilbao', '0000-00-00', 'M', 'N'),
(607, '11111111A', 'MARSHALL', 'THORN', 'Sabadell', '0000-00-00', 'M', 'N'),
(608, '11111111A', 'SALVADOR', 'TEEL', 'Barcelona', '0000-00-00', 'M', 'S'),
(609, '11111111A', 'PERRY', 'SWAFFORD', 'Bilbao', '0000-00-00', 'M', 'N'),
(610, '11111111A', 'KIRK', 'STCLAIR', 'Madrid', '0000-00-00', 'M', 'N'),
(611, '11111111A', 'SERGIO', 'STANFIELD', 'Sabadell', '0000-00-00', 'M', 'N'),
(612, '11111111A', 'MARION', 'OCAMPO', 'Bilbao', '0000-00-00', 'M', 'S'),
(613, '11111111A', 'TRACY', 'HERRMANN', 'Sabadell', '0000-00-00', 'M', 'N'),
(614, '11111111A', 'SETH', 'HANNON', 'Barcelona', '0000-00-00', 'M', 'N'),
(615, '11111111A', 'KENT', 'ARSENAULT', 'Madrid', '0000-00-00', 'M', 'N'),
(616, '11111111A', 'TERRANCE', 'ROUSH', 'Barcelona', '0000-00-00', 'M', 'S'),
(617, '11111111A', 'RENE', 'MCALISTER', 'Sabadell', '0000-00-00', 'M', 'N'),
(618, '11111111A', 'EDUARDO', 'HIATT', 'Bilbao', '0000-00-00', 'M', 'N'),
(619, '11111111A', 'TERRENCE', 'GUNDERSON', 'Sabadell', '0000-00-00', 'M', 'N'),
(620, '11111111A', 'ENRIQUE', 'FORSYTHE', 'Madrid', '0000-00-00', 'M', 'S'),
(621, '11111111A', 'FREDDIE', 'DUGGAN', 'Bilbao', '0000-00-00', 'M', 'N'),
(622, '11111111A', 'WADE', 'DELVALLE', 'Barcelona', '0000-00-00', 'M', 'N'),
(623, '11111111A', 'AUSTIN', 'CINTRON', 'Sabadell', '0000-00-00', 'M', 'N'),
(624, '11111111A', 'PEPE', 'LÓPEZ', 'Bilbao', '0000-00-00', 'M', 'S'),
(625, '11111111A', 'MARÍA', 'SÁNCHEZ', 'Madrid', '0000-00-00', 'M', 'N');

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

--
-- Estructura de la taula `profesor`
--

CREATE TABLE `profesor` (
  `id_profesor` int(10) UNSIGNED NOT NULL,
  `id_departamento` int(10) UNSIGNED NOT NULL,
  `nombre` varchar(40) NOT NULL,
  `apellido1` varchar(60) NOT NULL,
  `ciudad` varchar(50) NOT NULL,
  `fecha_nacimiento` date NOT NULL DEFAULT current_timestamp(),
  `sexo` char(1) NOT NULL,
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Bolcament de dades per a la taula `profesor`
--

INSERT INTO `profesor` (`id_profesor`, `id_departamento`, `nombre`, `apellido1`, `ciudad`, `fecha_nacimiento`, `sexo`, `id`) VALUES
(3, 1, 'Zoe', 'Ramirez', 'Bilbao', '1979-08-19', 'M', 0),
(5, 2, 'David', 'Schmidt', 'Madrid', '1978-01-19', 'H', 0),
(8, 3, 'Cristina', 'Lemke', 'Barcelona', '1977-08-21', 'M', 0),
(10, 4, 'Esther', 'Spencer', 'Madrid', '1977-05-19', 'M', 0),
(12, 4, 'Carmen', 'Streich', 'Bilbao', '1971-04-29', 'M', 0),
(13, 6, 'Alfredo', 'Stiedemann', 'Almería', '1980-02-01', 'H', 0),
(14, 1, 'Manolo', 'Hamill', 'Barcelona', '1977-01-02', 'H', 0),
(15, 2, 'Alejandro', 'Kohler', 'Madrid', '1980-03-14', 'H', 0),
(16, 3, 'Antonio', 'Fahey', 'Barcelona', '1982-03-18', 'H', 0),
(17, 4, 'Guillermo', 'Ruecker', 'Almería', '1973-05-05', 'H', 0),
(18, 5, 'Micaela', 'Monahan', 'Bilbao', '1976-02-25', 'M', 0),
(20, 6, 'Francesca', 'Schowalter', 'Madrid', '1980-10-31', 'H', 0),
(101, 5, 'JANE', 'BENNETT', 'Sabadell', '0000-00-00', 'H', 1),
(102, 5, 'LORI', 'WOOD', 'Bilbao', '0000-00-00', 'M', 1),
(200, 5, 'JUNE', 'CARROLL', 'Madrid', '0000-00-00', 'H', 1),
(201, 5, 'SAMANTHA', 'DUNCAN', 'Bilbao', '0000-00-00', 'H', 1),
(202, 5, 'MARION', 'SNYDER', 'Barcelona', '0000-00-00', 'H', 1),
(203, 5, 'DANA', 'HART', 'Sabadell', '0000-00-00', 'H', 1);

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

--
-- Estructura de la taula `tipos`
--

CREATE TABLE `tipos` (
  `tipo_id` int(3) NOT NULL,
  `tipo` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Bolcament de dades per a la taula `tipos`
--

INSERT INTO `tipos` (`tipo_id`, `tipo`) VALUES
(1, 'básica'),
(2, 'obligatoria'),
(3, 'optativa');

--
-- Índexs per a les taules bolcades
--

--
-- Índexs per a la taula `asignatura`
--
ALTER TABLE `asignatura`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_profesor` (`id_profesor`),
  ADD KEY `id_grado` (`id_grado`);

--
-- Índexs per a la taula `curso_escolar`
--
ALTER TABLE `curso_escolar`
  ADD PRIMARY KEY (`id`);

--
-- Índexs per a la taula `departamento`
--
ALTER TABLE `departamento`
  ADD PRIMARY KEY (`id`);

--
-- Índexs per a la taula `grado`
--
ALTER TABLE `grado`
  ADD PRIMARY KEY (`id`);

--
-- Índexs per a la taula `persona`
--
ALTER TABLE `persona`
  ADD PRIMARY KEY (`id`);

--
-- Índexs per a la taula `profesor`
--
ALTER TABLE `profesor`
  ADD KEY `id_departamento` (`id_departamento`);

--
-- Índexs per a la taula `tipos`
--
ALTER TABLE `tipos`
  ADD PRIMARY KEY (`tipo_id`);

--
-- AUTO_INCREMENT per les taules bolcades
--

--
-- AUTO_INCREMENT per la taula `asignatura`
--
ALTER TABLE `asignatura`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT per la taula `curso_escolar`
--
ALTER TABLE `curso_escolar`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT per la taula `departamento`
--
ALTER TABLE `departamento`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT per la taula `grado`
--
ALTER TABLE `grado`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT per la taula `persona`
--
ALTER TABLE `persona`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1048;

--
-- AUTO_INCREMENT per la taula `tipos`
--
ALTER TABLE `tipos`
  MODIFY `tipo_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
