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