Download - Bab 3 DataBase Relasional.pptx

7/21/2019 Bab 3 DataBase Relasional.pptx

1/14

BASIS DATA RELASIONAL

Kelompok 2


2/14


Awliya Wanhari Adjie Fabiansyah H Ivan Gu

(11140910000023) (1114091000001) (111409


3/14


1. DEFINISI BASIS DATA RELASIONAL

2. BASIS DATA MDK

3. OPERASI DAN BAHASA BASIS DATA

4. RELASI ANTAR TABEL

5. BASIS DATA YANG BAIK


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,


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


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/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


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


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$)$#"#


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


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$


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


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 '$#"# &$%


14/14

A!0 :/e#%"o!

Download - Bab 3 DataBase Relasional.pptx

Top Related