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','[email protected]')
INTO dosen VALUES('0317823002','Shkodran Mustafi','085730462809','[email protected]')
INTO dosen VALUES('0317823003','Gulherme Siqueira','085730462808','[email protected]')
INTO dosen VALUES('0317823004','Antonio Barragan','085730462807','[email protected]')
INTO dosen VALUES('0317823005','Danilo Barbosa','085730462806','[email protected]')
INTO dosen VALUES('0317823006','Enzo Perez','085730462805','[email protected]')
INTO dosen VALUES('0317823007','Javi Fuego','085730462804','[email protected]')
INTO dosen VALUES('0317823008','Pablo Piatti','085730462803','[email protected]')
INTO dosen VALUES('0317823009','Zakaria Bakkali','085730462802','[email protected]')
INTO dosen VALUES('0317823010','Rodrigo','085730462801','[email protected]')
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;