Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Drop DATABASE IF EXISTS akademik;
- CREATE DATABASE IF NOT EXISTS akademik;
- Use akademik;
- CREATE TABLE prodi (
- Kode_prodi VARCHAR(3),
- Nama_prodi VARCHAR(25),
- Fakultas VARCHAR(20),
- PRIMARY KEY (Kode_prodi)
- )ENGINE=InnoDB;
- CREATE TABLE mahasiswa (
- Nim CHAR(8),
- Nama VARCHAR(25),
- Alamat VARCHAR(50),
- Kode_prodi VARCHAR(3),
- PRIMARY KEY (Nim),
- FOREIGN KEY (Kode_prodi) REFERENCES prodi(Kode_prodi) ON DELETE CASCADE ON UPDATE CASCADE
- )ENGINE=InnoDB;
- CREATE TABLE matkul (
- kdmk CHAR(5),
- nama VARCHAR(20),
- sks CHAR(1),
- smst CHAR(1),
- PRIMARY KEY (kdmk)
- )ENGINE=InnoDB;
- INSERT INTO matkul VALUES
- ('IF321','Basis Data','4','3'),
- ('IF123','Kalkulus','3','1'),
- ('IF987','Metode Numerik','2','3'),
- ('IF879','Sistem Operasi','2','2');
- CREATE TABLE nilai (
- kdmk CHAR(5),
- nim CHAR(8),
- angka CHAR(3),
- indeks CHAR(1),
- FOREIGN KEY (kdmk) REFERENCES matkul(kdmk) ON DELETE CASCADE ON UPDATE CASCADE,
- FOREIGN KEY(nim) REFERENCES mahasiswa(nim) ON DELETE CASCADE ON UPDATE CASCADE
- )ENGINE=InnoDB;
- INSERT INTO PRODI VALUES
- ('IF','Teknik Informatika','Teknik dan Ilmu Komputer'),
- ('DKV','Desain Komunikasi Visual','Desain'),
- ('ARS','Teknik Arsitektur','Teknik dan Ilmu Komputer'),
- ('SPL','Teknik Sipil','Teknik dan Ilmu Komputer'),
- ('HKM','Ilmu Hukum','Hukum');
- INSERT INTO mahasiswa VALUES
- ('10110001','Ari Tresnawan','Bandung Pasisir','IF'),
- ('51910001','Abdi Negara','Cimahi Beulah Gigir A 23','DKV'),
- ('51910002','Budi Susanto','Karang Anyar A 23','DKV'),
- ('31610001','Susan Susanti','Banjarnegara B 53','HKM');
- CREATE TABLE log_mhs (
- Kejadian VARCHAR(100),
- Waktu DATETIME
- )ENGINE=InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement