-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jul 14, 2020 at 07:01 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.2.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 */;

--
-- Database: `student`
--

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

--
-- Table structure for table `cijfer`
--

CREATE TABLE `cijfer` (
  `id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `vak_id` int(11) NOT NULL,
  `cijfer` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cijfer`
--

INSERT INTO `cijfer` (`id`, `student_id`, `vak_id`, `cijfer`) VALUES
(0, 1, 1, 85),
(1, 1, 2, 89),
(2, 1, 3, 56),
(3, 1, 4, 54),
(4, 1, 5, 96),
(5, 1, 6, 74),
(6, 1, 7, 86),
(7, 1, 8, 63),
(8, 1, 9, 82),
(9, 2, 1, 41),
(10, 2, 2, 61),
(11, 2, 3, 40),
(12, 2, 4, 65),
(13, 2, 5, 61),
(14, 2, 6, 94),
(15, 2, 7, 65),
(16, 2, 8, 93),
(17, 2, 9, 99),
(18, 3, 1, 53),
(19, 3, 2, 70),
(20, 3, 3, 99),
(21, 3, 4, 45),
(22, 3, 5, 50),
(23, 3, 6, 85),
(24, 3, 7, 78),
(25, 3, 8, 70),
(26, 3, 9, 82),
(27, 4, 1, 98),
(28, 4, 2, 76),
(29, 4, 3, 95),
(30, 4, 4, 53),
(31, 4, 5, 85),
(32, 4, 6, 95),
(33, 4, 7, 25),
(34, 4, 8, 55),
(35, 4, 9, 51),
(36, 5, 1, 46),
(37, 5, 2, 80),
(38, 5, 3, 90),
(39, 5, 4, 69),
(40, 5, 5, 43),
(41, 5, 6, 84),
(42, 5, 7, 12),
(43, 5, 8, 90),
(44, 5, 9, 28),
(45, 6, 1, 58),
(46, 6, 2, 64),
(47, 6, 3, 99),
(48, 6, 4, 33),
(49, 6, 5, 53),
(50, 6, 6, 90),
(51, 6, 7, 67),
(52, 6, 8, 52),
(53, 6, 9, 26),
(54, 7, 1, 84),
(55, 7, 2, 70),
(56, 7, 3, 86),
(57, 7, 4, 61),
(58, 7, 5, 71),
(59, 7, 6, 41),
(60, 7, 7, 92),
(61, 7, 8, 50),
(62, 7, 9, 73),
(63, 8, 1, 69),
(64, 8, 2, 61),
(65, 8, 3, 59),
(66, 8, 4, 14),
(67, 8, 5, 99),
(68, 8, 6, 51),
(69, 8, 7, 90),
(70, 8, 8, 97),
(71, 8, 9, 69),
(72, 9, 1, 89),
(73, 9, 2, 99),
(74, 9, 3, 60),
(75, 9, 4, 92),
(76, 9, 5, 71),
(77, 9, 6, 88),
(78, 9, 7, 18),
(79, 9, 8, 94),
(80, 9, 9, 51),
(81, 10, 1, 87),
(82, 10, 2, 100),
(83, 10, 3, 52),
(84, 10, 4, 72),
(85, 10, 5, 81),
(86, 10, 6, 56),
(87, 10, 7, 81),
(88, 10, 8, 72),
(89, 10, 9, 99),
(90, 11, 1, 95),
(91, 11, 2, 91),
(92, 11, 3, 100),
(93, 11, 4, 66),
(94, 11, 5, 55),
(95, 11, 6, 55),
(96, 11, 7, 28),
(97, 11, 8, 92),
(98, 11, 9, 50),
(99, 12, 1, 99),
(100, 12, 2, 63),
(101, 12, 3, 78),
(102, 12, 4, 89),
(103, 12, 5, 53),
(104, 12, 6, 21),
(105, 12, 7, 80),
(106, 12, 8, 57),
(107, 12, 9, 94),
(108, 13, 1, 90),
(109, 13, 2, 50),
(110, 13, 3, 89),
(111, 13, 4, 95),
(112, 13, 5, 78),
(113, 13, 6, 80),
(114, 13, 7, 77),
(115, 13, 8, 53),
(116, 13, 9, 100),
(117, 14, 1, 60),
(118, 14, 2, 99),
(119, 14, 3, 72),
(120, 14, 4, 95),
(121, 14, 5, 58),
(122, 14, 6, 72),
(123, 14, 7, 52),
(124, 14, 8, 85),
(125, 14, 9, 87),
(126, 15, 1, 29),
(127, 15, 2, 83),
(128, 15, 3, 93),
(129, 15, 4, 15),
(130, 15, 5, 86),
(131, 15, 6, 60),
(132, 15, 7, 73),
(133, 15, 8, 57),
(134, 15, 9, 72),
(135, 16, 1, 23),
(136, 16, 2, 13),
(137, 16, 3, 63),
(138, 16, 4, 99),
(139, 16, 5, 78),
(140, 16, 6, 51),
(141, 16, 7, 77),
(142, 16, 8, 53),
(143, 16, 9, 40),
(144, 17, 1, 70),
(145, 17, 2, 69),
(146, 17, 3, 85),
(147, 17, 4, 56),
(148, 17, 5, 83),
(149, 17, 6, 57),
(150, 17, 7, 22),
(151, 17, 8, 57),
(152, 17, 9, 64),
(153, 18, 1, 82),
(154, 18, 2, 76),
(155, 18, 3, 82),
(156, 18, 4, 99),
(157, 18, 5, 89),
(158, 18, 6, 73),
(159, 18, 7, 53),
(160, 18, 8, 24),
(161, 18, 9, 52),
(162, 19, 1, 52),
(163, 19, 2, 50),
(164, 19, 3, 61),
(165, 19, 4, 80),
(166, 19, 5, 45),
(167, 19, 6, 91),
(168, 19, 7, 52),
(169, 19, 8, 51),
(170, 19, 9, 29),
(171, 20, 1, 88),
(172, 20, 2, 19),
(173, 20, 3, 53),
(174, 20, 4, 93),
(175, 20, 5, 68),
(176, 20, 6, 61),
(177, 20, 7, 62),
(178, 20, 8, 85),
(179, 20, 9, 51),
(180, 21, 1, 84),
(181, 21, 2, 74),
(182, 21, 3, 75),
(183, 21, 4, 61),
(184, 21, 5, 89),
(185, 21, 6, 97),
(186, 21, 7, 62),
(187, 21, 8, 85),
(188, 21, 9, 68),
(189, 22, 1, 73),
(190, 22, 2, 98),
(191, 22, 3, 61),
(192, 22, 4, 85),
(193, 22, 5, 17),
(194, 22, 6, 97),
(195, 22, 7, 72),
(196, 22, 8, 61),
(197, 22, 9, 64),
(198, 23, 1, 93),
(199, 23, 2, 80),
(200, 23, 3, 78),
(201, 23, 4, 53),
(202, 23, 5, 59),
(203, 23, 6, 90),
(204, 23, 7, 13),
(205, 23, 8, 72),
(206, 23, 9, 62),
(207, 24, 1, 81),
(208, 24, 2, 81),
(209, 24, 3, 99),
(210, 24, 4, 19),
(211, 24, 5, 80),
(212, 24, 6, 50),
(213, 24, 7, 68),
(214, 24, 8, 78),
(215, 24, 9, 74),
(216, 25, 1, 88),
(217, 25, 2, 70),
(218, 25, 3, 91),
(219, 25, 4, 39),
(220, 25, 5, 78),
(221, 25, 6, 93),
(222, 25, 7, 54),
(223, 25, 8, 88),
(224, 25, 9, 79),
(225, 26, 1, 82),
(226, 26, 2, 58),
(227, 26, 3, 56),
(228, 26, 4, 87),
(229, 26, 5, 81),
(230, 26, 6, 84),
(231, 26, 7, 11),
(232, 26, 8, 61),
(233, 26, 9, 51),
(234, 27, 1, 82),
(235, 27, 2, 39),
(236, 27, 3, 94),
(237, 27, 4, 65),
(238, 27, 5, 59),
(239, 27, 6, 73),
(240, 27, 7, 81),
(241, 27, 8, 70),
(242, 27, 9, 89),
(243, 28, 1, 66),
(244, 28, 2, 85),
(245, 28, 3, 55),
(246, 28, 4, 81),
(247, 28, 5, 68),
(248, 28, 6, 19),
(249, 28, 7, 91),
(250, 28, 8, 94),
(251, 28, 9, 38),
(252, 29, 1, 80),
(253, 29, 2, 64),
(254, 29, 3, 97),
(255, 29, 4, 16),
(256, 29, 5, 55),
(257, 29, 6, 69),
(258, 29, 7, 56),
(259, 29, 8, 69),
(260, 29, 9, 77),
(261, 30, 1, 64),
(262, 30, 2, 39),
(263, 30, 3, 66),
(264, 30, 4, 93),
(265, 30, 5, 99),
(266, 30, 6, 61),
(267, 30, 7, 60),
(268, 30, 8, 88),
(269, 30, 9, 93),
(270, 31, 1, 80),
(271, 31, 2, 62),
(272, 31, 3, 72),
(273, 31, 4, 64),
(274, 31, 5, 71),
(275, 31, 6, 84),
(276, 31, 7, 57),
(277, 31, 8, 54),
(278, 31, 9, 77),
(279, 32, 1, 91),
(280, 32, 2, 87),
(281, 32, 3, 53),
(282, 32, 4, 57),
(283, 32, 5, 86),
(284, 32, 6, 99),
(285, 32, 7, 83),
(286, 32, 8, 22),
(287, 32, 9, 96),
(288, 33, 1, 93),
(289, 33, 2, 99),
(290, 33, 3, 56),
(291, 33, 4, 65),
(292, 33, 5, 97),
(293, 33, 6, 34),
(294, 33, 7, 92),
(295, 33, 8, 78),
(296, 33, 9, 15),
(297, 34, 1, 10),
(298, 34, 2, 45),
(299, 34, 3, 77),
(300, 34, 4, 62),
(301, 34, 5, 28),
(302, 34, 6, 84),
(303, 34, 7, 61),
(304, 34, 8, 78),
(305, 34, 9, 85),
(306, 35, 1, 13),
(307, 35, 2, 72),
(308, 35, 3, 16),
(309, 35, 4, 79),
(310, 35, 5, 39),
(311, 35, 6, 49),
(312, 35, 7, 69),
(313, 35, 8, 74),
(314, 35, 9, 53),
(315, 36, 1, 43),
(316, 36, 2, 59),
(317, 36, 3, 68),
(318, 36, 4, 97),
(319, 36, 5, 92),
(320, 36, 6, 90),
(321, 36, 7, 68),
(322, 36, 8, 70),
(323, 36, 9, 73),
(324, 37, 1, 54),
(325, 37, 2, 60),
(326, 37, 3, 87),
(327, 37, 4, 29),
(328, 37, 5, 57),
(329, 37, 6, 98),
(330, 37, 7, 24),
(331, 37, 8, 65),
(332, 37, 9, 95),
(333, 38, 1, 71),
(334, 38, 2, 10),
(335, 38, 3, 61),
(336, 38, 4, 84),
(337, 38, 5, 96),
(338, 38, 6, 69),
(339, 38, 7, 70),
(340, 38, 8, 75),
(341, 38, 9, 75),
(342, 39, 1, 81),
(343, 39, 2, 99),
(344, 39, 3, 78),
(345, 39, 4, 84),
(346, 39, 5, 88),
(347, 39, 6, 75),
(348, 39, 7, 72),
(349, 39, 8, 53),
(350, 39, 9, 74),
(351, 40, 1, 78),
(352, 40, 2, 70),
(353, 40, 3, 69),
(354, 40, 4, 77),
(355, 40, 5, 76),
(356, 40, 6, 64),
(357, 40, 7, 52),
(358, 40, 8, 50),
(359, 40, 9, 62),
(360, 41, 1, 90),
(361, 41, 2, 81),
(362, 41, 3, 69),
(363, 41, 4, 45),
(364, 41, 5, 87),
(365, 41, 6, 97),
(366, 41, 7, 51),
(367, 41, 8, 59),
(368, 41, 9, 53),
(369, 42, 1, 84),
(370, 42, 2, 81),
(371, 42, 3, 56),
(372, 42, 4, 80),
(373, 42, 5, 97),
(374, 42, 6, 84),
(375, 42, 7, 76),
(376, 42, 8, 84),
(377, 42, 9, 55),
(378, 43, 1, 98),
(379, 43, 2, 52),
(380, 43, 3, 96),
(381, 43, 4, 60),
(382, 43, 5, 59),
(383, 43, 6, 53),
(384, 43, 7, 63),
(385, 43, 8, 90),
(386, 43, 9, 89),
(387, 44, 1, 52),
(388, 44, 2, 79),
(389, 44, 3, 61),
(390, 44, 4, 83),
(391, 44, 5, 89),
(392, 44, 6, 51),
(393, 44, 7, 62),
(394, 44, 8, 59),
(395, 44, 9, 54),
(396, 45, 1, 60),
(397, 45, 2, 87),
(398, 45, 3, 20),
(399, 45, 4, 71),
(400, 45, 5, 93),
(401, 45, 6, 71),
(402, 45, 7, 92),
(403, 45, 8, 78),
(404, 45, 9, 52),
(405, 46, 1, 22),
(406, 46, 2, 96),
(407, 46, 3, 67),
(408, 46, 4, 72),
(409, 46, 5, 87),
(410, 46, 6, 82),
(411, 46, 7, 73),
(412, 46, 8, 78),
(413, 46, 9, 65),
(414, 47, 1, 77),
(415, 47, 2, 56),
(416, 47, 3, 56),
(417, 47, 4, 52),
(418, 47, 5, 71),
(419, 47, 6, 91),
(420, 47, 7, 75),
(421, 47, 8, 93),
(422, 47, 9, 43),
(423, 48, 1, 85),
(424, 48, 2, 85),
(425, 48, 3, 56),
(426, 48, 4, 40),
(427, 48, 5, 71),
(428, 48, 6, 91),
(429, 48, 7, 93),
(430, 48, 8, 80),
(431, 48, 9, 58),
(432, 49, 1, 54),
(433, 49, 2, 34),
(434, 49, 3, 92),
(435, 49, 4, 84),
(436, 49, 5, 74),
(437, 49, 6, 67),
(438, 49, 7, 71),
(439, 49, 8, 67),
(440, 49, 9, 64),
(441, 50, 1, 96),
(442, 50, 2, 53),
(443, 50, 3, 19),
(444, 50, 4, 54),
(445, 50, 5, 93),
(446, 50, 6, 24),
(447, 50, 7, 23),
(448, 50, 8, 99),
(449, 50, 9, 50),
(450, 51, 1, 55),
(451, 51, 2, 81),
(452, 51, 3, 79),
(453, 51, 4, 65),
(454, 51, 5, 56),
(455, 51, 6, 94),
(456, 51, 7, 82),
(457, 51, 8, 95),
(458, 51, 9, 59),
(459, 52, 1, 68),
(460, 52, 2, 60),
(461, 52, 3, 72),
(462, 52, 4, 54),
(463, 52, 5, 98),
(464, 52, 6, 95),
(465, 52, 7, 95),
(466, 52, 8, 61),
(467, 52, 9, 100),
(468, 53, 1, 74),
(469, 53, 2, 72),
(470, 53, 3, 84),
(471, 53, 4, 68),
(472, 53, 5, 91),
(473, 53, 6, 90),
(474, 53, 7, 15),
(475, 53, 8, 81),
(476, 53, 9, 80),
(477, 54, 1, 92),
(478, 54, 2, 89),
(479, 54, 3, 22),
(480, 54, 4, 64),
(481, 54, 5, 85),
(482, 54, 6, 97),
(483, 54, 7, 91),
(484, 54, 8, 64),
(485, 54, 9, 86),
(486, 55, 1, 86),
(487, 55, 2, 72),
(488, 55, 3, 62),
(489, 55, 4, 63),
(490, 55, 5, 61),
(491, 55, 6, 66),
(492, 55, 7, 60),
(493, 55, 8, 27),
(494, 55, 9, 55),
(495, 56, 1, 67),
(496, 56, 2, 60),
(497, 56, 3, 96),
(498, 56, 4, 57),
(499, 56, 5, 77),
(500, 56, 6, 55),
(501, 56, 7, 37),
(502, 56, 8, 80),
(503, 56, 9, 59),
(504, 57, 1, 68),
(505, 57, 2, 21),
(506, 57, 3, 83),
(507, 57, 4, 70),
(508, 57, 5, 71),
(509, 57, 6, 82),
(510, 57, 7, 69),
(511, 57, 8, 100),
(512, 57, 9, 96),
(513, 58, 1, 96),
(514, 58, 2, 78),
(515, 58, 3, 75),
(516, 58, 4, 79),
(517, 58, 5, 80),
(518, 58, 6, 84),
(519, 58, 7, 76),
(520, 58, 8, 53),
(521, 58, 9, 59),
(522, 59, 1, 50),
(523, 59, 2, 75),
(524, 59, 3, 84),
(525, 59, 4, 56),
(526, 59, 5, 98),
(527, 59, 6, 83),
(528, 59, 7, 99),
(529, 59, 8, 50),
(530, 59, 9, 100),
(531, 60, 1, 12),
(532, 60, 2, 69),
(533, 60, 3, 91),
(534, 60, 4, 85),
(535, 60, 5, 78),
(536, 60, 6, 80),
(537, 60, 7, 59),
(538, 60, 8, 91),
(539, 60, 9, 78),
(540, 61, 1, 83),
(541, 61, 2, 93),
(542, 61, 3, 67),
(543, 61, 4, 56),
(544, 61, 5, 46),
(545, 61, 6, 87),
(546, 61, 7, 96),
(547, 61, 8, 91),
(548, 61, 9, 97),
(549, 62, 1, 46),
(550, 62, 2, 60),
(551, 62, 3, 53),
(552, 62, 4, 96),
(553, 62, 5, 98),
(554, 62, 6, 90),
(555, 62, 7, 23),
(556, 62, 8, 68),
(557, 62, 9, 69),
(558, 63, 1, 97),
(559, 63, 2, 58),
(560, 63, 3, 66),
(561, 63, 4, 89),
(562, 63, 5, 79),
(563, 63, 6, 56),
(564, 63, 7, 16),
(565, 63, 8, 100),
(566, 63, 9, 78),
(567, 64, 1, 70),
(568, 64, 2, 66),
(569, 64, 3, 73),
(570, 64, 4, 99),
(571, 64, 5, 97),
(572, 64, 6, 31),
(573, 64, 7, 100),
(574, 64, 8, 59),
(575, 64, 9, 52),
(576, 65, 1, 59),
(577, 65, 2, 88),
(578, 65, 3, 62),
(579, 65, 4, 97),
(580, 65, 5, 81),
(581, 65, 6, 86),
(582, 65, 7, 92),
(583, 65, 8, 74),
(584, 65, 9, 85),
(585, 66, 1, 88),
(586, 66, 2, 92),
(587, 66, 3, 63),
(588, 66, 4, 85),
(589, 66, 5, 36),
(590, 66, 6, 92),
(591, 66, 7, 41),
(592, 66, 8, 66),
(593, 66, 9, 100),
(594, 67, 1, 91),
(595, 67, 2, 99),
(596, 67, 3, 56),
(597, 67, 4, 56),
(598, 67, 5, 90),
(599, 67, 6, 86),
(600, 67, 7, 70),
(601, 67, 8, 24),
(602, 67, 9, 85),
(603, 68, 1, 75),
(604, 68, 2, 89),
(605, 68, 3, 32),
(606, 68, 4, 95),
(607, 68, 5, 75),
(608, 68, 6, 56),
(609, 68, 7, 86),
(610, 68, 8, 93),
(611, 68, 9, 69),
(612, 69, 1, 93),
(613, 69, 2, 62),
(614, 69, 3, 60),
(615, 69, 4, 62),
(616, 69, 5, 58),
(617, 69, 6, 83),
(618, 69, 7, 95),
(619, 69, 8, 77),
(620, 69, 9, 59),
(621, 70, 1, 80),
(622, 70, 2, 57),
(623, 70, 3, 75),
(624, 70, 4, 54),
(625, 70, 5, 53),
(626, 70, 6, 58),
(627, 70, 7, 17),
(628, 70, 8, 93),
(629, 70, 9, 89),
(630, 71, 1, 63),
(631, 71, 2, 14),
(632, 71, 3, 87),
(633, 71, 4, 67),
(634, 71, 5, 47),
(635, 71, 6, 78),
(636, 71, 7, 35),
(637, 71, 8, 94),
(638, 71, 9, 62),
(639, 72, 1, 88),
(640, 72, 2, 39),
(641, 72, 3, 38),
(642, 72, 4, 67),
(643, 72, 5, 69),
(644, 72, 6, 70),
(645, 72, 7, 98),
(646, 72, 8, 72),
(647, 72, 9, 70),
(648, 73, 1, 99),
(649, 73, 2, 14),
(650, 73, 3, 89),
(651, 73, 4, 77),
(652, 73, 5, 82),
(653, 73, 6, 63),
(654, 73, 7, 92),
(655, 73, 8, 53),
(656, 73, 9, 73),
(657, 74, 1, 74),
(658, 74, 2, 91),
(659, 74, 3, 93),
(660, 74, 4, 79),
(661, 74, 5, 94),
(662, 74, 6, 85),
(663, 74, 7, 78),
(664, 74, 8, 38),
(665, 74, 9, 62),
(666, 75, 1, 75),
(667, 75, 2, 55),
(668, 75, 3, 91),
(669, 75, 4, 98),
(670, 75, 5, 93),
(671, 75, 6, 34),
(672, 75, 7, 94),
(673, 75, 8, 56),
(674, 75, 9, 59),
(675, 76, 1, 70),
(676, 76, 2, 90),
(677, 76, 3, 85),
(678, 76, 4, 91),
(679, 76, 5, 98),
(680, 76, 6, 88),
(681, 76, 7, 64),
(682, 76, 8, 78),
(683, 76, 9, 79),
(684, 77, 1, 72),
(685, 77, 2, 52),
(686, 77, 3, 99),
(687, 77, 4, 34),
(688, 77, 5, 77),
(689, 77, 6, 62),
(690, 77, 7, 75),
(691, 77, 8, 88),
(692, 77, 9, 60),
(693, 78, 1, 49),
(694, 78, 2, 17),
(695, 78, 3, 53),
(696, 78, 4, 63),
(697, 78, 5, 54),
(698, 78, 6, 16),
(699, 78, 7, 11),
(700, 78, 8, 79),
(701, 78, 9, 67),
(702, 79, 1, 83),
(703, 79, 2, 56),
(704, 79, 3, 73),
(705, 79, 4, 74),
(706, 79, 5, 93),
(707, 79, 6, 99),
(708, 79, 7, 83),
(709, 79, 8, 61),
(710, 79, 9, 51),
(711, 80, 1, 56),
(712, 80, 2, 52),
(713, 80, 3, 61),
(714, 80, 4, 74),
(715, 80, 5, 45),
(716, 80, 6, 89),
(717, 80, 7, 94),
(718, 80, 8, 90),
(719, 80, 9, 84),
(720, 81, 1, 65),
(721, 81, 2, 54),
(722, 81, 3, 76),
(723, 81, 4, 62),
(724, 81, 5, 76),
(725, 81, 6, 65),
(726, 81, 7, 33),
(727, 81, 8, 26),
(728, 81, 9, 59),
(729, 82, 1, 79),
(730, 82, 2, 77),
(731, 82, 3, 74),
(732, 82, 4, 86),
(733, 82, 5, 62),
(734, 82, 6, 20),
(735, 82, 7, 68),
(736, 82, 8, 96),
(737, 82, 9, 85),
(738, 83, 1, 20),
(739, 83, 2, 97),
(740, 83, 3, 67),
(741, 83, 4, 99),
(742, 83, 5, 81),
(743, 83, 6, 56),
(744, 83, 7, 64),
(745, 83, 8, 71),
(746, 83, 9, 79),
(747, 84, 1, 57),
(748, 84, 2, 97),
(749, 84, 3, 95),
(750, 84, 4, 66),
(751, 84, 5, 59),
(752, 84, 6, 22),
(753, 84, 7, 53),
(754, 84, 8, 88),
(755, 84, 9, 61),
(756, 85, 1, 14),
(757, 85, 2, 89),
(758, 85, 3, 59),
(759, 85, 4, 60),
(760, 85, 5, 68),
(761, 85, 6, 80),
(762, 85, 7, 92),
(763, 85, 8, 75),
(764, 85, 9, 44),
(765, 86, 1, 82),
(766, 86, 2, 51),
(767, 86, 3, 77),
(768, 86, 4, 72),
(769, 86, 5, 84),
(770, 86, 6, 59),
(771, 86, 7, 55),
(772, 86, 8, 51),
(773, 86, 9, 97),
(774, 87, 1, 89),
(775, 87, 2, 62),
(776, 87, 3, 88),
(777, 87, 4, 56),
(778, 87, 5, 93),
(779, 87, 6, 93),
(780, 87, 7, 76),
(781, 87, 8, 91),
(782, 87, 9, 75),
(783, 88, 1, 70),
(784, 88, 2, 89),
(785, 88, 3, 70),
(786, 88, 4, 65),
(787, 88, 5, 97),
(788, 88, 6, 95),
(789, 88, 7, 72),
(790, 88, 8, 65),
(791, 88, 9, 72),
(792, 89, 1, 20),
(793, 89, 2, 76),
(794, 89, 3, 67),
(795, 89, 4, 52),
(796, 89, 5, 90),
(797, 89, 6, 72),
(798, 89, 7, 71),
(799, 89, 8, 89),
(800, 89, 9, 56),
(801, 90, 1, 95),
(802, 90, 2, 83),
(803, 90, 3, 64),
(804, 90, 4, 74),
(805, 90, 5, 59),
(806, 90, 6, 54),
(807, 90, 7, 76),
(808, 90, 8, 96),
(809, 90, 9, 73),
(810, 91, 1, 96),
(811, 91, 2, 59),
(812, 91, 3, 71),
(813, 91, 4, 41),
(814, 91, 5, 33),
(815, 91, 6, 84),
(816, 91, 7, 48),
(817, 91, 8, 84),
(818, 91, 9, 59),
(819, 92, 1, 40),
(820, 92, 2, 98),
(821, 92, 3, 84),
(822, 92, 4, 97),
(823, 92, 5, 29),
(824, 92, 6, 76),
(825, 92, 7, 81),
(826, 92, 8, 72),
(827, 92, 9, 72),
(828, 93, 1, 76),
(829, 93, 2, 96),
(830, 93, 3, 56),
(831, 93, 4, 92),
(832, 93, 5, 83),
(833, 93, 6, 80),
(834, 93, 7, 72),
(835, 93, 8, 54),
(836, 93, 9, 52),
(837, 94, 1, 88),
(838, 94, 2, 79),
(839, 94, 3, 29),
(840, 94, 4, 73),
(841, 94, 5, 99),
(842, 94, 6, 99),
(843, 94, 7, 85),
(844, 94, 8, 90),
(845, 94, 9, 51),
(846, 95, 1, 84),
(847, 95, 2, 70),
(848, 95, 3, 48),
(849, 95, 4, 73),
(850, 95, 5, 13),
(851, 95, 6, 73),
(852, 95, 7, 70),
(853, 95, 8, 87),
(854, 95, 9, 83),
(855, 96, 1, 53),
(856, 96, 2, 78),
(857, 96, 3, 97),
(858, 96, 4, 53),
(859, 96, 5, 88),
(860, 96, 6, 81),
(861, 96, 7, 84),
(862, 96, 8, 55),
(863, 96, 9, 50),
(864, 97, 1, 52),
(865, 97, 2, 98),
(866, 97, 3, 52),
(867, 97, 4, 97),
(868, 97, 5, 11),
(869, 97, 6, 92),
(870, 97, 7, 66),
(871, 97, 8, 90),
(872, 97, 9, 95),
(873, 98, 1, 79),
(874, 98, 2, 96),
(875, 98, 3, 16),
(876, 98, 4, 99),
(877, 98, 5, 76),
(878, 98, 6, 92),
(879, 98, 7, 23),
(880, 98, 8, 73),
(881, 98, 9, 100),
(882, 99, 1, 92),
(883, 99, 2, 76),
(884, 99, 3, 63),
(885, 99, 4, 28),
(886, 99, 5, 94),
(887, 99, 6, 51),
(888, 99, 7, 98),
(889, 99, 8, 87),
(890, 99, 9, 54),
(891, 100, 1, 68),
(892, 100, 2, 49),
(893, 100, 3, 79),
(894, 100, 4, 89),
(895, 100, 5, 65),
(896, 100, 6, 74),
(897, 100, 7, 53),
(898, 100, 8, 67),
(899, 100, 9, 90);

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

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
  `id` int(11) NOT NULL,
  `voornaam` varchar(50) DEFAULT NULL,
  `achternaam` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `student`
--

INSERT INTO `student` (`id`, `voornaam`, `achternaam`, `email`) VALUES
(1, 'Danika', 'Chiese', 'dchiese0@epa.gov'),
(2, 'Paddie', 'Durban', 'pdurban1@seattletimes.com'),
(3, 'Rosemonde', 'Surr', 'rsurr2@ameblo.jp'),
(4, 'Kenyon', 'Russilll', 'krussilll3@ow.ly'),
(5, 'Shaylyn', 'Bilbrey', 'sbilbrey4@globo.com'),
(6, 'Terrijo', 'Anear', 'tanear5@sakura.ne.jp'),
(7, 'Maryjo', 'Wylder', 'mwylder6@imdb.com'),
(8, 'Bo', 'Gantzman', 'bgantzman7@apache.org'),
(9, 'Meagan', 'Lindblom', 'mlindblom8@phpbb.com'),
(10, 'Link', 'Greatbanks', 'lgreatbanks9@alexa.com'),
(11, 'Grayce', 'Brevetor', 'gbrevetora@indiatimes.com'),
(12, 'Allys', 'Seaborne', 'aseaborneb@ca.gov'),
(13, 'Karolina', 'Durning', 'kdurningc@amazon.co.uk'),
(14, 'Pedro', 'Guslon', 'pguslond@over-blog.com'),
(15, 'Winnie', 'Hammonds', 'whammondse@t.co'),
(16, 'Benedick', 'Maciunas', 'bmaciunasf@dell.com'),
(17, 'Charla', 'Feldberg', 'cfeldbergg@prlog.org'),
(18, 'Shane', 'Vennard', 'svennardh@youku.com'),
(19, 'Huntley', 'Hoodlass', 'hhoodlassi@intel.com'),
(20, 'Maddi', 'Petersen', 'mpetersenj@pbs.org'),
(21, 'Felicia', 'Suermeiers', 'fsuermeiersk@creativecommons.org'),
(22, 'Jesse', 'Danaher', 'jdanaherl@blog.com'),
(23, 'Kaylee', 'Gillbard', 'kgillbardm@wunderground.com'),
(24, 'Vanni', 'Gylle', 'vgyllen@wikipedia.org'),
(25, 'Homerus', 'O\'Calleran', 'hocallerano@sbwire.com'),
(26, 'Templeton', 'Saladine', 'tsaladinep@google.co.uk'),
(27, 'Lowell', 'Pawel', 'lpawelq@weather.com'),
(28, 'Belinda', 'Wiles', 'bwilesr@fastcompany.com'),
(29, 'Hildagarde', 'Stanfield', 'hstanfields@tripod.com'),
(30, 'Sven', 'Slingsby', 'sslingsbyt@usnews.com'),
(31, 'Wolfie', 'Bellfield', 'wbellfieldu@imdb.com'),
(32, 'Ddene', 'Varnals', 'dvarnalsv@toplist.cz'),
(33, 'Mirilla', 'Hainey`', 'mhaineyw@ibm.com'),
(34, 'Carver', 'Clayden', 'cclaydenx@theglobeandmail.com'),
(35, 'Amabelle', 'Hembry', 'ahembryy@surveymonkey.com'),
(36, 'Marguerite', 'Beagley', 'mbeagleyz@tiny.cc'),
(37, 'Janey', 'Gillhespy', 'jgillhespy10@admin.ch'),
(38, 'Daniella', 'Hubatsch', 'dhubatsch11@themeforest.net'),
(39, 'Ardyth', 'MacKegg', 'amackegg12@loc.gov'),
(40, 'Marshall', 'Klulicek', 'mklulicek13@list-manage.com'),
(41, 'Mickey', 'Rainforth', 'mrainforth14@irs.gov'),
(42, 'Kylila', 'MacKaig', 'kmackaig15@home.pl'),
(43, 'Alberik', 'Bayman', 'abayman16@hatena.ne.jp'),
(44, 'Gav', 'Puffett', 'gpuffett17@ibm.com'),
(45, 'Elle', 'Vaud', 'evaud18@barnesandnoble.com'),
(46, 'Cash', 'Searight', 'csearight19@facebook.com'),
(47, 'Tildi', 'Topes', 'ttopes1a@stanford.edu'),
(48, 'Serene', 'Delap', 'sdelap1b@dell.com'),
(49, 'Brinn', 'Piccard', 'bpiccard1c@japanpost.jp'),
(50, 'Shea', 'Decourcy', 'sdecourcy1d@guardian.co.uk'),
(51, 'Pollyanna', 'Purton', 'ppurton1e@mashable.com'),
(52, 'Justine', 'Ovise', 'jovise1f@free.fr'),
(53, 'Merridie', 'L\'Homme', 'mlhomme1g@unesco.org'),
(54, 'Roley', 'Giorgielli', 'rgiorgielli1h@wordpress.com'),
(55, 'Appolonia', 'Veel', 'aveel1i@imgur.com'),
(56, 'Cele', 'Lightwing', 'clightwing1j@xing.com'),
(57, 'Thorndike', 'Vannucci', 'tvannucci1k@cnet.com'),
(58, 'Natalie', 'Tschiersch', 'ntschiersch1l@soup.io'),
(59, 'Mathe', 'Cogley', 'mcogley1m@elegantthemes.com'),
(60, 'Del', 'Bille', 'dbille1n@goo.gl'),
(61, 'Davy', 'Daymont', 'ddaymont1o@flickr.com'),
(62, 'Cleveland', 'Connor', 'cconnor1p@baidu.com'),
(63, 'Brittani', 'Pottage', 'bpottage1q@timesonline.co.uk'),
(64, 'Beatrix', 'Harte', 'bharte1r@nih.gov'),
(65, 'Nico', 'Cuskery', 'ncuskery1s@4shared.com'),
(66, 'Pearce', 'Tertre', 'ptertre1t@geocities.com'),
(67, 'Grazia', 'Godmar', 'ggodmar1u@chronoengine.com'),
(68, 'Owen', 'Phelip', 'ophelip1v@google.co.jp'),
(69, 'Ferris', 'Halligan', 'fhalligan1w@odnoklassniki.ru'),
(70, 'Layne', 'Pickerin', 'lpickerin1x@simplemachines.org'),
(71, 'Keslie', 'Stoute', 'kstoute1y@canalblog.com'),
(72, 'Sheri', 'Earingey', 'searingey1z@stumbleupon.com'),
(73, 'Grayce', 'Savatier', 'gsavatier20@xrea.com'),
(74, 'Nicolas', 'Solleme', 'nsolleme21@stanford.edu'),
(75, 'Kore', 'Lutman', 'klutman22@1688.com'),
(76, 'Nadine', 'Burnitt', 'nburnitt23@ifeng.com'),
(77, 'Wini', 'Lamping', 'wlamping24@mail.ru'),
(78, 'Reginauld', 'Dimitriades', 'rdimitriades25@netscape.com'),
(79, 'Henrik', 'Whitlaw', 'hwhitlaw26@biglobe.ne.jp'),
(80, 'Marchelle', 'Farleigh', 'mfarleigh27@stumbleupon.com'),
(81, 'Hestia', 'Kliesl', 'hkliesl28@harvard.edu'),
(82, 'Inna', 'Senchenko', 'isenchenko29@ucoz.com'),
(83, 'Jania', 'Beange', 'jbeange2a@about.com'),
(84, 'Ethe', 'Fruen', 'efruen2b@engadget.com'),
(85, 'Rhoda', 'Whitcomb', 'rwhitcomb2c@senate.gov'),
(86, 'Tersina', 'Dudmarsh', 'tdudmarsh2d@google.com.au'),
(87, 'Phedra', 'Deniske', 'pdeniske2e@ocn.ne.jp'),
(88, 'Therese', 'Ingolotti', 'tingolotti2f@facebook.com'),
(89, 'Tod', 'Shingfield', 'tshingfield2g@comcast.net'),
(90, 'Viv', 'Strettell', 'vstrettell2h@elpais.com'),
(91, 'Sheff', 'Repper', 'srepper2i@soundcloud.com'),
(92, 'Dar', 'Remer', 'dremer2j@typepad.com'),
(93, 'Rollins', 'Hubbis', 'rhubbis2k@friendfeed.com'),
(94, 'Elbertine', 'Hulle', 'ehulle2l@dot.gov'),
(95, 'Thadeus', 'Hevner', 'thevner2m@intel.com'),
(96, 'Sunshine', 'Brocklesby', 'sbrocklesby2n@usgs.gov'),
(97, 'Milli', 'Vampouille', 'mvampouille2o@toplist.cz'),
(98, 'Thaxter', 'Carruth', 'tcarruth2p@disqus.com'),
(99, 'Selig', 'Pagden', 'spagden2q@yolasite.com'),
(100, 'Vanna', 'Molloy', 'vmolloy2r@newyorker.com');

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

--
-- Table structure for table `vak`
--

CREATE TABLE `vak` (
  `id` int(11) NOT NULL,
  `naam` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `vak`
--

INSERT INTO `vak` (`id`, `naam`) VALUES
(1, 'Nederlands'),
(2, 'Engels'),
(3, 'Rekenen'),
(4, 'JavaScript'),
(5, 'PHP'),
(6, 'HTML'),
(7, 'SQL/Databases'),
(8, 'Burgerschap'),
(9, 'IT Security');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cijfer`
--
ALTER TABLE `cijfer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_student` (`student_id`),
  ADD KEY `fk_vak` (`vak_id`);

--
-- Indexes for table `student`
--
ALTER TABLE `student`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vak`
--
ALTER TABLE `vak`
  ADD PRIMARY KEY (`id`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cijfer`
--
ALTER TABLE `cijfer`
  ADD CONSTRAINT `fk_student` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`),
  ADD CONSTRAINT `fk_vak` FOREIGN KEY (`vak_id`) REFERENCES `vak` (`id`);
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 */;