Ya4FLvcz

1DROP TABLE IF EXISTS `pemain`;
2 
3CREATE TABLE `pemain` (
4    `id_pemain` INT(11) NOT NULL,
5    `id_klub` INT(11) NOT NULL,
6    `nama_depan` VARCHAR(50) NOT NULL,
7    `nama_belakang` VARCHAR(50) NOT NULL,
8    `tanggal_lahir` DATE NOT NULL,
9    `warga_negara` VARCHAR(50) NOT NULL,
10    PRIMARY KEY (`id_pemain`),
11    CONSTRAINT `fk_pemain` FOREIGN KEY (`id_klub`) REFERENCES `klub` (`id_klub`) ON DELETE NO ACTION ON UPDATE NO ACTION
12    
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14 
15INSERT INTO `pemain` VALUES (1, 1, 'cristiano', 'messi', '1988-03-31', 'spanyol'),
16(2, 2, 'lionel', 'ramos', '1983-04-06', 'jepang'),
17(3, 3, 'sergio', 'benzema', '1977-05-21', 'australia'),
18(4, 4, 'karim', 'ji sung', '1990-07-12', 'argentina'),
19(5, 5, 'park', 'ronaldo', '1987-09-10', 'denmark'),
20(6, 1, 'bang', 'jago', '2000-12-02', 'indonesia'),
21(7, 2, 'kim', 'jong un', '1960-11-06', 'korea utara'),
22(8, 3, 'vladimir', 'putin', '1965-08-07', 'rusia'),
23(9, 4, 'prabowo', 'subianto', '1985-01-02', 'inggris'),
24(10, 5, 'donald', 'trump', '1999-02-04', 'amerika serikat');
25 
26 
27DROP TABLE IF EXISTS `no_punggung`;
28 
29CREATE TABLE `no_punggung` (
30    `id_pemain` INT(11) NOT NULL,
31    `nomor_punggung` INT(11) NOT NULL,
32    PRIMARY KEY (`id_pemain`),
33    CONSTRAINT `fk_pemain` FOREIGN KEY (`id_pemain`) REFERENCES `pemain` (`id_pemain`) ON DELETE NO ACTION ON UPDATE NO ACTION
34) ENGINE=InnoDB DEFAULT CHARSET=utf8;
35 
36INSERT INTO `pemain` VALUES (1, 3),
37(2, 21),
38(3, 1),
39(4, 20),
40(5, 9),
41(6, 10),
42(7, 20),
43(8, 15),
44(9, 0),
45(10, 19);