CREATE TABLE nasabah
(kode_nasabah CHAR(10) PRIMARY KEY,
nama_nasabah VARCHAR2(30) NOT NULL,
jenis_kelamin CHAR(1) CHECK (jenis_kelamin IN('L','P')),
tempat_lahir VARCHAR2(50),
tanggal_lahir DATE,
alamat VARCHAR(50),
kode_petugas CHAR(10), CONSTRAINT fk_nasabah_petugas foreign KEY(kode_petugas)
references petugas(kode_petugas) ON DELETE CASCADE);

INSERT INTO nasabah VALUES ('KN001','Irfan','L','Bandung','1-Jan-2000','Kebun Jeruk','KP001');
INSERT INTO nasabah VALUES ('KN002','Mirana','P','Jakarta','1-Mar-2000','Kenali','KP001');
INSERT INTO nasabah VALUES ('KN003','Luna','P','Bali','1-Jun-2000','Jelutung','KP001');
SELECT * FROM nasabah;