bab 3 database relasional.pptx
TRANSCRIPT
-
7/21/2019 Bab 3 DataBase Relasional.pptx
1/14
BASIS DATA RELASIONAL
Kelompok 2
-
7/21/2019 Bab 3 DataBase Relasional.pptx
2/14
BASIS DATA RELASIONAL
Awliya Wanhari Adjie Fabiansyah H Ivan Gu
(11140910000023) (1114091000001) (111409
-
7/21/2019 Bab 3 DataBase Relasional.pptx
3/14
BASIS DATA RELASIONAL
1. DEFINISI BASIS DATA RELASIONAL
2. BASIS DATA MDK
3. OPERASI DAN BAHASA BASIS DATA
4. RELASI ANTAR TABEL
5. BASIS DATA YANG BAIK
-
7/21/2019 Bab 3 DataBase Relasional.pptx
4/14
De!"#" B$#"# D$%$ Rel$#"o!$l
P$&$ mo&el Rel$#"o!$l '$#"# &$%$ $k$! disebar (&"p"l$)*p
&$l$m 'e,'$-$" %$'el 2 &"me!#". Se%"$p %$'el %e,&"," $%$# l$/, m0$!- &"#e'/% &e!-$! Baris Data (Row), &$! l$/, e,%"k$l 0$!- &e!-$!Kolom (Column). D"#e%"$p pe,%em/$! '$,"# &$! kolom "%/l"%em &$%$ &"%emp$%k$!. o!%o) '$#"# &$%$ 0$!- #e,"!- k"%$ '/%$'el. B$#"# &$%$ ,el$#"o!$l "!" &"%em/k$! ole) E.F. o&&.
!%/k mem'/$% #e'/$) '$#"# &$%$ %e!%/!0$ k"%$ $k$! memp#o%$,e 0$!- k)/#/# /!%/k '$#"# &$%$. So%$,e "!" '"$#$!0$ Sistem Pengelola Basis Data (DataBase Management Systemo!%o) #o%$,e!0$ $&$l$) &B$#e III67 MS*A88e##7 Bo,l$!&*P$,$&o9o,$8le M0S:L. Pe,'e&$$! &$," #o%$,e*#o%$,e %e,#e'/% $&$l$pem$k$"$! &$! kele!-k$p$! /!-#" 0$!- $&$ &" &$l$m #o%$,e %e,
-
7/21/2019 Bab 3 DataBase Relasional.pptx
5/14
DATABASE MANAGEMENT SYSTEM
DBMS me!-elol$#/m'e, &$0$ &$%$#e'$-$"m$!$ o!eratingsystem(OS+ me!-elol$#/m'e, &$0$ pe,$!-k$%ke,$#
DBMSDBMS Basis datasebagai pusatdata organisas
Aplikasi1
Aplikasi2
Aplikasi3
-
7/21/2019 Bab 3 DataBase Relasional.pptx
6/14
Komponen DBMS
Perangkat Keras (Hardware)Komputer, memori, storage (Harddisk), peripheral, dll.Sistem Operasi (Operating System)
Program yang menjalankan sistem komputer, mengendalikresource komputer dan melakukan berbagai operasi dasarsistem komputer.
asis !ata (!atabase)"enyimpan berbagai obyek database (struktur tabel, indeks,dll
!"S (!atabase "anagement System)Perangkat lunak yang memaintain data dalam jumlah besar.
Pemakai (#ser)Para pemakai database.
$plikasi (perangkat lunak) lain.Program lain dalam !"S.
-
7/21/2019 Bab 3 DataBase Relasional.pptx
7/14
2. B$#"# D$%$ MDK
!%/k me!-"l/#%,$#"k$! Mo&el D$%$ Rel$#"o!$l #e8$,$ le'") !0$%$7k$m" $k$! mem'/$% &$%$ 0$!- 'e,"#" %"-$ %$'el7 0$"%/ %$'elM$)$#"#$7 Do#e!7 &$! M$%$ K/l"$).
$. T$'el M$)$#"#$
"I# "a$a#ahasiswa
Ala$at %an&&al 'ahir
1114
-
7/21/2019 Bab 3 DataBase Relasional.pptx
8/14
'. T$'el Do#e!
8. T$'el M$%$ K/l"$)
"a$a sen #ata *uliah
S"%" mm" M$#,/,o)7 M. S8 S"#%em B$#"# D$%$
N/,)$0$%"7 P.)D S%,/k%/, D$%$ &$! Al-o,"%m$
*de #ata *uliah +*+
INF 3
-
7/21/2019 Bab 3 DataBase Relasional.pptx
9/14
D$," &$%$ 0$!- %el$) k$m" '/$%7 &"%em/k$! #%,/k%/, &$l$m %$'el%e,#e'/%7 &"$!%$,$!0$ $&$l$) N$m$ Kolom7 T"pe D$%$7 &$! Le'$,(B$!0$k!0$ K$,$k%e,+. !%/k !$m$ kolom '"$#$!0$ &"#e#/$"k$!&e!-$! !$m$ kolom &$," 8o!%o) &$%$7 %e%$p" pe!$m$$! "%/ )$,/#&"/'$) k$,e!$ p$!$!- kolom DBMS '"$#$!0$ &"'$%$#"
(pem'$%$#$!!0$ 'e,'e&$*'e&$ m$#"!-*m$#"!- DBMS+ &$! )$,/#&"!0$%$k$! &$l$m #$%/ k$%$ ('"$#$!0$ k$l$/ mem$k$" #p$#" &"-$!%&e!-$! /!&e,#8o,e @+.
B$"kl$) "!" $k%$ 0$!- %el$) k$m" #"mp/lk$! &$," m$#"!-*m$#"!-&$%$7 #%,/k%/, &$," ke%"-$ %$'el &$l$m '$#"# &$%$ MDK $&$l$) C
1. T$'el M$)$#"#$
"a$a *l$ %i,e ata 'ebar-ntu. #ena$,un
ata
NIM )$,$8%e, 14 Nomo, I!&/k M$)$#"#
N$m$M)# )$,$8%e, 3< N$m$ M$)$#"#$
Al$m$%M)# )$,$8%e, ;< Al$m$% M$)$#"#$
T-lL$)", D$%e T$!--$l L$)", M$)$#"#
-
7/21/2019 Bab 3 DataBase Relasional.pptx
10/14
2. T$'el Do#e!
3. T$'el M$%$ K/l"$)
"a$a *l$ %i,e ata 'ebar-ntu. #ena$,u
ataN$m$Do#e! )$,$8%e, 3< N$m$ Do#e!
M$%$K/l"$) )$,$8%e, 3< N$m$ M$%$ K/l"$)
"a$a *l$ %i,e ata 'ebar -ntu. #ena$,uata
Ko&e )$,$8%e, Ko&e M$%$ K/l"$)
M$%$K/l"$) )$,$8%e, 3< N$m$ M$%$ K/l"$)
SKS I!%e-e, 1 >/ml$) SKS
-
7/21/2019 Bab 3 DataBase Relasional.pptx
11/14
3. Ope,$#" &$! B$)$#$ B$#"# D$%$Ope,$#"*ope,$#" 0$!- '"$#$ &"l$k/k$! &$l$m '$#"# &$%$ mel"p/%D$%$ ("uery)7 Pe!-/'$)$! D$%$ (#!date/$dit)7 &$! Pe!-)$p/#$!
Se8$,$ /m/m $&$ &/$ m$8$m 8$,$ /!%/k me!$l$!k$! ope,$#&$%$7 0$"%/ C
a/ #enjalan.an ,r&ra$ .husus untu. $ela.u.an ,erasiseara intera.ti
P,o-,$m #em$8$m "!" /m/m!0$ &"#e&"$k$! ole) #e%"$p DBmem/&$)k$! user&$l$m mel$k/k$! pe!-ope,$#"$! &$%$. Kem/&
&$p$% 'e,'e!%/k pe!0e&"$$! me!/ (/!%/k DBMS 0$!- 'e,'$#"# %e'$)k$! &"%$m'$) &e!-$! pem$!$$%$! pe,$!-k$% mouse(DBMS -,$#+.
b/ #en&&una.an bahasa basis data (Data Language/DBMS)
De!-$! '$)$#$ '$#"# &$%$7 /#e, )$,/# mel$k/k$! ope,$#"*
&$%$ 0$!- 'e,l$k/ k)/#/# /!%/k #/$%/ DBMS7 #epe,%" '$)$#$ &B$
-
7/21/2019 Bab 3 DataBase Relasional.pptx
12/14
4. Rel$#" A!%$, T$'el
!%/k mem'e!%/k #e'/$) '$#"# &$%$7 k"%$ )$,/# mele!-k$p" #/$%/
0$!- l$"!!0$ 0$!- memp,e#e!%$#"k$! ke%e,)/'/!-$! (Relasi)$!%$8o!%o)!0$ C
$. D$%$ N"l$"
. D$%$ !"l$" "!" me!/!/kk$! ,el$#" $!%$,$ &$%$ m$)$#"#$ &e!-$!k/l"$) 0$!- &""k/%" ole) m$)$#"#$ &$! )$#"l!0$ "!&ek# p,e#%$#" #e#/$" &e!-$! m$%$ k/l"$).
. S$%/ m$%$ k/l"$) &$p$% &"$m'"l le'") &$," #$%/ m$)$#"#$
#ata *uliah "I# "a$a#ahasiswa
In
S"#%em B$#"# D$%$ 1114
-
7/21/2019 Bab 3 DataBase Relasional.pptx
13/14
5. B$#"# D$%$ 0$!- B$"k
!%/k mem'/$% '$#"# &$%$ 0$!- '$"k %e,le'") &$)/l/
memp/!0$" #/$%/ ,$!8$!-$! '$#"# &$%$ %e,#e'/% $-$, e#"e!. Be,"k/% k$,$k%e,"#%"k &$! ke/!%/!-$! "k$ '$#"# &$%&$! e#"e! C
1. S%,/k%/, B$#"# D$%$ (%$'el*%$'el &$! ,el$#" $!%$, %$'el+komp$k.
2. S%,/k%/, m$#"!-*m$#"!- %$'el 0$!- le'") e#"e! &$! #"#%e
3. Ke'/%/)$! ,/$!- pe!0"mp$!$! &$%$ (memo," #ek/!&e,e#"e!.
4. Sem$k"! ke8"l (e#"e!#"+ /k/,$! %$'el7 m$k$ $k$! #emope,$#" '$#"# &$%$ 0$!- k"%$ l$k/k$!
5. E#"e!#" %e,#e'/% &"%$!&$" &e!-$! ,e&/!&$!#" &$%$ 0$!- o
;. T"&$k $&$ $m'"-/"%$# &$%$ &"#em/$ %$'el &$l$m '$#"# &$%
-
7/21/2019 Bab 3 DataBase Relasional.pptx
14/14
A!0 :/e#%"o!