LAPORAN I

PRAKTIKUM BAHASA PEMROGRAMAN SQL

Disusun Oleh
Nama

: Merlie Anita

Nim

: 091051009

Kelompok/
No. Komp : SL03/04
JURUSAN TEKNIK INFORMATIKA
FAKULTAS TEKNOLOGI INDUSTRI
INSTITUT SAINS & TEKNOLOGI AKPRIND
YOGYAKARTA
2012

mysql> create database praktikum;

Query OK, 1 row affected (0.13 sec)

mysql> use praktikum;

Database changed

mysql> create table mahasiswa(nim varchar(9),nama varchar(30),alamat

varchar(40),primary key(nim))type=innodb;

Query OK, 0 rows affected, 2 warnings (0.03 sec)

mysql> create table matakuliah(kode_mk varchar(8),nama_mk varchar(20),sks

int(2),primary key(kode_mk))type=innodb;

Query OK, 0 rows affected, 2 warnings (0.02 sec)

mysql> create table nilai(nim varchar(9),kode_mk varchar(6),nilai

int(2),primary key(nim,kode_mk),foreign key (nim) references mahasiswa (nim) on
delete cascade on update cascade,foreign key (kode_mk) references matakuliah
(kode_mk) on delete cascade on update cascade)type=innodb;

Query OK, 0 rows affected, 2 warnings (0.02 sec)

mysql> insert into mahasiswa value('003','deni','jogja');

Query OK, 1 row affected (0.01 sec)

mysql> insert into mahasiswa value('012','liliek','jogja');

Query OK, 1 row affected (0.00 sec)

mysql> insert into mahasiswa value('019','sule','bandung');

Query OK, 1 row affected (0.00 sec)

mysql> insert into matakuliah value('0001','bahasa sql',1);

Query OK, 1 row affected (0.01 sec)

mysql> insert into matakuliah value('0002','rekayasa web',2);

Query OK, 1 row affected (0.00 sec)

mysql> insert into nilai value('003','001',86);

Query OK, 1 row affected (0.00 sec)

mysql> insert into nilai value('012','001',83);

Query OK, 1 row affected (0.00 sec)

mysql> insert into nilai value('019','001',60);

Query OK, 1 row affected (0.00 sec)

mysql> select * from mahasiswa;

+-----+--------+---------+

| nim | nama

| alamat

+-----+--------+---------+
| 003 | deni

| jogja

| 012 | liliek | jogja

| 019 | sule

| bandung |

+-----+--------+---------+
3 rows in set (0.00 sec)

mysql> select * from matakuliah;

+---------+--------------+------+
| kode_mk | nama_mk

| sks

+---------+--------------+------+
| 0001

| bahasa sql

1 |

| 0002

| rekayasa web |

2 |

+---------+--------------+------+
2 rows in set (0.00 sec)

mysql> select * from nilai;

+-----+---------+-------+
| nim | kode_mk | nilai |
+-----+---------+-------+
| 003 | 001

86 |

| 012 | 001

83 |

| 019 | 001

60 |

+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> update mahasiswa set nim='020' where nim='019';

Query OK, 1 row affected (0.04 sec)

Rows matched: 1

Changed: 1

Warnings: 0

mysql> select * from mahasiswa;

+-----+--------+---------+
| nim | nama

| alamat

+-----+--------+---------+
| 003 | deni

| jogja

| 012 | liliek | jogja

| 020 | sule

| bandung |

+-----+--------+---------+
3 rows in set (0.00 sec)

mysql> select * from matakuliah;

+---------+--------------+------+
| kode_mk | nama_mk

| sks

+---------+--------------+------+
| 0001

| bahasa sql

1 |

| 0002

| rekayasa web |

2 |

+---------+--------------+------+
2 rows in set (0.00 sec)

mysql> select * from nilai;

+-----+---------+-------+
| nim | kode_mk | nilai |
+-----+---------+-------+
| 003 | 001

86 |

| 012 | 001

