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'
);