sistem basis data (after mid)

8/18/2019 Sistem Basis Data (After Mid)

1/28

SISTEM BASIS DATA(After MID)

Fidia Deny Tisna Amijaya

Program Studi StatistikaFakultas Matematika dan Ilmu Pengetahuan

Alam

Universitas Mulaarman


2/28

Materi!

1. PERANCANGAN DATABASE

2. KONSEP PEMBUATAN PROGRAM & PENGENALANKOMPONEN DELPHI

3. PROSEDUR DATABASE

4. QUICK REPORT

5. FINAL PROJECT*


3/28

Final Project*

Timeta"le Pert#$%

Pert#$$

Pert#$&

Pert#$'

Pert#$

Pert#$

Perancanan !a"a#a$e

%S"!' (a$$) Penen"anEn"'"a$)ERD*

Rancanan In"er+acePr,ra-

Pr,$e!r "a-#a) a/$)car') e!'"

Q'c( Re/,r"


4/28

Final Project*

Gar'$ Be$ar Final Project 0

1. S"!' (a$$

2. Pe-#en"(an en"'"a$ !an a"r'#"a"r'#"na

3. Pe-#a"an ERD

4. Pe-#a"an Pr,ra-

. Ea5a$'


5/28

Final Project*

C,n", Te-a0

1. Da"a#a$e RBS

2. Da"a#a$e Pra("'(-

3. Da"a#a$e /ena-#'5an $(r'/$' !an PKL

4. Da"a#a$e /e-'n6a-an ran

. Da"a#a$e P$a" Ana5'$'$ S"a"'$"'(a

7. Da"a#a$e R-a Sa('"

8. Da"a#a$e Ban(

9. Da"a#a$e Per$aaan


6/28

PE*A+,A+-A+ DATABASE

S"!' Ka$$

D'!a5a- Ran Baca S"a"'$"'(a %RBS* "er!a/a"0!a+"ar a!-'n) !a+"ar #() !a+"ar an,"a) !an !a+"ar/e-'n6a-an #(. A!-'n #er"a$ n"( -ena"r$e-a a5 an "er!a/a" !a5a- RBS. B( RBS #era$a5

!ar' #er-aca--aca- $-#er) #'$a !ar' $-#anan-aa$'$:a) !,$en !55. An,"a RBS $'+a"na #e#a$)ar"'na $'a/a/n #,5e -an6a!' an,"a RBS !enancara -en!a+"ara(an !'r' "er5e#' !a5. Pe-'n6a-an#( ana #,5e !'5a((an ,5e an,"a RBS an

"er!a+"ar. Ba"a$ /ene-#a5'an #( -a($'-a5 a!a5a 3ar' $e"e5a "ana5 /e-'n6a-an. A/a#'5a 5e#' !ar' 3ar' a(an !'(ena(an !en!a. Per'"nan !en!a RBSa!a5a 6-5a ar' (e"er5a-#a"an !'(a5'(an 1;;;.


7/28


Penen"an En"'"a$

En"'"a$ an "er!a/a" !a5a- RBS -e5'/"'0

1. A!-'n

2. B(

3. An,"a

Se!an(an En"'"a$ an -en#n(an(e$e5ran en"'"a$ %re5a$'* -e5'/"'0

1. Pe-'n6a-an


8/28


Penen"an A"r'#" !ar' En"'"a$

En"'"a$ an "er!a/a" !a5a- RBS-e5'/"'0

1. A!-'n) A"r'#"na0

a* K,!e A!-'n %S"r'nen'$ Ke5a-'n %S"r'n


9/28


Entity Relational Database %ERD*


10/28


Ta#e5"a#e5 an a(an !'#a" !a5a- !a"a#a$e

Ta#e5 A!-'n

Ta#e5 B(

.odeAdmin

+amaAdmin

Passord

.odeBuku

/udulBuku

Pengarang

Pener"it

TahunTer"it

.otaTer"it

.ategor

i

Tanggal

Masuk

Sum"er .etersedi

aan


11/28


Ta#e5"a#e5 an a(an !'#a" %5an6"an*

Ta#e5 An,"a

Ta#e5 Pe-'n6a-an

+oAnggota

+IM

+ama

Tem0at1ahir

Tanggal1ahir

/enis.elamin

Alamat 2P Instansi3Prodi Status

+o

Transaksi

+o

Anggota

.ode

Buku

Tanggal

Pin4am

Tanggal

Pengem"alian

Tangg

al.em"ali

Denda .odeAdmin


12/28


Ta$ 1

1. Ba"5a S"!' Ka$$ !enan "e-a an -enar'(

2. Ten"(an En"'"a$En"'"a$ an a!a !a5a- (a$$"er$e#"

3. Ten"(an A"r'#"A"r'#" $,a5 N,. 2

4. Ba"5a ERD #er!a$ar(an N,. 2 !an N,. 3

. Ba"5a Ta#e5Ta#e5 an a(an !'#a" !a5a-!a"a#a$e $e$a' !enan N,. 2)3)4


13/28

.5+SEP PEMBUATA+ P*5-*AM 6 PE+-E+A1A+

.5MP5+E+ DE1P2I

K,n$e/ Pe-#a"an Pr,ra-

Secara -- n"( -e-#a" /r,ra- !a"a#a$e"er!a/a" 3 e5e-en) a'"0

1. Me-#a" K,n$e/ Da"a#a$e %ERD*

2. Me-#a" Da"a#a$e %M$ Acce$$) a-//*

3. Me-#a" In"er+ace Pr,ra- %De5/') '$a5Ba$'c) MSQL*

In"er+aceDa"a#a$e

ERD


14/28


.5MP5+E+ DE1P2I

1. K,n$e/ !a"a#a$e !'na(an n"( -en$n

(eran(a /r,ra- !a"a#a$e an a(an !'#a".

2. Da"a#a$e !'na(an n"( -en'-/an !a"a!ar' /r,ra- !a"a#a$e an a(an !'#a"

3. In"er+ace /r,ra- !'na(an n"( -e-#a"

"a-/'5an /r,ra- !a"a#a$e $e$a' (e'n'nan/enna %user *


15/28


.5MP5+E+ DE1P2I

Pe-#a"an !a"a#a$e

Da"a#a$e a!a5a #a$'$ !a"a %"e-/a" #er(-/5na!a"a*. Sa" #a$'$ !a"a !'$$n ,5e #er-aca--aca- "a#e5. Sa" "a#e5 !'$$n ,5e #er#aa'-aca- !a"a. Sa" !a"a !'$$n ,5e #er#aa'

-aca- a"r'#"a"r'#".

Da5a- (5'a 'n' #a$'$ !a"a a(an !'#a" !enan M$.Acce$$ !enan a5a$an (e-!aan /r,$e$

a($e$'#'5a"a$ !a"a.


16/28


.5MP5+E+ DE1P2I

Pr,$e!r /e-#a"an !a"a#a$e !enan M$ Acce$$0

1. B(a M$ Acce$$

2. O/"',n) Genera5) Crea"'n !a"a#a$e) a"r !e+a5" 5e+,r-a" +,r #5an( !a"a#a$e -en6a!' Acce$$ 2;;2 2;;3 %6'(a M$ Acce$$ an !'na(an M$ Acce$$

2;1; (ea"a$) 'n' !'5a((an aar !a"a#a$e an !'#a"#'$a !'a($e$ ,5e M$ Acce$$ 2;1; (e#a:a*) ,(

3. B5an( !a"a#a$e

Un"( -e-#a" "a#e50 crea"e) "a#5e

Un"( -erena-e "a#e50 (5'( (anan "a#5e) rena-e

Un"( -en!e$a'n "a#e5 $e$a' a"r'#" an a(an!'na(an0 (5'( (anan "a#5e) !e$'n "a#5e


17/28


.5MP5+E+ DE1P2I

K,-/,nen(,-/,nen De5/' an !'na(an n"(

/e-#a"an !a"a#a$e

Da5a- /r,ra- !e5/' "er!a/a" #e#era/a(,-/,nen an #'$a !'na(an n"( -e-#a"/r,ra- !a"a#a$e) !'an"arana0

1. ADO %Ac"'e Da"a O#6ec"*

A!a5a -,!e5 a($e$ !a"a an !'na(an n"(#er'n"era($' !enan !a"a#a$e. K,-/,nen(,-/,nen ADO an #'$a !'na(an0

a. ADO C,nnec"',n) !'na(an n"(-en#n(an !a"a#a$e !ar' M$ Acce$$ (e De5/'a"a -e-#aca !a"a !ar' M$ Acce$$ (e De5/'.


18/28


.5MP5+E+ DE1P2I

#. ADO Ta#5e) !'na(an n"( -e-#aca "a#e5

"a#e5 !a5a- !a"a#a$e M$ Acce$$.

c. ADO Qer) !'na(an n"( -e-a$((an/er'n"a/er'n"a SQL !a5a- !a"a#a$e M$. Acce$$.

ADO Qer

ADO

Ta#5eADO C,nnec"',n


19/28


.5MP5+E+ DE1P2I

2. Da"a Acce$$

a!a5a (,-/,nen #aanan?n,n '$a5. Da"aAcce$$ !'na(an n"( -en#n(an ADO!enan Da"a C,n"r,5. K,-/,nen(,-/,nen !a"aacce$$ an #'$a !'na(an0

Da"a$,rce) !'na(an $e#aa' $-#er !a"a)"en"na 6'(a !a"a$,rce 'n' "er#n !enan!a"a#a$e -a(a !a"a$,rce 'n' a(an -en6a!'!a"a#a$e #aanan

Da"a$,rce


20/28


.5MP5+E+ DE1P2I

3. Da"a C,n"r,5

A!a5a (,-/,nen '$a5 !a"a ar"'na !a"a!a"aan a!a !a5a- !a"a$,rce !a/a" !'"a-/'5(an$ecara na"a !enan -enna(an Da"a C,n"r,5.K,-/,nen(,-/,nen !a"a acce$$ an #'$a

!'na(an0DBGr'!) !'na(an n"( -ena-/'5(an !a"a !a5a-#en"( "a#e5.

DBGr'!


21/28


.5MP5+E+ DE1P2I

• K,n$e/ (e"er#nan (,-/,nen(,-/,nen

!a"a#a$e !a5a- !e5/'

ADO Ta#5e

ADOQer

DBGr'!

ADOC,nnec"'

,n

Da"a$,rce


22/28


.5MP5+E+ DE1P2I

A!a 2 cara n"( -en,5a $a" !a"a#a$e ADO

'na -ene5ar(an $a" ,"/" "a-/'5an !a"a)a'" -e5a5' ADOTa#5e !an ADOQer. Per#e!aan!ar' (e!a 6en'$ /en,5aan !a"a "er$e#" a!a5a 0

1. ADOTa#5e -enna(an /er'n"a/er'n"a !a5a-

ADOTa#5e.2. ADOQer -enna(an /er'n"a/er'n"a SQL.


23/28


.5MP5+E+ DE1P2I

Un"( -en#n(an !a"a#a$e M$. Acce$$

!enan /r,ra- De5/') (,-/,nen(,-/,nen an/er5 !'/er$'a/(an 0

Denan -enna(an ADOTa#5e

1. Ba" !a"a#a$e !enan -enna(an M$. Acce$$.

M'$a5 0 !a"a/ea:a'.acc!#

2. Ba" "a-/'5an /r,ra- !a5a- De5/'.


24/28


.5MP5+E+ DE1P2I

A"r (,-/,nen(,-/,nen an "e5a !'#a" $e#aa' #er'("0

a. ADO F ADOC,nnnec"',n• Pa!a #a'an O#6ec" In$/ec",r) C,nnec"',n$"r'n$

• B'5!) M'cr,$,+" Oce 12.; Acce$$ Da"a#a$e En'ne OLE DB Pr,'!er

• P'5' Ne") /a!a (,"a( !a"a $,rce -a$((an a5a-a" "e-/a" ('"a -en'-/an5e !a"a#a$e an "e5a ('"a #a" !''("' !enan $5a$ na-a !a"a#a$e an"e5a ('"a #a". M'$a5 0 C0?/r,ra- 5e$?!a"a/ea:a'.acc!#

Ca"a"an 0 A/a#'5a !a"a#a$e an ('"a #a") ('"a $'-/an $a" +,5!er !enan/r,ra- an "e5a ('"a #a". Ma(a /en5'$an !a5a- (,"a( !a"a $,rce c(/!'"5'$(an na-a !a"a#a$ena $a6a. M'$a5 0 !a"a/ea:a'.acc!#

• K5'( "e$" c,nnec"',n) a/a#'5a -nc5 "5'$an J"e$" c,nnec"',n $ccee!e!-a(a !a"a#a$e an ('"a #a" "e5a "er#n !enan ADOC,nnec"',n. OK

#. ADO F ADOTa#5e1

• C,nnec"',n ADOC,nnnec"',n1

c. Da"a Acce$$ F Da"a$,rce1

• Da"a$e" ADOTa#5e1

!. Da"a c,n"r,5 F DBGr'!

• Da"a$,rce !a"a$,rce1


25/28


.5MP5+E+ DE1P2I

Denan -enna(an ADOQer

1. Ba" !a"a#a$e !enan -enna(an M$. Acce$$.M'$a5 0 !a"a/ea:a'.acc!#

2. Ba" "a-/'5an /r,ra- !a5a- De5/'.


26/28


.5MP5+E+ DE1P2I

3. A"r (,-/,nen(,-/,nen an "e5a !'#a" $e#aa'

#er'(" 0a. ADO F ADOC,nnnec"',n

• Sa-a !enan 5an(a /a!a ADOTa#5e

#. ADO F ADOQer1

• C,nnec"',n ADOC,nnnec"',n1c. Da"a Acce$$ F Da"a$,rce1

• Da"a$e" ADOQer1

!. Da"a c,n"r,5 F DBGr'!

•Da"a$,rce !a"a$,rce1

Ca"a"an 0 n"( ADOQer) /er'n"a/er'n"a SQL !a/a"!'-a$((an (e !a5a- ADOQer1) /a!a #a'an O#6ec"In$/ec",r /'5' SQL.


27/28


.5MP5+E+ DE1P2I

Ta$ 2

1. Ba"5a !a"a#a$e !enan -enna(an M$Acce$$

2. K,ne($'(an !a"a#a$e S,a5 N,. 1 !enan /r,ra-De5/'

3. Ba"5a "a-/'5an 'n"er+ace /r,ra- !a"a#a$e!e5/' an -enar'(


28/28

P*5SEDU* DATABASE

sistem basis data (after mid)

Documents