83 |

| 019 | 001

60 |

+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> alter table matakuliah modify kode_mk varchar(8);

Query OK, 2 rows affected (0.04 sec)

Records: 2

Duplicates: 0

Warnings: 0

mysql> alter table nilai modify kode_mk varchar(8);

Query OK, 3 rows affected (0.04 sec)

Records: 3

Duplicates: 0

Warnings: 0

mysql> update mahasiswa set nim='020' where nim='019';

Query OK, 0 rows affected (0.00 sec)

Rows matched: 0

Changed: 0

Warnings: 0

mysql> select * from nilai;

+-----+---------+-------+
| nim | kode_mk | nilai |
+-----+---------+-------+
| 003 | 001

86 |

| 012 | 001

83 |

| 019 | 001

60 |

+-----+---------+-------+
3 rows in set (0.01 sec)

Microsoft Windows [Version 6.1.7600]

Copyright (c) 2009 Microsoft Corporation.

All rights reserved.

C:\Users\Lia>mysql
Welcome to the MySQL monitor.

Commands end with ; or \g.

Your MySQL connection id is 1 to server version: 5.0.18-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database sl03;

Query OK, 1 row affected (0.01 sec)

mysql> use sl03;

Database changed

mysql> create table pelanggan(id_pelanggan varchar(12), nama_pelanggan

varchar(30), alamat varchar(30), telepon varchar(13), primary
key(id_pelanggan))type=innodb;

Query OK, 0 rows affected, 2 warnings (0.01 sec)

mysql> create table akun(id_akun varchar(12), id_cabang varchar(6), simpanan

int(12), primary key(id_akun,id_cabang))type=innodb;

Query OK, 0 rows affected, 2 warnings (0.01 sec)

mysql> create table tabungan(id_pelanggan varchar(12), id_akun varchar(12),

tabung int(12), primary key(id_akun,id_pelanggan), foreign
key(id_akun)references akun(id_akun) on delete cascade on update cascade,
foreign key(id_pelanggan) references pelanggan(id_pelanggan) on delete cascade
on update cascade)type=innodb;

Query OK, 0 rows affected, 2 warnings (0.02 sec)

mysql> create table cabang(id_cabang varchar(6), nama_cabang varchar(30),aset

int(12), primary key(id_cabang))type=innodb;

Query OK, 0 rows affected, 2 warnings (0.01 sec)

mysql> alter table akun add foreign key(id_cabang) references

cabang(id_cabang)on delete cascade on update cascade;

Query OK, 0 rows affected (0.04 sec)

Records: 0

Duplicates: 0

Warnings: 0

