(Nomor 1 - 4 Menggunakan MySQL Syntax)
1. create database dblatihan7;
2.
    a. CREATE TABLE tbl_kendaraan (kd_kendaraan nchar(10) not null, kd_jenis nchar(10) not null, kd_sopir nchar(9) not null, nopol nchar(9) not null, tahun int not null, warna nchar(15), PRIMARY KEY(kd_kendaraan, kd_jenis, kd_sopir));
    b. CREATE TABLE tbl_jenis (kd_jenis nchar(10) not null, nm_jenis nchar(20) not null, PRIMARY KEY(kd_jenis));
    c. CREATE TABLE tbl_sopir (kd_sopir nchar(9) not null, nm_sopir nchar(30) not null, jk nchar(1) not null, alamat nchar(50), PRIMARY KEY(kd_sopir));
3.
    a. ALTER TABLE tbl_kendaraan ADD CONSTRAINT FK_kdjenis FOREIGN KEY (kd_jenis) REFERENCES tbl_jenis(kd_jenis);
    b. ALTER TABLE tbl_kendaraan ADD CONSTRAINT FK_kdsopir FOREIGN KEY (kd_sopir) REFERENCES tbl_sopir(kd_sopir);

4.
    1. (Menambahkan Field umur):
       ALTER TABLE tbl_sopir ADD COLUMN umur int;
    2. (Trigger agar field jk bisa diinput 'L' atau 'P' saja)
    DELIMITER $$
    CREATE TRIGGER CHK_jk BEFORE INSERT ON `tbl_sopir`
        FOR EACH ROW
        BEGIN
            IF (NEW.jk NOT IN ('L', 'P')) THEN
                SIGNAL sqlstate '45000'
            SET message_text = 'Hanya bisa diinput L atau P saja';
            END IF;
        END$$
    DELIMITER ;