Dy6nPfHP

1SET FOREIGN_KEY_CHECKS=0;
2
3DROP TABLE IF EXISTS `mahasiswa`;
4CREATE TABLE IF NOT EXISTS `mahasiswa` (
5  `niu` varchar(50) NOT NULL,
6  `nama` varchar(50) NOT NULL,
7  `prodi` varchar(50) NOT NULL,
8  PRIMARY KEY (`niu`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1;
10
11INSERT INTO `mahasiswa` (`niu`, `nama`, `prodi`) VALUES
12	('00066', 'Derti', 'Kimia'),
13	('00114', 'Alfi', 'Rekmed'),
14	('00287', 'Syifa', 'Matematika'),
15	('00888', 'Anik', 'Gizi'),
16	('00993', 'Agnes', 'Ilkom'),
17	('01040', 'Dahlia', 'Statistika'),
18	('01052', 'Wahyu', 'Rekmed'),
19	('01104', 'Syifa', 'Pend. Dokter');
20
21DROP TABLE IF EXISTS `kelas_mk`;
22CREATE TABLE IF NOT EXISTS `kelas_mk` (
23  `kode` varchar(50) NOT NULL,
24  `nama` varchar(50) NOT NULL,
25  PRIMARY KEY (`kode`)
26) ENGINE=InnoDB DEFAULT CHARSET=latin1;
27
28INSERT INTO `kelas_mk` (`kode`, `nama`) VALUES
29	('A', 'Agama'),
30	('B', 'Basdat'),
31	('C', 'KKPMT');
32
33DROP TABLE IF EXISTS `krs`;
34CREATE TABLE IF NOT EXISTS `krs` (
35  `niu` varchar(50) NOT NULL,
36  `kode` varchar(50) NOT NULL,
37  `nilai` int(11) NOT NULL,
38  PRIMARY KEY (`niu`,`kode`),
39  KEY `kode` (`kode`),
40  CONSTRAINT `krs_ibfk_1` FOREIGN KEY (`niu`) REFERENCES `mahasiswa` (`niu`),
41  CONSTRAINT `krs_ibfk_2` FOREIGN KEY (`kode`) REFERENCES `kelas_mk` (`kode`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43
44INSERT INTO `krs` (`niu`, `kode`, `nilai`) VALUES
45	('00066', 'C', 67),
46	('00114', 'A', 90),
47	('00287', 'C', 78),
48	('00993', 'B', 87),
49	('01040', 'C', 89),
50	('01052', 'A', 70),
51	('01052', 'B', 88),
52	('01104', 'A', 67),
53	('01104', 'B', 99);
54
55SET FOREIGN_KEY_CHECKS=1;