DDL Restoran bentar taro sini dulu

CREATE TABLE pelanggan
    (
        no_pelanggan VARCHAR(10) NOT NULL,
        nama VARCHAR(50) NOT NULL,
        alamat text NOT NULL,
        jkelamin VARCHAR(12) NOT NULL,
        PRIMARY KEY (no_pelanggan)
    )
        ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE kasir
    (
        nik VARCHAR(10) NOT NULL,
        nama VARCHAR(50) NOT NULL,
        alamat text NOT NULL,
        jkelamin VARCHAR(12) NOT NULL,
        PRIMARY KEY (nik)
    )
        ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE chef
    (
        nid VARCHAR(10) NOT NULL,
        nama VARCHAR(50) NOT NULL,
        alamat text NOT NULL,
        jkelamin VARCHAR(12) NOT NULL,
        PRIMARY KEY (nid)
    )
        ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE pelayan
    (
        nid VARCHAR(10) NOT NULL,
        nama VARCHAR(50) NOT NULL,
        alamat text NOT NULL,
        jkelamin VARCHAR(12) NOT NULL,
        PRIMARY KEY (nid)
    )
        ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE pelayan
    (
        nid VARCHAR(10) NOT NULL,
        nama VARCHAR(50) NOT NULL,
        alamat text NOT NULL,
        jkelamin VARCHAR(12) NOT NULL,
        PRIMARY KEY (nid)
    )
        ENGINE=InnoDB DEFAULT CHARSET=latin1;