CREATE TABLE angsuran
(kode_angsuran CHAR(10) PRIMARY KEY,
kode_peminjaman CHAR(10), CONSTRAINT fk_angsuran_peminjaman
foreign KEY(kode_peminjaman) references peminjaman(kode_peminjaman)
ON DELETE CASCADE,
angsuran_ke NUMBER(2),
nominal int);

INSERT INTO angsuran VALUES ('KA001','PJ001','1','250000');
INSERT INTO angsuran VALUES ('KA002','PJ002','1','300000');
INSERT INTO angsuran VALUES ('KA003','PJ003','1','380000');
SELECT * FROM angsuran;