BR$17$ "Advans SQL$."$

Prinsipul d$$n f$$ di Database

Tul MYsql $$n Mysql Wokbench

Rayt wan skript f$$ mek di database, yuz di database we de d$$n ansa di kw$$sty$$n d$$n we de d$$ ya

Yuz $($YuzID$,$ Imel, Pasw$$d$,$ F$$sNem$,$ LasNem$)$

FamiliM$$mba $($FamiliM$$mbaID$,$ F$$sNem$,$ LasNem, Rilaysh$$n$,$ YuzID, F$$n N$$mba$)$

Ad RewardPoints k$$l$$m to FamilyMember tebul $($initialize to ziro$)$

Aktiviti $($AktivitiID$,$ Diskripsh$$n$,$ Tayp, Prioriti$).$

AktivitiAsaynm$$nt $($Asaynm$$ntID$,$ AktivitiID, FamiliM$$mbaID$,$ DueD$$t$,$ Asaynm$$ntD$$t$)$

$================================================================================================================================================================================================================================$

F$$ksplen di database b$$t$$ b$$t$$ wan na di Rilaysh$$nship bitwin $$ni $$ntiti:

Yuza g$$t b$$ku FamiliM$$mba d$$n

FamilyMember na f$$ Yuza in yon.

FamiliM$$mba g$$t b$$ku AktivitiAsaynm$$nt d$$n

Aktiviti g$$t b$$ku AktivitiAsaynm$$nt d$$n

AktivitiAsaynm$$nt na f$$ FamiliM$$mba $$n Aktiviti

KW$$SH$$N $1$

wan. Di database, $$n $$l in tebul d$$n$,$ de insay $3$NF

b$.$ Di SQL skript kin r$$n pas wan t$$m

c$.$l di k$$l$$n d$$n de yuz di kayn we we fit pas $$l

Program langwej$($JAVA$)$

$2.$ Yuz di database kriesh$$n skript fr$$m kw$$sh$$n wan, mek wan JDBC program

we de impruv tri yunik wokfl$.$ Wan wokfl$$ de difayn as yuza we d$$n pik

$$presh$$n we de riliz$$t insay wan database k$$l $$n s$$m bizn$$s l$$jik we d$$n de $$ks$$kutiv$.$

Yu f$$:

wan. No di tri wok we yu de du

b$.$ Inklud wan pr$$z$$nt layt we de manej aw di p$$sin we de yuz am

pik, $$n intarakt wit, yu tri wokfl$$ d$$n$.$

c$.$ Inklud wan bizn$$s l$$jik layt we de impruv funksh$$naliti

we g$$t f$$ du wit yu tri wokfl$$ d$$n$.$ A n$$ want mek yu j$$s aks f$$ data

fr$$m di database $$n sho am to di p$$sin we de yuz am$.$ Ad s$$m tin d$$n we intrestin

funksh$$naliti ya$.$

d$.$ Inklud wan DAL layt we:

a$.$ Manej di database k$$n$$ksh$$n

ii$.$ K$$l di prosidur $$ f$$nsh$$n d$$n we d$$n d$$n kip, $$n rit$$n di riz$$lt to di

bizn$$s layt insay wan efish$$nal we$.$

Mek sh$$ se yu program tink b$$t di tin d$$n we de m$$na b$$t aw f$$ kip tin d$$n $$n aw f$$ wok fayn

bay we yu de kech statik data usay i fayn.

Wi don si dat go na di database, en mo impotant to main

m$$mori$,$ na $$presh$$n we dia. Wi kod shud onli go to di$...$

database we i nid f$$ du am$.$ Wetin mek f$$ mek b$$ku database k$$l$,$ na f$$ g$$t n$$m$$

di sem data evri taim? Dis na di rizin we mek wi DAL f$$ smat inof

f$$ kesh di data."