CREATE TABLE simpanan
(kode_simpanan CHAR(10) PRIMARY KEY,
kode_kategori_simpanan CHAR(10), CONSTRAINT fk_simpanan_kategorisimpanan foreign KEY(kode_kategori_simpanan)
references kategori_simpanan(kode_kategori_simpanan) ON DELETE CASCADE,
kode_nasabah CHAR(10), CONSTRAINT fk_simpanan_nasabah foreign KEY(kode_nasabah)
references nasabah(kode_nasabah) ON DELETE CASCADE,
nominal int);

INSERT INTO simpanan VALUES ('S0001','KS001','KN001','500000');
INSERT INTO simpanan VALUES ('S0002','KS002','KN002','300000');
INSERT INTO simpanan VALUES ('S0003','KS002','KN003','100000');
SELECT * FROM simpanan;