DDL tubes pbdr

CREATE TABLE lokasi(
id_lokasi CHAR(9) CONSTRAINT pk_lokasi PRIMARY KEY,
letak varchar2(10)
);

CREATE TABLE petugas(
id_petugas CHAR(9) CONSTRAINT pk_petugas PRIMARY KEY,
nama_petugas varchar2(30),
almt_petugas varchar2(30),
tlp_petugas CHAR(12)
);

CREATE TABLE pembeli(
id_member CHAR(9) CONSTRAINT pk_member PRIMARY KEY,
nama_member varchar2(30),
tgl_join DATE,
tg_exp DATE
);

CREATE TABLE penerbit(
id_penerbit CHAR(9) CONSTRAINT pk_penerbit PRIMARY KEY,
nama_penerbit varchar2(30),
almt_penerbit varchar2(50),
tlp_penerbit CHAR(12)
);

CREATE TABLE kategori(
id_kategori CHAR(9) CONSTRAINT pk_kategori PRIMARY KEY,
jenis varchar2(15),
id_lokasi CHAR(9),
CONSTRAINT fk_lokasi FOREIGN KEY(id_lokasi) REFERENCES lokasi ON DELETE cascade
);

CREATE TABLE buku(
kode CHAR(9) CONSTRAINT pk_buku PRIMARY KEY,
judul varchar2(30),
pengarang varchar2(30),
status_diskon NUMBER(4,2),
jumlah NUMBER,
id_kategori CHAR(9),
id_penerbit CHAR(9),
CONSTRAINT fk_kategori FOREIGN KEY(id_kategori) REFERENCES kategori ON DELETE cascade,
CONSTRAINT fk_penerbit FOREIGN KEY(id_penerbit) REFERENCES penerbit ON DELETE cascade
);

CREATE TABLE dijual(
id_jual CHAR(9) CONSTRAINT id_jual PRIMARY KEY,
tgl_jual DATE,
harga_jual NUMBER,
id_member CHAR(9),
kode CHAR(9),
id_petugas CHAR(9),
CONSTRAINT fk_pembeli FOREIGN KEY(id_member) REFERENCES pembeli ON DELETE cascade,
CONSTRAINT fk_petugas FOREIGN KEY(id_petugas) REFERENCES petugas ON DELETE cascade,
CONSTRAINT fk_buku FOREIGN KEY(kode) REFERENCES buku ON DELETE cascade
);

CREATE TABLE inventaristoko(
id_inventaris CHAR(9) CONSTRAINT pk_inventaris PRIMARY KEY,
nama_barang varchar2(30),
kondisi varchar2(15),
tgl_beli DATE,
id_petugas CHAR(9),
CONSTRAINT fk_petugas_inventaris FOREIGN KEY(id_petugas) REFERENCES petugas ON DELETE cascade
);