tugas mandiri 3 - data dan basis data
TRANSCRIPT
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 1/10
X R @ C Z F C D H I \ I
^bd`cdxc| Xbkdeoe`i Idae|fczi
‟Hcxc hcd Lcziz Hcxc‖
Fid``r kb&:
DCFC 7 Fcmcyrhc
DIF 7 832>9>3>>3:
LOE@ 7 mxx~7%%ziorfcdhi`ixcoo$loe`z~ex$jef%
^|e`|cf Zxrhi Xbkdik Idae|fcxikc
Ackroxcz Iofr Kef~rxb|
Rdiqb|zixcz Fb|jr Lrcdc
Gckc|xc
<>3<
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 2/10
<
^bd`b|xicd Hcxc Hcd Idae|fczi
Hcxc chcocm ackxc fbd`bdci elgbk/ e|cd`/ hcd ocid&ocid/ hcxc hidycxckcd
hbd`cd dioci lcik ixr cd`kc/ hb|bxcd kc|ckxb| cxcr zyfleo$
Idae|fczi chcocm mczio cdcoiziz xb|mchc~ hcxc hbd`cd kcxc ocid idae|fczi hc~cx
hikcxckcd zblc`ci hcxc ycd` xbocm hie|`cdizczikcd kb hcocf lbdxrk ycd` zbzrci
hbd`cd kblrxrmcd zbzbe|cd` bdxcm ixr fcdcgb|/ zxcaa cxcr~rd e|cd` ocid hi hcocf
zrcxr e|`cdizczi cxcr ~b|rzcmccd$
Hc|i Lix kb Idae|fczi
Zbgck hiji~xckcd ~b|xcfc kcoi/ kef~rxb| lbkb|gc cxcz hczc| zizxbf lidb|$
Zizxbf lidb| chcocm zizxbf liocd`cd ycd` mcdyc fbd`bdco hrc fcjcf cd`kc ycd`
hizblrx hbd`cd izxiocm lix -lidc|y hi`ix )/ lb|r~c > hcd 3$ Mcdyc hbd`cd hrc
kbfrd`kidcd liocd`cd idiocm kef~rxb| hc~cx fbdycgikcd idae|fczi ycd` lb`ixr
lb|`rdc lc`i ~b|chclcd fcdrzic$
Lix&lix hc~cx hi`rdckcd rdxrk fbdyrzrd kc|ckxb| c~c zcgc$ Izxiocm kc|ckxb|
hcocf hrdic kef~rxb| lb|c|xi7
3$ Mr|ra/ fizcodyc C hcd w/
<$ Hi`ix/ zb~b|xi >/ </ hcd 9/
:$ Zbocid mr|ra fcr~rd hi`ix/ zb~b|xi xcdhc + zb|xc ! lcmkcd zifleo zb~b|xi μ$
Zblrcm kc|ckxb| hidycxckcd hbd`cd = lix cxcr~rd 31 lix$ Kbfrd`kidcd dioci
~chc zblrcm zizxbf lidb| ycd` lb|r~c > cxcr 3 hidycxckcd hcocf zizxbf kef~rxb|
hbd`cd fbxehb zckoc| ycd` mcdyc fbd`bdco kbchccd mihr~ cxcr fcxi$ Kbchccd
mihr~ hidycxckcd hbd`cd dioci 3 zbhcd`kcd kbchccd fcxi hidycxckcd hbd`cd dioci
>$
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 3/10
:
Zizxbf ~bd`kehbcd kc|ckxb| ycd` xb|kbdco chcocm CZJII/ BLJHIJ/ Rdijehb$
3$ CZJII
CZJII - Cfb|ijcd Zxcdhc|h Jehb ae| Idae|fcxied Idxb|jmcd`b) ycd`hikbflcd`kcd eobm CDZI - Cfb|ijcd Dcxiedco Zxcdhc|hz Idzxixrxb)$ ^chc
cpcodyc zxcdhc| idi fbd``rdckcd 0 lix rdxrk fbdycxckcd zblrcm kehb$
Hbd`cd fbd``rdckcd 0 lrcm lix/ kc|ckxb| ycd` xb|zbhic fboi~rxi kc|ckxb|
kedx|eo/ mr|ra -C zcf~ci hbd`cd W hcd c zcf~ci hbd`cd w)/ hi`ix ->
zcf~ci hbd`cd 9)/ hcd zbgrfocm zifleo zb~b|xi ' hcd +$ Lbockcd`cd idi
CZJII hikbflcd`kcd hbd`cd fbd``rdckcd = lrcm lix/ hbd`cd xcflcmcd
zbgrfocm zifleo Yrdcdi hcd kc|ckxb| `|caiz$
Zblc`ci jedxem/ kcxc MCI ckcd hikedqb|zikcd hc|i lidb| kb kehb CZJII7
M 6
6 ->'3) + ->'<) + ->'8) + -3'=) + ->'31) + ->':<) + -3'18) + ->'3<=)
6 = + 18
6 0< -hcocf kehb CZJII 0< zcfc hbd`cd mr|ra M)$
C 6
6 -3'3) + ->'<) + ->'8) + ->'=) + ->'31) + ->':<) + -3'18) + ->'3<=)
6 3 + 18
6 12 -hcocf kehb CZJIII 12 zcfc hbd`cd mr|ra C)
I 6
6 -3'3) + ->'<) + ->'8) + -3'=) + ->'31) + ->':<) + -3'18) + ->'3<=)
6 3 + = + 18
6 0: -hcocf kehb CZJIII 0: zcfc hbd`cd mr|ra I)
3<= 18 :< 31 = 8 < 3
> 3 > > 3 > > >
3<= 18 :< 31 = 8 < 3
> 3 > > > > > 3
3<= 18 :< 31 = 8 < 3
> 3 > > 3 > > 3
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 4/10
8
<$ BLJHIJ
BLJHIJ - B}xbdhbh Lidc|y Jehbh Hbjifco Idxb|jmcd`b Jehb) fb|r~ckcd
zxcdhc| ycd` hilrcx eobm ILF ~chc xcmrd 392>&cd hcd fbd``rdckcd = lix
rdxrk zbxic~ kehb$ ^b|xcfc kcoi hi`rdckcd ~chc ILF Zyzxbf%:1>$ Zxcdhc|
idi hixb|c~kcd ~chc lb|lc`ci kef~rxb| fcida|cfb$
Rdxrk ~b|mixrd`cd kedqb|zi kb kehb BLJHIJ zcfc hbd`cd ~chc kedqb|zi
kehb CZJII mcdyc zcgc lb|lbhc xclbo kehbdyc$
:$ RDIJEHB
Zbocid CZJII hcd BLJHIJ/ xb|hc~cx zxcdhc| ycd` oblim lc|r ycd`
hidcfckcd Rdijehb$ ^chc zxcdhc| idi zblrcm kc|ckxb| hidycxckcd hbd`cd
31 lix$ Comczio/ zxcdhc| idi hc~cx fbdjckr~ 12$2:1 kc|ckxb|$ Hbd`cd jc|c
zb~b|xi idi lb|lc`ci zifleo hcocf lcmczc zb~b|xi lcmczc C|cl hcd Jidc
lizc hixcf~rd`$
Zcxrcd Hcxc
Lix fb|r~ckcd zcxrcd hcxc xb|kbjio hcocf zizxbf kef~rxb|$ Hi cxcz zcxrcd idi
xb|hc~cx lb|lc`ci zcxrcd ocid/ yckdi lb|r~c lyxb/ fb`clyxb/ `i`clyxb/ xb|clyxb/
hcd ~bxclyxb$
Hcaxc| zcxrcd hcxc
Zcxrcd Bkriqcobd Kbxb|cd`cd
Lyxb = lixRdxrk fbdyif~cd zblrcm kc|ckxb| ~chc zizxbf
CZJII cxcr BLJHIJ$
Kioelyxb 3><8 lyxbCpco ^J mcdyc fbfioiki fbfe|i zblbzc| 18>
kioelyxb$
Fb`clyxb 3><8 kioelyxbFbfe|i ^J ~chc zccx idi lb|kizc| dxc|c 18&<21
fb`clyxb$
@i`clyxb 3><8 fb`clyxbRkr|cd Mc|hizk ycd` hi`rdckcd lb|kizc| cdxc|c
<> ‚ 8> `i`clyxb$
Xb|clyxb 3><8 `i`clyxb Hcxclczb ycd` zcd`cx lbzc|$
^bxclyxb 3><8 xb|clyxb ^bd``rdccd hi fczc fbdhcxcd`$
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 5/10
2
3$ Lyxb
Lyxb fb|r~ckcd zcxrcd ycd` hi`rdckcd rdxrk fbdycxckcd zblrcm
kc|ckxb|$ Zblc`ci jedxem/ zblrcm lyxb ~chc zizxbf CZJII hidycxckcd
hbd`cd zblrcm lyxb$ Zblrcm lyxb xb|zrzrd cxcz = lrcm lix$
<$ Kioelyxb
Kioelyxb zb|id`kcoi hizid`kcx fbdgchi KL cxcr K$ Lb|kcz `cflc| ycd`
lb|rkr|cd kbjio liczcdyc lb|rkr|cd hcocf e|hb kioelyxb$
3 Kioelyxb 6 3><8 lyxb
:$ Fb`clyxb
Fb`clyxb zb|id`kcoi hizid`kcx fbdgchi FL cxcr F$ Liczc hi`rdckcd
rdxrk fbdycxckcd kc~czixcz \CF hcocf ^J pcocr~rd zccx idi xbkdeoe`i
\CF zrhcm fbdjc~ci zcxrcd @i`clyxb$
3 Fb`clyxb 6 3><8 kioelyxb 6 3$>8=$201 lyxb
8$ @i`clyxb
@i`clyxb zb|id`kcoi hizid`kcx fbdgchi @L cxcr @$ Liczc hi`rdckcd rdxrk
fbdycxckcd kc~czixcz Mc|hizk hcocf ^J pcocr~rd zccx idi xbkdeoe`i
Mc|hizk zrhcm fbdjc~ci zcxrcd Xb|clyxb$
3 @i`clyxb 6 3><8 Fb`clyxb 6 3$>0:$083$=<8 Lyxb
2$ Xb|clyxb
Xb|clyxb zb|id`kcoi hizid`kcx fbdgchi XL cxcr X$
3 Xb|clyxb 6 3><8 @i`clyxb 6 3$>>9$233$1<0$001 lyxb
1$ ^bxclyxb
Xb|clyxb zb|id`kcoi hizid`kcx fbdgchi ^L cxcr ^$ Rdxrk zccx idi lborf
hi`rdckcd hcd rdxrk hi`rdckcd hi fczc ycd` ckcd hcxcd`$
3 ^bxclyxb 6 3><8 Xb|clyxb
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 6/10
1
Mib|c|ki Hcxc
Zbjc|c x|chiziedco hcxc hie|`cdizczikcd kb hcocf zrcxr mi|c|ki ycd` xb|hi|i
cxcz bobfbd hcxc/ |bkcfcd-|bje|h)/ hcd lb|kcz-aiob)$
• Bobfbd hcxc -Aiboh)
Chcocm zcxrcd hcxc xb|kbjio yc` xihck hc~cx hi~bjcm oc`i fbdgchi rdix ocid
ycd` lb|fckdc$
• \bkcfcd -\bje|h)
Chcocm `clrd`cd zbgrfocm bobfbd hcxc ycd` zcoid` xb|kcix$ Zblc`ci
jedxem7 dcfc/ cocfcx/ kexc hcd xcd``co ocmi| zbe|cd` ~b`cpci hc~cx
himif~rd hcocf zblrcm |bkcfcd$ Hcocf zizxbf lcziz hcxc |bocziedco
|bkcfcd liczc hizblrx xr~bo cxcr lc|iz$
• Lb|kcz -Aiob)
Chcocm mif~rdcd zbor|rm |bkcfcd ycd` lb|xi~b zcfc fbflbdxrk zblrcm
lb|kcz$ Lb|kcz hc~cx hikcxckcd zblc`ci krf~rocd |bkcfcd hcxc ycd`
lb|kcixcd hbd`cd zrcxr elgbk$ Hcocf zizxbf lcziz hcxc |bocziedco/ lb|kcz
fbpckioi kef~edbd ycd` hizblrx xclbo cxcr |boczi$
Lcziz Hcxc
Zrcxr zrzrdcd hcxc e~b|cziedco obd`kc~ hc|i zrcxr e|`cdizczi%~b|rzcmccd
ycd` hikboeoc hcd hizif~cd zbjc|c xb|idxb`|czi hbd`cd fbd``rdckcd fbxehb
xb|xbdxr/ hbd`cd fbd``rdckcd kef~rxb| zbmid``c fcf~r fbdybhickcd
idae|fczi ycd` e~xifco hi~b|orkcd ~bfckcidyc$
Xb|hc~cx 8 kef~edbd ~ekek hc|i hcxclczb7
3$ Hcxc
• Hcxc hizif~cd zbjc|c xb|idxb`|czi -idxb`|cxbh)$
Idxb`|cxbh chcocm krf~rocd hc|i lb|lc`ci fcjcf aiob hc|i c~oikczi&
c~oikczi ycd` lb|lbhc hizrzrd hbd`cd jc|c fbd`miocd`kcd lc`icd
ycd` |cd`kc~ -|bhrdhcdx)$
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 7/10
0
• Hcxc hc~cx hi~ckci zbjc|c lb|zcfc&zcfc -zmc|bh)$
Zmc|bh chcocm lc`icd hcxclczb ycd` hc~cx hickzbz hcd hi~ckci zbjc|c
lb|zcfc&zcfc ~chc pckxr ycd` lb|zcfccd rdxrk c~oikczi ycd`
lb|lbhc$
<$ Mc|hpc|b
Xb|hi|i hc|i zbfrc ~b|cocxcd ~b|cd`kcx kb|cz kef~rxb| ycd` hi`rdckcd
rdxrk ~bd`boeoccd zizxbf hcxclczb/ lb|r~c7
• ^b|cd`kcx ~bdyif~cdcd
• ^b|cd`kcx Id~rx%erx~rx
• ^b|cd`kcx kefrdikczi hcxc
:$ Zeaxpc|b
Lb|ard`zi zblc`ci ~b|cdxc|c cdxc| ~bfckci hbd`cd hcxc aizik ~chc
hcxclczb/ lb|r~c7
• Hcxc Lczb Fcdc`bfbdx Zyzxbf -HLFZ)
• ^|e`|cf&~|e`|cf c~oikczi
8$ Rzb|
Rzb| chcocm zbfrc ~bfckci ycd` xb|oilcx hcocf hcxclczb
• Hcxc Lczb Chfidizx|cxied -HLC)
E|cd` cxcr xbcf ycd` fbd`boeoc hcxclczb zbjc|c kbzbor|rmcd$
• ^|e`|cffb|
E|cd` cxcr xbcf ycd` fbflrcx ~|e`|cf c~oikczi rdxrk fbd`ckzbz
hcxclczb hbd`cd lcmczc ~bf|e`|cfcd xb|xbdxr$
• Bdh rzb|
E|cd` ycd` fbd`ckzbz hcxclczb hbd`cd fbd``rdckcd zrcxr ~|e`|cf
c~oikczi ycd` xbocm hilrcx eobm ~|e`|cffb|$
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 8/10
=
Hcxc Lczb Fcdc`bfbdx Zyzxbf -HLFZ)
HLFZ chcocm ~b|cd`kcx ordck ycd` fbdcd`cdi zbfrc ~bd`ckzbzcd hcxclczb$
Fbf~rdyci aczioixcz fbflrcx/ fbd`ckzbz/ fbfcdi~roczi hcd fbfboimc|c lcziz
hcxc$
Lcmczc hcocf HLFZ chcocm7
3$ Hcxc Hbaidixied Ocd`rc`b -HHO)
Mczio kef~ioczi hc|i ~b|idxcm HHO chcocm zcxr zbx hc|i xclbo ycd`
hizif~cd hcocf aiob kmrzrz hizblrx hcxc hijxiedc|y%hi|bjxe|y$
<$ Hcxc Fcdi~rocxied Ocd`rc`b -HFO)
Lcmczc ycd` fbf~b|leobmkcd ~bfckci rdxrk fbd`ckzbz cxcr
fbfcdi~roczi hcxc zblc`ci ycd` xbocm hie|`cdizczikcd zblborfdyc hcocf
fehbo hcxc ycd` xb~cx$
Ard`zi HFLZ chcocm7
3$ Hcxc Hbaidixied/ HLFZ mc|rz hc~cx fbd`eocm ~bdhbaidizicd hcxc
<$ Hcxc Fcdi~rocxied/ HLFZ mc|rz hc~cx fbdcd`cdi ~b|fidxccd hc|i
~bfckci rdxrk fbd`ckzbz hcxc
:$ Hcxc Zbjr|ixy ! Idxb`|ixy/ HLFZ mc|rz hc~cx fbfb|ikzc zbjr|ixy hcd
idxb`|ixy hcxc ycd` hihbaidizikcd eobm HLC$
8$ Hcxc \bjeqb|y ! Jedjr|bdjy/ HLFZ mc|rz hc~cx fbdcd`cdi kb`c`cocd&
kb`c`cocd ~bd`ckzbzcd hcxclczb ycd` hc~cx hizblclkcd eobm kbzcocmcd
zizxbf/ kb|rzckcd hizk/ hoo$
2$ Hcxc Hijxiedc|y/ HLFZ mc|rz fbdybhickcd hcxc hijxiedc|y
1$ ^b|ae|fcdjb/ HLFZ mc|rz fbdcd`cdi rdgrk kb|gc hc|i zbfrc ard`zi
zbbaizibd frd`kid$
Kef~edbd HLFZ chcocm7
3$ Srb|y ^|ejbzze|/ kef~edbd ycd` fbd`rlcm lbdxrk srb|y kb hcocf
idzx|rkzi hcd kb hcocf hcxclczb fcdc`b|$
<$ Hcxclczb Fcdc`b|/ fbdb|ifc srb|y hcd fbd`rgi bkzxb|dco ! kedzb~xrco
rdxrk fbdbdxrkcd c~ckcm |bje|h&|bje|h xb|zblrx hilrxrmkcd rdxrk
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 9/10
9
fbfbdrmi ~b|fidxccd kbfrhicd hcxclczb fcdc`b| fbfcd``io aiob
fcdc`b| rdxrk fbdybobzcikcd ~b|fidxccd$
:$ Aiob Fcdc`b|/ fbfcdi~roczi ~bdyif~cdcd aiob hcd fbd`cxr| |rcd`
~bdyif~cdcd hizk$
8$ HFO ^|ejbzze|/ chcocm fehro ycd` fbd`rlcm ~b|idxcm HFO ycd`
hixbf~bokcd kb hcocf ~|e`|cf c~oikczi hcocf lbdxrk ard`zi&ard`zi$
2$ HHO Jef~iob|/ fb|rlcm zxcxbfbdx HHO fbdgchi krf~rocd xclob cxcr aiob
ycd` lb|izi hcxc hijixedc|y cxcr fbxchcxc
1$ Hijxiedc|y Fcdc`b|/ fbd`cxr| ckzbz hcd fbfboimc|c hcxc hijxiedc|y$
Xi~b Aiob
3$ Aiob Idhrk -fczxb| Aiob)
c$ aiob idhrk cjrcd -|bab|bdjb fczxb| aiob) 7 aiob idhrk ycd` |bje|hdyc |bocxia
zxcxiz/ gc|cd` lb|rlcm diocidyc$ Fizcodyc aiob hcaxc| `cgi/ aiob fcxc
~bocgc|cd$
l$ aiob idhrk hidcfik -hydcfij fczxb| aiob)7 aiob idhrk ycd` dioci hc|i |bje|h&
|bje|hdyc zb|id` lb|rlcm cxcr zb|id` hifrxckmi|kcd -r~hcxb) zblc`ci mczio
hc|i zrcxr x|cdzckzi$ Fizcodyc aiob idhrk hcxc lc|cd`/ ycd` zbxic~ zccx
mc|rz hi r~&hcxb lioc xb|gchi x|cdzckzi$
<$ Aiob X|cdzckzi -x|cdzcjxied aiob)
Aiob idi lizc hizblrx aiob id~rx; hi`rdckcd rdxrk fb|bkcf hcxc mczio hc|i
x|cdzckzi ycd` xb|gchi$ Fizcodyc aiob ~bdgrcocd ycd` lb|izi hcxc mczio x|cdzckzi
~bdgrcocd$
:$ Aiob Oc~e|cd -\b~e|x aiob)
Aiob idi lizc hizblrx erx~rx aiob/ ycixr aiob ycd` lb|izi idae|fczi ycd` ckcd
hixcf~iokcd$
8$ Aiob Zbgc|cm -mizxe|y aiob)
7/23/2019 TUGAS MANDIRI 3 - Data dan Basis Data
http://slidepdf.com/reader/full/tugas-mandiri-3-data-dan-basis-data 10/10
3>
Aiob idi lizc hizblrx aiob c|zi~ -c|jmiqco aiob)/ fb|r~ckcd aiob ycd` lb|izi
hcxc fczc ocor ycd` zrhcm xihck ckxia oc`i/ xbxc~i fczim hizif~cd zblc`ci c|zi~$
2$ Aiob ^boidhrd` -lcjkr~ aiob)
Aiob idi fb|r~ckcd zcoidcd hc|i aiob&aiob ycd` fczim ckxia hi hcocf hcxclczb
~chc zrcxr zccx xb|xbdxr$ Aiob idi hi`rdckcd zblc`ci ~boidhrd` cxcr jchcd`cd
lioc aiob hcxclczb ycd` ckxia fbd`cocfi kb|rzckcd cxcr miocd`$
\bab|bdzi7
Kchi|/ Clhro hcd Xb||c Jm$ X|ipcmyrdi$ <>>:$ ^bd`bdcocd Xbkdeoe`i Idae|fczi$
Ye`yckc|xc7 Cdhi$
mxx~7%%ppp$loe`xe~zixbz$jef%erx~ezx%a123b3j8>819=9=ha89j83>>b129j021
mxx~7%%coac|izy=9$pe|h~|bzz$jef%<>3>%>0%<8%c|zixbkxr|&lcziz&hcxc%