GX1ShT71

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