Tugas ke 3
MySQL Xxamp BAB 8 : RELASI ANTAR 2 TABEL (WHERE) - BANK
Nama : Fayuda Puspanindra
Npm : 2010 4350 1131
Kelas : S4_N
Dosen : Nahot Frastian, S.Kom.
---------------------------------------------------------------------------------------------
CREATE DATABASE `Bank` ;
CREATE TABEL ‘nasabah’, ‘3’
INSERT FIELD
‘nasabah’
‘id_nasabah’,’nama_nasabah’,’alamat_nasabah’
CREATE TABLE `Bank`.`Nasabah` (
`id_nasabah` VARCHAR( 7 ) NOT NULL ,
`nama_nasabah` VARCHAR( 7 ) NOT NULL ,
`alamat_nasabah` VARCHAR( 15 ) NOT NULL
`nama_nasabah` VARCHAR( 7 ) NOT NULL ,
`alamat_nasabah` VARCHAR( 15 ) NOT NULL
) ENGINE = INNODB;
CREATE TABEL ‘rekening’, ‘4’
INSERT FIELD
‘rekening’
‘id_nasabah’,’nomor_rekening’,’saldo’,’kode_cabang’
CREATE TABLE `Bank`.`rekening` (
`id_nasabah` VARCHAR( 7 ) NOT NULL ,
`nomor_rekening` VARCHAR( 15 ) NOT NULL ,
`saldo` INT( 100 ) NOT NULL ,
`kode_cabang` VARCHAR( 7 ) NOT NULL
`nomor_rekening` VARCHAR( 15 ) NOT NULL ,
`saldo` INT( 100 ) NOT NULL ,
`kode_cabang` VARCHAR( 7 ) NOT NULL
) ENGINE = INNODB;
CREATE TABEL ‘cabang’, ‘3’
INSERT FIELD
‘cabang’
‘kode_cabang’,’nama_cabang’,’saldo’,’kota’
CREATE TABLE `Bank`.`cabang` (
`kode_cabang` VARCHAR( 7 ) NOT NULL ,
`nama_cabang` VARCHAR( 7 ) NOT NULL ,
`kota` VARCHAR( 15 ) NOT NULL
`nama_cabang` VARCHAR( 7 ) NOT NULL ,
`kota` VARCHAR( 15 ) NOT NULL
) ENGINE = INNODB;
INSERT VALUE
‘nasabah’
INSERT INTO `Bank`.`nasabah` (`id_nasabah`,
`nama_nasabah`, `alamat_nasabah`) VALUES ('AA001', 'Rudi', 'Jl. Sepat'),
('AB002', 'Yuni', 'Jl. Baung'), ('CC003', 'Hanny', 'Jl. Gurame'), ('CD004',
'Kiki', 'Jl. Nila'), ('DD005', 'Lala', 'Jl. Mujair');
INSERT VALUE ‘rekening’
INSERT INTO
`Bank`.`rekening` (`id_nasabah`, `nomor_rekening`, `saldo`, `kode_cabang`)
VALUES ('AA001', '001000123', '20000000', 'A123'), ('AB002', '002000123',
'5000000', 'B123'), ('CC003', '003000123', '75000000', 'C123'), ('CD004',
'004000123', '20000000', 'D123'), ('DD005', '005000123', '1500000', 'E123');
INSERT
VALUE
‘cabang’
INSERT INTO
`Bank`.`cabang` (`kode_cabang`, `nama_cabang`, `kota`) VALUES ('A123', 'JKT01',
'Jakarta Pusat'), ('B123', 'JKT02', 'Jakarta Selatan'), ('C123', 'BDO001',
'Bandung'), ('D123', 'SBY01', 'Surabaya'), ('E123', 'DPK01', 'Depok');