SBD-Contoh Database Perpustakaan-

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\ASUS>cd\xampp/mysql/bin

C:\xampp\mysql\bin>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.33-community MySQL Community Server (GPL)

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cdcol              |
| dbakademik         |
| dbakademik3        |
| dbhotel            |
| dbkaryawan         |
| dbmahasiswa        |
| dbsekolah          |
| karyawan           |
| mahasiswa          |
| mysql              |
| perpustakaan       |
| phpmyadmin         |
| spp                |
| test               |
| webauth            |
+--------------------+
16 rows in set (0.14 sec)
mysql> create database dbperpustakaan;
Query OK, 1 row affected (0.02 sec)

mysql> use dbperpustakaan;
Database changed
mysql> create table tblpengarang(
    -> id_pengarang char (4) not null,
    -> nama_pengarang varchar (30) not null,
    -> primary key (id_pengarang)
    -> );
Query OK, 0 rows affected (0.06 sec)
mysql> create table tblpenerbit(
    -> id_penerbit char (4) not null,
    -> nama_penerbit varchar (35),
    -> primary key (id_penerbit)
    -> );
Query OK, 0 rows affected (0.08 sec)

mysql> create table tblkategori(
    -> id_kategori char (4) not null,
    -> kategori varchar (25),
    -> primary key (id_kategori)
    -> );
Query OK, 0 rows affected (0.08 sec)

mysql> show tables;
+--------------------------+
| Tables_in_dbperpustakaan |
+--------------------------+
| tblkategori              |
| tblpenerbit              |
| tblpengarang             |
+--------------------------+
3 rows in set (0.00 sec)

mysql> create table tblbuku(
    -> kd_buku char (4) not null,
    -> judul_buku varchar (30),
    -> id_kategori char (4),
    -> id_pengarang char (4),
    -> id_penerbit char (4),
    -> tahun_terbit char (4),
    -> edisi char (4),
    -> primary key (kd_buku)
    -> );
Query OK, 0 rows affected (0.06 sec)

mysql> show tables;
+--------------------------+
| Tables_in_dbperpustakaan |
+--------------------------+
| tblbuku                  |
| tblkategori              |
| tblpenerbit              |
| tblpengarang             |
+--------------------------+
4 rows in set (0.00 sec)

mysql> alter table tblpenerbit add alamat varchar (30);
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show tables;
+--------------------------+
| Tables_in_dbperpustakaan |
+--------------------------+
| tblbuku                  |
| tblkategori              |
| tblpenerbit              |
| tblpengarang             |
+--------------------------+
4 rows in set (0.02 sec)

mysql> desc tblpenerbit;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| id_penerbit   | char(4)     | NO   | PRI | NULL    |       |
| nama_penerbit | varchar(35) | YES  |     | NULL    |       |
| alamat        | varchar(30) | YES  |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
3 rows in set (0.05 sec)

mysql> insert into tblpenerbit values
    -> ('B001','Andi Offset','yogyakarta'),
    -> ('B002','Loko Media','yogyakarta'),
    -> ('B003','Airlangga','jakarta');
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> insert into tblkategori values
    -> ('K001','Komputer'),
    -> ('K002','Ekonomi'),
    -> ('K003','kesehatan'),
    -> ('K004','sejarah'),
    -> ('K005','olahraga');
Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> select*from tblpengarang;
+--------------+-----------------+
| id_pengarang | nama_pengarang  |
+--------------+-----------------+
| A001         | Joni Andreas    |
| A002         | Mr.Lukman Hakim |
| A003         | Eko Purnama     |
+--------------+-----------------+
3 rows in set (0.00 sec)

mysql> select*from tblpenerbit;
+-------------+---------------+---------------+
| id_penerbit | nama_penerbit | alamat     |
+-------------+---------------+---------------+
| B001        | Andi Offset   | yogyakarta   |
| B002        | Loko Media  | yogyakarta   |
| B003        | Airlangga      | jakarta         |
+-------------+---------------+------------+
3 rows in set (0.00 sec)

