KK-19. Membuat Program Basis Data

RPP RENCANA PELAKSANAAN PEMBELAJARAN

PELAJARAN PRODUKTIF REKAYASA PERANGKAT LUNAK (RPL)

STANDAR KOMPETENSI

Membuat Proram Ba!"! Data KELAS #II

SMK AL A$%AR Sem&u  J' Imam Sa*+" No ,- Sem&u . Ba/u0a/" 1tt&233000!m4a'a51ar!61"7

89:8

RENCANA PELAKSANAAN PEMBELAJARAN SEKOLAH MATA PELAJARAN KELAS / SEMESTER  ALOKASI WAKTU

: SMK AL AZHAR SEMPU : Membuat Program Basis Data : XII / 1 : 10  !" 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-L S-L ., Me#g Me#ggu gu#a #a(a (a# # si# si#ta ta(s (s S-L S-L , Me#& Me#&a' a'a# a#(a (a# # $eri $eri#t #ta a S-L S-L TUJUAN PEMBELAJARAN : A. PERTEMUAN 1 1, Sisa Sisa %a$at %a$at me#geta me#getaui ui arti arti %ari %ari basi basiss %ata %ata ., Sisa Sisa %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 , Sisa Sisa %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-L B. PERTEMUAN 2 !, Sis Sisaa %a$at %a$at me#g me#ggu# gu#a(a a(a# # a'at a'at $emrog $emrogram rama# a# S-L S-L ", Sis Sisaa %a$at %a$at me#g me#gert ertii si#ta si#ta(s* (s*si# si#ta( ta(ss S-L S-L C. PERTEMUAN 3 2, Sis Sisaa %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-L S-L 3, Sis Sisaa %a$at %a$at me#&a me#&a'a# 'a#(a (a# # $eri $eri#ta #ta  S-L S-L 4, Sisa Sisa %a$at %a$at membuat membuat %ata %atabase base se%era# se%era#aa %e#ga# %e#ga# $eri# $eri#ta ta S-L S-L MATERI MATERI AJAR : Pengert!n B!"" D!t! : Sistem basis %ata a%a'a sistem ter(om$uterisasi 5a#g tu&ua# utama#5a a%a'a meme'iara %ata 5a#g su%a %io'a atau i#6ormasi7 %a# membuat i#6ormasi terse%ia saat %ibutu(a#, Pa%a i#ti#5a basis %ata a%a'a me%ia u#tu( me#5im$a# %ata agar %a$at %ia(ses %e#ga# mu%a %a# 8e$at, Pengert!n DBMS : DBMS DBMS 9 Database atau %a'a %a'am m baasa baasa 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 5a#g %igu#a(a# u#tu(  me#5im$a#7 me#ge'o'a7 %a# me#am$i'(a# %ata,

Suatu sistem a$'i(asi %isebut DBMS &i(a meme#ui $ers5arata# mi#ima' sebagai beri(ut : Me#5e%ia(a# 6asi'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 5a#g %i'a(u(a# Mam$u me#a#ga#i ba8(u$ %ata • • • •

Kare#a $e#ti#g#5a %ata bagi suatu orga#isasi/$erusaaa#7 ma(a am$ir sebagia# besar 

RENCANA PELAKSANAAN PEMBELAJARAN SEKOLAH MATA PELAJARAN KELAS / SEMESTER  ALOKASI WAKTU

: SMK AL AZHAR SEMPU : Membuat Program Basis Data : XII / 1 : 10  !" 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-L S-L ., Me#g Me#ggu gu#a #a(a (a# # si# si#ta ta(s (s S-L S-L , Me#& Me#&a' a'a# a#(a (a# # $eri $eri#t #ta a S-L S-L TUJUAN PEMBELAJARAN : A. PERTEMUAN 1 1, Sisa Sisa %a$at %a$at me#geta me#getaui ui arti arti %ari %ari basi basiss %ata %ata ., Sisa Sisa %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 , Sisa Sisa %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-L B. PERTEMUAN 2 !, Sis Sisaa %a$at %a$at me#g me#ggu# gu#a(a a(a# # a'at a'at $emrog $emrogram rama# a# S-L S-L ", Sis Sisaa %a$at %a$at me#g me#gert ertii si#ta si#ta(s* (s*si# si#ta( ta(ss S-L S-L C. PERTEMUAN 3 2, Sis Sisaa %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-L S-L 3, Sis Sisaa %a$at %a$at me#&a me#&a'a# 'a#(a (a# # $eri $eri#ta #ta  S-L S-L 4, Sisa Sisa %a$at %a$at membuat membuat %ata %atabase base se%era# se%era#aa %e#ga# %e#ga# $eri# $eri#ta ta S-L S-L MATERI MATERI AJAR : Pengert!n B!"" D!t! : Sistem basis %ata a%a'a sistem ter(om$uterisasi 5a#g tu&ua# utama#5a a%a'a meme'iara %ata 5a#g su%a %io'a atau i#6ormasi7 %a# membuat i#6ormasi terse%ia saat %ibutu(a#, Pa%a i#ti#5a basis %ata a%a'a me%ia u#tu( me#5im$a# %ata agar %a$at %ia(ses %e#ga# mu%a %a# 8e$at, Pengert!n DBMS : DBMS DBMS 9 Database atau %a'a %a'am m baasa baasa 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 5a#g %igu#a(a# u#tu(  me#5im$a#7 me#ge'o'a7 %a# me#am$i'(a# %ata,

Suatu sistem a$'i(asi %isebut DBMS &i(a meme#ui $ers5arata# mi#ima' sebagai beri(ut : Me#5e%ia(a# 6asi'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 5a#g %i'a(u(a# Mam$u me#a#ga#i ba8(u$ %ata • • • •

Kare#a $e#ti#g#5a %ata bagi suatu orga#isasi/$erusaaa#7 ma(a am$ir sebagia# besar 

 $erusaaa# mema#6aat(a# DBMS %a'am me#ge'o'a %ata 5a#g mere(a mi'i(i, Pe#ge'o'aa# DBMS se#%iri biasa#5a %ita#ga#i o'e te#aga a'i 5a#g s$esia'is me#a#ga#i DBMS 5a#g %isebut sebagai DBA 9 Database ,  Database Administrator , Beri(ut i#i a%a'a ! ma8am DBMS +ersi (omersia' 5a#g $a'i#g ba#5a( %igu#a(a# %i %u#ia saat i#i7 5aitu : ;ra8'e Mi8roso6t S-L Ser+er  IBM DB. Mi8roso6t A88ess • • • •

Se%a#g(a# DBMS +ersi o$e# sour8e 5a#g 8u(u$ ber(emba#g %a# $a'i#g ba#5a( %igu#a(a# saat i#i a%a'a sebagai beri(ut : M5S-L PostgreS-L
Pengert!n S#L : S-L 9Structured Query Language  a%a'a baasa baasa 5a#g 5a#g %igu#a(a# u#tu( u#tu( me#ge'o'a me#ge'o'a %ata %ata  $a%a RDBMS 9 Relational  Relational Database Management System ,

M5S-L 9 My Structured Query Language atau atau 5a#g 5a#g bias biasaa %iba %iba8a 8a $!%"e%&'e(  a%a'a sebua $rogram $embuat %a# $e#ge'o'a %atabase atau 5a#g seri#g %isebut %e#ga# DBMS 9 Database si6at %ari DBMS DBMS i#i a%a'a a%a'a ;$e# ;$e# Sour Sour8e 8e 5a#g 5a#g bisa bisa  Database Management System 7 si6at %i%a$at(a# se8ara gratis $a%a a'amat tt$://,m5s=',8om, Se'ai# itu M5S-L &uga meru$a(a# $rogram $e#ga(ses %atabase 5a#g bersi6at &ari#ga#7 sei#gga %a$at %igu#a(a# u#tu( a$'i(asi M'(t 9Ba#5a( Pe#ggu#a, Pe#ggu#a, Ke'ebia# Ke'ebia# 'ai# M'(t U"er 9Ba#5a( %ari M5S-L a%a'a me#ggu#a(a# baasa =uer5 9$ermi#taa# sta#%ar S-L 9Structured  Query Language , S-L a%a'a suatu baasa $ermi#taa# 5a#g terstru(tur7 S-L te'a %i sta#%ar(a# u#tu( semua $rogram $e#ga(ses %atabase se$erti ;ra8'e7 PosgreS-L7 S-L Ser+er %a# 'ai#*'ai#, Sebagai sebua $rogram $e#gasi' %atabase7 M5S-L ti%a( mu#g(i# ber&a'a# se#%iri ta#$a a%a#5a a%a#5a sebua sebua a$'i(as a$'i(asii $e#ggu#a $e#ggu#a 9i#ter6 9i#ter6a8e a8e 5a#g 5a#g bergu#a bergu#a sebagai sebagai $rogram $rogram a$'i(asi a$'i(asi  $e#ga(ses %atabase 5a#g %iasi'(a#, M5S-L %a$at %i%u(u#g o'e am$ir  am$ir semua s emua $rogram $r ogram a$'i(asi bai( 5a#g ;$e# Sour8e se$erti PHP mau$u# 5a#g ti%a( ;$e# Sour8e 5a#g a%a  $a%a $'at6orm i#%os se$erti se$e rti >isua' >isua' Basi87 De'$i %a# 'ai##5a, Program*Program a$'i(asi 5a#g me#%u(u#g M5S-L : PHP 9Page Hi$ertet Pre$rosesor Bor'a#% De'$i7 Bor'a#% )?? Bui'%er  >isua' Basi8 ",0/2,0 %a# ,@et >isua' >isua'
M)S#L ter$!"'& &e *!(!$ !r"te&t'r !+(&!" C(ent%Ser,er A$'i(asi C(ent%Ser,er 9sesuai #ama#5a memi'i(i %ua a$'i(asi 5aitu : meru$a(a# # $rogram $rogram 5a#g biasa#5 biasa#5aa ber&a'a ber&a'a# # sebagai sebagai background process • Ser,er : meru$a(a atau $roses %ibe'a(a#g 'a5ar sistem o$erasi, User biasa#5a ti%a( %a$at berubu#ga# berubu#ga# %e#ga# ser+er se8ara 'a#gsu#g7 teta$i arus me'a'ui a$'i(asi -(ent, meru$a(a# a$'i(asi a$'i(asi / $rogram 5a#g memi'i(i memi'i(i user interface 9a#tar mu(a • C(ent : meru$a(a# se$e se$ert rtii term termi# i#a' a' / 8omm 8omma# a#% % $rom $rom$t $t77 tomb tombo' o'77 (ota (ota( ( te(s te(s77 me#u me#u too' too'ba barr %a# %a# sebagai#5a, a%i a$'i(asi C(ent%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##5a 9ti%a( %a$at ber%iri se#%iri, Mengg'n!&!n !(!t +e$rgr!$!n S#L U#tu( me#ge'o'a %atabase M5S-L me#ggu#a(a# : Prom$t D;S 9too' 8omma#% 'i#e • Program Uti'it5 9PHP 9 PHP M5A%mi# •

U#tu( me'a(u(a# a(ses (e %atabase me#ggu#a(a# : Ko#e(si (e %atabase -uer5 / $ermi#taa# %ata Pemutusa# (o#e(si • • •

In"t!((!" M)S#L U#tu( bisa be(er&a %e#ga# so6tare M5S-L7 te#tu#5a so6tare tersebut arus teri#sta'' ter' ter'ebi ebi  %au' %au'u u %i (om (om$ut $uter er (ita, (ita, U#tu( U#tu( me#%a me#%a$at $at(a# (a# so6t so6tar aree terse tersebut but (ita (ita %a$at %a$at %o#'oa% %ari ebsite resmi M5S-L 5aitu tt$://,m5s=',8om, Di ebsite tersebut a%a  bebera$a so6tare M5S-L %ari 5a#g ter'ama sam$ai 5a#g terbaru, Da'am Da'am mo% mo%u' u' i#i (ita (ita a(a# me#ggu# me#ggu#a(a# a(a# M5S-L M5S-L +ersi +ersi m5 m5s='*e s='*esse sse#tia #tia'*", '*",0,.! 0,.!*i *i#., #., Sete'a a#%a %o#'oa%7 se'a#&ut#5a i(uti i#stru(si 5a#g a%a (eti(a i#sta''asi,

