Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE peminjaman
- (kode_peminjaman CHAR(10) PRIMARY KEY,
- kode_kategori_peminjaman CHAR(10), CONSTRAINT fk_peminjaman_kat_pem
- foreign KEY(kode_kategori_peminjaman) references kategori_peminjaman(kode_kategori_peminjaman)
- ON DELETE CASCADE,
- kode_nasabah CHAR(10), CONSTRAINT fk_peminjaman_nasabah
- foreign KEY(kode_nasabah) references nasabah(kode_nasabah) ON DELETE CASCADE,
- nominal_peminjaman int);
- DESC peminjaman;
- INSERT INTO peminjaman VALUES('PJ001','KP001','KN001','1000000');
- INSERT INTO peminjaman VALUES('PJ002','KP002','KN002','1500000');
- INSERT INTO peminjaman VALUES('PJ003','KP003','KN003','2000000');
- SELECT * FROM peminjaman;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement