Tuliskan record berikut ke masing-masing tabelnya pada database perbankan. Sebagai latihan jangan lupa sebelum menggunakan database anda harus memberikan perintah use <namadatabase>.
Isi record tabel Nasabah
| Idnasabah | Nmnasabah | Alamat |
|-----------|---------------------|-------------------------------|
| 1 | Ali Wardana | Karangkajen Kidul No. 72 |
| 2 | Susiana | Mergangsan Lor RT 02 No. 24 |
| 3 | Jaka Nugraha | Jl. Tamansiswa No. 142 |
| 4 | Fitriana Kusumawati | Jl. Tamansiswa No. 32 |
| 5 | Nilawati | Jl. Diponegoro Kranggan RT 04 |
| 6 | Mulawarman | Karangkajen Kidul RT. 18 |
| 7 | Purwanti | Jl. Tamansiswa No. 59 |
| 8 | Indah Rinawati | Karangkajen Kidul No. 34 |
| 9 | Laila Mirawardani | Jl. Tamansiswa No. 24 |
Untuk mengeksekusi tekan F5 atau tombol Query Execute. Untuk melihat hasilnya anda dapat memberikan perintah berikut ini:
Select * from nasabah
Isi record tabel Cabang
| Kdcabang | Nmcabang | Alamat |
|----------|-------------------|--------------------------|
| B1 | BPR Cahaya Insani | Karangkajen Kidul No. 12 |
| B2 | BPR Cahaya Mitra | Jl. Tamansiswa No.17 |
| B3 | BPR Cahaya Madani | Mergangsan Lor No. 4 |
Isi record tabel Rekening
| Norek | Kdcabang | Pin | Saldo |
|-------|----------|--------|--------|
| 101 | B1 | 111111 | 250000 |
| 102 | B1 | 222222 | 125000 |
| 103 | B3 | 333333 | 575000 |
| 104 | B1 | 444444 | 300000 |
| 105 | B3 | 555555 | 300000 |
| 106 | B1 | 666666 | 750000 |
| 107 | B2 | 777777 | 525000 |
| 108 | B2 | 888888 | 150000 |
| 109 | B1 | 999999 | 125000 |
Isi record tabel Nasabah_rek
| Idnasabah | Norek |
|-----------|-------|
| 1 | 104 |
| 2 | 103 |
| 3 | 105 |
| 3 | 106 |
| 4 | 101 |
| 4 | 107 |
| 5 | 102 |
| 5 | 107 |
Isi record tabel Transaksi
| Notransaksi | Norek | Idnasabah | jenistran | Tgl | Jml |
|-------------|-------|-----------|-----------|------------|-------|
| 1 | 105 | 3 | Debit | 2003-03-10 | 20000 |
| 2 | 103 | 2 | Debit | 2003-03-10 | 15000 |
| 3 | 101 | 4 | Kredit | 2003-03-12 | 20000 |
| 4 | 106 | 3 | Debit | 2003-03-13 | 20000 |
| 5 | 107 | 5 | Kredit | 2003-03-13 | 35000 |
| 6 | 104 | 1 | Kredit | 2003-03-15 | 15000 |
| 7 | 101 | 4 | Kredit | 2003-03-15 | 35000 |
| 8 | 102 | 5 | Debit | 2003-03-16 | 20000 |
| 9 | 105 | 3 | Kredit | 2003-03-18 | 20000 |
| 10 | 107 | 4 | Debit | 2003-03-19 | 35000 |
| 11 | 103 | 2 | Debit | 2003-03-19 | 15000 |
| 12 | 104 | 1 | Debit | 2003-03-19 | 35000 |
| 13 | 107 | 4 | Kredit | 2003-03-20 | 35000 |
| 14 | 105 | 3 | Debit | 2003-03-21 | 20000 |
| 15 | 104 | 1 | Kredit | 2003-03-22 | 15000 |
| 16 | 101 | 4 | Kredit | 2003-03-22 | 20000 |
| 17 | 103 | 2 | Debit | 2003-03-22 | 15000 |
| 18 | 102 | 5 | Debit | 2003-03-25 | 35000 |
| 19 | 107 | 5 | Debit | 2003-03-26 | 20000 |
| 20 | 106 | 3 | Kredit | 2003-03-27 | 35000 |
| 21 | 103 | 2 | Kredit | 2003-03-28 | 35000 |
| 22 | 105 | 3 | Kredit | 2003-03-28 | 20000 |
| 23 | 102 | 5 | Debit | 2003-03-28 | 35000 |
| 24 | 104 | 1 | Debit | 2003-03-28 | 15000 |
| 25 | 103 | 2 | Debit | 2003-03-29 | 20000 |
| 26 | 101 | 4 | Debit | 2003-03-29 | 20000 |
| 27 | 103 | 2 | Kredit | 2003-03-29 | 20000 |
| 28 | 102 | 5 | Kredit | 2003-03-30 | 35000 |
| 29 | 101 | 4 | Debit | 2003-03-30 | 35000 |
| 30 | 105 | 3 | Debit | 2003-03-30 | 20000 |