U#tu( me#getaui baa M5S-L i#i su%a be(er&a %e#ga# bai( bu(a )omma#% )omma#% $rom$t, $rom$t, K'i( Start  Ru# C (eti( 8m%  ;K, (emu%ia# 'a(u(a# 'a#g(a beri(ut i#i :

i(a te'a #am$a( si#ta( : mysql> ma(a (ita te'a masu( (e%a'a# s5stem %atabase M5S-L tersebut,

C!r! In"t!((!" 0AMPP XAMPP meru$a(a# sebua $a(et i#sta'asi i#sta'as i u#tu( u#tu ( PHP7 APA)HE APA)HE %a# M5S-L, De#ga# me#ggu#a(a# XAMPP7 (ita ti%a( $er'u 'agi re$ot me#gi#sta'' (etiga so6tare itu se8ara ter$isa, XAMPP %a$at %i %o#'oa% %i tt$://,a$a8e6rie#%s,org/e#/i#%e,tm', Beri(ut i#i a%a'a 8ara me#gi#sta'' XAMPP, 1, a'a a'a#( #(a# a# 6i'e 6i'e !$++%n32%1..4%n"t!((er.ee  9atau +ersi 'ai# ., Kemu%ia# Kemu%ia# a(a# tam$i' tam$i' $i'ia# $i'ia# u#tu( u#tu( memi'i memi'i baasa baasa (eti(a $roses i#sta'asi i#sta'asi ber&a'a#, ber&a'a#,

, Proses Proses i#sta'' i#sta''asi asi a(a# %imu'ai %imu'ai,, K'i( K'i( Net u#tu( memu'ai#5a,

!, Memi'i Memi'i 'o(asi 'o(asi u#tu( u#tu( $e#gi#sta' $e#gi#sta''a# 'a# XAMPP XAMPP77 (emu%ia# (emu%ia# ('i( ('i( Net u#tu( me'a#&ut(a#,

", Pa%a tam$i'a# XAMPP o$tio#s7 $i'i 8e#ta#g semua#5a %a# ('i( In"t!((,

2, Fu#ggu bebera$a saat i#gga $roses i#sta''asi se'esai, 3, I#sta''asi se'esai, K'i( 5n"6,

4, Sam$ai taa$ i#i7 berarti (ita su%a me#gi#sta' 0AMPP, Itu berarti (ita su%a se'esai me#gi#sta'' PHP7 APA)HE %a# MGS-L, La#g(a se'a#&ut#5a a%a'a me#&a'a#(a# ser+i8e#5a, , a'a#(a# 0AMPP Cntr( P!ne(  5a#g a%a %i *e"&t+ , Atau a#%a &uga %a$at me#&a'a#(a# 0AMPP Cntr( P!ne(  %ari me#u St!rt %7 A(( Prgr!$" %7 !+!-6e8ren*" %7 !$++ %7 !$++ -ntr( +!ne( ,

10, @5a'a(a# A$a8e %a# M5s=' %e#ga# me#g('i( tombo' Start, Bu(a eb broser a#%a7 'a'u (eti((a# tt$://'o8a'ost, i(a tam$i'a##5a se$erti %i baa i#i7 ma(a a$a8e su%a teri#sta'' %e#ga# be#ar,

M!"'& Ke%Ser,er M)S#L Sebagai %asar me#ggu#a(a# %atabase M5S-L a(a# %ibaas 8ara me#ga(ses %a# me#ggu#a(a# %atabase M5S-L, A%a bebera$a 8ara %ia#tara#5a 5aitu : 1, Memaami
., Me#ggu#a(a# User Famu Pa%a $ertama (a'i m5s=' %ii#sta''7 ser+er te'a me#5e%ia(a# user %e#ga# ta#$a a%a +eri6i(asi a$a$u#, Arti#5a7 (ita %a$at me'a(u(a# 'ogi# %e#ga# ti%a( me#ggu#a(a# user#ame %a# $assor% a$a$u#, Kita %a$at masu( $a%a $rom$t M5S-L %e#ga# 8ara masu( $a%a 6o'%er bi#7 %a# (emu%ia# %a$at me#&a'a#(a# M5S-L K'ie# 5a#g te'a %ise%ia(a# ber#ama $)"(.ee, Perati(a# 8ara beri(ut a$abi'a %i'a(u(a# %ari (om$uter i#%os, 1, Membu(a &e#%e'a MS DOS  atau C$$!n* Pr$+t me'a'ui me#u R'n %e#ga# 8ara me#u'is(a# $eri#ta -$* a$abi'a me#ggu#a(a# i#%os XP7 %a# me#u'is(a# $eri#ta -$$!n* $a%a i# ,

., Sete'a masu( $a%a &e#%e'a )MD atau MS D;S7 tu'is $eri#ta D;S se$erti  beri(ut CD9 (emu%ia# enter7 a(a# mu#8u' se$erti %ibaa i#i :

, Sete'a itu tu'is(a# $eri#ta CD 0AMPP (emu%ia# te(a# enter7 a(a# mu#8u' se$erti %ibaa i#i :

!, La#g(a se'a#&ut#5a tu'is $eri#ta CD $)"( (emu%ia# te(a# enter7 a(a# mu#8u' se$erti tam$i'a# %ibaa i#i :

", Kemu%ia# tu'is(a# (emba'i $eri#ta CD ;n (emu%ia# te(a# enter7 a(a# mu#8u' tam$i'a# sebagai beri(ut :

2, Sete'a masu( $a%a sub 6o'%er C:90AMPP9$)"(9;n7 se(ara#g (ita %a$at me#&a'a#(a# ('ie# M5S-L 5a#g ber#ama $)"(.ee, )ara#5a a%a'a %e#ga# me#u'is(a# $eri#ta $)"(7 (emu%ia# te(a# tombo' Enter, Beri(ut 8o#to#5a:

3, A$abi'a te'a me#%a$at $rom$t %e#ga# #ama m5s='7 berarti %atabase M5S-L te'a sia$ me#erima $eri#ta (ita, Me$;'!t *!n Meng!&t8&!n D!t!;!"e Sebe'um membuat tabe' %a# (o'om7 (ita arus mem$ersia$(a# %atabase#5a ter'ebi %au'u, M5S-L memi'i(i $eri#ta 5a#g %a$at %igu#a(a# u#tu( membuat %atabase baru7 5aitu CREATE DATABASE, Beri(ut i#i 8o#to#5a :

Pa%a $eri#ta %iatas7 $er#5ataa# -uer5 ;K7 1 ro a66e8te% 90,"3 se8 me#a#%a(a#  $eri#ta 5a#g %itu'is(a# ber&a'a# %e#ga# bai(7 sei#gga se(ara#g te'a berasi' memi'i(i %atabase baru ber#ama *!t!<"e&(!6*; , Kita %a$at membu(ti(a##5a %e#ga# me#ggu#a(a# $eri#ta SHOW DATABASES, U#tu( be(er&a $a%a %atabase *!t!<"e&(!6*;7 arus me#ga(ti6(a# 9masu( $a%a %atabase 5a#g bersa#g(uta# ter'ebi %au'u, Peri#ta 5a#g %igu#a(a# u#tu( me#ga(ti6(a# %atabase a%a'a USE, Beri(ut i#i 8o#to#5a :

Sete'a me#%a$at(a# $esa# Database 8a#ge%7 berarti se(ara#g te'a bera%a %i %a'am %atabase ber#ama *!t!<"e&!(6*; , Se(ara#g a$abi'a (ita me#geti((a# sebua $eri#ta7 ma(a se8ara otomatis e6e(#5a a(a# %itu&u(a# $a%a %atabase a(ti6, Me'iat Da6tar Fabe' : A$abi'a a(a# me'iat i#6ormasi me#ge#ai (ebera%aa# tabe' $a%a suatu %atabase7 %a$at me#ggu#a(a# $eri#ta SHOW TABLES, Beri(ut i#i 8o#to#5a :

B!6!"! S#L $e$(& ;e;er!+! ;!g!n +entng= )!t' : 1,  Data Definition Language >DDL, S-L DDL me#5e%ia(a# $eri#ta*$eri#ta u#tu(  me#%e6i#isi(a# s(ema re'asi7 me#ga$us re'asi7 serta memo%i6i(asi s(ema re'asi, .,  Data Manipulation Language  >DML, S-L DML me#8a(u$ baasa S-L u#tu(  me#5isi$(a# re(ama# $a%a re'asi7 me#ga$us re(ama# $a%a re'asi7 serta memo%i6i(asi re(ama# $a%a re'asi, , View Definition, S-L memuat $eri#ta*$eri#ta u#tu( me#%i6i#isi(a# tam$i'a#* tam$i'a# 9view 5a#g %i(ee#%a(i $e#ggu#a, !, Transaction Control , S-L memuat $eri#ta*$eri#ta u#tu( me#s$esi6i(asi aa' %a# a(ir tra#sa(si, ",  Embedded SQL  %a#  Dynamic SQL, Fermi#o'ogi i#i me#8a(u$ (emam$ua# S-L u#tu( %isisi$(a# $a%a bebera$a baasa $emrograma#7 misa'#5a $a%a >isua' Basi87

De'$i7 )??7 a+a %a# sebagai#5a, 2,  Integrity, S-L DDL me#8a(u$ $eri#ta*$eri#ta u#tu( me#s$esi6i(asi batasa#*  batasa# i#tegritas, 3,  Autori!ation, S-L DDL me#8a(u$ $eri#ta*$eri#ta u#tu( membatasi a(ses $a%a  basis %ata %emi a'asa# (eama#a#, Be&er?! *eng!n +ernt!6 DDL > Data Definition Language 1, Me#ggu#a(a# Peri#ta )REAFE Peri#ta CREATE meru$a(a# bagia# %ari $eri#ta DDL 9 Data Definition  Language 5a#g %igu#a(a# u#tu( memba#gu# atau me#%esai# stru(tur tabe' baru, U#tu( membuat tabe'7 si#ta( 5a#g %igu#a(a# a%a'a : CREATE TABLE n!$!K($(e;!r= K($<; T@PE >(e;!r= ............. ........... .............. K($(e;!r 

De#ga# me#ggu#a(a# si#ta(s %i atas7 (ita %a$at me#gim$'eme#tasi(a# $ere#8a#aa# tabe' ber#ama g'r'7 tabe' i#i (ita buat $a%a %atabase %ataJse(o'a%b 5a#g te'a (ita  buat sebe'um#5a, U#tu( mem$ermu%a $emaama#7 stru(tur %ari tabe' g'r' a%a'a: Ko'om  @i$  @ama Ke'ami# Agama A'amat Kea'ia#

Fi$e )HAR >AR)HAR E@UM >AR)HAR >AR)HAR >AR)HAR

Lebar " "

Ketera#ga#

9P7 1" 20 100

Dari stru(tur %esai# tabe' g'r' %i atas7 a$abi'a %iim$'eme#tasi(a# %e#ga# $eri#ta CREATE7 ma(a $eri#ta 'e#g(a$#5a a%a'a :

Pa%a $eri#ta %i atas7 $er#5ataa# NOT NULL  me#a#%a(a# baa (o'om 5a#g %ima(su% arus %iisi %e#ga# %ata7 atau berarti setia$ a%a re8or% baru (o'om tersebut ti%a( bo'e %ibiar(a# (oso#g, Sete'a tabe' tersebut terbuat (ita %a$at me'iat

ra#8a#ga# tabe' tersebut %e#ga# 8ara me#%is(ri$si(a##5a (emba'i, Peri#ta 5a#g %igu#a(a# a%a'a DESC atau DESCRIBE, Beri(ut i#i 8o#to#5a :

., Me#ggu#a(a# Peri#ta ALFER  Semua be#tu( tabe' 5a#g $er#a %ibuat bu(a# meru$a(a# tabe' a(ir 5a#g mati 9ti%a( %a$at %iuba7 a(a# teta$i (ita masi %a$at mema#i$u'asi be#tu( tabe' 5a#g te'a a%a me#&a%i be#tu( 'ai#, ALTER   meru$a(a# $eri#ta DDL 5a#g %igu#a(a# u#tu( me'a(u(a# $erubaa# %esai# tabe' me#&a%i tabe' %e#ga# stru(tur baru, Sebagai 8o#to7 $a%a tabe' g'r' 5a#g te'a %ibuat memi'i(i (o'om ber#ama &e!6(!n7 (ita a(a# meruba#5a me#&a%i (o'om ('('"!n, Beri(ut i#i 8o#to#5a :

Dari $eri#ta %i atas7 ma(a %iasi'(a# tam$i'a##5a sebagai beri(ut :

A$abi'a e#%a( me#amba(a# (o'om baru7 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#5a7 %a$at me#ggu#a(a# o$tio# A5TER , Sebagai 8o#to7 a$abi'a e#%a( me#amba(a# (o'om %e#ga# #ama &e!6(!n $a%a tabe' g'r'7 ti$e %ata#5a a%a'a >AR)HAR91007 (o'om baru i#i a(a# %i'eta((a# sete'a (o'om !(!$!t, Sei#gga  $eri#ta#5a a%a'a :

, Me#ggu#a(a# Peri#ta DR;P A$abi'a a(a# me#ga$us (o'om 'ama 5a#g su%a ti%a( %igu#a(a# 'agi7 ma(a  $eri#ta 5a#g %a$at %igu#a(a# a%a'a DROP n!$! &($7, Sebagai 'atia#7 me#8oba u#tu( me#ga$us (o'om !g!$! $a%a tabe' g'r', Beri(ut $eri#ta#5a :

Dari Peri#ta %iatas7 $erati(a# $erubaa##5a se$erti $a%a tam$i'a# beri(ut :

De#ga# me#ggu#a(a# DROP &uga %a$at me#ga$us tabe' 5a#g a%a %i %a'am %atabase a(ti6, Fe(#i( $e#ggu#aa##5a a%a'a %e#ga# me#u'is(a# $eri#ta DROP n!$!t!;e(7, A$abi'a a(a# me#ga$us tebe' %e#ga# #ama g'r'7 ma(a $eri#ta#5a a%a'a :

Be&er?! *eng!n +ernt!6 DML > Data Manipulation Language 1, Persia$a# Database %a# Fabe' Sebagai 'atia#7 (ita a(a# me#ggu#a(a# %atabase 5a#g bergu#a u#tu( me#ge'o'a %ata se(o'a ti#ggi, Re'asio#a' tabe' 5a#g a(a# %igu#a(a# a%a'a se$erti gambar   beri(ut :

Pa%a 'atia# i#i %atabase 5a#g %igu#a(a# a%a'a *!t!<&!$+'"*;7 u#tu( itu sebe'um#5a (ita arus membuat %atabase tersebut, Pa%a ra#8a#ga# %atabase %iatas7 tabe'  ?en"&!$+'" %igu#a(a# u#tu( mere(am %ata*%ata (am$us ber%asar(a#  &e#is#5a, Fabe' i#i a(a# memi'i(i ubu#ga# satu (eba#5a( 9one to many  %e#ga# tabe' *!t!&!$+'" , Beri(ut a%a'a $eri#ta u#tu( membuat %atabase *!t!<&!$+'"*; 7 tabe' *!t!&!$+'"  %a# tabe' ?en"&!$+'" $a%a ser+er M5S-L :

CREATE DATABASE *!t!<&!$+'"*; USE *!t!<&!$+'"*; CREATE TABLE ?en"&!$+'" > &*3 NOT NULL= n$ NOT NULL= PRIMAR@ KE@ >&*
Se'a#&ut#5a (ita %a$at membuat tabe' (e%ua 5a#g ber#ama *!t!&!$+'", Fabe' i#i a(a# %igu#a(a# u#tu( mere(am %ata*%ata (am$us se8ara %etai', Di %a'am tabe' i#i ter%a$at (u#8i tamu 5a#g berasa' %ari tabe' ?en"&!$+'", Kita %a$at membuat tabe' i#i %e#ga# me#geti((a# $eri#ta %ibaa i#i : CREATE TABLE *!t!&!$+'" > &*<&!$+'" CHAR> NOT NULL= &*3 NOT NULL= n$<&!$+'" ARCHAR>3F NOT NULL= t6n<;er*r ARCHAR> NOT NULL=  ?'$<8!&'(t!" INT>2 NOT NULL= *$"( ARCHAR>3F NOT NULL= "t!t'" ENUM>GNEERI=SWASTA NOT NULL= PRIMAR@ KE@ >&*<&!$+'" 

., Me#ggu#a(a# Peri#ta I@SERF 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' 5a#g masi (oso#g atau$u# tabe' 5a#g te'a berisi, Beri(ut a%a'a si#ta( %asar  u#tu( memasu((a# %ata : INSERT INTO n!$!t!;e( >&($!= &($;= ....= &($n ALUES >G"<&($!="<&($;=....="<&($n

De#ga# me#ggu#a(a# si#ta(s %iatas7 ma(a (ita %a$at memasu((a# %ata baru (e %a'am tabe' ?en"&!$+'" %e#ga# 8ara sebagai beri(ut :

Pa%a 8ara %iatas (ita a#5a memasu((a# %ata u#tu( satu re8or% 9satu baris sa&a7 sebe#ar#5a u#tu( me#gemat a(tu (ita %a$at memasu((a# bebera$a baris %ata se8ara bersamaa#, Beri(ut i#i 8o#to5a :

Se'a#&ut#5a memasu((a# %ata*%ata (am$us (e%a'am tabe' *!t!&!$+'"  %e#ga# me#&a'a#(a# $eri#ta se$erti sebe'um#5a, , Me#ggu#a(a# Peri#taSELE)F Peri#ta SELECT  %igu#a(a# u#tu( me#5e'e(si atau memi'i atau me#am$i'(a# sebagia# atau semua %ata 5a#g a%a %i %a'am sebua (o'om, Da'am %atabase re'asio#a'7 $eri#ta i#i %igu#a(a# u#tu( me#gambi' %ata %ari bebera$a tabe' 5a#g  bere'asi, De#ga# me#ggu#a(a# 8ara biasa7 $eri#ta SELE)F %a$at %igu#a(a# u#tu(  me#am$i'(a# semua %ata 9(o'om %a# baris %ari sebua tabe', Parameter 5a#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#5a : SELECT  5ROM n!$!t!;e(

De#ga# me#ggu#a(a# si#ta(s %iatas7 (ita %a$at me#8oba#5a u#tu( me#am$i'(a# semua %ata %ari tabe' ?en"&!$+'", Beri(ut i#i 8o#to asi'#5a :

Se'ai# me#ggu#a(a# ta#%a bi#ta#g7 (ita &uga %a$at 'a#gsu#g memba8a %ire(tori 5a#g %ata#5a a(a# %itam$i'(a#, Beri(ut 8o#to $e#ggambara# si#ta(s#5a : SELECT &($!= &($;= &($n 5ROM n!$!te;e(

Sebagai 8o#to7 (ita %a$at me#&a'a#(a# $eri#ta beri(ut :

!, Me#ggu#a(a# Peri#ta UPDAFE Peri#ta UPDATE7 sesuai %e#ga# #ama#5a $eri#ta i#i %igu#a(a# u#tu( me#g* update  atau mem$erbarui %ata 'ama me#&a%i %ata ter(i#i 9terbaru, Beri(ut 8ara  $e#ggu#aa# si#ta(s#5a : UPDATE n!$!t!;e( SET &($!*!t!;!r'= &($;*!t!;!r'= ....= &($n*!t!;!r' WHERE &($&'n-&*e;!r"

Pa%a si#ta(s %i atas7 $er#5ataa# WHERE %e#ga# satu (o#%isi berarti %ata 5a#g a(a# %i$erbarui a#5a satu baris, Sebagai 'atia#7 (ita a(a# me#guba %ata  ?en"&!$+'"  %ari  oliteknik  me#&a%i  "olite#ni# $"%LTE&'7 ma(a $eri#ta 5a#g %igu#a(a# a%a'a :

Pa%a $eri#ta %i atas7 $er#5ataa# WHERE &*
", Me#ggu#a(a# Peri#ta DELEFE Peri#ta DELETE %igu#a(a# u#tu( me#gi'a#g(a# atau me#ga$us sebagia# atau semua %ata 5a#g a%a %i %a'am tabe', Se$erti a'#5a %e#ga# $eri#ta UPDAFE7 u#tu( me#ggu#a(a# $eri#ta DELEFE &uga %i$er'u(a# (o#%isi %e#ga# ('ausa HERE u#tu( me#u#&u( baris ma#a 5a#g a(a# %ii'a#g(a#, Si#ta(s %asar $eri#ta DELEFE %a$at %i'iat %ibaa i#i : DELETE 5ROM n!$!t!;e( WHERE &($&'n-&'n-

De#ga# me#ggu#a(a# si#ta(s %i atas7 ma(a (ita %a$at me#ggu#a(a##5a u#tu(  me#gaa$us sa'a satu baris %ata 5a#g a%a %i %a'am tabe' ?en"&!$+'", Misa'#5a (ita a(a# me#ga$us %ata $a%a baris (e*"7 5aitu (o%e#5a 9JF7 ma(a $eri#ta#5a a%a'a sebagai beri(ut :

De#ga# me#ggu#a(a# $eri#ta %iatas7 ma(a $erubaa# %ata#5a %a$at %i'iat sebagai beri(ut :

METODE PEMBELAJARAN : A, Pe#&e'asa# / 8erama B, Demo#strasi ), Pra(ti(um D, Fa#5a &aab %a# %is(usi E, Prese#tasi tugas KEIATAN PEMBELAJARAN : PERTEMUAN 1 A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru mem$er(e#a'(a# %iri %a# (e#a'a# %e#ga# $esertaa %i%i( %e#ga# me#gabse# satu $er satu, , Nuru me#5am$ai(a# tu&ua# $embe'a&ara# &uga $e#&e'asa# aa' te#ta#g materi 5a#g a(a# %ia&ar(a#, B. KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, 3. Kn8r$!" a, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a#  b, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(, PERTEMUAN 2. A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$,

B.

KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, 3. Kn8r$!" a, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a#,  b, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(,

PERTEMUAN 3. A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, 3. Kn8r$!" a, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a#,  b, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(, PENUNAAN ALAT= BAHAN DAN SUMBER BELAJAR  A. Kom$uter u#tu( setia$ $eserta %i%i(, B. S$i%o' 7 $e#ga$us7 $a$a# tu'is, C. A'at $eraga $rese#tasi, D. So6tare 5a#g %ibutu(a# : XAMPP7 MoOi''a
A.

SOAL 1, A$a (e$a#&a#ga# S-L %a# &e'as(a# se8ara si#g(at te#ta#g S-L  9bobot #i'ai 10 ., Sebut(a# " 8o#to DBMS  9bobot #i'ai ." , A$a 6u#gsi %ari Data De6i#itio# La#guage 9DDL %a# Data Ma#i$u'atio# La#guage 9DML  9bobot #i'ai ." !, A$a 6u#gsi %ari $eri#ta i#sert $a%a si#ta(s m5s='  9 bobot #i'ai 1" ", Fu'is(a# si#ta(s m5s=' u#tu( membuat satu tabe' guru 5a#g tersusu# atas 6ie'% #i$7 #ama7 (e'ami# %a# a'amat  9bobot #i'ai ."

SUMBER BELAJAR A,S7 Rosa %a# M,Sa'au%%i#, .011, Mo%u' Pembe'a&ara# Re(a5asa Pera#g(at Lu#a(  • 9Ferstru(tur Da# Berorie#tasi ;b&e(, Ba#%u#g : Mo%u'a  @ugroo7 A%i, .011, Pera#8a#ga# %a# Im$'eme#tasi Sistem Basis Data, Gog5a(arta : • A#%i  @ugroo7 Bu#a6it, .00, Latia# Membuat A$'i(asi eb PHP %a# M5S-L %e#ga# • Dreamea+er MX 27 37 .00!Q %a# 4, Gog5a(arta : Na+a Me%ia

Ba#5ua#gi7 12 u'i .01. Me#getaui Ke$a'a SMK AL AZHAR Sem$u

Nuru Mata Pe'a&ara#

ASNAN= S.P*.

SUEN HARI WIBOWO= S.K$.

RENCANA PELAKSANAAN PEMBELAJARAN SEKOLAH MATA PELAJARAN KELAS / SEMESTER  ALOKASI WAKTU

: SMK AL AZHAR SEMPU : Membuat Program Basis Data : XII / 1 : 1.  !" me#it

STANDAR KOMPETENSI : Membuat $rogram basis %ata KOMPETENSI DASAR : Me#ggu#a(a# S-L INDIKATOR : 1, Me#&a'a#(a# uti'it5 M5S-L ., Membuat %atabase %e#ga# (ete#tua# (usus , Me#e#tu(a# Stru(tur tabe' !, Mema#i$u'asi %atabase TUJUAN PEMBELAJARAN : A. PERTEMUAN 1 1, Sisa %a$at me#&a'a(a# %a# me#ggu#a(a uti'it5 M5S-L ., Sisa %a$at mera#8a#g %atabase 5a#g bai(  B. PERTEMUAN 2 , Sisa %a$at me#getaui ti$e*ti$e %ata 5a#g %i%u(u#g o'e M5S-L !, Sisa %a$at membuat %atabase %e#ga# (ete#tua# (usus ", Sisa %a$at me#e#tu(a# stru(tur tabe' %a'am %atabase 5a#g %i buat C. PERTEMUAN 3 2, Sisa %a$at me#getaui $eri#ta*$eri#ta M5S-L 5a#g bergu#a mema#i$u'asi %atabase 3, Sisa %a$at mema#i$u'asi %atabase %e#ga# me#ggu#a(a# $eri#ta M5S-L MATERI AJAR : Mengg'n!&!n Ut(t) M)S#L >PHP M)A*$n La#g(a me#ggu#a(a# uti'it5 M5S-L me#ggu#a(a# PHP M5A%mi# : 1, A(ti6(a# Xam$$ )o#tro' Pa#e' ., K'i( tombo' A%mi# $a%a A$a8e , Foo's  PHPM5A%mi#

Atau %a$at &uga me'a'ui a'ama# broser : 1, Bu(a a'ama# broser tt$://'o8a'ost

u#tu( 

., Foo's  PHPM5A%mi# Men?!(!n&!n S#L #'er) * PHPM)A*$n Sa'a satu %atabase so6tare 5a#g umum %igu#a(a# u#tu( me#ge'o'a suatu eb %atabase a%a'a +6+M)A*$n, U#tu( membuat %a# me#ge'o'a tabe' %i $$M5A%mi# sebe#ar#5a (ita su%a %iberi (emu%aa# %e#ga# 8ara memi'i %a# me#g('i( me#u*me#u 5a#g a%a, Fa$i bagi 5a#g i#gi# be'a&ar me#ge#ai S#L #'er) se$erti DDL 9 Data Definition  Language %a# DML 9 Data Manipulation Language  u#tu( me#ge'o'a tabe' se8ara ma#ua'7 A#%a &uga bisa me#ggu#a(a# $$M5A%mi#, Beri(ut 8ara#5a : 1, i(a me#ggu#a(a# Xam$$7 bu(a $$M5A%mi# %i URL 6tt+://(-!(6"t7 (emu%ia# T(" +6+M)A*$n

., Buat %atabase baru %i (o'om Cre!te ne *!t!;!"e 7 misa' %e#ga# #ama %atabase *;+er+'"t!&!!n 7 'a'u ('i( Cre!te,

Atau &i(a i#gi# me#ggu#a(a# S#L #'er)7 $a%a si%ebar ('i( i8o# #'er) n* 9i8o# (e %ua %ari (iri7 ma(a i#%o baru a(a# mu#8u',

Pa%a i#%o baru tersebut (eti((a# sa&a S-L -uer5 5a#g %ii#gi#(a#7 sebagai 8o#to %isi#i sa5a membuat sebua %atabase %e#ga# #ama *;+er+'"t!&!!n , i(a su%a7 ('i( ,

, Kemu%ia# u#tu( membuat sebua tabe' beserta 6ie'%*6ie'%#5a a%a %ua 8ara &uga7 misa' membuat sebua tabel   %e#ga# #ama !nggt! %e#ga#  bua field 7 5a(#i n"7 n!$!<""! %a# !(!$!t %e#ga# field n" sebagai Pr$!r) Ke)*#5a, Pertama bu(a %atabase 5a#g a(a# %itamba(a# tabe'#5a7 misa'#5a *;+er+'"t!&!!n (emu%ia# isi(a# $a%a Cre!te ne t!;(e n *!t!;!"e *;+er+'"t!&!!n   %e#ga# nama tabel  %a# &um'a field!nya, i(a su%a7 ('i( ,

Se'a#&ut#5a isi(a# tabe' tersebut sesuai %e#ga# (ete#tua# stru(tur#5a7 &i(a su%a ('i( S!,e,

Atau &i(a i#gi# me#ggu#a(a# S#L #'er)7 $a%a si%ebar ('i( i8o# #'er) n* 9i8o# (e %ua %ari (iri7 ma(a i#%o baru a(a# mu#8u', Pa%a i#%o baru tersebut (eti((a# sa&a S-L -uer5 5a#g %ii#gi#(a#7 &i(a su%a ('i( ,

i(a -uer5 5a#g %imasu((a# su%a be#ar ma(a a(a# mu#8u' #oti6i(asi "our SQL query #as been e$ecuted successfully, Per!n-!ng!n B!"" D!t! U#tu( mera#8a#g basis %ata (ita $er'u me#getaui ter'ebi %au'u (om$o#e#*(om$o#e#  basis %ata tersebut, Kom$o#e# 5a#g $a'i#g $e#ti#g a%a'a e#titas %a# atribut, Entt!" *!n Atr;'t Entt!" a%a'a sesuatu atau ob&e( %i %u#ia #5ata 9real word  5a#g %a$at %ibe%a(a# %e#ga# sesuatu atau ob&e( 'ai##5a, Sebagai 8o#to7 setia$ maasisa %a'am suatu u#i+ersitas a%a'a suatu e#titas, Setia$ 6a(u'tas %a'am satu u#i+ersitas &uga suatu e#titas, Da$at %i(ata(a# baa e#titas bisa bersi6at (o#se$tua' / abstra( atau #5ata a%ir %i %u#ia #5ata 9entitas yang bersifat abstrak% misalnya persamaan kuadrat% rumus!rumus fisika dan  sebagainya, E#titas $a%a umum#5a memi'i(i se&um'a $ro$erti 5a#g %a$at %igu#a(a# u#tu( membe%a(a# suatu e#titas %e#ga# e#titas 'ai##5a, Sebagai 8o#to7 (ar5aa# suatu  $erusaaa# umum#5a memi'i(i @IP 5a#g membe%a(a# seora#g (ar5aa# %e#ga#

(ar5aa# 'ai##5a7 misa'#5a @IP "14!0." berarti (ar5aa# %e#ga# i%e#titas A%i @ugroo7 %a# @IP "14!00 berarti (ar5aa# %e#ga# i%e#titas Sa$to Bu%i Harto#o, Pro$erti*$ro$erti tersebut %i#ama(a# atribut, Suatu e#titas %ire$rese#tasi(a# %e#ga# se&um'a atribut, Atr;'t a%a'a $ro$erti %es(ri$ti6  5a#g %imi'i(i o'e setia$ a#ggota %ari im$u#a# e#titas, De#ga# me#gambi' 8o#to e#titas Maasisa7 atribut*atribut 5a#g mu#g(i# a%a'a @IM7 #ama maasisa7 a'amat7 serta #omor te'e$o#, Setia$ e#titas memi'i(i #i'ai u#tu( setia$ atribut#5a, Misa'#5a7 maasisa terte#tu memi'i(i #i'ai ',)isara#te# Ku'o# @o,..3 u#tu( atribut a'amat#5a, Atau7 maasisa 5a#g 'ai# memi'i(i #i'ai 3.01!4 u#tu( atribut #omor te'e$o##5a, Re(!" Re(!"  a%a'a ubu#ga# a#tara suatu im$u#a# e#titas %e#ga# im$u#a# e#titas 5a#g 'ai##5a, Misa'#5a7 e#titas Maasisa memi'i(i ubu#ga# terte#tu %e#ga# e#titas Mata(u'ia 9 Ma#asiswa mengambil Matakulia# , Pa%a $e#ggambara# mo%e' E#titas* Re'asio#a'7 re'asi a%a'a $ere(at 5a#g me#gubu#g(a# suatu e#titas %e#ga# e#titas 'ai##5a, K'n- K'n- >#ey meru$a(a# suatu atribut 5a#g u#i( 5a#g %a$at %igu#a(a# u#tu( membe%a(a# suatu e#titas %e#ga# e#titas 'ai##5a %a'am suatu im$u#a# e#titas, Se8ara (o#se$tua'7 sebua e#titas i#%i+i%ua' memi'i(i batas 5a#g &e'as, Dari su%ut $a#%a#g basis %ata7  $erbe%aa# %ia#tara mere(a arus %i8ermi#(a# 'eat $erbe%aa# %a'am #i'ai atribut#5a, Misa'#5a7 u#tu( e#titas maasisa7 atribut (u#8i#5a mu#g(i# a%a'a @IM*#5a sebab ti%a(  %i$er(e#a#(a# 'ebi %ari satu maasisa memi'i(i #i'ai atribut @IM 5a#g sama7 a'au$u# mu#g(i# maasisa*maasisa itu memi'i(i (ata(a#'a #i'ai atribut #ama 5a#g sama 9mu#g(i# a%a bebera$a maasisa %e#ga# #ama 5a#g sama7 misa'#5a Esti @ugrae#i %i suatu U#i+ersitas terte#tu, Me$;'!t R!n-!ng!n D!t!;!"e

Re'asi 5a#g %ia#ut tabe'*tabe' %iatas a%a'a re'asi &ne!to!Many7 misa'#5a re'asi a#tara tabe' user %a# tabe' berita 5a#g %iubu#g(a# o'e 6ie'% user#ame7 %a'am (o#te(s &ne!to!  Many7 ma(a seora#g user %a$at me#u'is ba#5a( berita 9ti%a( bisa seba'i(#5a, Fa#%a T me#a#%a(a# baa 6ie'% tersebut meru$a(a# (u#8i $rimer %a'am suatu tabe', Fa#%a TT me#a#%a(a# baa 6ie'% tersebut meru$a(a# (u#8i se8o#%ar5 9(u#8i tamu 5a#g me#gubu#g(a# a#tara satu tabe' %e#ga# tabe' 'ai##5a, T)+e D!t! P!*! M)S#L Fi$e %ata 5a#g %i%u(u#g M5S-L a#tara 'ai# 5aitu : 1, Fi$e %ata u#tu( bi'a#ga#  @o Fi$e Data Ketera#ga# 1, FI@GI@F U(ura# 1 b5te, Bi'a#ga# bu'at ter(e8i'7 %e#ga# &a#g(aua# u#tu( bi'a#ga# berta#%a *1.4 sam$ai %e#ga# 1.3 %a# u#tu( 5a#g ti%a( berta#%a 0 sam$ai %e#ga# ."", Bi'a#ga# ta( berta#%a %ita#%ai %e#ga# (ata U@SIN@ED, ., SMALLI@F U(ura# . b5te, Bi'a#ga# bu'at %e#ga# &a#g(aua# u#tu(   bi'a#ga# berta#%a *.324 sam$ai %e#ga# .323 %a# u#tu(  5a#g ti%a( berta#%a 0 sam$ai %e#ga# 2""", , MEDIUMI@F U(ura#  b5te, Bi'a#ga# bu'at %e#ga# &a#g(aua# u#tu(   bi'a#ga# berta#%a *444204 sam$ai %e#ga# 444203 %a# u#tu( 5a#g ti%a( berta#%a 0 sam$ai %e#ga# 12333.1", !, I@F U(ura# ! b5te, Bi'a#ga# bu'at %e#ga# &a#g(aua# u#tu(    bi'a#ga# berta#%a *.1!3!42!4 sam$ai %e#ga# .1!3!42!3 %a# u#tu( 5a#g ti%a( berta#%a 0 sam$ai %e#ga# !.!23.", ", I@FENER Sama %e#ga# I@F, 2, BINI@F U(ura# 4 b5te, Bi'a#ga# bu'at %e#ga# &a#g(aua# u#tu(    bi'a#ga# berta#%a *..3.024"!33"404 sam$ai %e#ga#

3, 4, ,


..3.024"!33"403 %a# u#tu( 5a#g ti%a( berta#%a 0 sam$ai %e#ga# 14!!23!!03303""121", U(ura# ! b5te, Bii'a#ga# $e8aa#, U(ura# 4 b5te, Bi'a#ga# $e8aa#, U(ura# M b5te, Bi'a#ga# $e8aa#, Misa'#5a DE)IMAL9"7. %a$at %igu#a(a# u#tu( me#5im$a#  bi'a#ga# *7 sam$ai %e#ga# 7,

., Fi$e %ata u#tu( ta#gga' %a# &am  @o Fi$e Data Ketera#ga# 1, DAFEFIME U(ura# 4 b5te, Kombi#asi ta#gga' %a# &am %e#ga#  &a#g(aua# %ari 1000*01*01 00:00:00 sam$ai %e#ga# *1.*1 .:":", ., DAFE U(ura# 4 b5te, Kombi#asi ta#gga' %a# &am %e#ga#  &a#g(aua# %ari 1000*01*01 sam$ai %e#ga# *1.*1 , , FIMESFAMP U(ura# ! b5te, Kombi#asi ta#gga' %a# &am %e#ga#  &a#g(aua# %ari 130*01*01 sam$ai %e#ga# .03 , !, FIME U(ura#  b5te,a(tu %e#ga# &a#g(aua# %ari *44:":" sam$ai %e#ga# 44:":", ", GEAR U(ura# 1 b5te, Data tau# a#tara 101 sam$ai %e#ga# .1"",

, Fi$e %ata u#tu( (ara(ter %a# 'ai#*'ai#  @o Fi$e Data Ketera#ga# 1, )HAR U(ura# M b5te7 1M."", Data stri#g %e#ga#  $a#&a#g 5a#g teta$, )HAR91 8u(u$ %itu'is %e#ga# )HAR, ., >AR)HAR U(ura# L?1 b5te %e#ga# LM %a# 1M."", Data stri#g %e#ga# $a#&a#g ber+ariasi terga#tu#g %ata#5a, , FI@GBL;B7 L?1 b5te7 %e#ga# L.4 , Fi$e FEXF atau BL;B %e#ga# FI@GFEXF  $a#&a#g ma(simum ."" (ara(ter, !, BL;B7 L?. b5te7 %e#ga# L.12 , Fi$e FEXF atau BL;B FEXF %e#ga# $a#&a#g ma(simum 2""" (ara(ter, ", MEDIUMBL;B7 L? b5te7 %e#ga# L..!, Fi$e FEXF atau BL;B MEDIUMFEXF %e#ga# $a#&a#g ma(simum 1233.1" (ara(ter, 2, L;@NBL;B7 L?! b5te7 %e#ga# L.., Fi$e FEXF atau BL;B L;@NFEXF %e#ga# $a#&a#g ma(simum !.!23." (ara(ter, 3, E@UM U(ura# 1 atau . b5te terga#tu#g #i'ai e#umerasi#5a ma(s 2""" #i'ai, 4, SEF U(ura# 17.77! atau 4 b5te terga#tu#g &um'a a#ggota im$u#a# ma(s 2! a#ggota, Me$;'!t D!t!;!"e Deng!n Str'&t'r D!n Ketent'!n K6'"'" Bebera$a (ete#tua# 5a#g arus %i$erati(a# %a'am $embuata# %atabase agar %a$at meme#ui (riteria sebagai suatu %atabase7 5aitu : 1, Re%u%a#si %a# i#(o#siste#si %ata : $e#5im$a#a# %ata 5a#g sama %ibebera$a tem$at %isebut re%u%a#si7 a' i#i me#5ebab(a# $emborosa# %a# me#imbu'a(a# i#(o#siste#si %ata 9%ata ti%a( (o#siste# (are#a bi'a ter&a%i $erubaa# tera%a$ %ata ma(a %ata arus %iuba %ibebera$a tem$at7 a' i#i te#tu#5a ti%a( e6isie#, ., Pe#ga(sesa# %ata : %ata %a'am %atabase arus sia$ %ia(ses o'e sia$a sa&a 5a#g

,

!,

",

2,

membutu(a# %a# mem$u#5ai a( u#tu( me#ga(ses#5a, ;'e (are#a itu $er'u %ibuat suatu $rogram $e#ge'o'aa# atau suatu a$'i(asi u#tu( me#ga(ses %ata 5a#g %i(e#a' sebagai DBMS, Data teriso'asi : &i(a %ata tersebar %a'am bebera$a 6i'e %a'am be#tu( 6ormat 5a#g ti%a( sama7 ma(a a(a# me#5u'it(a# %a'am me#u'is $rogram a$'i(asi u#tu(  me#gambi' %a# me#5im$a# %ata, ;'e (are#a itu %ata %a'am satu %atabase arus %ibuat satu 6ormat sei#gga mu%a %ibuat $rogram a$'ia(si#5a, Masa'a (eama#a# 9 security : ti%a( setia$ $ema(ai sistem %atabase %i$erbo'e(a# u#tu( me#ga(ses semua %ata7 misa'#5a %ata me#ge#ai ga&i $egaai a#5a bo'e %ibu(a o'e bagia# (eua#ga# %a# $erso#a'ia7 se%a#g(a# bagia# gu%a#g ti%a(  %i$er(e#a#(a# u#tu( membu(a#5a, Keama#a# %a$at %iatur %a# %isesuai(a# bai(  %iti#g(at %tabase atau a$'i(asi#5a, Masa'a i#tegritas 9integrity : %atabase berisis 6i'e 5a#g sa'i#g berubu#ga#7 masa'a utama a%a'a bagaima#a (aita# a#tar 6i'e tersebut ter&a%i mes(i %i(etaui  baa 6i'e A ter(ait %e#ga# 6i'e B7 #amu# se8ara te(#is a%a 6ie'% 5a#g me#gait(a# (e%ua 6i'e tersebut, ;'e (are#a itu 6ie'% (u#8i 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#5a %ata tersebut %igu#a(a# o'e ba#5a( ora#g7 bai( %a'am a(tu berbe%a mau$u#  bersamaa# sei#gga (ebutua# %atabase 5a#g a#%a' 5a#g me#%u(u#g ba#5a(   $ema(ai $er'u %i$ertimba#g(a#,

Me$!n+'(!" D!t!;!"e M)S#L U#tu( mema#i$u'asi %atabase M5S-L %a$at me#ggu#a(a# $eri#ta DDL %a# DML 1,  Data Definition Language  >DDL, S-L DDL me#5e%ia(a# $eri#ta*$eri#ta u#tu( me#%e6i#isi(a# s(ema re'asi7 me#ga$us re'asi7 serta memo%i6i(asi s(ema re'asi, Peri#ta DDL amtara 'ai# : )REAFE7 ALFER %a# DR;P, .,  Data Manipulation Language  >DML, S-L DML me#8a(u$ baasa S-L u#tu(  me#5isi$(a# re(ama# $a%a re'asi7 me#ga$us re(ama# $a%a re'asi7 serta memo%i6i(asi re(ama# $a%a re'asi, Peri#ta DML a#tara 'ai# : )REAFE7 I@SERF7 SELE)F7 UPDAFE %a# DELEFE, METODE PEMBELAJARAN : A, Pe#&e'asa# / 8erama B, Demo#strasi ), Pra(ti(um D, Fa#5a &aab %a# %is(usi E, Prese#tasi tugas KEIATAN PEMBELAJARAN : PERTEMUAN 1 A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, , Nuru me#5am$ai(a# tu&ua# $embe'a&ara# &uga $e#&e'asa# aa' te#ta#g materi 5a#g a(a# %ia&ar(a#, B. KEIATAN INTI : 1. E&+(r!"

2.

3.

Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, Kn8r$!" a, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i(   a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a#  b, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(,

PERTEMUAN 2. A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, 3. Kn8r$!" a, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a#,  b, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(, PERTEMUAN 3. A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, 3. Kn8r$!" a, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam

te#ta#g materi 5a#g %isam$ai(a#,  b, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(, PENUNAAN ALAT= BAHAN DAN SUMBER BELAJAR  A. Kom$uter u#tu( setia$ $eserta %i%i(, B. S$i%o' 7 $e#ga$us7 $a$a# tu'is, C. A'at $eraga $rese#tasi, D. So6tare 5a#g %ibutu(a# : XAMPP7 MoOi''a
SUMBER BELAJAR A,S7 Rosa %a# M,Sa'au%%i#, .011, Mo%u' Pembe'a&ara# Re(a5asa Pera#g(at Lu#a(  • 9Ferstru(tur Da# Berorie#tasi ;b&e(, Ba#%u#g : Mo%u'a  @ugroo7 A%i, .011, Pera#8a#ga# %a# Im$'eme#tasi Sistem Basis Data, Gog5a(arta : • A#%i  @ugroo7 Bu#a6it, .00, Latia# Membuat A$'i(asi eb PHP %a# M5S-L %e#ga# • Dreamea+er MX 27 37 .00!Q %a# 4, Gog5a(arta : Na+a Me%ia

Ba#5ua#gi7 12 u'i .01. Me#getaui Ke$a'a SMK AL AZHAR SEMPU

Nuru Mata Pe'a&ara#

ASNAN= S.P*.

SUEN HARI WIBOWO= S.K$.

RENCANA PELAKSANAAN PEMBELAJARAN SEKOLAH MATA PELAJARAN KELAS / SEMESTER  ALOKASI WAKTU

: SMK AL AZHAR SEMPU : Membuat Program Basis Data : XII / . : 1.  !" me#it

STANDAR KOMPETENSI : Membuat $rogram basis %ata KOMPETENSI DASAR : Me#ggu#a(a# store% $ro8e%ures INDIKATOR : 1, Mema#i$u'asi store% $ro8e%ures 9%ibuat7 mo%i6i(asi %a# a$us ., Membuat $rogrammi#g store% $ro8e%ures TUJUAN PEMBELAJARAN : A. PERTEMUAN 1 1, Sisa me#getaui a$a 5a#g %ima(su% %e#ga# store% $ro8e%ures ., Sisa me#getaui ma#6aat %ari store% $ro8e%ures , Sisa me#getaui (e'emaa# store% $ro8e%ures

B.

C.

PERTEMUAN 2 !, Sisa me#getaui %a# %a$at membuat si#ta(s $embuata# store% $ro8e%ures ", Sisa me#getaui $eri#ta $ema#ggi'a# store% $ro8e%ures 2, Sisa %a$at me#getaui $e#%e('arasia# +ariabe' $a%a store% $ro8e%ures PERTEMUAN 3 3, Sisa %a$at me#am$i'(a# store% $ro8e%ures 5a#g tersim$a# %i %atabase 4, Sisa %a$at me#ga$us store% $ro8e%ures 5a#g $er#a %ibuat , Sisa %a$at membuat $rogrammi#g store% $ro8e%ures

MATERI AJAR : Stre* Pr-e*'re" Store% Pro8e%ures a%a'a (o%e*(o%e atau $eri#ta S-L 5a#g %isim$a# %i %a'am (ata'og %atabase, Sebua store% $ro8e%ures %a$at %i$a#ggi' o'e $rogram7 trigger7 mau$u# store%  $ro8e%ures 'ai##5a,

Store% $ro8e%ure 5a#g mema#ggi' %iri#5a se#%iri %isebut %e#ga# Re8ursi+e Store% Pro8e%ures, Ham$ir semua so6tare RDBMS mam$u me#&a'a#(a# Re8ursi+e Store% Pro8e%ures, Stre* Pr-e*'re" * M)S#L M5S-L termasu( so6tare $e#go'a %atabase 5a#g 8u(u$ ter(e#a' %a# ba#5a( %igu#a(a#, Pa%a aa'#5a M5S-L be'um me#%u(u#g store% $ro8e%ures7 #amu# se&a( +ersi "7 M5S-L su%a me#%u(u#g store% $ro8e%ures, M!n8!!t Stre* Pr-e*'re" 1, Store% Pro8e%ures %a$at me#i#g(at(a# $er6orma atau (i#er&a $rogram7 (usus#5a 5a#g ber(aita# %e#ga# $e#go'aa# %atabase, ., Store% Pro8e%ures %a$at me#gura#gi tra6i( atau 'a'u'i#tas %ata7 (are#a $rogram a#5a 8u(u$ mema#ggi' #ama $ro8e%ures %ari $a%a me#girim(a# $eri#ta S-L 5a#g $a#&a#g, , Store% Pro8e%ures %a$at %igu#a(a# (emba'i o'e $rogrammer 'ai# 5a#g i#gi# me#ggu#a(a##5a7 sei#gga $rogrammer tersebut ti%a( $er'u membuat se#%iri (o%e* (o%e $rogram u#tu( me#ga(ses tabe' terte#tu, !, Store% Pro8e%ures memi'i(i ti#g(at (eama#a# 5a#g ti#ggi7 (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% $ro8e%ures i#i, Ke(e$!6!n Stre* Pr-e*'re" 1, Store% Pro8e%ures membuat beba# (er&a ser+er me#&a%i ti#ggi7 (usus#5a $a%a Pro8essor %a# memor5, ., Store% Pro8e%ures a#5a berisi (o%e S-L 5a#g bersi6at %e('arati67 sei#gga ti%a(  %a$at %igu#a(a# u#tu( me#u'is $rose%ur 5a#g membutu(a# 'ogi(a 5a#g (om$'e(s, , Store% Pro8e%ures su'it u#tu( %i'a(u(a# $roses %ebuggi#g,

Sete'a me#getaui (e'ebia# %a# (e(ura#ga# Store% Pro8e%ures7 ma(a sebai(#5a %i %a'am me#gemba#g(a# sebua a$'i(asi7 $er'u %i$ertimba#g(a# a$a(a $er'u u#tu(  me#ggu#a(a# store% $ro8e%ures atau ti%a(7 a' i#i terga#tu#g %e#ga# ti#g(at (om$'e(sitas a$'i(asi 5a#g a(a# %ibuat, Snt!&" Pe$;'!t!n Stre* Pr-e*'re"
DELIMIFER // )REAFE PR;)EDURE @amaJPro8e%ure9$arameter17 $arameter.7 $arameter #Q BENI@ S-L SFAFEME@FSV E@D // DELIMIFER V Atau7 &i(a Store% Pro8e%ures tersebut me#gemba'i(a# #i'ai ba'i( 6ormat#5a a%a'a sebagai  beri(ut : DELIMIFER // )REAFE
Pe#&e'asa#: 1, Pa%a (o%e %iatas ter%a$at stateme#t DELIMIFER //7 stateme#t i#i bu(a# $eri#ta u#tu( membuat Store% Pro8e%ures7 a(a# teta$i $eri#ta i#i u#tu( me#guba ta#%a a(ir e(se(usi $eri#ta 5a#g aa'#5a beru$a ta#%a semi*8o'o# 9titi( (oma me#&a%i ta#%a %oub'e*s'as, ., Pa%a baris (e%ua ter%a$at $eri#ta )REAFE PR;)EDURE7 stateme#t i#i %igu#a(a# u#tu( membuat Store% Pro8e%ures, Pa%a 8o#to (o%e %iatas7 NetA''Pro%u8ts9 a%a'a #ama Store% Pro8e%ures 5a#g %a$at %i$a#ggi', , Se'a#&ut#5a $eri#ta 5a#g ber(aita# %e#ga# $e#go'aa# %atabase %i'eta((a# %i a#tarab'o( BENI@ %a# E@D, Pa%a 8o#to (o%e %iatas7 ter%a$at $eri#ta S-L SELE)F T
Ber(aita# %e#ga# 8o#to %iatas7 u#tu( mema#ggi' Store% Pro8e%ures NetA''Pro%u8ts9 %a$at %i'a(u(a# %e#ga# me#geti( $eri#ta : CALL etA((Pr*'-t"> De#ga# memberi(a# $eri#ta tersebut7 ma(a a(a# %itam$i'(a# se'uru %ata 5a#g ter%a$at %i %a'am tabe' $ro%u8ts, De&(!r!" !r!;e( P!*! Stre* Pr-e*'re"
DE)LARE +ariab'eJ#ame%ataJt5$e9siOe DEariab'eJ#ame a%a'a #ama +ariab'e , DataJt5$e a%a'a ti$e %ata 5a#g %igu#a(a# o'e +ariabe'7 misa'#5a I@F u#tu(  i#teger7 3 DE5AULT 

Ma(su% stateme#t %iatas a%a'a me#%e('arasi(a# +ariab'e ber#ama =ua#tit5 berti$e %ata I#teger %a# memi'i(i 'ebar %ata  b5te serta memi'i(i #i'ai aa' 0, DECLARE = ? INT>2 DE5AULT 

Ma(su% stateme#t %iatas a%a'a me#%e('arasi(a# %ua bua +ariab'e 5aitu i %a# &7 (e%ua#5a  berti$e %ata I#teger %e#ga# 'ebar %ata . b5te %a# memi'i(i #i'ai aa' 0, Me$;er&!n N(! Ke D!(!$ !r!;e( Sete'a memaami 8ara me#%e('arasi(a# +ariab'e %i %a'am store% $ro8e%ures7 ma(a se'a#&ut#5a a%a'a mem$e'a&ari 8ara memberi(a# #i'ai (e%a'am +ariabe',

U#tu( memberi(a# #i'ai (e%a'am suatu +ariab'e %a$at me#ggu#a(a# $eri#ta SEF %a#  $eri#ta SELE)F I@F;, Beri(ut i#i 8o#to bagaima#a $e#era$a# $eri#ta SEF %a#  $eri#ta SELE)F I@F; : DECLARE &e((ng INT>3 DE5AULT  SET &e((ng  4 Pe#&e'asa# me#ge#ai $eri#ta*$eri#ta %iatas : 1, DE)LARE (e'i'i#g I@F9 DE INTO tt!(<+r*'-t" 5ROM +r*'-t"

Pe#&e'asa# me#ge#ai $eri#ta*$eri#ta %i atas : 1, DE)LARE tota'J$ro%u8ts I@F DE
U#tu( me#am$i'(a# semua Store% Pro8e%ures 5a#g tersim$a# %i %atabase7 %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% Pro8e%ures 5a#g su%a %ibuat $eri#ta#5a a%a'a : SHOW CREATE PROCEDURE N!$!
)o#to: SHOW CREATE PROCEDURE etA((Pr*'-t" Meng6!+'" Stre* Pr-e*'re" @!ng Pern!6 D;'!t U#tu( me#ga$us suatu Store% Pro8e%ures 5a#g ter%a$at %a'am %atabase atau 5a#g su%a  $er#a %ibuat7 $eri#ta#5a a%a'a : DROP PROCEDURE N!$!
)o#to: DROP PROCEDURE etA((Pr*'-t" Prgr!$$ng Stre* Pr-e*'re" Me$;'!t *!n Me$!ngg( Stre* Pr-e*'re" 1, Bu(a );MMA@D I@D;

.,

Masu((e 6o'%er %ima#a m5s=',ee bera%a %e#ga# me#geti(    $eri#ta : CD C:90AMPP9M)S#L9;nE@FERQ

,

Se'a#&ut#5a masu( (e'i#g(u#ga# M5S-L %e#ga# me#geti(    $eri#ta: $)"( 'rt +  E@FERQ7 (emu%ia# masu((a# $assor% M5S-L A#%a %a# te(a# E@FERQ,

!,

Se'a#&ut#5a &i(a $roses 'ogi# (e M5S-L berasi'7 A#%a a(a# %isa&i(a# 'i#g(u#ga# $e#go'a %ata M5S-L,

",

Buat

sebua

%atabase

me#geti((a# $eri#ta : CREATE DATABASE *;<(!t6"+ ENTER USE *;<(!t6"+ ENTER

ber#ama

*;<(!t6"+

%e#ga#

2,

Buat sebua tabe' %e#ga# #ama +r*'-t" %e#ga# stru(tur : 5e(* N!$e

D!t! T)+e

Lengt6

 $ro%u8tJi%

)ar



 $ro%u8tJ#ame

)ar

"0

 $ri8e

Doub'e

Peri#ta#5a a%a'a : CREATE TABLE +r*'-t">+r*'-t<* -6!r>3= +r*'-tF= +r-e *';(e  E@FERQ

3,

Kemu%ia# isi'a tabe' $ro%u8ts tersebut %e#ga# bebera$a  baris %ata beri(u ti#i : +r*'-t<* 001 00. 00 00!

+r*'-t
Pr-e

0000 !000 "000 1"00

Peri#ta#5a a%a'a sebagai beri(ut : INSERT INTO +r*'-t" ALUES >G1= GKERTAS A= G3 E@FERQ INSERT INTO +r*'-t" ALUES >G2= GKERTAS 5= G3 E@FERQ INSERT INTO +r*'-t" ALUES >G3= GSPIDOL 0@= GF E@FERQ INSERT INTO +r*'-t" ALUES >G= GLEM KERTAS= G1F E@FERQ

4,

Agar 'ebi 5a(i#7 8oba tam$i'(a# se'uru %ata 5a#g ter%a$at %i %a'am tabe' $ro%u8ts %e#ga# memberi(a# $eri#ta : SELECT  5ROM +r*'-t" E@FERQ

,

Se(ara#g saat#5a membuat store% $ro8e%ures 5a#g ber#ama NetA''Pro%u8ts, Peri#ta#5a a%a'a sebagai beri(ut : DELIMITER // CREATE PROCEDURE etA((Pr*'-t"> BEIN SELECT  5ROM +r*'-t" END // DELIMITER 

10,

Peri#ta %iatas ma(su%#5a a%a'a membuat Store% Pro8e%ures 5a#g ber#ama NetA''Pro%u8ts %a# out$ut %ari $a%a Store% Pro8e%ures

tersebut a%a'a me#am$i'(a# se'uru %ata 5a#g ter%a$at %i %a'am tabe' +r*'-t" , 11,

U#tu( me#&a'a#(a# Store% Pro8e%ures NetA''Pro%u8ts 5a#g te'a %ibuat %iatas7 $eri#ta#5a a%a'a: CALL etA((Pr*'-t">E@FERQ Hasi'#5a a%a'a se'uru %ata %i %a'am tabe' +r*'-t" a(a# %itam$i'(a#, Perati(a# gambar beri(ut:

Me$;'!t *!n Me$!ngg( Stre* 5'n-tn Masi %i 'i#g(u#ga# M5S-L 5a#g masi a(ti67 $a%a $ra(ti(um (a'i i#i a(a# %i&e'as(a# me#ge#ai 8ara membuat Store% ,!rID -6!r>3 RETURNS tet BEIN DECLARE ,N!$!CHAR>F SELECT +r*'-t
., U#tu( me#gu&i*8oba Store% G2  E@FERQ

METODE PEMBELAJARAN : A, Pe#&e'asa# / 8erama B, Demo#strasi ), Pra(ti(um D, Fa#5a &aab %a# %is(usi E, Prese#tasi tugas KEIATAN PEMBELAJARAN : PERTEMUAN 1 A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, , Nuru me#5am$ai(a# tu&ua# $embe'a&ara# &uga $e#&e'asa# aa' te#ta#g materi 5a#g a(a# %ia&ar(a#, B. KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, 3. Kn8r$!" a, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i(   a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a#  b, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(, PERTEMUAN 2. A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI :

1.

2.

3.

E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, Kn8r$!" a, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a#,  b, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(,

PERTEMUAN 3. A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, 3. Kn8r$!" a, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a#,  b, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(,

PENUNAAN ALAT= BAHAN DAN SUMBER BELAJAR  A. Kom$uter u#tu( setia$ $eserta %i%i(, B. S$i%o' 7 $e#ga$us7 $a$a# tu'is, C. A'at $eraga $rese#tasi, D. So6tare 5a#g %ibutu(a# : XAMPP7 MoOi''a
A.

SOAL 1, A$a 5a#g %ima(su% %e#ga# store% $ro8e%ures  9bobot #i'ai 1" ., Sebut(a# ! ma#6aat store% $ro8e%ures  9bobot #i'ai .0 , Sebut(a# (e'emaa# store% $ro8e%ures  9bobot #i'ai 1" !, Fu'is(a# si#ta(s $embuata# store% $ro8e%ures  9 bobot #i'ai 0 ", Fu'is(a# $eri#ta u#tu( me#ga$us store% $ro8e%ures 5a#g  $er#a %ibuat  9bobot #i'ai .0

SUMBER BELAJAR A,S7 Rosa %a# M,Sa'au%%i#, .011, Mo%u' Pembe'a&ara# Re(a5asa Pera#g(at Lu#a(  • 9Ferstru(tur Da# Berorie#tasi ;b&e(, Ba#%u#g : Mo%u'a  @ugroo7 A%i, .011, Pera#8a#ga# %a# Im$'eme#tasi Sistem Basis Data, Gog5a(arta : • A#%i  @ugroo7 Bu#a6it, .00, Latia# Membuat A$'i(asi eb PHP %a# M5S-L %e#ga# • Dreamea+er MX 27 37 .00!Q %a# 4, Gog5a(arta : Na+a Me%ia

Ba#5ua#gi7 12 u'i .01. Me#getaui Ke$a'a SMK AL AZHAR SEMPU

Nuru Mata Pe'a&ara#

ASNAN= S.P*.

SUEN HARI WIBOWO= S.K$.

RENCANA PELAKSANAAN PEMBELAJARAN SEKOLAH MATA PELAJARAN KELAS / SEMESTER  ALOKASI WAKTU

: SMK AL AZHAR SEMPU : Membuat Program Basis Data : XII / . : 1.  !" 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, Sisa me#getaui a$a 5a#g %ima(su% %e#ga# triggers ., Sisa me#getaui $erbe%aa# triggers %e#ga# store% $ro8e%ures , Sisa me#getaui ma#6aat triggers B. PERTEMUAN 2 !, Sisa bisa membuat %a# me#ge'o'a triggers C. PERTEMUAN 3 ", Sisa bisa membuat $rogrammi#g triggers MATERI AJAR : Trgger" Frigger &uga termasu( (um$u'a# $eri#ta S-L 5a#g tersim$a# %i (ata'og %atabase, Frigger  %a$at %ia(ti6(a# $a%a saat %atabase me#&a'a#(a# $roses I@SERF7 UPDAFE7 %a# DELEFE, Per;e*!!n Trgger" *eng!n Stre* Pr-e*'re" Perbe%aa# Frigger %e#ga# Store% Pro8e%ure ter'eta( $a%a 8ara me#ga(ti6(a##5a, i(a $a%a Store% Pro8e%ure %ia(ti6(a# %e#ga# memberi(a $eri#ta )ALL7 ma(a $a%a trigger   $e#ga(ti6a##5a &ustru ter&a%i se8ara otomatis $a%a saat %atabase me#ga'ami e+e#t I@SERF7 UPDAFE7 mau$u# DELEFE, M!n8!!t Trgger" 1, S-L Frigger %a$at %igu#a(a# u#tu( me'a(u(a# $e#ge8e(a# atas i#tegritas %ata  $a%a 'e+e' %atabase, ., S-L Frigger %a$at %igu#a(a# u#tu( me#a#g(a$ (esa'aa#*(esa'aa# 'ogi(a $a%a 'e+e' %atabase, , S-L Frigger %a$at %igu#a(a# sebagai 8ara a'ter#ati6 u#tu( me#&a'a#(a# $eri#ta 5a#g ter&a%a' $a%a 'e+e' %atabase, Pener!+!n Trgger * M)S#L Se&a( +ersi ",0,.7 M5S-L su%a memi'i(i 6itur trigger, Dima#a $a%a +ersi sebe'um#5a M5S-L be'um memi'i(i 6itur trigger i#i7 %a# 6itur i#i a#5a %a$at %itemu(a# $a%a M5S-L +ersi E#ter$rises sa&a,

Pa%a saat (ita membuat sebua trigger %i M5S-L7 ma(a $eri#ta*$eri#ta trigger tersebut tersim$a# (e %a'am 6i'e 5a#g bere(ste#si ,FRN %i %a'am 6o'%er %atabase, BE5ORE  A5TER INSERT  UPDATE  DELETE.

U#tu( 'ebi &e'as#5a $ra(ti((a# 'a#g(a*'a#g(a beri(ut i#i u#tu( membuat trigger : 1, Bu(a );MMA@D I@D;

., Masu( (e 6o'%er %ima#a m5s=',ee bera%a %e#ga# me#geti( $eri#ta : CD C:90AMPP9M)S#L9;n E@FERQ

, Se'a#&ut#5a masu( (e 'i#g(u#ga# M5S-L %e#ga# me#geti( $eri#ta: $)"( 'rt  + E@FERQ7 (emu%ia# masu((a# $assor% M5S-L A#%a %a# te(a# E@FERQ,

!, Se'a#&ut#5a &i(a $roses 'ogi# (e M5S-L berasi'7 A#%a a(a# %isa&i(a# 'i#g(u#ga#  $e#go'a %ata M5S-L,

", Buat sebua %atabase ber#ama *;
2, Se'a#&ut#5a (eti( $eri#ta S-L beri(ut i#i : )REAFE FABLE Wem$'o5eesW 9 Wem$'o5ee@umberW i#t911 @;F @ULL7

W'ast@ameW +ar8ar9"0 @;F @ULL7 W6irst@ameW +ar8ar9"0 @;F @ULL7 Wete#sio#W +ar8ar910 @;F @ULL7 Wemai'W +ar8ar9100 @;F @ULL7 Wo66i8e)o%eW +ar8ar910 @;F @ULL7 Wre$ortsFoW i#t911 %e6au't @ULL7 W&obFit'eW +ar8ar9"0 @;F @ULL7   PRIMARG KEG 9Wem$'o5ee@umberW V E@FERQ

3, Kemu%ia# isi'a tabe' em$'o5ees %e#ga# me#geti( $eri#ta S-L beri(ut i#i : I@SERF I@F; em$'o5ees >ALUES 90017a5a7A%i7Sta667a%i5aoo,8om7)B@7107Sta66V

4, Se(ara#g7 &i(a (ita i#gi# agar $erubaa# %ata 5a#g ter&a%i $a%a tabe' em$'o5ee %a$at %i(etaui7 ma(a (ita %a$at mebuat sebua tabe' 'agi u#tu( me#am$u#g %ata  $erubaa# tersebut, Fabe' i#i (ita beri #ama em$'o5eesJau%it7 5a#g ber6u#gsi u#tu(  me'a(u(a# $e'a8a(a# atas $erubaa# %ata 5a#g ter&a%i $a%a tabe' em$'o5ee, Keti(   $eri#ta S-L beri(ut u#tu( membuat tabe' em$'o5eesJau%it :

CREATE TABLE e$+()ee" * nt>11 NOT NULL AUTO11 NOT NULL=

(!"tn!$e ,!r-6!r>F NOT NULL= -6!nge*n *!tet$e DE5AULT NULL= !-tn ,!r-6!r>F DE5AULT NULL= PRIMAR@ KE@ >*  ENTER

, U#tu( %a$at me'a8a( $erubaa# 5a#g ter&a%i $a%a tabe' em$'o5ee7 (ita %a$at membuat sebua trigger 5a#g a(a# %i&a'a#(a# $a%a saat SEBELUM (ita me'a(u(a#  $erubaa# %ata $a%a tabe' em$'o5ee, Keti( $eri#ta i#i u#tu( membuat trigger : DELIMIFER YY )REAFE FRINNER be6oreJem$'o5eeJu$%ate BE<;RE UPDAFE ;@ em$'o5ees <;R EA)H R; BENI@ I@SERF I@F; em$'o5eesJau%it SEF a8tio#  u$%ate7 em$'o5ee@umber  ;LD,em$'o5ee@umber7 'ast#ame  ;LD,'ast#ame7 8a#ge%o#  @;9V E@DYY DELIMIFER V E@FERQ

10, Se'a#&ut#5a (ita %a$at me'a(u(a# test atas trigger 5a#g su%a (ita buat7 misa'#5a %e#ga# me#guba %ata $a%a 6ie'% 'ast@ame, Keti((a# $eri#ta S-L beri(ut i#i : UPDATE e$+()ee" SET (!"tN!$e  GW!&* WHERE e$+()eeN'$;er1

11, Se(ara#g7 (ita %a$at me'iat $erubaa# se8ara otomatis %i tabe' em$'o5eesJau%it %e#ga# me#geti((a# $eri#ta beri(ut i#i : SELECT  5ROM e$+()ee"
1., Kesim$u'a##5a : %ata $a%a tabe' em$'o5eesJau%it terisi se8ara otomatis o'e trigger  5a#g (ita buat $a%a saat (ita me'a(u(a# $erubaa# %ata $a%a tabe' em$'o5ees, METODE PEMBELAJARAN : A, Pe#&e'asa# / 8erama B, Demo#strasi ), Pra(ti(um D, Fa#5a &aab %a# %is(usi E, Prese#tasi tugas KEIATAN PEMBELAJARAN : PERTEMUAN 1 A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, , Nuru me#5am$ai(a# tu&ua# $embe'a&ara# &uga $e#&e'asa# aa' te#ta#g materi 5a#g a(a# %ia&ar(a#,

B.

KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, 3. Kn8r$!" 8, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i(   a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a# %, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(,

PERTEMUAN 2. A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut, 3. Kn8r$!" 8, Nuru me#a#5a(a# (emba'i $a%a $eserta %i%i( a$a(a mere(a $aam te#ta#g materi 5a#g %isam$ai(a#, %, Nuru me#&e'as(a# (emba'i a$a 5a#g be'um %i$aami $eserta %i%i(, PERTEMUAN 3. A. KEIATAN AWAL / PENDAHULUAN : 1, Nuru me#5ia$(a# $si(is %a# 6isi( $eserta %i%i( u#tu( memu'ai $embe'a&ara# %e#ga# memeri#ta(a# (etua (e'as memim$i# %oa sebe'um $embe'a&ara# %imu'ai, ., Nuru me#gabse# $eserta %i%i( satu $ersatu7 memasti(a# baa $eserta %i%i( su%a 'e#g(a$, B. KEIATAN INTI : 1. E&+(r!" Peserta %i%i( me#gum$u'(a# i#6ormasi ter(ait materi 5a#g %isam$ai(a# : Memberi(a# (esem$ata# $a%a $eserta %i%i( me#8ari materi 'ai# 5a#g berubu#ga# %e#ga# materi 5a#g %isam$ai(a# 'eat i#ter#et atau$u# bu(u re6ere#si 5a#g ter(ait, 2. E(!;r!" Memberi(a# $erta#5aa#*$erta#5aa# (e8i' saat $embe'a&ara# ber'a#gsu#g7 sei#gga  $eserta %i%i( 5a#g me#gerti %a$at me#ga#g(at ta#ga# %a# me#&aab $erta5aa# tersebut,