mysql> insert into pelanggan value('001002003004','liliek prasetya','jl. bung

karno no. 12','081212345678');

Query OK, 1 row affected (0.00 sec)

mysql> insert into pelanggan value('002003004005','bagong naufal','jl. buntu

no. 99','081223456789');

Query OK, 1 row affected (0.00 sec)

mysql> insert into pelanggan value('003004005006','sasa sisilia','jl. jalan no.

65a','081234567890');

Query OK, 1 row affected (0.00 sec)

mysql> select * from pelanggan;

+--------------+-----------------+-----------------------+--------------+
| id_pelanggan | nama_pelanggan

| alamat

| telepon

+--------------+-----------------+-----------------------+--------------+
| 001002003004 | liliek prasetya | jl. bung karno no. 12 | 081212345678 |
| 002003004005 | bagong naufal

| jl. buntu no. 99

| 081223456789 |

| 003004005006 | sasa sisilia

| jl. jalan no. 65a

| 081234567890 |

+--------------+-----------------+-----------------------+--------------+
3 rows in set (0.00 sec)

mysql> insert into akun value('100200300400','123987',6000000);

Query OK, 1 row affected (0.00 sec)

mysql> insert into akun value('123456789876','123456',80000000);

Query OK, 1 row affected (0.00 sec)

mysql> insert into akun value('987654321234','123987',60000000);

Query OK, 1 row affected (0.00 sec)

mysql> insert into tabungan value('001002003004','100200300400',160000);

Query OK, 1 row affected (0.01 sec)

mysql> insert into tabungan value('002003004005','123456789876',1200000);

Query OK, 1 row affected (0.00 sec)

mysql> insert into tabungan value('003004005006','987654321234',1000000);

Query OK, 1 row affected (0.00 sec)

mysql> insert into cabang value('123456','ist akprind yogyakarta','komplek

balapan',130000000);

ERROR 1136 (21S01): Column count doesn't match value count at row 1

mysql> insert into cabang value('123456','ist akprind yogyakarta','komplek

balapan',130000000);

ERROR 1136 (21S01): Column count doesn't match value count at row 1

mysql> desc cabang;

+-------------+-------------+------+-----+---------+-------+
| Field

| Type

| Null | Key | Default | Extra |

+-------------+-------------+------+-----+---------+-------+
| id_cabang

| varchar(6)

| PRI |

| nama_cabang | varchar(30) | YES

| NULL

| aset

| NULL

| int(12)

| NO

| YES

+-------------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql> alter table cabang add alamat varchar(30);

Query OK, 0 rows affected (0.03 sec)

Records: 0

Duplicates: 0

Warnings: 0

mysql> desc cabang;

+-------------+-------------+------+-----+---------+-------+
| Field

| Type

| Null | Key | Default | Extra |

+-------------+-------------+------+-----+---------+-------+
| id_cabang

| varchar(6)

| NO

| PRI |

| nama_cabang | varchar(30) | YES

| NULL

| aset

| int(12)

| YES

| NULL

| alamat

| varchar(30) | YES

| NULL

+-------------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> insert into cabang value('123456','ist akprind

yogyakarta',130000000,'komplek balapan');

Query OK, 1 row affected (0.00 sec)

mysql> insert into cabang value('123987','babarsari',170000000,'jl. dirgantara

III');

Query OK, 1 row affected (0.00 sec)

mysql> insert into cabang value('987654','jakal',200000000,'jl. kaliurang');

Query OK, 1 row affected (0.00 sec)

mysql> select * from pelanggan;

+--------------+-----------------+-----------------------+--------------+
| id_pelanggan | nama_pelanggan

| alamat

| telepon

+--------------+-----------------+-----------------------+--------------+
| 001002003004 | liliek prasetya | jl. bung karno no. 12 | 081212345678 |
| 002003004005 | bagong naufal

| jl. buntu no. 99

| 081223456789 |

| 003004005006 | sasa sisilia

| jl. jalan no. 65a

| 081234567890 |

+--------------+-----------------+-----------------------+--------------+
3 rows in set (0.00 sec)

mysql> select * from tabungan;

+--------------+--------------+---------+
| id_pelanggan | id_akun

| tabung

+--------------+--------------+---------+
| 001002003004 | 100200300400 |

160000 |

| 002003004005 | 123456789876 | 1200000 |

| 003004005006 | 987654321234 | 1000000 |
+--------------+--------------+---------+
3 rows in set (0.00 sec)

mysql> select * from akun;

+--------------+-----------+----------+
| id_akun

| id_cabang | simpanan |

+--------------+-----------+----------+
| 100200300400 | 123987

6000000 |

| 123456789876 | 123456

| 80000000 |

| 987654321234 | 123987

| 60000000 |

+--------------+-----------+----------+
3 rows in set (0.00 sec)

mysql> select * from cabang;

+-----------+------------------------+-----------+--------------------+
| id_cabang | nama_cabang

| aset

| alamat

+-----------+------------------------+-----------+--------------------+
| 123456

| ist akprind yogyakarta | 130000000 | komplek balapan

| 123987

| babarsari

| 170000000 | jl. dirgantara III |

| 987654

| jakal

| 200000000 | jl. kaliurang

+-----------+------------------------+-----------+--------------------+
3 rows in set (0.00 sec)