RELASI ANTAR 2 TABEL (WHERE)

1.  Buat table nasabah

CREATE TABLE `BANK`.`Nasabah` (

`Id_nasabah` VARCHAR( 15 ) NOT NULL ,
`Nama_nasabah` VARCHAR( 25 ) NOT NULL ,
`Alamat_nasabah` TEXT NOT NULL

) ENGINE = InnoDB;

2.       Buat table rekening

CREATE TABLE `bank`.`Rekening` (

`Id_nasabah` VARCHAR( 15 ) NOT NULL ,
`Nomor_rekening` VARCHAR( 25 ) NOT NULL ,
`Saldo` FLOAT( 10 ) NOT NULL ,
`Kode_cabang` CHAR( 10 ) NOT NULL

) ENGINE = InnoDB;

3.     Buat table cabang

CREATE TABLE `bank`.`Cabang` (

`Kode_cabang` VARCHAR( 15 ) NOT NULL ,
`Nama_cabang` VARCHAR( 25 ) NOT NULL ,
`Kota` VARCHAR( 15 ) NOT NULL

) ENGINE = InnoDB;

Terbentuk 3 table

44.   Memasukkan data ke table cabang

INSERT INTO `bank`.`cabang` (

`Kode_cabang` ,
`Nama_cabang` ,
`Kota`

)
VALUES (

'A123', 'JKT01', 'Jakarta Pusat'

), (

55.  Memasukkan data ke table nasabah

INSERT INTO `bank`.`nasabah` (

`Id_nasabah` ,
`Nama_nasabah` ,
`Alamat_nasabah`

)
VALUES (

'AA001', 'Rudi', 'Jl. Sepat'

), (

INSERT INTO `bank`.`rekening` (

`Id_nasabah` ,
`Nomor_rekening` ,
`Saldo` ,
`Kode_cabang`

)
VALUES (

'AA001', '001000123', '20.000.000', 'A123'

), (

'AB002', '002000123', '5.000.000', 'B123'

), (

'CC003', '003000123', '75.000.000', 'C123'

), (

'CD004', '004000123', '20.000.000', 'D123'

), (

'DD005', '004000123', '1.500.000', 'E123'

);