7/23/2019 Tugas 1 Praktikum Sistem Manajemen Basis Data

1/5

PRAKTIKUM

SISTEM MANAJEMEN BASIS DATA

TUGAS 1

Disusun Oleh :

Nama : Tinezia Arum Cendhani

Nim : 141051108

Jurusan : Teknik Informatika

Kelas : SN-2 ( Senin, 10.0012.30 )

FAKULTAS TEKNOLOGI INDUSTRI

INSTITUT SAINS & TEKNOLOGI AKPRIND

YOGYAKARTA

2015

7/23/2019 Tugas 1 Praktikum Sistem Manajemen Basis Data

2/5

Setting environment for using XAMPP for Windows.

U S E R@USER-PC C:\xampp# mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

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

| Database |+----------------------------+

| information_schema |

| cdcol |

| mysql |

| phpmyadmin |

| test |

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

5 rows in set (0.00 sec)

mysql> create database 141051108_Tinezia;

Query OK, 1 row affected (0.00 sec)

mysql> use 141051108_Tinezia;

Database changed

mysql> create table perpustakaan(id_buku char(4) primary key, nama_buku

varchar(

15), pengarang varchar(10), penerbit varchar(15), jenis_buku varchar(10));

Query OK, 0 rows affected (0.00 sec)

mysql> desc perpustakaan;

+---------------+---------------+------+-----+-----------+-------+| Field | Type | Null | Key | Default | Extra |

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

| id_buku | char(4) | NO | PRI | NULL | |

| nama_buku | varchar(15) | YES | | NULL | |

| pengarang | varchar(10) | YES | | NULL | |

| penerbit | varchar(15) | YES | | NULL | |

| jenis_buku | varchar(10) | YES | | NULL | |

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

5 rows in set (0.00 sec)

7/23/2019 Tugas 1 Praktikum Sistem Manajemen Basis Data

3/5

mysql> create table stok_buku(id_stok char(4) primary key, kode_buku char(4),

ke

terangan varchar(8), tanggal_akses date, foreign key(kode_buku) references perpustakaan(id_buku));

Query OK, 0 rows affected (0.00 sec)

mysql> desc stok_buku;

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

| Field | Type | Null | Key | Default | Extra |

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

| id_stok | char(4) | NO | PRI | NULL | |

| kode_buku | char(4) | YES | MUL | NULL | |

| keterangan | varchar(8) | YES | | NULL | |

| tanggal_akses | date | YES | | NULL | |+------------------+------------+-------+---------+---------+-------+

4 rows in set (0.00 sec)

mysql> show tables;

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

| Tables_in_141051108_tinezia |

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

| perpustakaan |

| stok_buku |

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

2 rows in set (0.02 sec)

mysql> select*from perpustakaan;

Empty set (0.00 sec)

mysql> select*from stok_buku;

Empty set (0.00 sec)

mysql> insert into perpustakaan values('1001', 'Dibalik 98', 'Chelsea Islan', 'G

ramedia', 'Fiksi');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into perpustakaan values('1002', 'Merry Riana', 'Dion Wiyoko', 'Gr

amedia', 'Fiksi');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into perpustakaan values('1003', 'Pengantar Teknologi Informasi',

'Amir Hamzah', 'Erlangga', 'Non Fiksi');

Query OK, 1 row affected, 2 warnings (0.00 sec)

7/23/2019 Tugas 1 Praktikum Sistem Manajemen Basis Data

4/5

mysql> insert into perpustakaan values('1004', 'Struktur Data', 'Erna Kumalasari

', 'Erlangga', 'Non Fiksi');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into perpustakaan values('1005', 'Kalkulus', 'Dina A', 'Gagas Medi

a', 'Non Fiksi');

Query OK, 1 row affected (0.00 sec)

mysql> insert into perpustakaan values('1006', 'For You', 'Nova Anastasya', 'Sta

r Media', 'Fiksi');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into perpustakaan values('1007', 'Cinta Tapi Beda', 'Dwita Sari',

'Gramedia', 'Fiksi');Query OK, 1 row affected (0.02 sec)

mysql> insert into perpustakaan values('1008', 'JCDD', 'Dwita Sari', 'Gramedia',

'Fiksi');

Query OK, 1 row affected (0.00 sec)

mysql> insert into perpustakaan values('1009', 'Dream Book', 'Rangga Umara', 'St

ar Media', 'Non Fiksi');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> insert into perpustakaan values('1010', 'Ibu', 'Mayang DAA', 'Gagas Media

', 'Non Fiksi');

Query OK, 1 row affected (0.00 sec)

mysql> select*from perpustakaan;

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

| id_buku | nama_buku | pengarang | penerbit | jenis_buku |

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

| 1001 | Dibalik 98 | Chelsea Is | Gramedia | Fiksi |

| 1002 | Merry Riana | Dion Wiyok | Gramedia | Fiksi |

| 1003 | Pengantar Tekno | Amir Hamza | Erlangga | Non Fiksi || 1004 | Struktur Data | Erna Kumal | Erlangga | Non Fiksi |

| 1005 | Kalkulus | Dina A | Gagas Media | Non Fiksi |

| 1006 | For You | Nova Anast | Star Media | Fiksi |

| 1007 | Cinta Tapi Beda | Dwita Sari | Gramedia | Fiksi |

| 1008 | JCDD | Dwita Sari | Gramedia | Fiksi |

| 1009 | Dream Book | Rangga Uma | Star Media | Non Fiksi |

| 1010 | Ibu | Mayang DAA | Gagas Media | Non Fiksi |

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

10 rows in set (0.00 sec)

7/23/2019 Tugas 1 Praktikum Sistem Manajemen Basis Data

5/5

mysql> insert into stok_buku values('0001', '1001', 'Pinjam', '01/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> insert into stok_buku values('0002', '1002', 'Pinjam', '01/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> insert into stok_buku values('0003', '1003', 'Kembali', '02/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> insert into stok_buku values('0004', '1004', 'Kembali', '03/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> insert into stok_buku values('0005', '1005', 'Pinjam', '04/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> insert into stok_buku values('0006', '1006', 'Kembali', '04/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> insert into stok_buku values('0007', '1007', 'Kembali', '05/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> insert into stok_buku values('0008', '1008', 'Pinjam', '06/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> insert into stok_buku values('0009', '1009', 'Pinjam', '07/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> insert into stok_buku values('0010', '1010', 'Pinjam', '07/10/15');

Query OK, 1 row affected (0.00 sec)

mysql> select*from stok_buku;

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

| id_stok | kode_buku | keterangan | tanggal_akses |

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

| 0001 | 1001 | Pinjam | 2001-10-15 || 0002 | 1002 | Pinjam | 2001-10-15 |

| 0003 | 1003 | Kembali | 2002-10-15 |

| 0004 | 1004 | Kembali | 2003-10-15 |

| 0005 | 1005 | Pinjam | 2004-10-15 |

| 0006 | 1006 | Kembali | 2004-10-15 |

| 0007 | 1007 | Kembali | 2005-10-15 |

| 0008 | 1008 | Pinjam | 2006-10-15 |

| 0009 | 1009 | Pinjam | 2007-10-15 |

| 0010 | 1010 | Pinjam | 2007-10-15 |

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

10 rows in set (0.00 sec)