RENCANA PELAKSANAAN PEMBELAJARAN TAHUN TAHUN PELAJARAN 2012/2013 2012/201 3 SEKOLAH MATA PELAJARAN KELAS / SEMESTER ALOKASI WAKTU
: SMK NEGERI 5 SURAKARTA : Membuat Program Basis Data : XII / 1 : 1 ! "5 me#it
STANDAR KOMPETENSI : Membuat $rogram basis %ata KOMPETENSI DASAR : Me#&e'as(a# (o#se$ $embuata# DBMS berbasis )'ie#t*Ser+er INDIKATOR : 1, Me#ggu#a Me#ggu#a(a# (a# a'at*a' a'at*a'at at $emrogr $emrograma ama# # u#tu( u#tu( S-. S-. , Me#g Me#ggu gu#a #a(a (a# # si# si#ta ta(s (s S-. S-. 0, Me#& Me#&a' a'a# a#(a (a# # $eri $eri#t #ta a S-. S-. TUJUAN PEMBELAJARAN : A. PERTEMUAN 1 1, Sis2a Sis2a %a$at %a$at me#geta me#getaui ui arti arti %ari %ari basi basiss %ata %ata , Sis2a Sis2a %a$at %a$at me#&e me#&e'as( 'as(a# a# te#ta#g te#ta#g $e#ge $e#gerti rtia# a# DBMS DBMS 0, Sis2a Sis2a %a$at %a$at me#&e me#&e'as( 'as(a# a# te#ta#g te#ta#g $e#ge $e#gerti rtia# a# S-. B. PERTEMUAN 2 ", Sis2 Sis2aa %a$at %a$at me#g me#ggu# gu#a(a a(a# # a'at a'at $emrog $emrogram rama# a# S-. S-. 5, Sis2 Sis2aa %a$at %a$at me#g me#gert ertii si#ta si#ta(s* (s*si# si#ta( ta(ss S-. S-. C. PERTEMUAN 3 3, Sis2 Sis2aa %a$at %a$at me#ggu me#ggu#a( #a(a# a# si#ta si#ta(s* (s*si# si#ta ta(s (s S-. S-. 4, Sis2 Sis2aa %a$at %a$at me#&a me#&a'a# 'a#(a (a# # $eri $eri#ta #ta S-. S-. , Sis2a Sis2a %a$at %a$at membuat membuat %ata %atabase base se%era# se%era#aa %e#ga# %e#ga# $eri# $eri#ta ta S-. S-. MATERI MATERI AJAR : Penger!"n B"#!# D"" : Sistem basis %ata a%a'a sistem ter(om$uterisasi 6a#g tu&ua# utama#6a a%a'a meme'iara %ata 6a#g su%a %io'a atau i#7ormasi8 %a# membuat i#7ormasi terse%ia saat %ibutu(a#, Pa%a i#ti#6a basis %ata a%a'a me%ia u#tu( me#6im$a# %ata agar %a$at %ia(ses %e#ga# mu%a %a# 9e$at, Penger!"n DBMS : DBMS DBMS Database atau %a'a %a'am m baasa baasa I#%o#e I#%o#esia sia seri#g seri#g %isebu %isebutt Database Management System ; atau sebagai Sistem Ma#a&eme# Ma#a&eme# Basis Data a%a'a suatu sistem a$'i(asi 6a#g %igu#a(a# u#tu( me#6im$a#8 me#ge'o'a8 %a# me#am$i'(a# %ata,
Suatu sistem a$'i(asi %isebut DBMS &i(a meme#ui $ers6arata# mi#ima' sebagai beri(ut : Me#6e%ia(a# 7asi'itas u#tu( me#ge'o'a a(ses %ata Mam$u me#a#ga#i i#tegritas %ata Mam$u me#a#ga#i a(ses %ata 6a#g %i'a(u(a# Mam$u me#a#ga#i ba9(u$ %ata • • • •
Kare#a $e#ti#g#6a %ata bagi suatu orga#isasi/$erusaaa#8 ma(a am$ir sebagia# besar $erusaaa# mema#7aat(a# DBMS %a'am me#ge'o'a %ata 6a#g mere(a mi'i(i, Pe#ge'o'aa# DBMS se#%iri biasa#6a %ita#ga#i o'e te#aga a'i 6a#g s$esia'is me#a#ga#i DBMS 6a#g %isebut sebagai DBA Database ;, Database Administrator ;, Beri(ut i#i a%a'a " ma9am DBMS +ersi (omersia' 6a#g $a'i#g ba#6a( %igu#a(a# %i %u#ia saat i#i8 6aitu :
Se%a#g(a# DBMS +ersi o$e# sour9e 6a#g 9u(u$ ber(emba#g %a# $a'i#g ba#6a( %igu#a(a# saat i#i a%a'a sebagai beri(ut : M6S-. PostgreS-. =irebir% S-.ite >am$ir semua DBMS me#ga%o$si S-. sebagai baasa u#tu( me#ge'o'a %ata $a%a DBMS, • • • •
Penger!"n S$L : S-. Structured Query Language ; a%a'a baasa baasa 6a#g 6a#g %igu#a(a# u#tu( u#tu( me#ge'o'a me#ge'o'a %ata %ata $a%a RDBMS Relational Relational Database Management System ;,
M6S-. My Structured Query Language; atau atau 6a#g 6a#g bias biasaa %iba %iba9a 9a %"!e&'(e) a%a'a sebua $rogram $embuat %a# $e#ge'o'a %atabase atau 6a#g seri#g %isebut %e#ga# DBMS Database si7at %ari DBMS DBMS i#i a%a'a a%a'a <$e# <$e# Sour Sour9e 9e 6a#g 6a#g bisa bisa Database Management System ;8 si7at %i%a$at(a# se9ara gratis $a%a a'amat tt$://222,m6s?',9om, Se'ai# itu M6S-. &uga meru$a(a# $rogram $e#ga(ses %atabase 6a#g bersi7at &ari#ga#8 sei#gga %a$at %igu#a(a# u#tu( a$'i(asi M()! Ba#6a( Pe#ggu#a;, Pe#ggu#a;, Ke'ebia# Ke'ebia# 'ai# M()! U#er Ba#6a( %ari M6S-. a%a'a me#ggu#a(a# baasa ?uer6 $ermi#taa#; sta#%ar S-. Structured Query Language ;, S-. a%a'a suatu baasa $ermi#taa# 6a#g terstru(tur8 S-. te'a %i sta#%ar(a# u#tu( semua $rogram $e#ga(ses %atabase se$erti
P mau$u# 6a#g ti%a( <$e# Sour9e 6a#g a%a $a%a $'at7orm 2i#%o2s se$erti se$e rti @isua' @isua' Basi98 De'$i %a# 'ai##6a, Program*Program a$'i(asi 6a#g me#%u(u#g M6S-. : P>P Page >i$erte!t Pre$rosesor; Bor'a#% De'$i8 Bor'a#% ) Bui'%er @isua' Basi9 5,/3, %a# ,Net @isua' @isua' =o!Pro )o'% =usio#8 %a# masi ba#a6a( 'agi • • • • •
Kare#a $e#ti#g#6a %ata bagi suatu orga#isasi/$erusaaa#8 ma(a am$ir sebagia# besar $erusaaa# mema#7aat(a# DBMS %a'am me#ge'o'a %ata 6a#g mere(a mi'i(i, Pe#ge'o'aa# DBMS se#%iri biasa#6a %ita#ga#i o'e te#aga a'i 6a#g s$esia'is me#a#ga#i DBMS 6a#g %isebut sebagai DBA Database ;, Database Administrator ;, Beri(ut i#i a%a'a " ma9am DBMS +ersi (omersia' 6a#g $a'i#g ba#6a( %igu#a(a# %i %u#ia saat i#i8 6aitu :
Se%a#g(a# DBMS +ersi o$e# sour9e 6a#g 9u(u$ ber(emba#g %a# $a'i#g ba#6a( %igu#a(a# saat i#i a%a'a sebagai beri(ut : M6S-. PostgreS-. =irebir% S-.ite >am$ir semua DBMS me#ga%o$si S-. sebagai baasa u#tu( me#ge'o'a %ata $a%a DBMS, • • • •
Penger!"n S$L : S-. Structured Query Language ; a%a'a baasa baasa 6a#g 6a#g %igu#a(a# u#tu( u#tu( me#ge'o'a me#ge'o'a %ata %ata $a%a RDBMS Relational Relational Database Management System ;,
M6S-. My Structured Query Language; atau atau 6a#g 6a#g bias biasaa %iba %iba9a 9a %"!e&'(e) a%a'a sebua $rogram $embuat %a# $e#ge'o'a %atabase atau 6a#g seri#g %isebut %e#ga# DBMS Database si7at %ari DBMS DBMS i#i a%a'a a%a'a <$e# <$e# Sour Sour9e 9e 6a#g 6a#g bisa bisa Database Management System ;8 si7at %i%a$at(a# se9ara gratis $a%a a'amat tt$://222,m6s?',9om, Se'ai# itu M6S-. &uga meru$a(a# $rogram $e#ga(ses %atabase 6a#g bersi7at &ari#ga#8 sei#gga %a$at %igu#a(a# u#tu( a$'i(asi M()! Ba#6a( Pe#ggu#a;, Pe#ggu#a;, Ke'ebia# Ke'ebia# 'ai# M()! U#er Ba#6a( %ari M6S-. a%a'a me#ggu#a(a# baasa ?uer6 $ermi#taa#; sta#%ar S-. Structured Query Language ;, S-. a%a'a suatu baasa $ermi#taa# 6a#g terstru(tur8 S-. te'a %i sta#%ar(a# u#tu( semua $rogram $e#ga(ses %atabase se$erti P mau$u# 6a#g ti%a( <$e# Sour9e 6a#g a%a $a%a $'at7orm 2i#%o2s se$erti se$e rti @isua' @isua' Basi98 De'$i %a# 'ai##6a, Program*Program a$'i(asi 6a#g me#%u(u#g M6S-. : P>P Page >i$erte!t Pre$rosesor; Bor'a#% De'$i8 Bor'a#% ) Bui'%er @isua' Basi9 5,/3, %a# ,Net @isua' @isua' =o!Pro )o'% =usio#8 %a# masi ba#a6a( 'agi • • • • •
M*S$L er%"#(' 'e +")"% "r#!e'(r ",)!'"#! C)!en&Ser-er A$'i(asi C)!en&Ser-er sesuai #ama#6a; memi'i(i %ua a$'i(asi 6aitu : meru$a(a# # $rogram $rogram 6a#g biasa#6 biasa#6aa ber&a'a ber&a'a# # sebagai sebagai background process Ser-er : meru$a(a • atau $roses %ibe'a(a#g 'a6ar sistem o$erasi, User biasa#6a ti%a( %a$at berubu#ga# berubu#ga# %e#ga# ser+er se9ara 'a#gsu#g8 teta$i arus me'a'ui a$'i(asi )!en, meru$a(a# a$'i(asi a$'i(asi / $rogram 6a#g memi'i(i memi'i(i user interface a#tar mu(a; C)!en : meru$a(a# • se$e se$ert rtii term termi# i#a' a' / 9omm 9omma# a#% % $rom $rom$t $t88 tomb tombo' o'88 (ota (ota( ( te(s te(s88 me#u me#u too' too'ba barr %a# %a# sebagai#6a, a%i a$'i(asi C)!en&Ser-er a%a'a %ima#a sistem ter%iri atas bebera$a a$'i(asi %a# mere(a sa'i#g terga#tu#g satu %e#ga# 'ai##6a ti%a( %a$at ber%iri se#%iri;, Mengg(n"'"n ")" ,e%rgr"%"n S$L U#tu( me#ge'o'a %atabase M6S-. me#ggu#a(a# : Prom$t DP P>P M6A%mi# •
U#tu( me'a(u(a# a(ses (e %atabase me#ggu#a(a# : Ko#e(si (e %atabase -uer6 / $ermi#taa# %ata Pemutusa# (o#e(si • • •
In#"))"#! M*S$L U#tu( bisa be(er&a %e#ga# so7t2are M6S-.8 te#tu#6a so7t2are tersebut arus teri#sta'' ter' ter'ebi ebi %au' %au'u u %i (om (om$ut $uter er (ita, (ita, U#tu( U#tu( me#%a me#%a$at $at(a# (a# so7t2 so7t2ar aree terse tersebut but (ita (ita %a$at %a$at %o2#'oa% %ari 2ebsite resmi M6S-. 6aitu tt$://222,m6s?',9om, Di 2ebsite tersebut a%a bebera$a so7t2are M6S-. %ari 6a#g ter'ama sam$ai 6a#g terbaru, Da'am Da'am mo% mo%u' u' i#i (ita (ita a(a# me#ggu# me#ggu#a(a# a(a# M6S-. M6S-. +ersi +ersi m6 m6s?'*e s?'*esse sse#tia #tia'*5, '*5,," ,"*2i *2i#0, #0, Sete'a a#%a %o2#'oa%8 se'a#&ut#6a i(uti i#stru(si 6a#g a%a (eti(a i#sta''asi,
U#tu( me#getaui ba2a M6S-. i#i su%a be(er&a %e#ga# bai( bu(a )omma#% )omma#% $rom$t, $rom$t, K'i( Start C Ru# (eti( 9m%F C
i(a te'a #am$a( si#ta( : mysql> ma(a (ita te'a masu( (e%a'a# s6stem %atabase M6S-. tersebut,
C"r" In#"))"#! AMPP XAMPP meru$a(a# sebua $a(et i#sta'asi i#sta'as i u#tu( u#tu ( P>P8 APA)>E APA)>E %a# M6S-., De#ga# me#ggu#a(a# XAMPP8 (ita ti%a( $er'u 'agi re$ot me#gi#sta'' (etiga so7t2are itu se9ara ter$isa, XAMPP %a$at %i %o2#'oa% %i tt$://222,a$a9e7rie#%s,org/e#/i#%e!,tm', Beri(ut i#i a%a'a 9ara me#gi#sta'' XAMPP, 1, a'a a'a#( #(a# a# 7i'e 7i'e "%,,&!n32&1.4.5&!n#"))er.ee atau +ersi 'ai#; , Kemu%ia# Kemu%ia# a(a# tam$i' tam$i' $i'ia# $i'ia# u#tu( u#tu( memi'i memi'i baasa baasa (eti(a $roses i#sta'asi i#sta'asi ber&a'a#, ber&a'a#,
0, Proses Proses i#sta'' i#sta''asi asi a(a# %imu'ai %imu'ai,, K'i( K'i( Ne u#tu( memu'ai#6a,
", Memi'i Memi'i 'o(asi 'o(asi u#tu( u#tu( $e#gi#sta' $e#gi#sta''a# 'a# XAMPP XAMPP88 (emu%ia# (emu%ia# ('i( ('i( Ne u#tu( me'a#&ut(a#,
5, Pa%a tam$i'a# tam$i'a# XAMPP XAMPP o$tio#s8 $i'i 9e#ta#g semua#6a semua#6a %a# ('i( ('i( In#")),
3, Tu#ggu Tu#ggu bebera bebera$a $a saat i#gg i#ggaa $roses $roses i#sta'' i#sta''asi asi se'esai se'esai,, 4, I#sta I#sta'' ''asi asi se'es se'esai ai,, K'i K'i( ( 6!n!#7,
, Sam$ai taa$ i#i8 berarti (ita su%a me#gi#sta' AMPP, Itu berarti (ita su%a se'esai me#gi#sta'' P>P8 APA)>E %a# MS-., .a#g(a se'a#&ut#6a a%a'a me#&a'a#(a# ser+i9e#6a, H, a'a#(a# AMPP Cnr) P"ne) 6a#g a%a %i +e#', , Atau a#%a &uga %a$at me#&a'a#(a# AMPP Cnr) P"ne) %ari me#u S"r &8 A)) Prgr"%# &8 ","7e9r!en+# &8 "%,, &8 "%,, nr) ,"ne) ,
1, N6a'a(a# A$a9e %a# M6s?' %e#ga# me#g('i( tombo' Start, Bu(a 2eb bro2ser a#%a8 'a'u (eti((a# tt$://'o9a'ost, i(a tam$i'a##6a se$erti %i ba2a i#i8 ma(a a$a9e su%a teri#sta'' %e#ga# be#ar,
M"#(' Ke&Ser-er M*S$L Sebagai %asar me#ggu#a(a# %atabase M6S-. a(a# %ibaas 9ara me#ga(ses %a# me#ggu#a(a# %atabase M6S-., A%a bebera$a 9ara %ia#tara#6a 6aitu : 1, Memaami =o'%er Ser+er M6S-. M6S-. se9ara sta#%ar %a$at %i i#sta'' $a%a %ri+e utama %ri+e )8 a$abi'a %i i#%o2s;, Semua uti'it6 %a# $e#em$ata# %atabase/tabe' %i'eta((a# $a%a 7o'%er C:AMPP%*#;), U#tu( %atabase basis %ata; 6a#g te'a %ibuat %a$at %itemu(a# $a%a sub 7o'%er C:AMPP%*#;)+"",
, Me#ggu#a(a# User Tamu Pa%a $ertama (a'i m6s?' %ii#sta''8 ser+er te'a me#6e%ia(a# user %e#ga# ta#$a a%a +eri7i(asi a$a$u#, Arti#6a8 (ita %a$at me'a(u(a# 'ogi# %e#ga# ti%a( me#ggu#a(a# user#ame %a# $ass2or% a$a$u#, Kita %a$at masu( $a%a $rom$t M6S-. %e#ga# 9ara masu( $a%a 7o'%er bi#8 %a# (emu%ia# %a$at me#&a'a#(a# M6S-. K'ie# 6a#g te'a %ise%ia(a# ber#ama %*#;).ee, Perati(a# 9ara beri(ut a$abi'a %i'a(u(a# %ari (om$uter i#%o2s, 1, Membu(a &e#%e'a MS DOS atau C%%"n+ Pr%, me'a'ui me#u R(n %e#ga# 9ara me#u'is(a# $eri#ta %+ a$abi'a me#ggu#a(a# i#%o2s XP8 %a# me#u'is(a# $eri#ta %%"n+ $a%a i# H!,
, Sete'a masu( $a%a &e#%e'a )MD atau MS D
0, Sete'a itu tu'is(a# $eri#ta CD AMPP (emu%ia# te(a# ener8 a(a# mu#9u' se$erti %iba2a i#i :
", .a#g(a se'a#&ut#6a tu'is $eri#ta CD %*#;) (emu%ia# te(a# ener8 a(a# mu#9u' se$erti tam$i'a# %iba2a i#i :
5, Kemu%ia# tu'is(a# (emba'i $eri#ta CD
3, Sete'a masu( $a%a sub 7o'%er C:AMPP%*#;)
4, A$abi'a te'a me#%a$at $rom$t %e#ga# #ama m6s?'CF8 berarti %atabase M6S-. te'a sia$ me#erima $eri#ta (ita, Me%<(" +"n Meng"'!9'"n D""<"#e Sebe'um membuat tabe' %a# (o'om8 (ita arus mem$ersia$(a# %atabase#6a ter'ebi %au'u, M6S-. memi'i(i $eri#ta 6a#g %a$at %igu#a(a# u#tu( membuat %atabase baru8 6aitu CREATE DATABASE, Beri(ut i#i 9o#to#6a :
Pa%a $eri#ta %iatas8 $er#6ataa# -uer6
Sete'a me#%a$at(a# $esa# Database 9a#ge%F8 berarti se(ara#g te'a bera%a %i %a'am %atabase ber#ama +""=#e'")7+< , Se(ara#g a$abi'a (ita me#geti((a# sebua $eri#ta8 ma(a se9ara otomatis e7e(#6a a(a# %itu&u(a# $a%a %atabase a(ti7, Me'iat Da7tar Tabe' : A$abi'a a(a# me'iat i#7ormasi me#ge#ai (ebera%aa# tabe' $a%a suatu %atabase8 %a$at me#ggu#a(a# $eri#ta SHOW TABLES, Beri(ut i#i 9o#to#6a :
B"7"#" S$L %e%!)!'! *"!( : 1, Data Definition Language ?DDL, S-. DD. me#6e%ia(a# $eri#ta*$eri#ta u#tu( me#%e7i#isi(a# s(ema re'asi8 me#ga$us re'asi8 serta memo%i7i(asi s(ema re'asi, , Data Manipulation Language ?DML, S-. DM. me#9a(u$ baasa S-. u#tu( me#6isi$(a# re(ama# $a%a re'asi8 me#ga$us re(ama# $a%a re'asi8 serta memo%i7i(asi re(ama# $a%a re'asi, 0, View Definition, S-. memuat $eri#ta*$eri#ta u#tu( me#%i7i#isi(a# tam$i'a#* tam$i'a# view; 6a#g %i(ee#%a(i $e#ggu#a, ", Transaction Control , S-. memuat $eri#ta*$eri#ta u#tu( me#s$esi7i(asi a2a' %a# a(ir tra#sa(si, 5, Embedded SQL %a# Dynamic SQL, Termi#o'ogi i#i me#9a(u$ (emam$ua# S-. u#tu( %isisi$(a# $a%a bebera$a baasa $emrograma#8 misa'#6a $a%a @isua' Basi98
De'$i8 )8 a+a %a# sebagai#6a, 3, Integrity, S-. DD. me#9a(u$ $eri#ta*$eri#ta u#tu( me#s$esi7i(asi batasa#* batasa# i#tegritas, 4, Autori!ation, S-. DD. me#9a(u$ $eri#ta*$eri#ta u#tu( membatasi a(ses $a%a basis %ata %emi a'asa# (eama#a#, Be'er@" +eng"n ,er!n"7 DDL ? Data Definition Language 1, Me#ggu#a(a# Peri#ta )REATE Peri#ta CREATE meru$a(a# bagia# %ari $eri#ta DD. Data Definition Language; 6a#g %igu#a(a# u#tu( memba#gu# atau me#%esai# stru(tur tabe' baru, U#tu( membuat tabe'8 si#ta( 6a#g %igu#a(a# a%a'a : CREATE TABLE n"%"=" K)%=< TPE ?)e<"r> ............. ........... .............. K)%=n TPE ?)e<"r
De#ga# me#ggu#a(a# si#ta(s %i atas8 (ita %a$at me#gim$'eme#tasi(a# $ere#9a#aa# tabe' ber#ama g(r(8 tabe' i#i (ita buat $a%a %atabase %ataJse(o'a%b 6a#g te'a (ita buat sebe'um#6a, U#tu( mem$ermu%a $emaama#8 stru(tur %ari tabe' g(r( a%a'a: Ko'om Ni$ Nama Ke'ami# Agama A'amat Kea'ia#
Ti$e )>AR @AR)>AR ENUM @AR)>AR @AR)>AR @AR)>AR
.ebar 5 05
Ketera#ga#
PL8LL; 15 3 1
Dari stru(tur %esai# tabe' g(r( %i atas8 a$abi'a %iim$'eme#tasi(a# %e#ga# $eri#ta CREATE8 ma(a $eri#ta 'e#g(a$#6a a%a'a :
Pa%a $eri#ta %i atas8 $er#6ataa# NOT NULL me#a#%a(a# ba2a (o'om 6a#g %ima(su% arus %iisi %e#ga# %ata8 atau berarti setia$ a%a re9or% baru (o'om tersebut ti%a( bo'e %ibiar(a# (oso#g, Sete'a tabe' tersebut terbuat (ita %a$at me'iat
ra#9a#ga# tabe' tersebut %e#ga# 9ara me#%is(ri$si(a##6a (emba'i, Peri#ta 6a#g %igu#a(a# a%a'a DESC atau DESCRIBE, Beri(ut i#i 9o#to#6a :
, Me#ggu#a(a# Peri#ta A.TER Semua be#tu( tabe' 6a#g $er#a %ibuat bu(a# meru$a(a# tabe' a(ir 6a#g mati ti%a( %a$at %iuba;8 a(a# teta$i (ita masi %a$at mema#i$u'asi be#tu( tabe' 6a#g te'a a%a me#&a%i be#tu( 'ai#, ALTER meru$a(a# $eri#ta DDL 6a#g %igu#a(a# u#tu( me'a(u(a# $erubaa# %esai# tabe' me#&a%i tabe' %e#ga# stru(tur baru, Sebagai 9o#to8 $a%a tabe' g(r( 6a#g te'a %ibuat memi'i(i (o'om ber#ama 'e"7)!"n8 (ita a(a# meruba#6a me#&a%i (o'om )()(#"n, Beri(ut i#i 9o#to#6a :
Dari $eri#ta %i atas8 ma(a %iasi'(a# tam$i'a##6a sebagai beri(ut :
A$abi'a e#%a( me#amba(a# (o'om baru8 ma(a $er'u me#ggu#a(a# o$tio# ADD %a'am $eri#ta ALTER , Se%a#g(a# u#tu( a'amat $e#em$ata# atau $osisi (o'om#6a8 %a$at me#ggu#a(a# o$tio# A6TER , Sebagai 9o#to8 a$abi'a e#%a( me#amba(a# (o'om %e#ga# #ama 'e"7)!"n $a%a tabe' g(r(8 ti$e %ata#6a a%a'a @AR)>AR1;8 (o'om baru i#i a(a# %i'eta((a# sete'a (o'om ")"%", Sei#gga $eri#ta#6a a%a'a :
0, Me#ggu#a(a# Peri#ta DR
Dari Peri#ta %iatas8 $erati(a# $erubaa##6a se$erti $a%a tam$i'a# beri(ut :
De#ga# me#ggu#a(a# DROP &uga %a$at me#ga$us tabe' 6a#g a%a %i %a'am %atabase a(ti7, Te(#i( $e#ggu#aa##6a a%a'a %e#ga# me#u'is(a# $eri#ta DROP n"%""
Be'er@" +eng"n ,er!n"7 DML ? Data Manipulation Language 1, Persia$a# Database %a# Tabe' Sebagai 'atia#8 (ita a(a# me#ggu#a(a# %atabase 6a#g bergu#a u#tu( me#ge'o'a %ata se(o'a ti#ggi, Re'asio#a' tabe' 6a#g a(a# %igu#a(a# a%a'a se$erti gambar beri(ut :
Pa%a 'atia# i#i %atabase 6a#g %igu#a(a# a%a'a +""='"%,(#+<8 u#tu( itu sebe'um#6a (ita arus membuat %atabase tersebut, Pa%a ra#9a#ga# %atabase %iatas8 tabe' @en!#'"%,(# %igu#a(a# u#tu( mere(am %ata*%ata (am$us ber%asar(a# &e#is#6a, Tabe' i#i a(a# memi'i(i ubu#ga# satu (eba#6a( one to many ; %e#ga# tabe' +""'"%,(# , Beri(ut a%a'a $eri#ta u#tu( membuat %atabase +""='"%,(#+< 8 tabe' +""'"%,(# %a# tabe' @en!#'"%,(# $a%a ser+er M6S-. :
CREATE DATABASE +""='"%,(#+< USE +""='"%,(#+< CREATE TABLE @en!#'"%,(# ? '+=@en!# CHAR?3 NOT NULL> n%=@en!# ARCHAR?40 NOT NULL> PRIMAR KE ?'+=@en!#
Se'a#&ut#6a (ita %a$at membuat tabe' (e%ua 6a#g ber#ama +""'"%,(#, Tabe' i#i a(a# %igu#a(a# u#tu( mere(am %ata*%ata (am$us se9ara %etai', Di %a'am tabe' i#i ter%a$at (u#9i tamu 6a#g berasa' %ari tabe' @en!#'"%,(#, Kita %a$at membuat tabe' i#i %e#ga# me#geti((a# $eri#ta %iba2a i#i : CREATE TABLE +""'"%,(# ? '+='"%,(# CHAR? NOT NULL> '+=@en!# CHAR?3 NOT NULL> n%='"%,(# ARCHAR?3F NOT NULL> 7n= @(%=9"'()"# INT?2 NOT NULL> +%!#!)! ARCHAR?3F NOT NULL> #"(# ENUM?GNEERI>SWASTA NOT NULL> PRIMAR KE ?'+='"%,(#
, Me#ggu#a(a# Peri#ta INSERT Peri#ta INSERT %igu#a(a# u#tu( memasu((a# %ata (e %a'am tabe' terte#tu, De#ga# me#ggu#a(a# $eri#ta i#i (ita %a$at me#amba %ata baru (e %a'am tabe' 6a#g masi (oso#g atau$u# tabe' 6a#g te'a berisi, Beri(ut a%a'a si#ta( %asar u#tu( memasu((a# %ata : INSERT INTO n"%"" ')%<> ....> ')%n ALUES ?G!#!=')%">!#!=')%<>....>!#!=')%n
De#ga# me#ggu#a(a# si#ta(s %iatas8 ma(a (ita %a$at memasu((a# %ata baru (e %a'am tabe' @en!#'"%,(# %e#ga# 9ara sebagai beri(ut :
Pa%a 9ara %iatas (ita a#6a memasu((a# %ata u#tu( satu re9or% satu baris; sa&a8 sebe#ar#6a u#tu( me#gemat 2a(tu (ita %a$at memasu((a# bebera$a baris %ata se9ara bersamaa#, Beri(ut i#i 9o#to6a :
Se'a#&ut#6a memasu((a# %ata*%ata (am$us (e%a'am tabe' +""'"%,(# %e#ga# me#&a'a#(a# $eri#ta se$erti sebe'um#6a, 0, Me#ggu#a(a# Peri#taSE.E)T Peri#ta SELECT %igu#a(a# u#tu( me#6e'e(si atau memi'i atau me#am$i'(a# sebagia# atau semua %ata 6a#g a%a %i %a'am sebua (o'om, Da'am %atabase re'asio#a'8 $eri#ta i#i %igu#a(a# u#tu( me#gambi' %ata %ari bebera$a tabe' 6a#g bere'asi, De#ga# me#ggu#a(a# 9ara biasa8 $eri#ta SE.E)T %a$at %igu#a(a# u#tu( me#am$i'(a# semua %ata (o'om %a# baris; %ari sebua tabe', Parameter 6a#g %igu#a(a# u#tu( me#u#&u( $a%a semua (o'om a%a'a ta#%a bi#ta#g ?, Beri(ut a%a'a si#ta(s#6a : SELECT 6ROM n"%""
De#ga# me#ggu#a(a# si#ta(s %iatas8 (ita %a$at me#9oba#6a u#tu( me#am$i'(a# semua %ata %ari tabe' @en!#'"%,(#, Beri(ut i#i 9o#to asi'#6a :
Se'ai# me#ggu#a(a# ta#%a bi#ta#g8 (ita &uga %a$at 'a#gsu#g memba9a %ire(tori 6a#g %ata#6a a(a# %itam$i'(a#, Beri(ut 9o#to $e#ggambara# si#ta(s#6a : SELECT ')%"> ')%<> ')%n 6ROM n"%"e
Sebagai 9o#to8 (ita %a$at me#&a'a#(a# $eri#ta beri(ut :
", Me#ggu#a(a# Peri#ta UPDATE Peri#ta UPDATE8 sesuai %e#ga# #ama#6a $eri#ta i#i %igu#a(a# u#tu( me#g* update atau mem$erbarui %ata 'ama me#&a%i %ata ter(i#i terbaru;, Beri(ut 9ara $e#ggu#aa# si#ta(s#6a : UPDATE n"%"" ')%<+""<"r(> ....> ')%n+""<"r( WHERE ')%'(n!'+e<"r!#
Pa%a si#ta(s %i atas8 $er#6ataa# WHERE %e#ga# satu (o#%isi berarti %ata 6a#g a(a# %i$erbarui a#6a satu baris, Sebagai 'atia#8 (ita a(a# me#guba %ata @en!#'"%,(# %ari oliteknik F me#&a%i "olite#ni# $"%LTE&'F8 ma(a $eri#ta 6a#g %igu#a(a# a%a'a :
Pa%a $eri#ta %i atas8 $er#6ataa# WHERE '+=@en!#J04F bergu#a u#tu( me#u#&u( baris 6a#g memi'i(i (o%e3 u#tu( %ie%it, Sei#gga %e#ga# $eri#ta tersebut a(a# me#ga(ibat(a# $erubaa# se$erti beri(ut :
5, Me#ggu#a(a# Peri#ta DE.ETE Peri#ta DELETE %igu#a(a# u#tu( me#gi'a#g(a# atau me#ga$us sebagia# atau semua %ata 6a#g a%a %i %a'am tabe', Se$erti a'#6a %e#ga# $eri#ta UPDATE8 u#tu( me#ggu#a(a# $eri#ta DE.ETE &uga %i$er'u(a# (o#%isi %e#ga# ('ausa >ERE u#tu( me#u#&u( baris ma#a 6a#g a(a# %ii'a#g(a#, Si#ta(s %asar $eri#ta DE.ETE %a$at %i'iat %iba2a i#i : DELETE 6ROM n"%""
De#ga# me#ggu#a(a# si#ta(s %i atas8 ma(a (ita %a$at me#ggu#a(a##6a u#tu( me#gaa$us sa'a satu baris %ata 6a#g a%a %i %a'am tabe' @en!#'"%,(#, Misa'#6a (ita a(a# me#ga$us %ata $a%a baris (e*58 6aitu (o%e#6a J0F;8 ma(a $eri#ta#6a a%a'a sebagai beri(ut :
De#ga# me#ggu#a(a# $eri#ta %iatas8 ma(a $erubaa# %ata#6a %a$at %i'iat sebagai beri(ut :
METODE PEMBELAJARAN : A, Pe#&e'asa# / 9erama B, Demo#strasi ), Pra(ti(um D, Ta#6a &a2ab %a# %is(usi E, Prese#tasi tugas KEIATAN PEMBELAJARAN : PERTEMUAN 1 A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru mem$er(e#a'(a# %iri %a# (e#a'a# %e#ga# $esertaa %i%i( %e#ga# me#gabse# satu $er satu, 0, Guru me#6am$ai(a# tu&ua# $embe'a&ara# &uga $e#&e'asa# a2a' te#ta#g materi 6a#g a(a# %ia&ar(a#, B. KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, 3. Kn9!r%"#! a, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a# b, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(, PERTEMUAN 2. A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$,
B.
KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, 3. Kn9!r%"#! a, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a#, b, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(,
PERTEMUAN 3. A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, 3. Kn9!r%"#! a, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a#, b, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(, PENUNAAN ALAT> BAHAN DAN SUMBER BELAJAR A. Kom$uter u#tu( setia$ $eserta %i%i(, B. S$i%o' 8 $e#ga$us8 $a$a# tu'is, C. A'at $eraga $rese#tasi, D. So7t2are 6a#g %ibutu(a# : XAMPP8 Moi''a =ire7o! atau Goog'e )rome E. Mo%u' te#ta#g M6S-. PENILAIAN
A.
SOAL 1, A$a (e$a#&a#ga# S-. %a# &e'as(a# se9ara si#g(at te#ta#g S-. Q bobot #i'ai 1; , Sebut(a# 5 9o#to DBMS bobot #i'ai 5; 0, A$a 7u#gsi %ari Data De7i#itio# .a#guage DD.; %a# Data Ma#i$u'atio# .a#guage DM.; Q bobot #i'ai 5; ", A$a 7u#gsi %ari $eri#ta i#sert $a%a si#ta(s m6s?' Q bobot #i'ai 15; 5, Tu'is(a# si#ta(s m6s?' u#tu( membuat satu tabe' guru 6a#g tersusu# atas 7ie'% #i$8 #ama8 (e'ami# %a# a'amat bobot #i'ai 5;
SUMBER BELAJAR A,S8 Rosa %a# M,Sa'au%%i#, 11, Mo%u' Pembe'a&ara# Re(a6asa Pera#g(at .u#a( • Terstru(tur Da# Berorie#tasi P %a# M6S-. %e#ga# • Dream2ea+er MX O38 48 " %a# , og6a(arta : Ga+a Me%ia
Sura(arta8 ,,,,,,,,,, u'i 1 Me#getaui Ke$a'a SMK Negeri 5 Sura(arta
Dr#. T"(' Her*"n> MM NIP, 1H35"4 1HH0 1 1H
Guru Mata Pe'a&ara# / Kom$ete#si
R!n" ()!"n"> S.K%.
RENCANA PELAKSANAAN PEMBELAJARAN TAHUN PELAJARAN 2012/2013 SEKOLAH MATA PELAJARAN KELAS / SEMESTER ALOKASI WAKTU
: SMK NEGERI 5 SURAKARTA : Membuat Program Basis Data : XII / 1 : 1 ! "5 me#it
STANDAR KOMPETENSI : Membuat $rogram basis %ata KOMPETENSI DASAR : Me#ggu#a(a# S-. INDIKATOR : 1, Me#&a'a#(a# uti'it6 M6S-. , Membuat %atabase %e#ga# (ete#tua# (usus 0, Me#e#tu(a# Stru(tur tabe' ", Mema#i$u'asi %atabase TUJUAN PEMBELAJARAN : A. PERTEMUAN 1 1, Sis2a %a$at me#&a'a(a# %a# me#ggu#a(a uti'it6 M6S-. , Sis2a %a$at mera#9a#g %atabase 6a#g bai( B. PERTEMUAN 2 0, Sis2a %a$at me#getaui ti$e*ti$e %ata 6a#g %i%u(u#g o'e M6S-. ", Sis2a %a$at membuat %atabase %e#ga# (ete#tua# (usus 5, Sis2a %a$at me#e#tu(a# stru(tur tabe' %a'am %atabase 6a#g %i buat C. PERTEMUAN 3 3, Sis2a %a$at me#getaui $eri#ta*$eri#ta M6S-. 6a#g bergu#a mema#i$u'asi %atabase 4, Sis2a %a$at mema#i$u'asi %atabase %e#ga# me#ggu#a(a# $eri#ta M6S-. MATERI AJAR : Mengg(n"'"n U!)!* M*S$L ?PHP M*A+%!n .a#g(a me#ggu#a(a# uti'it6 M6S-. me#ggu#a(a# P>P M6A%mi# : 1, A(ti7(a# Xam$$ )o#tro' Pa#e' , K'i( tombo' A%mi# $a%a A$a9e 0, Too's P>PM6A%mi#
Atau %a$at &uga me'a'ui a'ama# bro2ser :
u#tu(
1, Bu(a a'ama# bro2ser tt$://'o9a'ost , Too's P>PM6A%mi# Men@")"n'"n S$L $(er* +! PHPM*A+%!n Sa'a satu %atabase so7t2are 6a#g umum %igu#a(a# u#tu( me#ge'o'a suatu 2eb %atabase a%a'a ,7,M*A+%!n, U#tu( membuat %a# me#ge'o'a tabe' %i $$M6A%mi# sebe#ar#6a (ita su%a %iberi (emu%aa# %e#ga# 9ara memi'i %a# me#g('i( me#u*me#u 6a#g a%a, Ta$i bagi 6a#g i#gi# be'a&ar me#ge#ai S$L $(er* se$erti DDL Data Definition Language; %a# DML Data Manipulation Language ; u#tu( me#ge'o'a tabe' se9ara ma#ua'8 A#%a &uga bisa me#ggu#a(a# $$M6A%mi#, Beri(ut 9ara#6a : 1. i(a me#ggu#a(a# Xam$$8 bu(a $$M6A%mi# %i UR. 7,://)")7#8 (emu%ia# T)# ,7,M*A+%!n 2. Buat %atabase baru %i (o'om Cre"e ne +""<"#e 8 misa' %e#ga# #ama %atabase +<,er,(#"'""n 8 'a'u ('i( Cre"e,
Atau &i(a i#gi# me#ggu#a(a# S$L $(er*8 $a%a si%ebar ('i( i9o# $(er* !n+ i9o# (e %ua %ari (iri;8 ma(a 2i#%o2 baru a(a# mu#9u',
Pa%a 2i#%o2 baru tersebut (eti((a# sa&a S-. -uer6 6a#g %ii#gi#(a#8 sebagai 9o#to %isi#i sa6a membuat sebua %atabase %e#ga# #ama +<,er,(#"'""n , i(a su%a8 ('i( ,
3. Kemu%ia# u#tu( membuat sebua tabe' beserta 7ie'%*7ie'%#6a a%a %ua 9ara &uga8 misa' membuat sebua tabel %e#ga# #ama "ngg" %e#ga# 0 bua field 8 6a(#i n!#8 n"%"=#!#" %a# ")"%" %e#ga# field n!# sebagai Pr!%"r* Ke**#6a, Pertama bu(a %atabase 6a#g a(a# %itamba(a# tabe'#6a8 misa'#6a +<,er,(#"'""n (emu%ia# isi(a# $a%a Cre"e ne "<)e n +""<"#e +<,er,(#"'""n %e#ga# nama tabel %a# &um'a field!nya, i(a su%a8 ('i( ,
Se'a#&ut#6a isi(a# tabe' tersebut sesuai %e#ga# (ete#tua# stru(tur#6a8 &i(a su%a ('i( S"-e,
Atau &i(a i#gi# me#ggu#a(a# S$L $(er*8 $a%a si%ebar ('i( i9o# $(er* !n+ i9o# (e %ua %ari (iri;8 ma(a 2i#%o2 baru a(a# mu#9u', Pa%a 2i#%o2 baru tersebut (eti((a# sa&a S-. -uer6 6a#g %ii#gi#(a#8 &i(a su%a ('i( ,
i(a -uer6 6a#g %imasu((a# su%a be#ar ma(a a(a# mu#9u' #oti7i(asi "our SQL query #as been e$ecuted successfully, Per"n"ng"n B"#!# D"" U#tu( mera#9a#g basis %ata (ita $er'u me#getaui ter'ebi %au'u (om$o#e#*(om$o#e# basis %ata tersebut, Kom$o#e# 6a#g $a'i#g $e#ti#g a%a'a e#titas %a# atribut, En!"# +"n Ar!<( En!"# a%a'a sesuatu atau ob&e( %i %u#ia #6ata real word ; 6a#g %a$at %ibe%a(a# %e#ga# sesuatu atau ob&e( 'ai##6a, Sebagai 9o#to8 setia$ maasis2a %a'am suatu u#i+ersitas a%a'a suatu e#titas, Setia$ 7a(u'tas %a'am satu u#i+ersitas &uga suatu e#titas, Da$at %i(ata(a# ba2a e#titas bisa bersi7at (o#se$tua' / abstra( atau #6ata a%ir %i %u#ia #6ata
entitas yang bersifat abstrak% misalnya persamaan kuadrat% rumus!rumus fisika dan sebagainya;, E#titas $a%a umum#6a memi'i(i se&um'a $ro$erti 6a#g %a$at %igu#a(a# u#tu( membe%a(a# suatu e#titas %e#ga# e#titas 'ai##6a, Sebagai 9o#to8 (ar6a2a# suatu $erusaaa# umum#6a memi'i(i NIP 6a#g membe%a(a# seora#g (ar6a2a# %e#ga# (ar6a2a# 'ai##6a8 misa'#6a NIP 51"5 berarti (ar6a2a# %e#ga# i%e#titas A%i Nugroo8 %a# NIP 51"0 berarti (ar6a2a# %e#ga# i%e#titas Sa$to Bu%i >arto#o, Pro$erti*$ro$erti tersebut %i#ama(a# atribut, Suatu e#titas %ire$rese#tasi(a# %e#ga# se&um'a atribut, Ar!<( a%a'a $ro$erti %es(ri$ti7 6a#g %imi'i(i o'e setia$ a#ggota %ari im$u#a# e#titas, De#ga# me#gambi' 9o#to e#titas Maasis2a8 atribut*atribut 6a#g mu#g(i# a%a'a NIM8 #ama maasis2a8 a'amat8 serta #omor te'e$o#, Setia$ e#titas memi'i(i #i'ai u#tu( setia$ atribut#6a, Misa'#6a8 maasis2a terte#tu memi'i(i #i'ai ',)isara#te# Ku'o# No,4 u#tu( atribut a'amat#6a, Atau8 maasis2a 6a#g 'ai# memi'i(i #i'ai 401" u#tu( atribut #omor te'e$o##6a, Re)"#! Re)"#! a%a'a ubu#ga# a#tara suatu im$u#a# e#titas %e#ga# im$u#a# e#titas 6a#g 'ai##6a, Misa'#6a8 e#titas Maasis2a memi'i(i ubu#ga# terte#tu %e#ga# e#titas Mata(u'ia Ma#asiswa mengambil Matakulia# ;, Pa%a $e#ggambara# mo%e' E#titas* Re'asio#a'8 re'asi a%a'a $ere(at 6a#g me#gubu#g(a# suatu e#titas %e#ga# e#titas 'ai##6a, K(n! K(n! ?#ey meru$a(a# suatu atribut 6a#g u#i( 6a#g %a$at %igu#a(a# u#tu( membe%a(a# suatu e#titas %e#ga# e#titas 'ai##6a %a'am suatu im$u#a# e#titas, Se9ara (o#se$tua'8 sebua e#titas i#%i+i%ua' memi'i(i batas 6a#g &e'as, Dari su%ut $a#%a#g basis %ata8 $erbe%aa# %ia#tara mere(a arus %i9ermi#(a# 'e2at $erbe%aa# %a'am #i'ai atribut#6a, Misa'#6a8 u#tu( e#titas maasis2a8 atribut (u#9i#6a mu#g(i# a%a'a NIM*#6a sebab ti%a( %i$er(e#a#(a# 'ebi %ari satu maasis2a memi'i(i #i'ai atribut NIM 6a#g sama8 2a'au$u# mu#g(i# maasis2a*maasis2a itu memi'i(i (ata(a#'a #i'ai atribut #ama 6a#g sama mu#g(i# a%a bebera$a maasis2a %e#ga# #ama 6a#g sama8 misa'#6a Esti Nugrae#i %i suatu U#i+ersitas terte#tu;, Me%<(" R"n"ng"n D""<"#e
Re'asi 6a#g %ia#ut tabe'*tabe' %iatas a%a'a re'asi &ne!to!Many8 misa'#6a re'asi a#tara tabe' user %a# tabe' berita 6a#g %iubu#g(a# o'e 7ie'% user#ame8 %a'am (o#te(s &ne!to! Many8 ma(a seora#g user %a$at me#u'is ba#6a( berita ti%a( bisa seba'i(#6a;, Ta#%a me#a#%a(a# ba2a 7ie'% tersebut meru$a(a# (u#9i $rimer %a'am suatu tabe', Ta#%a me#a#%a(a# ba2a 7ie'% tersebut meru$a(a# (u#9i se9o#%ar6 (u#9i tamu; 6a#g me#gubu#g(a# a#tara satu tabe' %e#ga# tabe' 'ai##6a, T*,e D"" P"+" M*S$L Ti$e %ata 6a#g %i%u(u#g M6S-. a#tara 'ai# 6aitu : 1, Ti$e %ata u#tu( bi'a#ga# No Ti$e Data Ketera#ga# 1, TININT U(ura# 1 b6te, Bi'a#ga# bu'at ter(e9i'8 %e#ga# &a#g(aua# u#tu( bi'a#ga# berta#%a *1 sam$ai %e#ga# 14 %a# u#tu( 6a#g ti%a( berta#%a sam$ai %e#ga# 55, Bi'a#ga# ta( berta#%a %ita#%ai %e#ga# (ata UNSIGNED, , SMA..INT U(ura# b6te, Bi'a#ga# bu'at %e#ga# &a#g(aua# u#tu( bi'a#ga# berta#%a *043 sam$ai %e#ga# 0434 %a# u#tu( 6a#g ti%a( berta#%a sam$ai %e#ga# 35505, 0, MEDIUMINT U(ura# 0 b6te, Bi'a#ga# bu'at %e#ga# &a#g(aua# u#tu( bi'a#ga# berta#%a *03 sam$ai %e#ga# 034 %a# u#tu( 6a#g ti%a( berta#%a sam$ai %e#ga# 1344415, ", INT U(ura# " b6te, Bi'a#ga# bu'at %e#ga# &a#g(aua# u#tu( bi'a#ga# berta#%a *1"4"03" sam$ai %e#ga# 1"4"03"4 %a# u#tu( 6a#g ti%a( berta#%a sam$ai %e#ga# "H"H34H5, 5, INTEGER Sama %e#ga# INT, 3, BIGINT U(ura# b6te, Bi'a#ga# bu'at %e#ga# &a#g(aua# u#tu( bi'a#ga# berta#%a *H004035"445 sam$ai %e#ga#
4, , H,
=.
H004035"4454 %a# u#tu( 6a#g ti%a( berta#%a sam$ai %e#ga# 1""34""4044H551315, U(ura# " b6te, Bii'a#ga# $e9aa#, U(ura# b6te, Bi'a#ga# $e9aa#, U(ura# M b6te, Bi'a#ga# $e9aa#, Misa'#6a DE)IMA.58; %a$at %igu#a(a# u#tu( me#6im$a# bi'a#ga# *HH8HH sam$ai %e#ga# HH8HH,
, Ti$e %ata u#tu( ta#gga' %a# &am No Ti$e Data Ketera#ga# 1, DATETIME U(ura# b6te, Kombi#asi ta#gga' %a# &am %e#ga# &a#g(aua# %ari 1*1*1 ::L sam$ai %e#ga# HHHH*1*01 0:5H:5HL, , DATE U(ura# b6te, Kombi#asi ta#gga' %a# &am %e#ga# &a#g(aua# %ari 1*1*1L sam$ai %e#ga# HHHH*1*01 L, 0, TIMESTAMP U(ura# " b6te, Kombi#asi ta#gga' %a# &am %e#ga# &a#g(aua# %ari 1H4*1*1L sam$ai %e#ga# 04 L, ", TIME U(ura# 0 b6te,2a(tu %e#ga# &a#g(aua# %ari *0:5H:5H sam$ai %e#ga# 0:5H:5H, 5, EAR U(ura# 1 b6te, Data tau# a#tara 1H1 sam$ai %e#ga# 155,
0, Ti$e %ata u#tu( (ara(ter %a# 'ai#*'ai# No Ti$e Data Ketera#ga# 1, )>AR U(ura# M b6te8 1M55, Data stri#g %e#ga# $a#&a#g 6a#g teta$, )>AR1; 9u(u$ %itu'is %e#ga# )>AR, , @AR)>AR U(ura# .1 b6te %e#ga# .M %a# 1M55, Data stri#g %e#ga# $a#&a#g ber+ariasi terga#tu#g %ata#6a, 0, TINB.
0,
",
5,
3,
membutu(a# %a# mem$u#6ai a( u#tu( me#ga(ses#6a, <'e (are#a itu $er'u %ibuat suatu $rogram $e#ge'o'aa# atau suatu a$'i(asi u#tu( me#ga(ses %ata 6a#g %i(e#a' sebagai DBMS, Data teriso'asi : &i(a %ata tersebar %a'am bebera$a 7i'e %a'am be#tu( 7ormat 6a#g ti%a( sama8 ma(a a(a# me#6u'it(a# %a'am me#u'is $rogram a$'i(asi u#tu( me#gambi' %a# me#6im$a# %ata, <'e (are#a itu %ata %a'am satu %atabase arus %ibuat satu 7ormat sei#gga mu%a %ibuat $rogram a$'ia(si#6a, Masa'a (eama#a# security; : ti%a( setia$ $ema(ai sistem %atabase %i$erbo'e(a# u#tu( me#ga(ses semua %ata8 misa'#6a %ata me#ge#ai ga&i $ega2ai a#6a bo'e %ibu(a o'e bagia# (eua#ga# %a# $erso#a'ia8 se%a#g(a# bagia# gu%a#g ti%a( %i$er(e#a#(a# u#tu( membu(a#6a, Keama#a# %a$at %iatur %a# %isesuai(a# bai( %iti#g(at %tabase atau a$'i(asi#6a, Masa'a i#tegritas integrity; : %atabase berisis 7i'e 6a#g sa'i#g berubu#ga#8 masa'a utama a%a'a bagaima#a (aita# a#tar 7i'e tersebut ter&a%i mes(i %i(etaui ba2a 7i'e A ter(ait %e#ga# 7i'e B8 #amu# se9ara te(#is a%a 7ie'% 6a#g me#gait(a# (e%ua 7i'e tersebut, <'e (are#a itu 7ie'% (u#9i ti%a( %a$at %iabai(a# %a'am membuat suatu %atabase, Mu'ti user : sa'a satu a'asa# %atabase %iba#gu# a%a'a (are#a #a#ti#6a %ata tersebut %igu#a(a# o'e ba#6a( ora#g8 bai( %a'am 2a(tu berbe%a mau$u# bersamaa# sei#gga (ebutua# %atabase 6a#g a#%a' 6a#g me#%u(u#g ba#6a( $ema(ai $er'u %i$ertimba#g(a#,
Me%"n!,()"#! D""<"#e M*S$L U#tu( mema#i$u'asi %atabase M6S-. %a$at me#ggu#a(a# $eri#ta DD. %a# DM. 1, Data Definition Language ?DDL, S-. DD. me#6e%ia(a# $eri#ta*$eri#ta u#tu( me#%e7i#isi(a# s(ema re'asi8 me#ga$us re'asi8 serta memo%i7i(asi s(ema re'asi, Peri#ta DD. amtara 'ai# : )REATE8 A.TER %a# DR
2.
3.
Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, Kn9!r%"#! a, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a# b, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(,
PERTEMUAN 2. A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, 3. Kn9!r%"#! a, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a#, b, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(, PERTEMUAN 3. A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, 3. Kn9!r%"#! a, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam
te#ta#g materi 6a#g %isam$ai(a#, b, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(, PENUNAAN ALAT> BAHAN DAN SUMBER BELAJAR A. Kom$uter u#tu( setia$ $eserta %i%i(, B. S$i%o' 8 $e#ga$us8 $a$a# tu'is, C. A'at $eraga $rese#tasi, D. So7t2are 6a#g %ibutu(a# : XAMPP8 Moi''a =ire7o! atau Goog'e )rome E. Mo%u' te#ta#g M6S-. PENILAIAN A. SOAL 1, Tu'is(a# 'a#ga(a*'a#g(a me#ggu#a(a# uti'it6 M6S-. bobot #i'ai ; , e'as(a# a$a 6a#g %isebut $rimar6 (e6 bobot #i'ai 1; 0, Sebut %a# &e'as(a# mi#ima' 5 ti$e %ata 6a#g %i%u(u#g o'e M6S-. bobot #i'ai 0; ", A$a 6a#g %ima(sut %e#ga# re%u%a#si %a# i#(o#siste#si %ata Q bobot #i'ai ; 5, Sebut(a# $eri#ta*$eri#ta 6a#g ber7u#gsi u#tu( mema#i$u'asi %atabase bobot #i'ai ;
SUMBER BELAJAR A,S8 Rosa %a# M,Sa'au%%i#, 11, Mo%u' Pembe'a&ara# Re(a6asa Pera#g(at .u#a( • Terstru(tur Da# Berorie#tasi P %a# M6S-. %e#ga# • Dream2ea+er MX O38 48 " %a# , og6a(arta : Ga+a Me%ia
Sura(arta8 ,,,,,,,,,, u'i 1 Me#getaui Ke$a'a SMK Negeri 5 Sura(arta
Guru Mata Pe'a&ara# / Kom$ete#si
Dr#. T"(' Her*"n> MM
R!n" ()!"n"> S.K%.
NIP, 1H35"4 1HH0 1 1H
RENCANA PELAKSANAAN PEMBELAJARAN TAHUN PELAJARAN 2012/2013 SEKOLAH MATA PELAJARAN KELAS / SEMESTER ALOKASI WAKTU
: SMK NEGERI 5 SURAKARTA : Membuat Program Basis Data : XII / : 1 ! "5 me#it
STANDAR KOMPETENSI : Membuat $rogram basis %ata KOMPETENSI DASAR : Me#ggu#a(a# store% $ro9e%ures INDIKATOR : 1, Mema#i$u'asi store% $ro9e%ures %ibuat8 mo%i7i(asi %a# a$us; , Membuat $rogrammi#g store% $ro9e%ures TUJUAN PEMBELAJARAN : A. PERTEMUAN 1 1, Sis2a me#getaui a$a 6a#g %ima(su% %e#ga# store% $ro9e%ures , Sis2a me#getaui ma#7aat %ari store% $ro9e%ures
B.
C.
0, Sis2a me#getaui (e'emaa# store% $ro9e%ures PERTEMUAN 2 ", Sis2a me#getaui %a# %a$at membuat si#ta(s $embuata# store% $ro9e%ures 5, Sis2a me#getaui $eri#ta $ema#ggi'a# store% $ro9e%ures 3, Sis2a %a$at me#getaui $e#%e('arasia# +ariabe' $a%a store% $ro9e%ures PERTEMUAN 3 4, Sis2a %a$at me#am$i'(a# store% $ro9e%ures 6a#g tersim$a# %i %atabase , Sis2a %a$at me#ga$us store% $ro9e%ures 6a#g $er#a %ibuat H, Sis2a %a$at membuat $rogrammi#g store% $ro9e%ures
MATERI AJAR : Sre+ Pre+(re# Store% Pro9e%ures a%a'a (o%e*(o%e atau $eri#ta S-. 6a#g %isim$a# %i %a'am (ata'og %atabase, Sebua store% $ro9e%ures %a$at %i$a#ggi' o'e $rogram8 trigger8 mau$u# store% $ro9e%ures 'ai##6a,
Store% $ro9e%ure 6a#g mema#ggi' %iri#6a se#%iri %isebut %e#ga# Re9ursi+e Store% Pro9e%ures, >am$ir semua so7t2are RDBMS mam$u me#&a'a#(a# Re9ursi+e Store% Pro9e%ures, Sre+ Pre+(re# +! M*S$L M6S-. termasu( so7t2are $e#go'a %atabase 6a#g 9u(u$ ter(e#a' %a# ba#6a( %igu#a(a#, Pa%a a2a'#6a M6S-. be'um me#%u(u#g store% $ro9e%ures8 #amu# se&a( +ersi 58 M6S-. su%a me#%u(u#g store% $ro9e%ures, M"n9"" Sre+ Pre+(re# 1, Store% Pro9e%ures %a$at me#i#g(at(a# $er7orma atau (i#er&a $rogram8 (usus#6a 6a#g ber(aita# %e#ga# $e#go'aa# %atabase, , Store% Pro9e%ures %a$at me#gura#gi tra7i( atau 'a'u'i#tas %ata8 (are#a $rogram a#6a 9u(u$ mema#ggi' #ama $ro9e%ures %ari $a%a me#girim(a# $eri#ta S-. 6a#g $a#&a#g, 0, Store% Pro9e%ures %a$at %igu#a(a# (emba'i o'e $rogrammer 'ai# 6a#g i#gi# me#ggu#a(a##6a8 sei#gga $rogrammer tersebut ti%a( $er'u membuat se#%iri (o%e* (o%e $rogram u#tu( me#ga(ses tabe' terte#tu, ", Store% Pro9e%ures memi'i(i ti#g(at (eama#a# 6a#g ti#ggi8 (are#a seora#g a%mi#istrator %atabase %a$at memberi(a# a( a(ses terte#tu (e$a%a seora#g user u#tu( me#ga(ses store% $ro9e%ures i#i, Ke)e%"7"n Sre+ Pre+(re# 1, Store% Pro9e%ures membuat beba# (er&a ser+er me#&a%i ti#ggi8 (usus#6a $a%a Pro9essor %a# memor6, , Store% Pro9e%ures a#6a berisi (o%e S-. 6a#g bersi7at %e('arati78 sei#gga ti%a( %a$at %igu#a(a# u#tu( me#u'is $rose%ur 6a#g membutu(a# 'ogi(a 6a#g (om$'e(s, 0, Store% Pro9e%ures su'it u#tu( %i'a(u(a# $roses %ebuggi#g,
Sete'a me#getaui (e'ebia# %a# (e(ura#ga# Store% Pro9e%ures8 ma(a sebai(#6a %i %a'am me#gemba#g(a# sebua a$'i(asi8 $er'u %i$ertimba#g(a# a$a(a $er'u u#tu( me#ggu#a(a# store% $ro9e%ures atau ti%a(8 a' i#i terga#tu#g %e#ga# ti#g(at (om$'e(sitas a$'i(asi 6a#g a(a# %ibuat, S!n"'# Pe%<(""n Sre+ Pre+(re# =ormat $eri#ta u#tu( membuat Store% Pro9e%ures a%a'a sebagai beri(ut :
DE.IMITER // )REATE PR<)EDURE NamaJPro9e%ureO$arameter18 $arameter8 $arameter #; BEGIN S-. STATEMENTS END // DE.IMITER Atau8 &i(a Store% Pro9e%ures tersebut me#gemba'i(a# #i'ai ba'i( 7ormat#6a a%a'a sebagai beri(ut : DE.IMITER // )REATE =UN)TI
Pe#&e'asa#: 1, Pa%a (o%e %iatas ter%a$at stateme#t DE.IMITER //8 stateme#t i#i bu(a# $eri#ta u#tu( membuat Store% Pro9e%ures8 a(a# teta$i $eri#ta i#i u#tu( me#guba ta#%a a(ir e(se(usi $eri#ta 6a#g a2a'#6a beru$a ta#%a semi*9o'o# titi( (oma; me#&a%i ta#%a %oub'e*s'as, , Pa%a baris (e%ua ter%a$at $eri#ta )REATE PR<)EDURE8 stateme#t i#i %igu#a(a# u#tu( membuat Store% Pro9e%ures, Pa%a 9o#to (o%e %iatas8 GetA''Pro%u9ts; a%a'a #ama Store% Pro9e%ures 6a#g %a$at %i$a#ggi', 0, Se'a#&ut#6a $eri#ta 6a#g ber(aita# %e#ga# $e#go'aa# %atabase %i'eta((a# %i a#tarab'o( BEGIN %a# END, Pa%a 9o#to (o%e %iatas8 ter%a$at $eri#ta S-. SE.E)T =R
Ber(aita# %e#ga# 9o#to %iatas8 u#tu( mema#ggi' Store% Pro9e%ures GetA''Pro%u9ts; %a$at %i'a(u(a# %e#ga# me#geti( $eri#ta : CALL eA))Pr+(#? De#ga# memberi(a# $eri#ta tersebut8 ma(a a(a# %itam$i'(a# se'uru %ata 6a#g ter%a$at %i %a'am tabe' $ro%u9ts, De')"r"#! "r!"
=ormat $eri#ta u#tu( me#%e('arasi(a# +ariab'e %i %a'am store% $ro9e%ures a%a'a : DE).ARE +ariab'eJ#ame%ataJt6$esie; DE=AU.T %e7au'tJ+a'ue Pe#&e'asa# : 1, Stateme#t DE).ARE8 stateme#t i#i u#tu( me#6ata(a# +ariab'e , @ariab'eJ#ame a%a'a #ama +ariab'e 0, DataJt6$e a%a'a ti$e %ata 6a#g %igu#a(a# o'e +ariabe'8 misa'#6a INT u#tu( i#teger8 =.AR u#tu( )ara9ter, ", Sie a%a'a u(ura# atau $a#&a#g %ata, 5, DE=AU.T u#tu( memberi(a# #i'ai %e7au't atau #i'ai a2a' +ariab'e, Cn7&n7 Pen+e')"r"#!"n "r!"
Ma(su% stateme#t %iatas a%a'a me#%e('arasi(a# +ariab'e ber#ama ?ua#tit6 berti$e %ata I#teger %a# memi'i(i 'ebar %ata 0 b6te serta memi'i(i #i'ai a2a' , DECLARE !> @ INT?2 DE6AULT 0
Ma(su% stateme#t %iatas a%a'a me#%e('arasi(a# %ua bua +ariab'e 6aitu i %a# &8 (e%ua#6a berti$e %ata I#teger %e#ga# 'ebar %ata b6te %a# memi'i(i #i'ai a2a' , Me%
U#tu( memberi(a# #i'ai (e%a'am suatu +ariab'e %a$at me#ggu#a(a# $eri#ta SET %a# $eri#ta SE.E)T INT<, Beri(ut i#i 9o#to bagaima#a $e#era$a# $eri#ta SET %a# $eri#ta SE.E)T INT< : DECLARE 'e)!)!ng INT?3 DE6AULT 0 SET 'e)!)!ng 50 Pe#&e'asa# me#ge#ai $eri#ta*$eri#ta %iatas : 1, DE).ARE (e'i'i#g INT0; DE=AU.T 8 ma(su%#6a me#%e('arasi(a# +ariabe' ber#ama (e'i'i#g 6a#g berti$e %ata I#teger %e#ga# 'ebar %ata 0 b6te %a# memi'i(i #i'ai a2a' , , SET (e'i'i#g 8 ma(su%#6a memberi(a# #i'ai (e%a'am +ariabe' (e'i'i#g8 sei#gga #i'ai +ariabe' (e'i'i#g se(ara#g a%a'a 8 bu(a# 'agi, Disam$i#g me#ggu#a(a# $eri#ta SET u#tu( memberi(a# #i'ai +ariabe'8 %a$at &uga %igu#a(a# $eri#ta SE.E)T INT<, Perati(a# 9o#to beri(ut i#i: DECLARE ")=,r+(# INT DE6AULT 0 SELECT COUNT? INTO ")=,r+(# 6ROM ,r+(#
Pe#&e'asa# me#ge#ai $eri#ta*$eri#ta %i atas : 1, DE).ARE tota'J$ro%u9ts INT DE=AU.T 8 ma(su%#6a a%a'a me#%e('arasi(a# +ariabe' ber#ama tota'J$ro%u9ts 6a#g berti$e %ata i#teger %e#ga# #i'ai a2a' , , SE.E)T )
Men"%,!)'"n Sre+ Pre+(re# "ng Ter#!%,"n D! D""<"#e U#tu( me#am$i'(a# semua Store% Pro9e%ures 6a#g tersim$a# %i %atabase8 %a$at %i'a(u(a# %e#ga# memberi(a# $eri#ta : SHOW PROCEDURE STATUS
Se%a#g(a# u#tu( me#am$i'(a# isi suatu Store% Pro9e%ures 6a#g su%a %ibuat $eri#ta#6a a%a'a : SHOW CREATE PROCEDURE N"%"=Sre+=Pre+(re
)o#to: SHOW CREATE PROCEDURE eA))Pr+(# Meng7",(# Sre+ Pre+(re# "ng Pern"7 D!<(" U#tu( me#ga$us suatu Store% Pro9e%ures 6a#g ter%a$at %a'am %atabase atau 6a#g su%a $er#a %ibuat8 $eri#ta#6a a%a'a : DROP PROCEDURE N"%"=Sre+=Pre+(re
)o#to: DROP PROCEDURE eA))Pr+(# Prgr"%%!ng Sre+ Pre+(re# Me%<(" +"n Me%"ngg!) Sre+ Pre+(re# 1, Bu(a )
,
Masu((e 7o'%er %ima#a m6s?',e!e bera%a %e#ga# me#geti( $eri#ta : CD C:AMPPM*S$L
0,
Se'a#&ut#6a masu( (e'i#g(u#ga# M6S-. %e#ga# me#geti( $eri#ta: %*#;) (r , OENTER8 (emu%ia# masu((a# $ass2or% M6S-. A#%a %a# te(a# OENTER,
",
Se'a#&ut#6a &i(a $roses 'ogi# (e M6S-. berasi'8 A#%a a(a# %isa&i(a# 'i#g(u#ga# $e#go'a %ata M6S-.,
5,
Buat
sebua
%atabase
me#geti((a# $eri#ta : CREATE DATABASE +<=)"!7#, ENTER USE +<=)"!7#, ENTER
ber#ama
+<=)"!7#,
%e#ga#
3,
Buat sebua tabe' %e#ga# #ama ,r+(# %e#ga# stru(tur : 6!e)+ N"%e
D"" T*,e
Leng7
$ro%u9tJi%
)ar
0
$ro%u9tJ#ame
)ar
5
$ri9e
Doub'e
Peri#ta#6a a%a'a : CREATE TABLE ,r+(#?,r+(=!+ 7"r?3> ,r+(=n"%e 7"r?F0> ,r!e +(<)e OENTER
4,
Kemu%ia# isi'a tabe' $ro%u9ts tersebut %e#ga# bebera$a baris %ata beri(u ti#i : ,r+(=!+ 1 0 "
,r+(=n"%e Kertas A" Kertas =" S$i%o' XV .emKertas
Pr!e
0 0" 5 15
Peri#ta#6a a%a'a sebagai beri(ut : INSERT INTO ,r+(# ALUES ?G001> GKERTAS A> G30000 OENTER INSERT INTO ,r+(# ALUES ?G002> GKERTAS 6> G3000 OENTER INSERT INTO ,r+(# ALUES ?G003> GSPIDOL > GF000 OENTER INSERT INTO ,r+(# ALUES ?G00> GLEM KERTAS> G1F00 OENTER
,
Agar 'ebi 6a(i#8 9oba tam$i'(a# se'uru %ata 6a#g ter%a$at %i %a'am tabe' $ro%u9ts %e#ga# memberi(a# $eri#ta : SELECT 6ROM ,r+(# OENTER
H,
Se(ara#g saat#6a membuat store% $ro9e%ures 6a#g ber#ama GetA''Pro%u9ts, Peri#ta#6a a%a'a sebagai beri(ut : DELIMITER // CREATE PROCEDURE eA))Pr+(#? BEIN SELECT 6ROM ,r+(# END // DELIMITER
1,
Peri#ta %iatas ma(su%#6a a%a'a membuat Store% Pro9e%ures 6a#g ber#ama GetA''Pro%u9ts %a# out$ut %ari $a%a Store% Pro9e%ures
tersebut a%a'a me#am$i'(a# se'uru %ata 6a#g ter%a$at %i %a'am tabe' ,r+(# , 11,
U#tu( me#&a'a#(a# Store% Pro9e%ures GetA''Pro%u9ts 6a#g te'a %ibuat %iatas8 $eri#ta#6a a%a'a: CALL eA))Pr+(#?OENTER >asi'#6a a%a'a se'uru %ata %i %a'am tabe' ,r+(# a(a# %itam$i'(a#, Perati(a# gambar beri(ut:
Me%<(" +"n Me%"ngg!) Sre+ 6(n!n Masi %i 'i#g(u#ga# M6S-. 6a#g masi a(ti78 $a%a $ra(ti(um (a'i i#i a(a# %i&e'as(a# me#ge#ai 9ara membuat Store% =u#9tio# 6a#g ber#ama GetPro%u9tName8 %i ma#a store% 7u#9tio# i#i a(a# memberi(a# #i'ai ba'i( beru$a #ama $ro%u(, 1, Pa%a &e#%e'a M6S-. 6a#g masi a(ti78 (eti('a $eri#ta beri(ut i#i : DELIMITER // CREATE 6UNCTION ePr+(N"%e?-"rID 7"r?3 RETURNS e BEIN DECLARE -N"%"CHAR?F0 SELECT ,r+(=n"%e INTO -N"%" 6ROM ,r+(# WHERE ,r+(=!+-"rID RETURN -N"%" END // DELIMITER
, U#tu( me#gu&i*9oba Store% =u#9tio# %iatas8 missa'(a# (ita i#gi# me#getaui #ama $ro%u( 6a#g memi'i(i $ro%u9tJi%LL8 $eri#ta#6a a%a'a sebagai beri(ut : SELECT ePr+(N"%e?G002 OENTER
METODE PEMBELAJARAN : A, Pe#&e'asa# / 9erama B, Demo#strasi ), Pra(ti(um D, Ta#6a &a2ab %a# %is(usi E, Prese#tasi tugas KEIATAN PEMBELAJARAN : PERTEMUAN 1 A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$, 0, Guru me#6am$ai(a# tu&ua# $embe'a&ara# &uga $e#&e'asa# a2a' te#ta#g materi 6a#g a(a# %ia&ar(a#, B. KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, 3. Kn9!r%"#! a, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a# b, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(, PERTEMUAN 2. A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI :
1.
2.
3.
E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, Kn9!r%"#! a, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a#, b, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(,
PERTEMUAN 3. A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, 3. Kn9!r%"#! a, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a#, b, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(,
PENUNAAN ALAT> BAHAN DAN SUMBER BELAJAR A. Kom$uter u#tu( setia$ $eserta %i%i(, B. S$i%o' 8 $e#ga$us8 $a$a# tu'is, C. A'at $eraga $rese#tasi, D. So7t2are 6a#g %ibutu(a# : XAMPP8 Moi''a =ire7o! atau Goog'e )rome E. Mo%u' te#ta#g M6S-. PENILAIAN
A.
SOAL 1, A$a 6a#g %ima(su% %e#ga# store% $ro9e%ures Q bobot #i'ai 15; , Sebut(a# " ma#7aat store% $ro9e%ures bobot #i'ai ; 0, Sebut(a# (e'emaa# store% $ro9e%ures bobot #i'ai 15; ", Tu'is(a# si#ta(s $embuata# store% $ro9e%ures bobot #i'ai 0; 5, Tu'is(a# $eri#ta u#tu( me#ga$us store% $ro9e%ures 6a#g $er#a %ibuat bobot #i'ai ;
SUMBER BELAJAR A,S8 Rosa %a# M,Sa'au%%i#, 11, Mo%u' Pembe'a&ara# Re(a6asa Pera#g(at .u#a( • Terstru(tur Da# Berorie#tasi P %a# M6S-. %e#ga# • Dream2ea+er MX O38 48 " %a# , og6a(arta : Ga+a Me%ia
Sura(arta8 ,,,,,,,,,, u'i 1 Me#getaui Ke$a'a SMK Negeri 5 Sura(arta
Dr#. T"(' Her*"n> MM NIP, 1H35"4 1HH0 1 1H
Guru Mata Pe'a&ara# / Kom$ete#si
R!n" ()!"n"> S.K%.
RENCANA PELAKSANAAN PEMBELAJARAN TAHUN PELAJARAN 2012/2013
SEKOLAH MATA PELAJARAN KELAS / SEMESTER ALOKASI WAKTU
: SMK NEGERI 5 SURAKARTA : Membuat Program Basis Data : XII / : 1 ! "5 me#it
STANDAR KOMPETENSI : Membuat $rogram basis %ata KOMPETENSI DASAR : Me#ggu#a(a# triggers INDIKATOR : 1, Membuat %a# me#ge'o'a triggers , Membuat $rogrammi#g triggers TUJUAN PEMBELAJARAN : A. PERTEMUAN 1 1, Sis2a me#getaui a$a 6a#g %ima(su% %e#ga# triggers , Sis2a me#getaui $erbe%aa# triggers %e#ga# store% $ro9e%ures 0, Sis2a me#getaui ma#7aat triggers B. PERTEMUAN 2 ", Sis2a bisa membuat %a# me#ge'o'a triggers C. PERTEMUAN 3 5, Sis2a bisa membuat $rogrammi#g triggers MATERI AJAR : Tr!gger# Trigger &uga termasu( (um$u'a# $eri#ta S-. 6a#g tersim$a# %i (ata'og %atabase, Trigger %a$at %ia(ti7(a# $a%a saat %atabase me#&a'a#(a# $roses INSERT8 UPDATE8 %a# DE.ETE, Per
Pa%a saat (ita membuat sebua trigger %i M6S-.8 ma(a $eri#ta*$eri#ta trigger tersebut tersim$a# (e %a'am 7i'e 6a#g bere(ste#si ,TRG %i %a'am 7o'%er %atabase, =i'e i#i beru$a te(s biasa8 sei#gga (ita %a$at me#ge%it#6a me#ggu#a(a# te(s e%itor a$a$u#,
Pe#era$a# trigger %i M6S-. arus me#gi(uti atura#*atura# sebagai beri(ut: a, Ti%a( %i$erbo'e(a# me'a(u(a# $ema#ggi'a# store% $ro9e%ure, b, Ti%a( %i$erbo'e(a# membuat trigger u#tu( me#am$i'(a# tabe' tem$orer, 9, Ti%a( %i$erbo'e(a# u#tu( me'a(u(a# $roses tra#sa(si $a%a sebua trigger, %, Trigger ti%a( memberi(a# #i'ai ba'i( Retur#; se$erti $a%a store% 7u#9tio#, e, Semua #ama trigger $a%a %atabase arus memi'i(i #ama 6a#g u#i?ue8 ti%a( bo'e a%a #ama trigger 6a#g sama %e#ga# $eri#ta 6a#g berbe%a, Me%<(" D"n Menge))" Prgr"%%!ng Tr!gger# U#tu( membuat trigger8 gu#a(a# 7ormat sebagai beri(ut : ?BE6ORE A6TER =N"%"T"
U#tu( 'ebi &e'as#6a $ra(ti((a# 'a#g(a*'a#g(a beri(ut i#i u#tu( membuat trigger : 1, Bu(a )
, Masu( (e 7o'%er %ima#a m6s?',e!e bera%a %e#ga# me#geti( $eri#ta : CD C:AMPPM*S$L
0, Se'a#&ut#6a masu( (e 'i#g(u#ga# M6S-. %e#ga# me#geti( $eri#ta: %*#;) (r , OENTER8 (emu%ia# masu((a# $ass2or% M6S-. A#%a %a# te(a# OENTER,
", Se'a#&ut#6a &i(a $roses 'ogi# (e M6S-. berasi'8 A#%a a(a# %isa&i(a# 'i#g(u#ga# $e#go'a %ata M6S-.,
5, Buat sebua %atabase ber#ama +<=r!gger %e#ga# me#geti((a# $eri#ta : CREATE DATABASE +<=r!gger ENTER USE +<=r!gger ENTER
3, Se'a#&ut#6a (eti( $eri#ta S-. beri(ut i#i : )REATE TAB.E Wem$'o6eesW Wem$'o6eeNumberW i#t11; N
W'astNameW +ar9ar5; N
4, Kemu%ia# isi'a tabe' em$'o6ees %e#ga# me#geti( $eri#ta S-. beri(ut i#i : INSERT INT< em$'o6ees @A.UES 1L8La6aL8LA%iL8LSta77L8La%i6aoo,9omL8L)BNL8L1L8LSta77L;
, Se(ara#g8 &i(a (ita i#gi# agar $erubaa# %ata 6a#g ter&a%i $a%a tabe' em$'o6ee %a$at %i(etaui8 ma(a (ita %a$at mebuat sebua tabe' 'agi u#tu( me#am$u#g %ata $erubaa# tersebut, Tabe' i#i (ita beri #ama em$'o6eesJau%it8 6a#g ber7u#gsi u#tu( me'a(u(a# $e'a9a(a# atas $erubaa# %ata 6a#g ter&a%i $a%a tabe' em$'o6ee, Keti( $eri#ta S-. beri(ut u#tu( membuat tabe' em$'o6eesJau%it :
CREATE TABLE e%,)*ee#="(+! ? !+ !n?11 NOT NULL AUTO=INCREMENT> e%,)*eeN(%
)"#n"%e -"r7"r?F0 NOT NULL> 7"nge+n +"e!%e DE6AULT NULL> "!n -"r7"r?F0 DE6AULT NULL> PRIMAR KE ?!+ ENTER
H, U#tu( %a$at me'a9a( $erubaa# 6a#g ter&a%i $a%a tabe' em$'o6ee8 (ita %a$at membuat sebua trigger 6a#g a(a# %i&a'a#(a# $a%a saat SEBE.UM (ita me'a(u(a# $erubaa# %ata $a%a tabe' em$'o6ee, Keti( $eri#ta i#i u#tu( membuat trigger : DE.IMITER YY )REATE TRIGGER be7oreJem$'o6eeJu$%ate BE= R< BEGIN INSERT INT< em$'o6eesJau%it SET a9tio# Zu$%ateZ8 em$'o6eeNumber <.D,em$'o6eeNumber8 'ast#ame <.D,'ast#ame8 9a#ge%o# N<; ENDYY DE.IMITER OENTER
1, Se'a#&ut#6a (ita %a$at me'a(u(a# test atas trigger 6a#g su%a (ita buat8 misa'#6a %e#ga# me#guba %ata $a%a 7ie'% 'astName, Keti((a# $eri#ta S-. beri(ut i#i : UPDATE e%,)*ee# SET )"#N"%e GW"'!+! WHERE e%,)*eeN(%
11, Se(ara#g8 (ita %a$at me'iat $erubaa# se9ara otomatis %i tabe' em$'o6eesJau%it %e#ga# me#geti((a# $eri#ta beri(ut i#i : SELECT 6ROM e%,)*ee#="(+!
1, Kesim$u'a##6a : %ata $a%a tabe' em$'o6eesJau%it terisi se9ara otomatis o'e trigger 6a#g (ita buat $a%a saat (ita me'a(u(a# $erubaa# %ata $a%a tabe' em$'o6ees, METODE PEMBELAJARAN : A, Pe#&e'asa# / 9erama B, Demo#strasi ), Pra(ti(um D, Ta#6a &a2ab %a# %is(usi E, Prese#tasi tugas KEIATAN PEMBELAJARAN : PERTEMUAN 1 A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$, 0, Guru me#6am$ai(a# tu&ua# $embe'a&ara# &uga $e#&e'asa# a2a' te#ta#g materi 6a#g a(a# %ia&ar(a#,
B.
KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, 3. Kn9!r%"#! 9, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a# %, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(,
PERTEMUAN 2. A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut, 3. Kn9!r%"#! 9, Guru me#a#6a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 6a#g %isam$ai(a#, %, Guru me#&e'as(a# (emba'i a$a 6a#g be'um %i$aami $eserta %i%i(, PERTEMUAN 3. A. KEIATAN AWAL / PENDAHULUAN : 1, Guru me#6ia$(a# $si(is %a# 7isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oLa sebe'um $embe'a&ara# %imu'ai, , Guru me#gabse# $eserta %i%i( satu $ersatu8 memasti(a# ba2a $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E',)r"#! Peserta %i%i( me#gum$u'(a# i#7ormasi ter(ait materi 6a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#9ari materi 'ai# 6a#g berubu#ga# %e#ga# materi 6a#g %isam$ai(a# 'e2at i#ter#et atau$u# bu(u re7ere#si 6a#g ter(ait, 2. E)"<r"#! Memberi(a# $erta#6aa#*$erta#6aa# (e9i' saat $embe'a&ara# ber'a#gsu#g8 sei#gga $eserta %i%i( 6a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&a2ab $erta6aa# tersebut,