CREATE DATABASE diafilmek;
USE diafilmek;

CREATE TABLE Film (
    id INT(11) PRIMARY KEY,
    cim VARCHAR(100),
    kiadasiev INT(11),
    kocka INT(11),
    szinese TINYINT(1)
);

CREATE TABLE Kiado (
    id INT(11) PRIMARY KEY,
    nev VARCHAR(100)
);

CREATE TABLE Kapcsolo (
    filmid INT(11),
    kiadoid INT(11),
    PRIMARY KEY (filmid, kiadoid),
    FOREIGN KEY (filmid) REFERENCES film(filmid),
    FOREIGN KEY (kiadoid) REFERENCES kiado(kiadoid)
);

INSERT INTO film (id, cim, kiadasiev, kocka, szinese) VALUES
(1, 'Bolondfalva', 1958, 27, 1),
(2, 'Dia Dani űrutazása', 1958, 32, 1),
(3, 'Odüsszeusz kalandjai', 1958, 60, 1),
(4, 'Az égig érő fa', 1962, 38, 1),
(5, 'Böbe baba és a horgászbot', 2000, 28, 1),
(6, 'Egy ceruza kalandjai', 1960, 32, 1),
(7, 'Dia Dani kalandjai a gépemberrel', 1960, 32, 1),
(8, 'Benyovszky Móric kalandjai', 1959, 70, 1),
(9, 'Csalóka Péter', 1959, 41, 1),
(10, 'A dzsungel meséje', 1959, 47, 1),
(11, 'Az aranyszőrű bárányka', 1959, 31, 1),
(12, 'Az árvízi hajós', 1958, 74, 0),
(13, 'Csali és a léggömbök', 1958, 18, 1),
(14, 'A didergő király', 1958, 36, 1),
(15, 'A bűvös kép', 1958, 45, 1),
(16, 'Égből pottyant vendég', 1958, 38, 1),
(17, 'Borzas Misi', 1958, 49, 1),
(18, 'Csodabot', 1957, 46, 1),
(19, 'Jancsi és Juliska mézeskalácsházikója', 1961, 30, 1),
(20, 'A hét kis törpe egyedül', 1961, 30, 1),
(21, 'Az engedetlen kisfiú', 1958, 50, 1),
(22, 'Két kis csavargó', 1958, 29, 1),
(23, 'Három kívánság', 1962, 27, 1),
(24, 'A hókirálynő', 1962, 43, 1),
(25, 'A kincses barlang', 1961, 30, 1),
(26, 'Furcsa vándorok', 1960, 40, 1),
(27, 'A falánk kiskacsa', 1960, 24, 1),
(28, 'Hangyaország', 1961, 26, 1),
(29, 'Esőcseppecskék', 1959, 19, 1),
(30, 'A fából faragott királyfi', 1960, 39, 1),
(31, 'Az eltévedt kiscica', 1959, 27, 0),
(32, 'Az ezeregyéjszaka meséiből', 1960, 24, 1),
(33, 'Hárman Atlantiszban', 1958, 46, 1),
(34, 'Lurkó a mesterdetektív', 1958, 22, 1),
(35, 'Első nap az óvodában', 1959, 33, 1),
(36, 'Dia Kati Játékországban', 1962, 32, 0),
(37, 'Dia Dani és Dini kutya', 1961, 35, 1),
(38, 'Hivatlan vendég', NULL, 41, 1),
(39, 'A hálás sündisznó', 1957, 54, 1),
(40, 'Hasznos örökség', 1957, 35, 1),
(41, 'Hárman a Holdban', 1957, 43, 0),
(42, 'Lurkó és a varázsital', 1957, 36, 1),
(43, 'Három kis törpe', 1957, 31, 1),
(44, 'Egy hűtlen kutya kalandjai Ugatóniában', 1957, 34, 0),
(45, 'Lesipuskás', 1957, 44, 1),
(46, 'Az igazi barátság', 1957, 31, 1),
(47, 'Moby Dick a fehér bálna', NULL, 52, 1),
(48, 'A megszökött játékok', NULL, 40, 1),
(49, 'Mese a kis óriásról', 1962, 30, 1),
(50, 'A nagyhatalmú sündisznócska', 1962, 26, 1);

INSERT INTO kiado (id, nev) VALUES
(1, 'Magyar Diafilmgyártó Vállalat'),
(2, 'Diafilmgyártó Kft'),
(3, 'Magyar Könyvkereskedelmi Vállalat'),
(4, 'Medicina Film'),
(5, 'Wspólna Sprawa Fotó és Diafilm Vállalat'),
(6, 'Medicina Könyvkiadó'),
(7, 'Magyar Fotó Dia-osztálya'),
(8, 'Állami Biztosító'),
(9, 'Egészségügyi Felvilágosító Központ'),
(10, 'Szövetkezetek Országos Szövetsége'),
(11, 'Filmtrade'),
(12, 'Magyar Szinkron és Videó Vállalat'),
(13, 'Horizont Könyv- Lap- és Zeneműterjesztő Vállalat'),
(14, 'Játéktervező Intézet'),
(15, 'Ecclesia Szövetkezet'),
(16, 'Népművelési Minisztérium'),
(17, 'Állami Könyvterjesztő Vállalat');

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