DDL dan DML

CREATE TABLE mahasiswa(
    npm CHAR(10),
    nama VARCHAR(32),
    par CHAR(2),
    jur VARCHAR(32),
    CONSTRAINT pk_mahasiswa PRIMARY KEY(npm)
    );

CREATE TABLE matkul(
    kd_mk CHAR(4),
    nama_mk VARCHAR(32),
    sks CHAR(1),
    semester VARCHAR(2),
    CONSTRAINT pk_matkul PRIMARY KEY(kd_mk)
    );

CREATE TABLE dosen(
    nip CHAR(10),
    nama VARCHAR(32),
    telp VARCHAR(16),
    email VARCHAR(64),
    CONSTRAINT pk_dosen PRIMARY KEY(nip)
    );


INSERT ALL
INTO mahasiswa VALUES('1634010001','Diego Alves','1A','IF')
INTO mahasiswa VALUES('1634010002','Joao Cancelo','1A','IF')
INTO mahasiswa VALUES('1634010003','Ruben Vezo','1A','IF')
INTO mahasiswa VALUES('1634010004','Aderlan Santos','1A','IF')
INTO mahasiswa VALUES('1634010005','Jose Luis Gaya','1A','IF')
INTO mahasiswa VALUES('1634010006','Sofiane Feghouli','1A','IF')
INTO mahasiswa VALUES('1634010007','Daniel Parejo','1A','IF')
INTO mahasiswa VALUES('1634010008','Andre Gomes','1A','IF')
INTO mahasiswa VALUES('1634010009','Denis Cheryshev','1A','IF')
INTO mahasiswa VALUES('1634010010','Paco Alcacer','1A','IF')
SELECT * FROM DUAL;

INSERT ALL
INTO matkul VALUES('IF01','PEMROGRAMAN BERORIENTASI OBJEK','4','2')
INTO matkul VALUES('IF02','ALJABAR LINIER & MATRIKS','3','2')
INTO matkul VALUES('IF03','SISTEM INFORMASI','3','2')
INTO matkul VALUES('IF04','BASIS DATA','4','2')
INTO matkul VALUES('IF05','ETIKA PROFESI','2','2')
INTO matkul VALUES('IF06','AGAMA ISLAM','3','2')
INTO matkul VALUES('IF07','BAHASA INGGRIS II','2','2')
INTO matkul VALUES('IF08','BAHASA INDONESIA','3','1')
INTO matkul VALUES('IF09','SISTEM DIGITAL','3','1')
INTO matkul VALUES('IF10','ALGORITMA DAN PEMROGRAMAN','4','1')
SELECT * FROM DUAL;

INSERT ALL
INTO dosen VALUES('0317823001','Mathew Ryan','085730462810','mr@gmail.com')
INTO dosen VALUES('0317823002','Shkodran Mustafi','085730462809','sm@gmail.com')
INTO dosen VALUES('0317823003','Gulherme Siqueira','085730462808','gs@gmail.com')
INTO dosen VALUES('0317823004','Antonio Barragan','085730462807','ab@gmail.com')
INTO dosen VALUES('0317823005','Danilo Barbosa','085730462806','db@gmail.com')
INTO dosen VALUES('0317823006','Enzo Perez','085730462805','ep@gmail.com')
INTO dosen VALUES('0317823007','Javi Fuego','085730462804','jf@gmail.com')
INTO dosen VALUES('0317823008','Pablo Piatti','085730462803','pp@gmail.com')
INTO dosen VALUES('0317823009','Zakaria Bakkali','085730462802','zb@gmail.com')
INTO dosen VALUES('0317823010','Rodrigo','085730462801','r@gmail.com')
SELECT * FROM DUAL;

UPDATE matkul SET nama_mk='Pengantar Sistem Informasi',sks='3',semester='1' WHERE kd_mk='IF05';

DELETE FROM dosen WHERE nip='0317823010';

SELECT*FROM dosen;
SELECT*FROM matkul;
SELECT*FROM mahasiswa;

ALTER TABLE mahasiswa MODIFY par VARCHAR(2);

DROP TABLE dosen;