tag:blogger.com,1999:blog-59094757788399978642024-02-20T16:24:17.309-08:00Systematics Of Basis DataArga Arifriatnahttp://www.blogger.com/profile/12597084815269875938noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5909475778839997864.post-22696522899006265062013-01-10T21:44:00.000-08:002013-01-10T21:54:43.359-08:00Tugas Basis Data ORACLE 10G<div class="separator" style="clear: both; text-align: left;">
<b>1. Membuat Tablespace</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-QOLmtU_cKPA/UO-nCZ6MgXI/AAAAAAAAAOo/TepdKV-Xc6g/s1600/1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><b><img border="0" height="232" src="http://1.bp.blogspot.com/-QOLmtU_cKPA/UO-nCZ6MgXI/AAAAAAAAAOo/TepdKV-Xc6g/s320/1.JPG" width="320" /></b></a></div>
<div class="separator" style="clear: both; text-align: center;">
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: left;">
<b>2. Menampilkan Tablespace</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-cFku3CgMQec/UO-njJSrH-I/AAAAAAAAAOw/WTbc2bmn7fo/s1600/2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><b><img border="0" height="158" src="http://3.bp.blogspot.com/-cFku3CgMQec/UO-njJSrH-I/AAAAAAAAAOw/WTbc2bmn7fo/s320/2.JPG" width="320" /></b></a></div>
<div class="separator" style="clear: both; text-align: center;">
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: left;">
<b>3. Menampilkan Properti Tablespace</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-Ey4EGXAvW-U/UO-n4mC6VnI/AAAAAAAAAO4/1qdw9daeAxc/s1600/3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><b><img border="0" height="157" src="http://1.bp.blogspot.com/-Ey4EGXAvW-U/UO-n4mC6VnI/AAAAAAAAAO4/1qdw9daeAxc/s320/3.JPG" width="320" /></b></a></div>
<div class="separator" style="clear: both; text-align: left;">
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: left;">
<b>4. Menampilkan Status Tablespace</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-6ZQ9QMe7k3I/UO-oKeatPOI/AAAAAAAAAPA/o2AOPmi0Jic/s1600/4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><b><img border="0" height="158" src="http://3.bp.blogspot.com/-6ZQ9QMe7k3I/UO-oKeatPOI/AAAAAAAAAPA/o2AOPmi0Jic/s320/4.JPG" width="320" /></b></a></div>
<div class="separator" style="clear: both; text-align: center;">
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: left;">
<b>5. Memanggil Data File Tablespace</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-1vbcWJn0g8c/UO-ocN2sevI/AAAAAAAAAPI/XK1jvCshUmI/s1600/5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><b><img border="0" height="259" src="http://1.bp.blogspot.com/-1vbcWJn0g8c/UO-ocN2sevI/AAAAAAAAAPI/XK1jvCshUmI/s320/5.JPG" width="320" /></b></a></div>
<div class="separator" style="clear: both; text-align: center;">
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: left;">
<b>6. Off Line Tablespace</b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-4TjgGQ7bfSw/UO-o4tvwQxI/AAAAAAAAAPQ/OqkxUq64sBc/s1600/6.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><b><img border="0" height="158" src="http://2.bp.blogspot.com/-4TjgGQ7bfSw/UO-o4tvwQxI/AAAAAAAAAPQ/OqkxUq64sBc/s320/6.JPG" width="320" /></b></a></div>
<div class="separator" style="clear: both; text-align: center;">
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: left;">
<b>7. Disconnect</b></div>
<div class="separator" style="clear: both; text-align: center;">
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-J2YKJKrfbqc/UO-pD0tEKPI/AAAAAAAAAPY/NfmbFqOBEsU/s1600/10.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><b><img border="0" height="252" src="http://1.bp.blogspot.com/-J2YKJKrfbqc/UO-pD0tEKPI/AAAAAAAAAPY/NfmbFqOBEsU/s320/10.JPG" width="320" /></b></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Arga Arifriatnahttp://www.blogger.com/profile/12597084815269875938noreply@blogger.com0tag:blogger.com,1999:blog-5909475778839997864.post-56521980913281036702012-10-31T10:59:00.001-07:002012-10-31T11:08:47.897-07:00Kuis I Basisdata II –Syntax SQL dengan Studi Kasus Buku Tabungan<span style="color: #666666;"><br /></span>
<br />
<header class="entry-header" style="background-color: white; font-family: 'Lucida Grande', Arial, 'Lucida Sans Unicode', sans-serif; font-size: 13px; line-height: 19px;"><h1 class="entry-title" style="border: 0px; clear: none; font-size: 2.2rem; line-height: 1.2; margin: 0px 56px 5px 0px; outline: 0px; padding: 5px 36px 0px 0px; text-shadow: rgba(0, 0, 0, 0.2) 0px 1px 1px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-size: 13px; font-style: inherit; line-height: 19px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="color: #666666;">1) Membuat Tabel tr_transaksi, tr_job, tr_petugas, tr_agama, nasabah dan tr_tabungan</span></strong></h1>
</header><br />
<div class="entry-content" style="background-color: white; border: 0px; font-family: 'Lucida Grande', Arial, 'Lucida Sans Unicode', sans-serif; font-size: 13px; line-height: 19px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="color: #666666;"> a. Tabel tr_transaksi</span></strong></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">create table tr_transaksi</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">(</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">c_transaksi varchar(10) primary key,</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">e_transaksi varchar(20)</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">b. Tabel tr_job</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">create table tr_job</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">(</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">c_job varchar(10) primary key,</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">n_job varchar(15)</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">c. Tabel tr_petugas</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">create table tr_petugas</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">(</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">i_petugas varchar(15) primary key,</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">n_petugas varchar(20)</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">d. Tabel tr_agama</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">create table tr_agama</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">(</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">c_agama varchar(10) primary key,</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">n_agama varchar(15)</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">e. Tabel nasabah</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">create table nasabah</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">(</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">i_rek varchar(10) constraint nasabah_PK primary key,</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">n_nasabah varchar(30),</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">a_nasabah varchar(100),</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">d_lahir date,</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">c_job number(2) constraint nasabah_PK_c_job references tr_job(c_job),</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">c_agama number(5) constraint nasabah_PK_c_agama references tr_agama(c_agama)</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">e. Tabel tr_tabungan</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">create table tr_tabungan</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">(</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">i_transaksi varchar(15) constraint tr_tabungan_PK primary key,</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">c_trans number(4) constraint tr_tabungan_PK_c_trans references tr_transaksi(c_trans),</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">d_transaksi date,</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">v_debet varchar(20),</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">v_kredit varchar(20),</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">v_saldo varchar(20),</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">i_petugas varchar(10) constraint tmbaungan_PK_i_petugas references tr_petugas(i_petugas),</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">i_rek varchar(10) constraint tmbaungan_PK_i_rek references nasabah(i_rek)</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;"><b>2) </b><b>Memasukkan nilai pada masing-masing table</b></span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;"><b> </b><b>a. Pada tabel tr_transaksi</b></span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_transaksi values ( 1,’setor’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_transaksi values ( 2,’tarik’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_transaksi values ( 3,’atm’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_transaksi values ( 4,’pemindah bukuan’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_transaksi values ( 5,’koreksi plus’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_transaksi values ( 6,’koreksi minus’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_transaksi values ( 7,’bunga’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_transaksi values ( 8,’administrasi biaya’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_transaksi values ( 9,’pajak’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">b. Pada tabel tr_job</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_job values ( ‘pgm’,’programer’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_job values ( ‘tel’,’teller’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_job values ( ‘mgr’,’manager’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_job values ( ‘sys’,’system analys’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_job values ( ‘prs’,’president’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">c. Pada tabel tr_petugas</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_petugas values ( ‘PTG-01′,’lintang’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_petugas values ( ‘PTG-02′,’bogi’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_petugas values ( ‘PTG-03′,’putra’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_petugas values ( ‘PTG-04′,’yardi’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_petugas values ( ‘PTG-05′,’tarjo’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_petugas values ( ‘PTG-06′,’anggi’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_petugas values ( ‘PTG-07′,’ciga’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_petugas values ( ‘PTG-08′,’tono’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">d. Pada tabel tr_agama</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_agama values ( ‘A1′,’islam’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_agama values ( ‘A2′,’kristen’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_agama values (‘A3′, ‘katholik’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_agama values (‘A4′, ‘hindhu’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_agama values (‘A5′, ‘budha’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;"><b>3) </b><b>Menginputkan nilai pada tabel nasabah dan tr_tabungan</b></span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;"><b> </b><b>a. Tabel nasabah</b></span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into nasabah values (‘A11’, ‘lintang’, ‘Sarijadi gang no.1’, ‘29-juni-1992’, ‘mgr’, ‘A1’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into nasabah values (‘A12’, ‘yardi’, ‘Sarijadi gang no.2’, ‘24-May-1992’, ‘tel’, ‘A1’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into nasabah values (‘A13’, ‘pontius’, ‘Sariasih 2’, ‘6-Juni-1992’, ‘pgm’, ‘A2’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into nasabah values (‘A14’, ‘arga’, ‘Sukajadi’, ‘8-agustus-1993’, ‘prs’, ‘A1’);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">b. Tabel tr_tabungan</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_tabungan values( ‘trans-01′, 1, ’27-Oktober-2012′,5000000, 0, 7000000, ‘PTG-01′, ‘A11′);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_tabungan values (‘trans-02′, 2, ’28-Oktober-2012′, 0, 3000000, 8500000, ‘PTG-05′, ‘A13′);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">insert into tr_tabungan values (‘trans-03′, 4, ’28-Oktober-2012′, 2000000, 0, 4300000, ‘PTG-03′, ‘A12′);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;"><b>4) </b><b>Menampilkan i_rek, n_nasabah dan v_saldo, dengan saldo yang paling kecil.</b></span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">select tr_tabungan.i_rek , nasabah.n_nasabah, trr_tabungan.v_saldo from tr_tabungan inner join nasabah on nasabah.i_rek = tr_tabungan.i_rek where v_saldo = ( select min ( v_saldo) from tr_tabungan);</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;"><b>5) Syntak Untuk men</b><b>ampilkan :</b></span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;"><b> </b><b>a. c_transaksi, e_transaksi, sum(v_debet) dan sum (v_kredit)</b></span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">select tr_transaksi.c_transaksi, tr_transaksi.e_transaksi, sum( tr_tabungan.v_debet), sum ( tr_tabungan.v_kredit) from tr_tabungan inner join tr_transaksi on tr_transaksi.c_transaksi=tr_tabungan.c_transaksi group by tr_transaksi.c_transaksi, tr_transaksi.e_transaksi;</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;"><b>b.</b> <b>c_transaksi, e_transaksi, sum(v_debet) dan sum (v_kredit) diantara Bln Januari 2012 s.d. Bln Desember 2012</b></span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;">select tr_transaksi.c_transaksi, tr_transaksi.e_transaksi, sum(tr_tabungan.v_debet), sum (tr_tabungan.v_kredit) from tr_tabungan inner join tr_transaksi on tr_transaksi.c_transaksi= tr_tabungan.c_transaksi where d_transaksi between ‘1-oct-2012’ and ’30-nov-2012’ group by tr_transaksi.c_transaksi, tr_transaksi.e_transaksi;</span></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="color: #666666;">c. Jumlah nasabah dengan kode transaksinya saja > Berdasarkan Kode Transaksi)</span></b></div>
<div style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.5em; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #666666;"><b> </b>select count (*) as “jumlah”, c_trans from tr_tabungan group by c_trans;</span></div>
</div>
Arga Arifriatnahttp://www.blogger.com/profile/12597084815269875938noreply@blogger.com0tag:blogger.com,1999:blog-5909475778839997864.post-1175146956276741812012-10-24T03:44:00.000-07:002012-10-25T03:55:00.781-07:00Perbedaan DDL dan DML dalam SQL<span style="background-color: red; font-family: Verdana, sans-serif;">A. DDL (<i>Data Definition Language</i>) digunakan untuk mendefinisikan informasi </span><br />
<span style="background-color: red;"><span style="font-family: Verdana, sans-serif;"> data pada database. Di</span><span style="font-family: Verdana, sans-serif;"> dalamnya terdapat record, elemen data, kunci </span></span><br />
<span style="background-color: red;"><span style="font-family: Verdana, sans-serif;"> elemen </span><span style="font-family: Verdana, sans-serif;">dan relasinya. Yang termasuk perintah dasar DDL </span><span style="font-family: Verdana, sans-serif;">antara lain :</span></span><br />
<span style="background-color: red;"><br /></span>
<br />
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;"><b>A. CREATE</b> (Digunakan untuk membuat databae, tabel, function dsb)</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">1) <b>CREATE DATABASE</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">CREATE DATABASE nama_database</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">2) <b> CREATE FUNCTION</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">Function nama_function(variabel,variabel_2,variabel)</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">{</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: 'Courier New', Courier, monospace;">perintah yang harus di jalankan</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">return data_yang_telah_di_proses</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">}</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">3) <b>CREATE PROCEDURE</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">delimiter ‘/’;<br />create procedure nama_procedure()<br />begin<br />select * from nama_table;<br />end/</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">4) <b>CREATE TABLE</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">CREATE TABLE nama_table</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">(</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">nama_kolom1 tipe_data,</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">nama_kolom2 tipe_data,</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">nama_kolom3 tipe_data</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">)</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">5) <b>CREATE TRIGGER</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">CREATE TRIGGER insert_from_tableA_to_tableB</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">AFTER insert ON Table A</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">FOR EACH ROW</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">BEGIN</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">insert into Table B</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">(id,firstname,lastname)</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">VALUES (new.firstname,new.lastname);</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">END;</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">6) CREATE VIEW</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">CREATE VIEW nama_table</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">[( nama_kolom1, nama_kolom2, ... )]</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">AS SELECT …</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<b><span style="background-color: red;">B. ALTER DAN RENAME</span></b></div>
<div style="border: 0px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<ul>
<li><span style="font-family: Georgia, Times New Roman, serif; font-size: x-small;"><span style="background-color: red; line-height: 22px;"><i>Alter digunakan untuk memperbaharui elemen-elemen yang terdapat di dalam tabel, sedangkan rename digunakan untuk menganti nama sebuah tabel dan kolom.</i></span></span></li>
</ul>
<br />
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">1) <b>ALTER TABLE</b></span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<i><span style="background-color: red;">Primary key menggunakan alter table</span></i></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">ALTER TABLE table_name ADD PRIMARY KEY (column_name)</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<i><span style="background-color: red;">Foreign key menggunakan alter table</span></i></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">ALTER TABLE table_name ADD FOREIGN KEY (column_name) REFERENCES table_name (column_name)</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">- Merubah nama tabel</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">ALTER TABLE old_name RENAME TO new_name</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">- Merubah nama kolom</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">Alter table table_name change old_column_name new_column_name type size</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">- Menambah kolom pada tabel</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">ALTER TABLE table_name ADD column_name datatype</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">- Menghapus kolom</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">ALTER TABLE table_name DROP column_name</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">- Mengubah tipe data pada kolom</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">ALTER TABLE table_name ALTER COLUMN column_name datatype</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">2) <b>ALTER VIEW</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">ALTER VIEW [View_yang_sudah_ada] AS Query anda yang baru</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">3) <b>RENAME TABLE</b></span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">- Merubah nama tabel</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">ALTER TABLE old_name RENAME TO new_name</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;"><b>C. DROP</b> (Drop digunakan untuk menghapus database, index serta tabel yang telah dibuat)</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">1) <b>DROP DATABASE</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">DROP DATABASE(nama_database)</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">2) <b>DROP INDEX</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">DROP INDEX <i>index_name</i> ON <i>tbl_name</i></span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">3) <b>DROP TABLE</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">DROP TABLE table_name1, table_name2, ….</span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">4) <b>DROP TRIGGER</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">DROP TRIGGER[<i>schema_name</i>.]<i>trigger_name</i></span></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="border: 0px; font-family: Verdana, sans-serif; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red;">5) <b>DROP VIEW</b></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;">DROP VIEW table_name</span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;"><br /></span></div>
<div style="border: 0px; font-size: 13px; line-height: 22px; margin-bottom: 22px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: red; font-family: Courier New, Courier, monospace;"><br /></span></div>
<br />
<div>
<span style="background-color: red;">B. <span style="font-size: 11pt; line-height: 115%;"><span style="font-family: Verdana, sans-serif;">DML (<i>Data manipulation
Language</i>) merupakan perintah SQL yang berhubungan </span></span></span><br />
<span style="background-color: red; font-size: 11pt; line-height: 115%;"><span style="font-family: Verdana, sans-serif;"> dengan manipulasi /
pengolahan data atau record pada tabel. DML sendiri dibagi </span></span><br />
<span style="background-color: red; font-size: 11pt; line-height: 115%;"><span style="font-family: Verdana, sans-serif;"> menjadi 2 jenis, yaitu:</span></span><br />
<span style="background-color: red; font-size: 11pt; line-height: 115%;"><span style="font-family: Verdana, sans-serif;"><br /></span></span>
<br />
<ul>
<li><span style="font-family: Verdana, sans-serif;"><span style="font-size: 15px; line-height: 17px;"><div class="MsoListParagraph" style="line-height: 18pt; margin-bottom: 0.0001pt; text-align: justify;">
<b style="background-color: red;">Procedural DML</b><span style="background-color: red;"><o:p></o:p></span></div>
<span style="background-color: red; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">Digunakan untuk mendefinisikan data yang diolah
dan perintah yang akan dilaksanakan.</span></span></span></li>
</ul>
<div>
<ul>
<li><div style="text-align: justify;">
<span style="background-color: red; font-size: 15px; line-height: 24px;"><b><span style="font-family: Verdana, sans-serif;">Non Procedural DML</span></b></span></div>
<span style="font-family: Calibri, sans-serif;"><span style="background-color: red; font-size: 15px; line-height: 17px;">
<span style="font-size: 11pt; line-height: 115%;">Digunakan untuk menjabarkan data yang diinginkan
tanpa menyebutkan bagaimana cara pengambilannya.</span></span></span></li>
</ul>
</div>
</div>
<div>
<span style="background-color: red;"> <span style="font-family: Verdana, sans-serif; font-size: x-small;">--> Berikut Syntax-syantax dari DML</span></span><br />
<span style="background-color: red; font-family: Verdana, sans-serif; font-size: x-small;"><br /></span>
<span style="background-color: red;"><span style="font-size: x-small;"></span></span><br />
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;">1) <b>DELETE</b></span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<span style="font-size: x-small;"><span style="background-color: red; font-family: Courier New, Courier, monospace;">DELETE FROM table_name WHERE some_column=some_value</span></span><br />
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<div style="font-family: Verdana, sans-serif;">
<br /></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;">2) <b>INSERT</b> (Insert berfungsi utuk menyisipkan atribut pada kolom-kolom yang sudah dibuat </span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"> pada tabel)</span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<span style="font-size: x-small;"><span style="background-color: red; font-family: Courier New, Courier, monospace;">INSERT INTO table_name VALUES (value1, value2, value3,…)</span></span><br />
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<div style="font-family: Verdana, sans-serif;">
<br /></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;">3) <b>SELECT</b> (Berfungsi untuk menampilkan semua kolom)</span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<span style="font-size: x-small;"><span style="background-color: red; font-family: Courier New, Courier, monospace;">SELECT * FROM table_name</span></span><br />
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<div style="font-family: Verdana, sans-serif;">
<br /></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;">- Sedangkan untuk menampilkan kolom tertentu,</span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<span style="font-size: x-small;"><span style="background-color: red; font-family: Courier New, Courier, monospace;">SELECT column_name(s) FROM table_name</span></span><br />
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<div style="font-family: Verdana, sans-serif;">
<br /></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;">4) <b>UPDATE</b> (Dignakan untuk mengupdate atau mengedit nama atribut kolom yang sudah </span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"> diisikan)</span></span></div>
<div style="font-family: Verdana, sans-serif;">
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span></div>
<span style="font-size: x-small;"><span style="background-color: red; font-family: Courier New, Courier, monospace;">UPDATE table_name SET column1=value, column2=value2,… WHERE some_column=some_value</span></span><br />
<span style="font-size: x-small;"><span style="background-color: red;"><br /></span></span>
<span style="font-size: x-small;"><br /></span>
</div>
Arga Arifriatnahttp://www.blogger.com/profile/12597084815269875938noreply@blogger.com0tag:blogger.com,1999:blog-5909475778839997864.post-61149710256314376182012-10-04T11:52:00.002-07:002012-10-04T11:52:35.122-07:00ORACLE<br />
<b>A. Oracle</b><br />
Oracle merupakan DBMS yang paling rumit dan paling mahal di dunia, namun banyak orang memiliki kesan yang negatif terhadap Oracle. Namun disamping itu, oracle juga memiliki eberapa keunggulan di antaranya, Oracle menyediakan teknologi paling lengkap, terbuka, dan terintegrasi di dunia stack, termasuk database, perangkat lunak bisnis, sistem operasi, server, dan storage. Strategi produk Oracle menyediakan fleksibilitas dan pilihan seluruh infrastruktur sehingga oracle dapat digolongkan database RDBMS. Selain di atas, oracle juga memiliki keefisienan dan keefektifan yang sangat membantu dalam pengelolaan data, seperti :<br />
- Dapat diakses oleh lebih dari satu komputer menalui client server,<br />
- Dapat akses data secara continue dan terstruktur,<br />
- Menjamin ketersediaan yang terkontrol,<br />
- Memiliki ruang penyimpanan yang cukup besar,<br />
- Performansi pemrosesan transaksi yang tinggi,<br />
- Menjamin ketersediaan yang terkontrol.<br />
<br />
<b># Berikt System Pengolahan Data Pada Oracle</b><br />
<b><br /></b>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-Cfo1P9Ts1DY/UG3azutE3nI/AAAAAAAAACY/YUjMGBDmEjE/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="223" src="http://1.bp.blogspot.com/-Cfo1P9Ts1DY/UG3azutE3nI/AAAAAAAAACY/YUjMGBDmEjE/s320/2.png" width="320" /></a></div>
<br />
<br />
<b>B. Type-type data (fungsi) yang Terdapat Pada Oracle</b><br />
<b><br /></b>
<b>1. CHAR</b><br />
Tipe data char memiliki ciri-ciri yaitu dengan karakter string yang panjang. Pada char memiliki panjang yang tetap karena pada tipe ini karakter yang disimpan agar memiliki ukutan kang terbatas sehingga mendukung kekonsistenan data. Karena tipe ini memiliki fungsi demikian, maka apabila kita menginputkan data melebihi batas maksimal pada char, maka akan ditampilkan pesan eror.<br />
<br />
<b>2. NCHAR</b><br />
Tipe data NCHAR adalah tipe data Unicode-only. Bila Anda membuat sebuah tabel dengan kolom NCHAR, Anda akan diminta menentukan panjang kolom dalam karakter. Anda mendefinisikan karakter nasional saat Anda membuat (create) database Anda.<br />
<b><br /></b>
<b>3. NVARCHAR2</b><br />
Untuk menampung string/karakter dengan panjang bervariasi (tidak harus sepanjang saat didefinisikan). Ukuran maksimum 4000, tergantung dari karakter nasional yang dipakai dalam database.<br />
<br />
<b>4. VARCHAR2</b><br />
Tipe data VARCHAR2 menetapkan string karakter variabel-panjang. Ketika membuat kolom VARCHAR2, anda akan diminta menyertakan jumlah maksimal byte atau karakter data yang dapat diisikan kedalamnya. Oracle kemudian menyimpan setiap nilai dalam kolom persis seperti yang Anda tentukan itu, asalkan nilai tidak melebihi panjang maksimum kolom tentang kolom. Jika Anda mencoba untuk memasukkan nilai yang melebihi panjang yang ditentukan, maka Oracle akan menampilkan pesan error. Banyak yang menegaskan agar lebih mengunakan varchar2 dibandingkan varchar1 karena disaming banyaknya kesamaan, tetapi varchar2 lebih unggul.<br />
<br />
<b>5. LONG</b><br />
Kolom LONG didukung hanya untuk kompatibilitas. Kolom LONG menyimpan string karakter yang mengandung variabel-panjang sampai dengan 2 gigabyte -1 atau 231-1 byte. Kolom LONG memiliki banyak karakteristik kolom VARCHAR2. Anda dapat menggunakan kolom LONG untuk menyimpan string teks panjang. Panjang nilai LONG mungkin dibatasi oleh memori yang tersedia pada komputer Anda. Namun akan lebih baik lagi apabila anda menggunakan kolom LOB (CLOB, NCLOB, BLOB) sebagai gantinya.<br />
<b><br /></b>
<b>6. RAW dan LONG RAW</b><br />
Tipe data RAW dan LONG RAW menyimpan data yang tidak secara eksplisit dikonversi oleh Oracle Database ketika memindahkan data antara sistem yang berbeda. Tipe data ini<br />
dimaksudkan untuk data biner atau string byte. Sebagai contoh, Anda dapat menggunakan<br />
LONG RAW untuk menyimpan grafik, sound, dokumen, atau array data biner, yang<br />
penafsirannya tergantung pada penggunaan masing-masing.<br />
<br />
<br />
<b>C. Tools Yang Biasa Digunakan Pada Database Oracle</b><br />
<br />
-<i>Oracle Universal Installer</i> : Digunakan untuk instalasi software oracle, dan dapat juga digunakan untuk menjalankan Oracle database configuration assistant untuk menginstal sebuah database<br />
-<i>Oracle Database Configuration Assistant</i> : Digunakan untuk meng-create database dari template yang dibuat oleh oracle, atau kita dapat membuat database sendiri sesuai keinginan kita<br />
-<i>Database Upgrade Assistant</i> : Tools yang membantu kita dalam melakukan upgrade database.<br />
-<i>Net Configuration Assistant</i> : Digunakan untuk konfigurasi listener dan naming methods, yang merupakan komponen penting dalam oracle database network<br />
-<i>Oracle Enterprise Manager Database Control</i> : Tools yang digunakan untuk me-manage oracle database interface yang berbasis web.<br />
Arga Arifriatnahttp://www.blogger.com/profile/12597084815269875938noreply@blogger.com0tag:blogger.com,1999:blog-5909475778839997864.post-88617484202692426302012-10-04T05:32:00.003-07:002012-10-04T12:28:20.700-07:00Database CDM & Database PDM<br />
<span style="font-family: Rockwell, serif;"> <b>A. Database CDM (Conceptual Data Model)</b></span><br />
<span style="font-family: Rockwell, serif;"> Merupakan perancangan basisdata yang berdasarkan pengumpulan datandan analisis.</span><br />
<span style="font-family: Rockwell, serif;"> Pembuatan CDM adalah suatu tahap di mana kita melakukan roses idntifikasi dan analisa kebutuhan-kebutuhan data. Untuk menentukan kebutuhan suatu system database, kita harus mengenal terlebih dahulu bagian-bagian lain dari system informasi yang akan berinteraksi dengan system database secara tidak spesifik.</span><br />
<span style="font-family: Rockwell, serif;"><br /></span>
<b><span style="font-family: Rockwell, serif;"> A.1. Berikut adalah Ciri-ciri
dari CDM :</span></b><br />
<span style="font-family: Rockwell, serif;"> - </span><span style="font-family: Rockwell, serif;">Model yang dibuat berdasarkan anggapan bahwa dunia nyata terdiri
dari koleksi obyek-obyek dasar yang dinamakan entitas (entity) serta hubungan
(relationship) antara entitas-entitas itu.</span><span style="font-family: Rockwell, serif;"> </span><br />
<span style="font-family: Rockwell, serif;">- Biasanya direpresentasikan dalam bentuk Entity Relationship Diagram.</span><span style="font-family: Rockwell, serif;">Manfaat Penggunaan CDM dalam perancangan database.</span><br />
<span style="font-family: Rockwell, serif;">
- Memberikan gambaran yang lengkap dari struktur basis data yaitu arti,
hubungan, dan batasan-batasan</span><br />
<span style="font-family: Rockwell, serif;">
- Alat komunikasi antar pemakai basis data, designer, dan analis.</span><br />
<span style="font-family: Rockwell, serif;"><br /></span>
<b><span style="border: 1pt none windowtext; font-family: Rockwell, serif; padding: 0in;"> A.2 . Jenis-jenis objek
dalam CDM :</span></b><br />
<span style="border: 1pt none windowtext; font-family: Rockwell, serif; padding: 0in;"> - Entity</span><br />
<span style="border: 1pt none windowtext; font-family: Rockwell, serif; padding: 0in;"> - Relationship</span><br />
<span style="border: 1pt none windowtext; font-family: Rockwell, serif; padding: 0in;"> - Inheritane</span><br />
<span style="border: 1pt none windowtext; font-family: Rockwell, serif; padding: 0in;"> - Association</span><br />
<b><span style="border: 1pt none windowtext; font-family: Rockwell, serif; padding: 0in;"><br /></span></b>
<b><span style="font-family: Rockwell, serif;">B. Database PDM (Physycal Data Model)</span></b><br />
<span style="font-family: Rockwell, serif;">
Sedangkan PDM merupakan perancangan database secara fisik</span><span style="font-family: Rockwell, serif;">
Tipe data bersifat lebih khusus dan spesifik. Perancangan PDM merupakan
representasi fisik / sebenarnya dari database.</span><br />
<br />
<b><span style="font-family: Rockwell, serif;">B.1.
Berikut adalah Ciri-ciri dari PDM :</span></b><br />
<span style="font-family: Rockwell, serif;"> Menurut ANSI/SPARC, arsitektur basis data terbagi atas tiga level
yaitu :</span><br />
<span style="font-family: Rockwell, serif;">
- Internal/Physical Level : (yang dapat direpresentasikan dengan PDM)
berhubungan dengan bagaimana data disimpan secara fisik (physical storage).</span><span style="font-family: Rockwell, serif;"> </span><br />
<span style="font-family: Rockwell, serif;">- External /View Level : berhubungan dengan bagaimana data di representasikan
dari sisi setiap user.</span><br />
<span style="font-family: Rockwell, serif;">
- Conceptual/Logical Level : (yang dapat direpsesentasikan dengan CDM) yang
menghubungkan antara internal & external level.</span><br />
<span style="font-family: Rockwell, serif;"><br /></span>
<span style="border: 1pt none windowtext; font-family: Rockwell, serif; padding: 0in;"> <b>B.2 . Jenis-jenis
objek dalam PDM :<br /><o:p></o:p></b></span><span style="font-family: Rockwell, serif;">- Table</span><br />
<span style="font-family: Rockwell, serif;">
- View</span><br />
<span style="font-family: Rockwell, serif;">
- Reference</span><o:p> </o:p><br />
<div style="text-align: center;">
<o:p><br /></o:p></div>
<div style="text-align: center;">
<o:p><span style="color: white;">++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</span></o:p></div>
<div style="text-align: center;">
<o:p><br /></o:p></div>
<div style="text-align: left;">
<o:p><b><span style="color: #6aa84f;"># Berikut Perbrdaan Pola Database CDM dan PDM Pada Koperasi</span></b></o:p></div>
<div style="text-align: left;">
<o:p><b><br /></b></o:p></div>
<div style="text-align: left;">
<o:p><b>A. Database CDM </b></o:p><b style="font-family: Rockwell, serif;"> (Conceptual Data Model)</b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-KnipeWehJig/UG3iuP1-CBI/AAAAAAAAACo/MbpjiRBRL_g/s1600/CDMx.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="246" src="http://3.bp.blogspot.com/-KnipeWehJig/UG3iuP1-CBI/AAAAAAAAACo/MbpjiRBRL_g/s320/CDMx.png" width="320" /></a></div>
<o:p><br /></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: left;">
<o:p><b>B. Database PDM</b> </o:p><b><span style="font-family: Rockwell, serif;">(Physycal Data Model)</span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-YcmcWx7m0aQ/UG3MHQfX9bI/AAAAAAAAACI/6nimu9R3eig/s1600/PDMi.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="276" src="http://3.bp.blogspot.com/-YcmcWx7m0aQ/UG3MHQfX9bI/AAAAAAAAACI/6nimu9R3eig/s320/PDMi.png" width="320" /></a></div>
<div style="text-align: left;">
<o:p><br /></o:p></div>
<div style="margin: 0in 0in 0.0001pt;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt; vertical-align: baseline;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt; vertical-align: baseline;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt; vertical-align: baseline;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-size: 13.5pt;"><o:p></o:p></span></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt; vertical-align: baseline;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt; vertical-align: baseline;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<br />
<div style="margin: 0in 0in 0.0001pt; vertical-align: baseline;">
<u1:p></u1:p></div>
<u2:p></u2:p>
<u2:p></u2:p>
Arga Arifriatnahttp://www.blogger.com/profile/12597084815269875938noreply@blogger.com1