mysql> select*from tblkategori;
+-------------+-----------+
| id_kategori | kategori  |
+-------------+-----------+
| K001        | Komputer  |
| K002        | Ekonomi    |
| K003        | kesehatan   |
| K004        | sejarah        |
| K005        | olahraga     |
+-------------+-----------+
5 rows in set (0.00 sec)

mysql> insert into tblbuku values
    -> ('N001','BELAJAR PHP dan MYSQL','K001','A002','B001','2010','1'),
    -> ('N002','MENCINTAI SEJARAH INDONESIA','K004','A001','B003','2009','II'),
    -> ('N003','MAHIR PHOTOSHOP 24 JAM','K001','A001','B002','2011','I'),
    -> ('N004','AKUNTANSI BIAYA LANJUT','K002','A003','B003','2009','III'),
    -> ('N005','BELAJAR MYOB UNTUK PEMULA','K002','A001','B001','2010','II');
Query OK, 5 rows affected (0.02 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> show tables;
+--------------------------------+
| Tables_in_dbperpustakaan |
+--------------------------------+
| tblbuku                                |
| tblkategori                           |
| tblpenerbit                           |
| tblpengarang                        |
+---------------------------------+
4 rows in set (0.01 sec)

mysql> desc tblbuku;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| kd_buku      | char(4)     | NO   | PRI | NULL    |       |
| judul_buku   | varchar(30) | YES  |     | NULL    |       |
| id_kategori  | char(4)     | YES  |     | NULL    |       |
| id_pengarang | char(4)     | YES  |     | NULL    |       |
| id_penerbit  | char(4)     | YES  |     | NULL    |       |
| tahun_terbit | char(4)     | YES  |     | NULL    |       |
| edisi        | char(4)     | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
7 rows in set (0.02 sec)

mysql> select*from tblbuku;
+---------+-----------------------------+-------------+--------------+-------------+--------------+-------+
| kd_buku | judul_buku                  | id_kategori | id_pengarang | id_penerbit | tahun_terbit | edisi |
+---------+-----------------------------+-------------+--------------+-------------+--------------+-------+
| N001    | BELAJAR PHP dan MYSQL       | K001        | A002         | B001 | 2010         | 1     |
| N002    | MENCINTAI SEJARAH INDONESIA | K004        | A001         | B003 | 2009 | II    |
| N003    | MAHIR PHOTOSHOP 24 JAM      | K001        | A001         | B002| 2011         | I     |
| N004    | AKUNTANSI BIAYA LANJUT      | K002        | A003         | B003| 2009         | III   |
| N005    | BELAJAR MYOB UNTUK PEMULA   | K002        | A001         | B001 | 2010         | II    |
+---------+-----------------------------+-------------+--------------+-------------+--------------+-------+
5 rows in set (0.00 sec)
mysql> select tblbuku.kd_buku,tblbuku.judul_buku,tblkategori.kategori,tblpengara
ng.nama_pengarang,tblbuku.tahun_terbit,tblbuku.edisi from tblpengarang,tblpenerb
it,tblkategori,tblbuku where tblkategori.id_kategori=tblbuku.id_kategori and tbl
pengarang.id_pengarang=tblbuku.id_pengarang and tblpenerbit.id_penerbit=tblbuku.
id_penerbit;
+---------+-----------------------------+----------+-----------------+--------------+-------+
| kd_buku | judul_buku                  | kategori | nama_pengarang  | tahun_terbit | edisi |
+---------+-----------------------------+----------+-----------------+--------------+-------+
| N001    | BELAJAR PHP dan MYSQL       | Komputer | Mr.Lukman Hakim | 2010 | 1     |
| N002    | MENCINTAI SEJARAH INDONESIA | sejarah  | Joni Andreas    | 2009 | II 
|N003     | MAHIR PHOTOSHOP 24 JAM      | Komputer | Joni Andreas    | 2011 | I     |
| N004    | AKUNTANSI BIAYA LANJUT      | Ekonomi  | Eko Purnama     | 2009| III   |
| N005    | BELAJAR MYOB UNTUK PEMULA   | Ekonomi  | Joni Andreas    | 2010| II    |
+---------+-----------------------------+----------+-----------------+--------------+-------+
5 rows in set (0.03 sec)

mysql>