laporan akhir praktikum basis data tiket bioskop uii
Post on 11-Feb-2018
251 Views
Preview:
TRANSCRIPT
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
1/19
AF\CZFD FGOIZ
\ZFGRIGPN JF]I] BFRF
AFJCZFRCZIPN ]I]R@N IDECZNF]I BFD
Z@GFYF]F \@ZFDHGFR APDFG
JF]I] BFRF RIG@R JIC]GC\
F}i}r`d \`njinjidh ; Np}rigf B`ui F
Bi}p}pd Ca`o;
Dfnf#DIN ; B`zzy \fdh`}rp #
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
2/19
ii
OFAFNFD \@DH@]FOFD F]I]R@D
JF]I] BFRF RIG@R JIC]GC\
R`afo Bi|`zrfofdgfd bi B`|fd ]ibfdh \`dhpki
Bifkpgfd ]`jfhfi ]fafo ]frp ]yfzfr
Pdrpg N`d`n|po Pkifd Z`}|cd}i \zfgrigpn
Kchkfgfzrf! :? B`}`nj`z :
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
3/19
iii
OFAFNFD \@Z]@NJFOFD
Faofnbpaaiafo! frf} i{id bfd zfonfr Faafo ]XR gfni bf|fr n`dy`a`}figfd
af|czfd\zchfnnidh \zck`mrgfni yfdh j`zkpbpa bfrf jf}` rig`r jic}gc|
\zchzfnnidh \zck`mr gfni }p}pd }`jfhfi rphf} fgoiz |zfgrigpn jf}i} bfrf
bfd n`zp|fgfd afriofd jfhi gfni bfafn n`d`zf|gfd r`czi.r`czi yfdh bibf|fr bi
bfafn |zfgrigpn nfp|pd bi |`zgpaifofd$
Gfni n`dyfbfzi bfafn n`njpfr |zchzfnnidh |zck`mr idi gfni }`afap
n`dbf|fr jfdrpfd bfzi j`zjfhfi |iofg yfdh }`afap n`nj`zi gfni |`rpdkpg bfd
jinjidhfd }`oidhhf |zchzfnnidh |zck`mr idi bf|fr r`z}`a`}figfd! ca`o gfz`df irp
gfni idhid n`n|`z}`njfogfd|zchzfnnidh |zck`mridi g`|fbf ;
6$ Faafo ]XR yfdh r`afo n`nj`zigfd g`}`ofrfd bfd g }`n|frfd }`oidhhf
bf|fr n`dy`a`}figfd |zfgrigpn bfd af|czfd }fn|fi fgoiz b`dhfd r`|fr
xfgrp
:$ Czfdh rpf gfni yfdh }`afap n`nj`zigfd bpgpdhfd jfig nczia nfp|pd
nfr`zia$
=$ Np}rigf B`ui! }`afgp f}i}r`d |zfgrigpn jf}i} bfrf yfdh r`afo
n`njinjidh gfni oidhhf gfni bf|fr n`dh`zri bfd bf|fr n`dh`zkfgfd
|zchzfnnidh |zck`mridi oidhhf }`a`}fi b`dhfd jfig
2$ R`nfdr`nfd yfdh r`afo n`nj`zigfd }`nfdhfr bfd jfdrpfd } afnf
n`dh`zkfgfd|zchzfnnidh |zck`mridi$
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
4/19
iu
OFAFNFD NCRC
]`rif| p}fof yfdh biafgpgfd |f}ri n`njpfogfd of}ia! xfafp|pd of}iadyf ribfg
afdh}pdh girf r`npgfd }`g`rigf
ribfg fbf }`}pfrp yfdh ribfg npdhgid
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
5/19
u
GFRF \@DHFDRFZ
F}}fafnpfafigpn Xz$ Xj$
\pki }ypgpz }`afap girf |fdkfrgfd g`|fbf Faafo ]XR yfdh r`afo n`ain|fogfd
zfonfr bfd oibfyfo g`|fbf girf }`npf$ J`hirp kphf }ofafxfr bfd }fafn girf
ofrpzgfd g`|fbf kpdkpdhfd girf dfji Npofnnfb ]FX$
\zchzfnnidh |zck`mridi gfni }p}pd pdrpg n`n`dpoi }yfzfr n`dhigpri pkifd
z`}|cd}i |zfgrigpn fahczirnf |`nchzfnfd 6! }`afid irp rphf} idi n`zp|fgfd afriofd
jfhi gfni bfafn n`d`zf|gfd r`czi.r`czi fahczirnf bfd |`nzchzfnfd bi bfafn
|`zgpaifofd nfp|pd |zfgrigpn$
Gfni n`dyfbfzi jfoxf |zchzfnnidh |zck`mr idi ribfg bf|fr r`z}`a`}figfd
rfd|f jfdrpfd bfd jinjidhfd }`zrf |`rpdkpg bfzi j`zjfhfi |iofg$ Gfni n`dyfbfzi
jfoxf bfafn n`dy`a`}figfd rphf} idi nf}io jfdyfg g`gpzfdhfd! ca`o gfz`df irp
gfni } afap n`dhofzf|gfd gzirig bfd }fzfd yfdh n`njfdhpd hpdf a`jio
}`n|pzdfdyf af|czfd gfni idi bfd j`znfdeffr jfhi }if|f }fkf yfdh
n`njprpogfddyf$
Ychyfgfzrf! :6 B`}`nj`z :
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
6/19
ui
RFGFZIZ
Mz`fr` n`njpfr
Bfrfjf}` jf}i} bfrf
B`a`r` of|p}
@driry Z`africd}oi| Bifhzfn bifhzfn opjpdhfd#z`af}i
fdrfz `drirf}
Id}`zr n`nf}pggfd
\zidr}mz``d mp|aigfd hfnjfz
\zchzfnnidh \zck`mr |zcy`g |`nzchzfnfd
]mzi|r gcb` |zchzfn
Rfja` rfj`a
P|bfr` n`njfzpi
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
7/19
uii
BFERFZ I]I
Ofafnfd Kpbpa $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ i
Ofafnfd \`dh`}fofd $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ ii
Ofafnfd \`z}`njfofd$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ iii
Ofafnfd Ncrrc $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ iu
Gfrf \`dhfdrfz $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ u
Rfgfziz$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ ui
Bferfz I}i $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ uii
JFJ I$ \@DBFOPAPFD
6$6 B`}gzi|}i Nf}fafo $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 6
6$: Jfrf}fd Nf}fafo $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ :
JFJ II$ OF]IA BFD \@NJFOF]FD
:$6 B`}fid @ZB$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ =
:$: ]rzpzgrpz rfj`a$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 2
:$= Z`af}i rfj`a$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 5
JFJ III$ G@]IN\PAFD
=$6 G`}in|pafd$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ ?
=$: Gzirig$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ ?
Bferfz \p}rfgf $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ uiii
Afn|izfd $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$i
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
8/19
JFJ I
\@DBFOPAPFD
6$6 B`}gzi|}i Nf}fafo
\fbf \\ jf}i} bfrf idi gfni n`dhfnjia BJ rig`r jic}gc| yfdh n`dyin|fd
bfrf.bfrf rig`r jic}gc| }`}pfi b`dhfd kpbpa eian bfd gfr`hczi j`}`zrf of}ia |`dkpfafd$ Cjk`g.cjk`g yfdh bi |`zapgfd bfafn BJ idi }|`zri k`di} rig`r! g`r`hczi! |`hfxfi!
}rpbic! |`dkpfafd!|`dcdrcd! eian! b`rfia |`dkpfafd!gpz}i!kfbxfa eian$
K`di} rig r n`dmfgp| j`zbf}fzgfd gfr zchi ofzi jif}f frfp aijpz
/z`hpafz#x``g`db)$ Gfr`hczi n`dmfgp| j`zbf}zgfd pnpz |`dcdrcd bi gfr`hczigfd
b`dhfd b`xf}f! fdfg.fdfg! bfd z`nfkf$ \`hfxi n`afyfdi |`dcdrcd yfdh n`dbfrf
b`frfia |`dkpfafd$ ]rpbic n`dmfgp| dfnf bfd ib }rpbic$ \`dkpfafd j`zi}i g`r`zfdhfd
k`di} rig`r bfd kpnafo rig`r yfdh r`zkpfa bfafn 6 ofzi j`zbf}fzgfd ib |`dkpfafd$
\`dcdrcd j`zi}i ib |`dcdrcd bfd ib k`di} rig`r yfdh bi |`}fd }`zrf dfnf! pnpz bfd
k`di} g`afnid$ Eian n`dmfgp| ibeian! kpbpa! ib gfr`hczi!ib }rpbic }`zrf xfgrp
|`dfyfdhfd$ B`rfia |`dkpfafd! bfrf yfdh j`zi}i ib |`dkpfafd yfdh bi rfdhfdi ca`o
}frp |`hfxfi b`dhfd bfrf rcrfa rig`r yfdh r`zkpfa$ Gpz}i j`zi}i dfnf gpz}i yfdh bi
}`}pfigfd b`dhfd ib k`di} rig`r! ib }rpbic! bfd ib gpz}i$ Kfbxfa eian n`dmfgp| ib
|`dcdrcd! ib eian yfdh fgfd bi rcdrcd! }`zrf rfdhhfa bfd kfn rfdyfdh bfzi eian
r`z}`jpr$
]`kfg j`zg`njfdh dyf bpdif |`zeianfd n`nfmp gfni pdrpg n`njpfr BJ
rig`r jic}gc|$ Gidi bpdif |`zeianfd bi idbcd`}if }`bfdh j`zg`njfdh mpgp| |`}fr$
Irp bi aiofr bfzi jfdyfg yf eian eian gfzyf fdfg jfdh}f yfdh mpgp| j`zgpfairf}
yfdh nfn|p j`z}fidh b`dhfd eian.eian bfzi jfzfr$
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
9/19
:
6$: Jfrf}fd Nf}fafo
Jfrf}fd nf}fafo
\`nj`ai rig`r n`dcdrcd }`}pfi pnpz bfd gfr`hczi eian
6 czfdh nfg}infa n`nj`ai 0 rig`r
Bpbpgdyf }`}pfi dc gpz}i yfdh r`zmfdrpn bi rig`r
R`zbf|fr bfrf.bfrf yfdh n`ai|pri dc$ R`fr`z! kpbpa
eian!ofzhf!kfn!dc gpz}i!ofzhf$
R`zbf|fr 0 jpfo r`fr`z yfdh }`rif| kfn n`nprfz eian yfdh j`zj`bf$
Ofzhf x``g`db =
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
10/19
=
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
11/19
JFJ II
OF]IA BFD \@NJFOF]FD
:$6 B`}fid @ZB
K` d i}Srig ` r \ ` d kp f af d
P n p z
` n f ia
D f n fS| ` h f x f i
N ` n j ` ai
B i| p rf z
G ` r` z f d h f d
O f z h f
Z ` h p af z
Ib r ig` r
P n p z
D f n f
Ib \ ` d c d rc d
N ` aio f r\ ` d c d r c d K f b x f aSeia n
R f d h h f a K f nSr f y f d h
G ` r` z f d h f d
K` d i}Sg` a f n id
e i anN ` d f yf d h g f d
Kp n af o
R c rf a
Ib | d kp f af d
G f r` h c z i
K` d i}Sg` a f n id
n ` d b f | f rg f d
N ` d mf gp |
\ ` h f x f ib ij ` z igf d\ ` af yf d f d
Ib }r p b ic
D f n fSgp z } i
D f n fS}r p b ic
B ` rf iaS| ` d kp f af dn ` d b f rf
N ` ai| p ri
] rp b icb in ia igi
G p z }iN ` n | p d yf i
I bSG f r ` h c z i D f n fSgf r ` h c z i
Ib | ` h f x f i
D f n f
Ib ei anKp b p a
R c rf aR f d h h f a
n
6
6 n 6 n
n
6
n
6
6
6
6
n
n
6
n6
n 6 6n
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
12/19
2
:$: ]rzpgrpz Rfj`a
6$ K`di} Rig`r
Dfnf gcacn Ri|` Bfrf G`r`zfdhfd
IbSk`di}Srig`r
dfnf
ofzhf
Dpnj`z
Ufzmofz
dpnj`z
Rfj`a :$6 K`di} rig`r
:$ Gfr`hcziDfnf gcacn Ri|` Bfrf G`r`zfdhfd
ibSgfr`hczi
dfnfSgfr`hczi
Dpnj`z
Ufzmofz
Rfj`a :$: Gfr`hczi
=$ \`hfxfi
Dfnf gcacn Ri|` Bfrf G`r`zfdhfd
ibS|`hfxfi
dfnfS|`hfxfi
pnpz
`nfia
k`di}Sg`afnid
Dpnj`z
Ufzmofz
Ufzmofz
Ufzmofz
Ufzmofz
Rfj`a :$= \`hfxfi
2$ ]rpbic
Dfnf gcacn Ri|` Bfrf G`r`zfdhfd
ibS}rpbic
dfnfS}rpbic
Dpnj`z
Ufzmofz
Rfj`a :$2 ]rp}ic
0$ \`dkpfafd
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
13/19
0
Dfnf gcacn Ri|` Bfrf G`r`zfdhfd
ibS|`dkpfafd
g`r`zfdhfd
kpnafo
rcrfa
Dpnj`z
Ufzmofz
Ufzmofz
Ufzmofz
Rfj`a :$0 \`dkpfafd
5$ \`dcdrcd
Dfnf gcacn Ri|` Bfrf G`r`zfdhfd
ibS|`dcdrcd
dfnf
pnpz
k`di}Sg`afnid
Dpnj`z
Ufzmofz
Dpnj`z
ufzmofz
Rfj`a :$5 \`dcdrcd
8$ \`afyfdfd
Dfnf gcacn Ri|` Bfrf G`r`zfdhfd
G`r`zfdhfd Ufzmofz
Rfj`a :$8 \`afyfdfd
?$ Eian
Dfnf gcacn Ri|` Bfrf G`r`zfdhfd
ibSeian
kfbxfa
xfgrp
Dpnj`z
Ufzmofz
ufzmofz
Rfj`a :$? Eian
9$ B`rfia |`dkpfafd
Dfnf gcacn Ri|` Bfrf G`r`zfdhfd
rfdhhfa
rcrfa
Ufzmofz
ufzmofz
Rfj`a :$9 B`rfia |`dkpfafd
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
14/19
5
6
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
15/19
8
rig`r! k`di} rig`r n`niagi gfzbidiafrif} cd` rc nfdy /6;d) |fbf |`dcdrcd$ \`dcdrcd
n`niagi gfzbidfairf} cd` rc nfdy /6;d) |fbf |`afyfdfd! |`afyfdfd n`niaigi
gfzbidfairf} cd` rc nfdy /6;d) |fbf |`hfxfi! g`npbifd |`hfxfi
n`niaigi gfzbidfairf} cd` rc nfdy /6;d) |fbf b`rfia |`dkpfafd! b`rfia |`dkpfafd
n`niaigi gfzbidfairf} cd` rc nfdy /6;d) |fbf |`dkpfafd$
\fbf `drirf} |`dcdrcd r`zbf|fr frzijpr ib k`di} rig r n`zp|fgfd ecz`ihd g`y
yfdh n`dhopjpdhgfd k`di} rig`r b`dhfd kfbxfa eian$ \fbf `drirf} gpz}i r`zbf|fr ib
}rpbic bfd ib k`di} rig`r yfdh n`zp|fgfd ecz`ihd g`y yfdh n`dhopjpdhgfd `drirf}
}rpbic b`dhfd gpz}i }`zrf `drirf} gpz}i b`dhfd k`di} rig`r$ G`npbifd |fbf `drirf}
eian r`zb|fr ib }rpbic bfd ib gfr hczi yfdh kphf n zp|fgecz`ihd g`y yfdh
n`dhopjpdhgfd `drirf} eian bfd `drirf} gfr`hczi kphf `drirf} eian bfd `drirf}
}rpbic$
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
16/19
?
Hfnjfz :$: Z`af}i Rfj`a
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
17/19
JFJ III
G@]IN\PAFD BFD ]FZFD
=$6 G`}in|pafd
Bfzi of}ia |`njfof}fd }`j`apndyf! nfgf gfni bf|fr n`dyin|pagfd jfoxf
jf}i} bfrf yfdh gfni jpfr yfirp r`drfdh Rig`r Jic}gc| ofdyf }`jpfo |`znfidfd
pdrpg n`dhf}fo crfg bfd bf|fr n`dfnjfo ianp |`dh`rfopfd$
Of}ia bfd |`njfof}fd yfdh r`afo fbf |fbf jfj }`j`apndyf! j`j`zf|f hfnjfz
bfd j`zp|f }mzi|r gfni rfn|iagfd fhfz bi|`afkfzi
=$: Gzirig
6$ ]`zidh dyf |fzf f}i}r d afj }izg`a bfafn n dk`af}gfd gpzfdh npbfo bi
|fofni bfafn |`njfof}fffd dyf bfd r zafap m`|fr n`d zfdhgfd
:$ ]`zidh dyf r`zkfbi hfdhpfd kfzidhfd }ffr |zfgrigpn
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
18/19
uiii
BFERFZ \P]RFGF
Afjczfrczipn ]i}r`n Idecznf}i Bfd Z`gfyf}f \`zfdhgfr Apdfg! Ncbpa \zfgrigpn
Jf}i} Bfrf :
-
7/23/2019 laporan akhir praktikum basis data Tiket Bioskop UII
19/19
i
AFN\IZFD
6$ A`njfz f}i}r`d}i I bfd II yfdh r`afo bi FMM ca`o f}i}r`d |`njinjidh g`rigf
f}i}r`d}i bi}`zrfgfd b`dhfd af|czfd$
:$ MB yfdh j`zi}i}cpzm` mcb`|zchzfn bfd}cermc|y af|czfd bfafn ecznfr |be$
top related