cwiczonko drugie z baz danych na stopieniek

background image

&ZLF]HQLH,,



8WZyU]ED] GDQ\FKZJ]Dá F]RQHJRVFKHPDWXRNUH ONOXF]HJáyZQHZSRV]F]HJyOQ\FK

WDEHODFKRUD]UHODFMHPL G]\WDEHODPL



3RV]F]HJyOQHSRODSRZLQQ\VSHáQLDüQDVW SXM FHZDUXQNL

XVWDOLüPDVNLZSURZDG]DQLDGODSyONWyUHVWDQRZL NRGSRF]WRZ\

GODND GHJRSRODZSRV]F]HJyOQ\FKWDEHODFKXVWDOLüZDUWR üDWU\EXWXµ:\PDJDQH¶

XVWDOLüUHJXá SRSUDZQR FLZUD]]RGSRZLHGQLPNRPXQLNDWHPREá G]LHGODQDVW SXM F\FK

SyOLOR ü =DPyZLRQH.VL

NL FHQD .VL

NL GDWD=DP =DPyZLHQLH GDWD:\V

=DPyZLRQH.VL

NL 

GODZ\EUDQ\FKSyOZWDEHODFKRNUH OLüZDUWR FLGRP\ OQH

RNUH OLüIRUPDWZ\ ZLHWODQLDGODSyONWyU\FKZDUWR FLE G QLHRNUH ORQH GODQLHRNUH ORQ\FK

SyOWHNVRZ\FKSRZLQLHQE\üZ\ ZLHWODQ\WHNVWÄ1LH]QDQH´GODSyOOLF]ERZ\FKÄ1XOO´ 

GODZ\EUDQ\FKSyOXVWDOLüDWU\EXWµ,QGHNVRZDQH¶

XWZRU]\üLQGHNVZLHORSRORZ\

'RGDMGRSRV]F]HJyOQ\FKWDEHOUHNRUG\

background image

3RPRF



7DEHOHL5HODFMH



&RWRMHVWWDEHOD"

7DEHODMHVWSRMHPQLNLHPQDGDQHGRW\F] FHNRQNUHWQHJRWHPDWXQSLQIRUPDFMHGRW\F] FH

SUDFRZQLNyZOXEIDNWXUVSU]HGD \:ED]LHGDQ\FKPR HE\üZLHOHWDEHO]NWyU\FKND GD

SU]HFKRZXMHLQIRUPDFMHGRW\F] FHLQQHJRWHPDWX.D GD]WDEHOPR H]DZLHUDüGDQHZLHOX

W\SyZZá F]QLH]WHNVWHPOLF]EDPLGDWDPLLREUD]DPL





7ZRU]HQLHWDEHOL

8WZRU]RQDWDEHODMHVWSXVW\PSRMHPQLNLHPQDGDQH7DEHO SURMHNWXMHVL ]D]Z\F]DM]P\ O 

RSU]HFKRZ\ZDQLXZQLHMGDQ\FKRNUH ORQHJRURG]DMXQDSU]\NáDGQD]ZLVNLDGUHVyZ3R

]DFKRZDQLXWDEHOLPR QDGRQLHMZSURZDG]LüGDQH

1DMSURVWV]\PVSRVREHPWZRU]HQLDW\SRZ\FKWDEHOGRFHOyZ]DZRGRZ\FKOXESU\ZDWQ\FK

MHVWX \FLH.UHDWRUDWDEHO

$E\XWZRU]\üWDEHOH]DSRPRF NUHDWRUDWDEHO

:RNQLHED]\GDQ\FKNOLNQLMSU]\FLVN³7DEHOD´ OXE]PHQX:LGRNZ\ELHU]SROHFHQLH

7DEHOD 

:\ELHU]SU]\FLVN³1RZ\´

:\ELHU]SU]\FLVN³.UHDWRU\WDEHO´

$E\GRGDüSRODGRWZRU]RQHMWDEHOLSRVW SXM]JRGQLH]HZVND]yZNDPLZ\ ZLHWODQ\PLZ

SRODFKGLDORJRZ\FK.UHDWRUDWDEHO

3R]DNR F]HQLXWZRU]HQLDWDEHOLPR QDZ\EUDüMHGQ ]GZyFKRSFMLRWZRU]\üWDEHO Z

ZLGRNX3URMHNWFHOXZ\ ZLHWOHQLDLPRG\ILNDFMLSURMHNWXWDEHOLOXERWZRU]\üMDZZLGRNX

$UNXV]GDQ\FKDE\UR]SRF] üZSURZDG]DQLHGDQ\FK0R QDWDN HZ\EUDüRSFM WZRU]HQLD

QRZHJRIRUPXODU]DGRZ\ ZLHWOHQLDGDQ\FKZWDEHOL

7DEHO PR QDWDN HXWZRU]\üLPSRUWXM FGDQHOXE]Dá F]DM F]HZQ WU]Q WDEHO GRZáDVQHM

ED]\GDQ\FK

$E\XWZRU]\üWDEHO EH]SRPRF\NUHDWRUDWDEHO

:RNQLHED]\GDQ\FKNOLNQLMSU]\FLVN³7DEHOD´ OXE]PHQX:LGRNZ\ELHU]SROHFHQLH

7DEHOD 

:\ELHU]SU]\FLVN³1RZ\´

:\ELHU]SU]\FLVN³1RZDWDEHOD´

=RVWDQLHRWZDUWHSXVWHRNQRWDEHOLZZLGRNX3URMHNW

:WUDNFLHSURMHNWRZDQLDOXEPRG\ILNDFMLWDEHOLZJyUQHMF]

FLRNQDWDEHOLRNUH ODVL SROD

NWyUHPD]DZLHUDüWDEHOD:GROQHMF]

FLRNQDPR QDRNUH OLüZáD FLZR FLND GHJR]SyO





'RGDZDQLHSyO

5HNRUG\ZWDEHOLPRJ ]DZLHUDüUy QHNDWHJRULHLQIRUPDFML'RWDEHOLQDOH \GRGDüSROHGOD

ND GHMNDWHJRULLLQIRUPDFMLNWyUHPDM E\üZQLHMSU]HFKRZ\ZDQHQDSU]\NáDGWDEHOD

SU]HFKRZXM FDUHNRUG\SUDFRZQLNyZPR H]DZLHUDüSRODSU]H]QDF]RQHQDQD]ZLVNRDGUHV

LQXPHUWHOHIRQXSUDFRZQLND

7ZRU]HQLHWDEHOLUR]SRF]\QDVL RGRNUH OHQLDSyOSRF] ZV]\RGSLHUZV]HJRZLHUV]DJyUQHM

F]

FLRNQDWDEHOL'RND GHJRZLHUV]DQDOH \ZSURZDG]LüQD]Z SRODLW\SGDQ\FKPR QD

WDN HGRá F]\üRSFMRQDOQ\RSLVSRODSRMDZLDM F\VL QDVW SQLHQDSDVNXVWDQXZWUDNFLH

ZSURZDG]DQLDGDQ\FKGRSROD





.RU]\VWDQLH]JHQHUDWRUDSyO

-H OLEUDNSHZQR FLMDNQD]ZDüSROHOXEMDNLHJRX \üW\SXGDQ\FKZDUWRVNRU]\VWDü]

ZF]H QLHMSU]\JRWRZDQHMOLVW\SyO:\NRU]\VWXM F*HQHUDWRUSyOPR QDGRNRQDüZ\ERUX]

W\FKVDP\FKOLVWSyONWyUHV GRVW SQHZWUDNFLHNRU]\VWDQLD].UHDWRUDWDEHOSyO]

background image

SU]\NáDGRZ\FKWDEHOGRW\F] F\FKWDNLFKG]LHG]LQMDNNRQWDNW\KDQGORZHZ\SRVD HQLH

GRPXOXENDUWRWHNDPHG\F]QD

$E\GRGDüSROH]DSRPRF *HQHUDWRUDSyO

:RNQLHWDEHOLNOLNQLMZLHUV]ZNWyU\PFKFHV]GRGDüSROH

.OLNQLMSUDZ\PSU]\FLVNLHPP\V]\ZFHOXZ\ ZLHWOHQLDPHQXSRGU F]QHJRDQDVW SQLH

Z\ELHU]SROHFHQLH%XGXM OXENOLNQLMSU]\FLVN³%XGXM´QDSDVNXQDU] G]L 

=D]QDF]WDEHO ZSROX³7DEHOHSU]\NáDGRZH´

=D]QDF]QD]Z SRODZSROX³3U]\NáDGRZHSROD´

:\ELHU]SU]\FLVN³2.´

'RELH

FHJRZLHUV]DZRNQLHWDEHOL]RVWDQLHZVWDZLRQDZ\EUDQDQD]ZDSRODXVWDZLRQ\

RGSRZLHGQLW\SGDQ\FKSRODRUD]ZáD FLZR FLWHJRSROD-H OLELH

F\ZLHUV]MX ]DZLHUD

SROH]RVWDQLHZVWDZLRQ\QRZ\ZLHUV]

1D]\ZDQLHSyO

3LHUZV] F]\QQR FL ]ZL ]DQ ]GRGDZDQLHPSRODMHVWZSLVDQLHMHJRQD]Z\ZNROXPQLH

³1D]ZDSROD´1D]Z\SyOPRJ ]DZLHUDüPDNV\PDOQLH]QDNL OLWHU\OXEF\IU\ ]HVSDFMDPL

Zá F]QLH



:\ELHUDQLHW\SyZGDQ\FK

SRQD]ZDQLXSRODQDOH \Z\EUDüW\SGDQ\FKNWyUHPDM E\üSU]HFKRZ\ZDQHZSROX

:\ELHUDM FW\SGDQ\FKMHGQRF]H QLHRNUH ODVL 

‡

5RG]DMZDUWR FLNWyUHPRJ E\üSU]HFKRZ\ZDQHZSROX1DSU]\NáDGQLHPR QD

SU]HFKRZ\ZDüWHNVWXZSROXRW\SLHGDQ\FK/LF]ED

‡

5R]PLDUREV]DUXSDPL FLSU]\G]LHORQHJRGODZDUWR FLSU]HFKRZ\ZDQ\FKZSROX1D

SU]\NáDGND GDZDUWR üW\SX:DOXWD]DMPXMHEDMWyZSDPL FL

‡

7\SRSHUDFMLNWyUHPRJ E\üZ\NRQ\ZDQHQDZDUWR FLDFKSU]HFKRZ\ZDQ\FKZW\P

SROX1DSU]\NáDGPR QDREOLF]\üVXP ZDUWR FLZSROXRW\SLH/LF]EDOXE:DOXWDDOHQLH

QDZDUWR FLDFKW\SX7HNVWOXERELHNW2/(

‡

&]\PR QDZ\NRQ\ZDüLQGHNVRZDQLHOXEVRUWRZDQLHZDUWR FLZSROXQLHPR QD

VRUWRZDüDQLWZRU]\üLQGHNVyZGODSyOW\SX0HPROXERELHNW2/(



7\S\GDQ\FK

7HNVW]QDNLDOIDQXPHU\F]QHUR]PLDUGREDMWyZ

0HPR]QDNLDOIDQXPHU\F]QHGREDMWyZ

/LF]EDZDUWR FLOLF]ERZHOXEEDMWyZ

'DWD*RG]LQDGDW\LJRG]LQ\EDMWyZ

:DOXWDZDUWR FLSLHQL

QHEDMWyZ

/LF]QLNZDUWR FLOLF]ERZH]ZL NV]DQHDXWRPDW\F]QLHGODND GHJRQRZHJRUHNRUGXEDMW\

7DN1LHZDUWR FLORJLF]QHELW

2ELHNW2/(2ELHNW\2/(JUDILNDOXELQQHGDQHELQDUQHGRJLJDEDMWD

:SU]\SDGNXW\SXWHNVWL/LF]EDPR QDSUHF\]\MQLHMRNUH OLüW\SGDQ\FKLUR]PLDUSROD

2SLV\ZDQLHSyO

$E\WDEHOHE\á\EDUG]LHMF]\WHOQHLáDWZLHMV]HGRDNWXDOL]DFMLGRND GHJRSRODZWDEHOLPR QD

GRá F]\üRSLV:WUDNFLHZSURZDG]DQLDGDQ\FKGRSRODOXEGRHOHPHQWXVWHUXM FHJR

]ZL ]DQHJR]SROHPMHJRRSLVMHVWZ\ ZLHWODQ\QDSDVNXVWDQX





8VWDZLHQLHNOXF]DSRGVWDZRZHJR

3URJUDP0LFURVRIW$FFHVVG]LDáDHIHNW\ZQLHMMH OLMHVWRNUH ORQ\NOXF]SRGVWDZRZ\.OXF]

SRGVWDZRZ\WDEHOLVNáDGDVL ]MHGQHJROXEZLHOXSyOMHGQR]QDF]QLHLGHQW\ILNXM FND G\

UHNRUGSU]HFKRZ\ZDQ\ZWDEHOL

NOXF]HPSRGVWDZRZ\PPR HE\üQXPHUSRU] GNRZ\OXENRGSRQLHZD ZDUWR üWHJRW\SX

MHVW]DZV]HLQQDGODND GHJRUHNRUGX1DSU]\NáDGZWDEHOL³3UDFRZQLF\´ZED]LHGDQ\FK

1RUWKZLQGND G\PDMHGQR]QDF]Q\QXPHUSRU] GNRZ\.OXF]HPSRGVWDZRZ\PWHMWDEHOL

MHVWSROH³1U3UDFRZQLND´

7DEHOD]RNUH ORQ\PNOXF]HPSRGVWDZRZ\PPDQDVW SXM FH]DOHW\

background image

:SURJUDPLH0LFURVRIW$FFHVVMHVWDXWRPDW\F]QLHWZRU]RQ\LQGHNVGODNOXF]D

SRGVWDZRZHJR,QGHNVSU]\ SLHV]DG]LDáDQLH]DS\WD LLQQ\FKRSHUDFML

MH OLUHNRUG\V SU]HJO GDQHZIRUPXODU]XOXEDUNXV]XGDQ\FKWRV RQHGRP\ OQLH

Z\ ZLHWODQHZSRU] GNXZHGáXJVZ\FKNOXF]\SRGVWDZRZ\FK

'RGDQLHGRWDEHOLUHNRUGXRZDUWR FLNOXF]DSRGVWDZRZHJRNWyUDMX LVWQLHMHZWDEHOLQLH

MHVWDNFHSWRZDQH']L NLWHPXND G\UHNRUGMHVWLGHQW\ILNRZDQ\MHGQR]QDF]QLH

0R OLZHMHVWWDN HXWZRU]HQLHZLHORSRORZHJRNOXF]DSRGVWDZRZHJRZSU]\SDGNXJG\ DGQH

SRMHG\QF]HSROHZWDEHOLQLH]DZLHUDXQLNDWRZ\FKZDUWR FL







'RGDZDQLHUHNRUGyZ

3R]DSURMHNWRZDQLXWDEHOLPR QDUR]SRF] üGRGDZDQLHUHNRUGyZ

8VWDZLHQLHUHODFMLSRPL G]\WDEHODPL

0LFURVRIW$FFHVVMHVWUHODF\MQ ED] GDQ\FKPR QD]DWHPUyZQRF]H QLHZ\NRU]\VW\ZDü

GDQH]ZLHOXWDEHOOXE]DS\WD -H OLED]DGDQ\FK]DZLHUDWDEHOH]SRZL ]DQ\PLGDQ\PL

PR QDZQLHMRNUH OLüUHODFMHUHODFMHXPR OLZLDM 

WZRU]HQLHSRá F]H ZQRZ\FK]DS\WDQLDFK

Z\ ZLHWODQLHSRZL ]DQ\FKUHNRUGyZSRGIRUPXODU]XOXESRGUDSRUFLH

Z\PXV]DQLHZL ]yZLQWHJUDOQR FLZFHOXRFKURQ\UHODFMLPL G]\WDEHODPLZWUDNFLH

GRGDZDQLD]PLDQ\OXEXVXZDQLDUHNRUGyZ

3RZL ]DQLH]HVRE WDEHOOXE]DS\WD QDVW SXMHZZ\QLNXXVWDOHQLDMHGQHJROXEZLHOXSyO

]DZLHUDM F\FKWHVDPHZDUWR FLZSRZL ]DQ\FKUHNRUGDFK1RZRXWZRU]RQDWDEHODQLHMHVW

]ZL ]DQD] DGQDLQQ WDEHO $E\XWZRU]\üUHODFM QDOH \]DF] üRGRWZDUFLDRNQDUHODFMLL

GRGDQLDWDEHOOXE]DS\WD NWyUHPRJ E\üSRZL ]DQH1DVW SQLHQDOH \VDPRG]LHOQLH

]GHILQLRZDüUHODFM 

:SU]\SDGNXQLHNWyU\FKUHODFMLSU]\GRGDZDQLXOXEXVXZDQLXUHNRUGyZ]SRZL ]DQ\FKWDEHO

PRJ E\üZ\PXV]RQHZL ]\LQWHJUDOQR FL=DSHZQLDM RQHSRSUDZQR üUHODFMLPL G]\

UHNRUGDPLRUD]SR]ZDODM XQLNQ üSU]\SDGNRZHJRXVXQL FLDSRZL ]DQ\FKGDQ\FK0R QDMH

Z\PXVLüMH HOLVSHáQLRQHV QDVW SXM FHZDUXQNL

2GSRZLDGDM FHSROH]WDEHOLSRGVWDZRZHMMHVWNOXF]HPSRGVWDZRZ\POXEPDXQLNDWRZ\

LQGHNV

3RZL ]DQHSRODPDM WHQVDPW\SGDQ\FK

2E\GZLHWDEHOHQDOH

GRWHMVDPHMED]\GDQ\FK0LFURVRIW$FFHVV-H OLWDEHOHV 

]Dá F]RQHPXV] QDOH HüGRWHMVDPHMED]\GDQ\FK0LFURVRIW$FFHVV

-H OLV Z\PXV]RQHZL ]\LQWHJUDOQR FLQDOH \SU]HVWU]HJDüQDVW SXM F\FK]DVDG

*G\GR]ZL ]DQHMWDEHOLMHVWGRGDZDQ\UHNRUGLMHVWRNUH ODQDZDUWR üZ]ZL ]DQ\PSROX

SRODFK ZWDEHOLSRGVWDZRZHMPXVLMX LVWQLHüUHNRUG]W ZDUWR FL 

8VXQL FLHUHNRUGX]WDEHOLSRGVWDZRZHMMHVWQLHPR OLZHMH OLZWDEHOL]ZL ]DQHMLVWQLHM 

RGSRZLDGDM FHPXUHNRUG\



7\S\UHODFML

:SU]\SDGNXUHODFMLGODNWyU\FK]RVWDá\Z\PXV]RQHZL ]\LQWHJUDOQR FLQDOH \RNUH OLüF]\

UHODFMD]DSRPRF NWyUHMPDM E\üSRZL ]DQHGZLHWDEHOHMHVWW\SMHGHQGRZLHOXF]\MHGHQ

GRMHGQHJR:QDMF] VWV]\PSU]\SDGNX±UHODFMLW\SXMHGHQGRZLHOX±ND G\UHNRUGZWDEHOL

SRGVWDZRZHMPR HE\ü]ZL ]DQ\]ZLHORPDUHNRUGDPL]WDEHOL]ZL ]DQHM ND GDZDUWR ü

NOXF]DSRGVWDZRZHJRPR HVL ZLHORNURWQLHSRMDZLDüZWDEHOL]ZL ]DQHM 1DSU]\NáDGND G\

UHNRUGGRVWDZF\PR HE\ü]ZL ]DQ\]ZLHORPDUHNRUGDPLSURGXNWyZ

:UHODFMLW\SXMHGHQGRMHGQHJRND G\UHNRUGZWDEHOLSRGVWDZRZHMPR HE\ü]ZL ]DQ\W\ONR

]MHGQ\PUHNRUGHPZWDEHOL]ZL ]DQHM:ZLHOXSU]\SDGNDFKRGSRZLDGDM FHVRELHSRODSR

REXVWURQDFKUHODFMLV NOXF]DPLSRGVWDZRZ\PLOXEPDM XQLNDWRZ\LQGHNV



2SHUDFMHXVXZDQLDLDNWXDOL]DFMLNDVNDGRZHM

'ODUHODFMLGODNWyU\FKV Z\PXV]DQHZL ]\LQWHJUDOQR FLPR QDRNUH OLüF]\PDM E\ü

Z\NRQ\ZDQHDXWRPDW\F]QHRSHUDFMH³NDVNDGRZHJR´XVXZDQLDLDNWXDOL]DFML]ZL ]DQ\FK

background image

UHNRUGyZ-H OLWHRSFMHV ]D]QDF]RQHRSHUDFMHXVXZDQLDLDNWXDOL]DFMLNWyUHQRUPDOQLH

áDPDá\E\]DVDG\ZL ]yZLQWHJUDOQR FLVWDMDVL GRSXV]F]DOQH:FHOXLFK]DFKRZDQLDZ

SU]\SDGNXXVXZDQLDUHNRUGyZOXE]PLDQ\ZDUWR FLNOXF]DSRGVWDZRZHJRZWDEHOLGR

]ZL ]DQ\FKWDEHOV DXWRPDW\F]QLHZSURZDG]DQHQLH]E GQH]PLDQ\

8VWDZLDQLHZáD FLZR FLSROD

8 \WNRZQLNPR HXVWDODüZ\JO GGDQ\FK]DSRELHJDüZSURZDG]DQLXQLHSRSUDZQ\FK

GDQ\FKRNUH OLüZDUWR FLGRP\ OQHRUD]SU]\VSLHV]DüZ\V]XNLZDQLHLVRUWRZDQLHXVWDZLDM F

ZáD FLZR FLSRODZZLGRNX3URMHNWWDEHOL1DSU]\NáDGPR QDIRUPDWRZDüOLF]E\DE\E\á\

EDUG]LHMF]\WHOQHOXEXVWDZLüZDUXQNLNWyUHPXV] VSHáQLDüGDQHDE\PRJá\E\ü

ZSURZDG]RQHGRSROD

8VWDZLHQLDZáD FLZR FLSRODV Z\NRU]\VW\ZDQHZWUDNFLHSU]HJO GDQLDLHG\FMLGDQ\FK

8VWDZLRQHZáD FLZR FL³)RUPDW´³0DVNDZSURZDG]HQLD´L³7\WXá´SRMDZLDM VL ZDUNXV]DFK

GDQ\FKWDEHOL]DS\WD DWDN HZHOHPHQWDFKVWHUXM F\FKIRUPXODU]\LUDSRUWyZ

Z\NRU]\VWXM F\FKWDEHO MDNRSRGVWDZ LSU]HMPXM F\FKGRP\ OQLHWHZáD FLZR FL,QQH

ZáD FLZR FLV Z\NRU]\VW\ZDQHGRXVWDZLDQLDUHJXáGRW\F] F\FKZSURZDG]DQLDGDQ\FKOXE

RNUH OHQLDZ\PDJD ZSURZDG]HQLDGDQ\FKGRSyO6 RQHDNW\ZQHSRGF]DVND GHJR

ZSURZDG]DQLDOXEHG\FMLGDQ\FKZWDEHOL



:áD FLZR FLSRODL]DVWRVRZDQLD

5R]PLDUSROD±8VWDZLDQLHUR]PLDUXSROD7HNVWOXERJUDQLF]HQLH]DNUHVXGRSXV]F]DOQ\FK

ZDUWR FLZSROXW\SX/LF]ED1DSU]\NáDGGRSRODWHNVWRZHJRRUR]PLDU]HSRODQLHPR QD

SU]\SDGNRZRZSURZDG]LüZL FHMQL V]H FLX]QDNyZ

)RUPDW

±:\ ZLHWODQLHGDWLOLF]EZSHZQ\PIRUPDFLHWDNLPMDNIRUPDWGDW\'DWDSHáQDOXE

IRUPDW3URFHQW

0LHMVFDG]LHVL WQH±:\ ZLHWODQLHRNUH ORQHMOLF]E\PLHMVFSRSU]HFLQNXG]LHVL WQ\PZ

SU]\SDGNX]DVWRVRZDQLDIRUPDWXGODSRODW\SX/LF]EDOXE:DOXWD

0DVNDZSURZDG]DQLD:\ ZLHWOHQLH]QDNyZIRUPDWXM F\FKZSROXDE\E\áR]E GQHLFK

ZSURZDG]DQLHL]DSHZQLHQLH HZSURZDG]RQHGDQHSDVXM GRPDVNL

7\WXá±2NUH OHQLHHW\NLHWLQQ\FKQL GRP\ OQH QD]ZDSROD GODQRZ\FKIRUPXODU]\L

UDSRUWyZ

:DUWR üGRP\ OQD±$XWRPDW\F]QHZSLV\ZDQLHSHZQHMZDUWR FLGRSRODZQRZ\FK

UHNRUGDFKGRGDZDQ\FKGRWDEHOL

5HJXáDSRSUDZQR FL±2JUDQLF]HQLHGDQ\FKZSURZDG]DQ\FKGRSRODGRZDUWR FL

VSHáQLDM F\FKSHZQHZ\PDJDQLD3RPRFQ\SU]\

ZSURZDG]DQLXZ\UD HQLDVSUDZG]DM FHJR



MHVW*HQHUDWRUZ\UD H  PR HNRU]\VWDü]IXQNFMLVWDá\FKLRSHUDWRUyZ$FFHVVDRUD]

XWZRU]RQ\FKSU]H]VLHELHRELHNWyZ ZIRUPXODU]DFK  WDEHOH]DS\WDQLDIRUPXODU]H

UDSRUW\ 

.RPXQLNDWREá G]LH±7UH üNRPXQLNDWXNWyU\PDVL SRMDZLüMH OLZ\VW SLáEá G

QLHVSHáQLHQLDUHJXá\SRSUDZQR FL

:\PDJDQH±:\PDJDQLHZSURZDG]HQLDGDQ\FKGRSROD

=HURZDGáXJR ü±'RSXV]F]HQLHSU]HFKRZ\ZDQLDFL JyZ]QDNyZR]HURZHMGáXJR FLZ

SRODFKW\SX7HNVWL0HPR-H OLXVWDZLP\³7$.´WRSU]HFKRZ\ZDQHV FL JL]QDNyZR

GáXJR FL]HURZHM]DPLDVWZDUWR FL1XOOOXESU]HFKRZ\ZDQHV ]DUyZQRZDUWR FL1XOOMDNL

FL JL]QDNyZRGáXJR FL]HURZHM

,QGHNVRZDQH±3U]\VSLHV]HQLHZ\V]XNLZDQLDZF] VWRSU]HV]XNLZDQ\FKSRODFK



)RUPDW\GDQ\FK± VSRVyEZ\ ZLHWODQLDGDQ\FKZWU\ELH:LGRN 

)RUPDW\$FFHVVD

 GODW\SX/LF]EDRJyOQ\SURFHQWRZ\QDXNRZ\ZDOXWDIL[HGVWDQGDUG

 GODW\SX'DWD*RG]LQDRJyOQ\GDWDF]DVGáXJD UHGQLDNUyWND

 GODW\SXORJLF]QHJR7DN1LH:á:\á2Q2II



)RUPDW\ZáDVQH

GODW\SyZWHNVWRZ\FKSRODRGG]LHORQH UHGQLNDPL

 VSRVyEZ\ ZLHWODQLD

background image

 FRSRMDZLVL JG\SROH]DZLHUDáD FXFK]HURZ\ QDOH \Zá F]\üDWU\EXW=HURZDGá 

 FRSRMDZLVL JG\SROH]DZLHUDQXOO SXVWR 

QS#´1LHSRGDQR´>&]HUZRQ\@´1LH]QDQ\´

]QDNLIRUPDWRZDQLD

‡

Z\ ZLHWODQLHGX \PLOLWHUDPL

Z\ ZLHWODQLHPDá\PLOLWHUDPL

#UHSUH]HQWXMHWHNVW]QDN MH OLQLHPD]QDNXZ\ ZLHWODQDMHVWVSDFMD 

UHSUH]HQWXMHWHNVW]QDN MH OLQLHPD]QDNXQLFQLHMHVWZ\ ZLHWODQH 

?ZVWDZLDQ\SU]HGP\ OQLNLHPV\JQDOL]XMH HQDVW SXM F\SRQLPSRMHG\QF]\]QDNQLHMHVW

]QDNLHPNRQWUROQ\PLPDE\üZ\ ZLHWORQ\

3U]\NáDG\ #?##?## WHOHIRQ 





##?### 

NRGSRF]WRZ\ 







?´  ?´



SROHZFXG]\VáRZDFK]QDNyZ W\OHMDNDGá

SROD 







³XO³  



SROH]GRSLVNLHPVWDá\P 

GODW\SyZOLF]ERZ\FKSRODRGG]LHORQH UHGQLNDPL

 FRSRMDZLVL JG\SROH]DZLHUDZDUWR FLGRGDWQLH

 FRSRMDZLVL JG\SROH]DZLHUDZDUWR FLXMHPQH

 FRSRMDZLVL JG\SROH]DZLHUD]HUR

 FRSRMDZLVL JG\SROH]DZLHUDQXOO SXVWR 

]QDNLIRUPDWRZDQLD



MHGQDF\IUD MH OLMHMEUDNZ\ ZMHVW]HUR 



MHGQDF\IUD MH OLMHMEUDNZ\ ZMHVWVSDFMD 



IRUPDWSURFHQWRZ\

(OXEH (OXEH  Z\ ZZSRVWDFLHNVSRQHQFMDOQHM QS( 

 SU]HFLQHN  VHSDUDWRUF]

FLG]LHVL WQHM

VSDFMD 



VHSDUDWRUW\VL F\

QS?´1LHSRGDQR´

GODW\SyZORJLF]Q\FK

SUDZGDIDáV]  

QS

´]DSáDFRQR´>=LHORQ\@´GR]DSáDW\´>&]HUZRQ\@

GODW\SyZGDW\F]DVX

]QDNLIRUPDWRZDQLD

VHSDUDWRUF]DVX

VHSDUDWRUGDW\

FGDWDRJyOQD

GG]LH PLHVL FD  

WQUGQLDW\JRGQLD   ZHUVMDDQJZ 

GGG]LH PLHVL FD  

WWQUGQLDW\JRGQLDZURNX  

GGGVNUyWQD]Z\GQLDW\JRGQLD

PQUPLHVL FD  

GGGGQD]ZDGQLDW\JRGQLD

PPQUPLHVL FD  

GGGGGGDWDNUyWND

PPPVNUyWQD]Z\PLHVL FD

GGGGGGGDWDSHáQD



PPPPQD]ZDPLHVL FD

JJJRG]LQD  

JJRG]LQD   ZHUVMDDQJK 

NQUNZDUWDáX ZHUVMDDQJT 

UQUGQLDZURNX   ZHUVMDDQJ\ 

UUURN  

PPLQXWD   ZHUVMDDQJQ 

UUUUURN  

PPPLQXWD  

background image

VVHNXQGD  

VVVHNXQGD  

OOOOOJRG]LQDSHáQD ZHUVMDDQJW 

$030 OXEDPSPDSDPSP SU]HGSRSRáXGQLX





0DVNDZSURZDG]DQLDGDQ\FK

6SRVyEZSURZDG]DQLD QLH]DOH QLHRGIRUPDWX ]QDNVWDQGDUGRZ\³B´SRODRGG]LHORQH

UHGQLNDPL

 SRVWDüPDVNL

 F]\]QDNLPDVNL QSP\ OQLNL E G SU]HFKRZ\ZDQHZWDEHOLZUD]]ZSLVDQ ZDUWR FL 

GRP\ OQLHMH OL]QDNLPDVNLE G ]DSLVDQHZWDEHOL 

 LQQ\QL VWDQGDUGRZ\]QDNGRZVND]DQLDPLHMVFDNWyUHQDOH \Z\SHáQLü

1S GRZSURZDG]DQLDGDW\ BBBBBBOXEB

6\PEROHGODPDVNLZSURZDG]DQLD

GRZROQDF\IUDEH]]QDNXNWPXVLE\üZSLVDQD

GRZROQ\]QDNPXVLE\üZSLVDQ\

GRZROQDF\IUDEH]]QDNXOXESXVWHPLHMVFH

&GRZROQ\]QDNOXEQLF

GRZROQDF\IUDOXEQLF]QDNGR]ZRORQ\SXVWHPLHMVFD]DPLHQLDQHQDVSDFMH

]QDNG]LVL WQ\VHSDUDWRU\W\VL F\GDW\LF]DVX SDWU]3DQHO6WHURZDQLD 

/OLWHUDPXVLE\üZSLVDQD

]PLDQDQDVWSRQLPOLWHUQDPDáH

"OLWHUDOXEQLF

‡

]PLDQDQDVWSRQLPOLWHUQDGX H

$OLWHUDOXEF\IUDPXVLE\üZSLVDQD

DOLWHUDF\IUDOXEQLF

Z\SHáQLHQLHPDVNLRGSUDZHMGROHZHMVWURQ\

?SR]ZDODX \üZPDVFHMHGQHJR]ZZ]QDNyZNRQWUROQ\FK

3DVVZRUG KDVáR 8WDMQLHQLHGDQ\FK JZLD]GNL 



:SURZDG]DQLHZ\UD HQLDVSUDZG]DM FHJR

5HJXá\SRSUDZQR FL]DSLVXMHVL ZSRVWDFLZ\UD H 

QSGODSRODSURFBZ\Vá ! $QG  2U

PR QDX \ZDüIXQNFML QS'DWH  

RSHUDWRUyZ/LNH,Q%HWZHHQ$QG

RSHUDWRU/LNH]V]DEORQHP]H]QDNDPLJOREDOQ\PL

"]QDNQDRNUH OPLHMVFX 

GRZROQ\FL J]QDNyZ

SRMHG\QF]DF\IUD





>DN@GRZROQ\]QDN]]DNUHVX

>DN@GRZROQ\]QDNVSR]D]DNUHVX

3U]\NáDG\/LNH³>D]@>D]@´ GRZyGRVRELVW\ 

8ZDJD6DPH]QDNLJOREDOQHPRJ Z\VW SLüMDNROLWHUDá\ZHZ]RUFXPXV] MHGQDNE\ü

RWRF]RQHQDZLDVDPLSURVWRN WQ\PL

RSHUDWRU,Q]DZLHUDOLVW PR OLZ\FKZDUWR FLGODSRODRGG]LHORQ\FK UHGQLNDPL

QS,Q  OXE,Q ³:DUV]DZD´´.UDNyZ´´*GD VN´ 

RSHUDWRU%HWZHHQ$QGSRGDMHPR OLZ\]DNUHVGODZDUWR FLSROD

QS%HWZHHQDQGOXE%HWZHHQ$QG 

5HJXáDSRSUDZQR FLGODWDEHOLXVWDZLDQDZHZáD FLZR FLDFKWDEHOLZyZF]DVJG\ZDUWR ü

MHGQHJRSROD]DOH \RGZDUWR FLLQQHJR QLHPR QDWHJR]URELü]SR]LRPXSROD 

QS>GDWDBZ\VW@ >GDWDBVSU]HG@ QD]Z\SyOWDEHOLZQDZLDVDFKNZDGUDWRZ\FK























background image

.ZHUHQG\



3RGDüOLVW NOLHQWyZ QULPL QD]ZLVNRDGUHV 

3RGDüOLVW GRVWDZFyZLW\WXá\NVL

HNNWyUHV SU]H]QLFKGRVWDUF]DQH OLVWDSRZLQQD

]DZLHUDüLGHQW\ILNDWRULQD]Z GRVWDZF\,6%1LW\WXáNVL

NL 

'ODND GHJRDXWRUDSRGDüOLVW MHJRNVL

HN/LVWDPD]DZLHUDüQD]ZLVNRLLPL DXWRUD

,6%1W\WXáLFHQ NVL

NL

3RGDüLQIRUPDFMHR]DPyZLHQLDFK GDWDQXPHULZDUWR ü]DPyZLHQLD 

8WZRU]\ü]DS\WDQLHPRG\ILNXM FHFHQ NVL

HN

=WDEHOL'RVWDZF\QDOH \XVXQ üWHUHNRUG\GODNWyU\FKSROHµQD]ZD'RVWDZF\¶QLHMHVW

RNUH ORQD

3RGDüOLVW NVL

HN W\WXá,6%1DXWRU]\ 

3RGDüOLF]E W\WXáyZNVL

NRZ\FKRSXEOLNRZDQ\FKSU]H]NROHMQHZ\GDZQLFWZD QD]ZD

Z\GDZF\OLF]EDW\WXáyZ 

3RGDüW\WXá\NVL

HNNWyU\FKOLF]EDVSU]HGDQ\FKHJ]HPSODU]\QLHSU]HNUDF]D

3RGDüW\WXáLDXWRUyZQDMGUR V]HMNVL

NL

3RGDüQD]ZLVNRLLPL NOLHQWDNWyU\QDMF]

FLHM]DPDZLDNVL

NL

3RGDüQD]ZLVNRLLPL NOLHQWDNWyU\Z\GDáQDMZL FHMZELH

F\PURNX

3RGDü UHGQL OLF]E ]DNXSLRQ\FKNVL

HNQDNOLHQWD

'ODND GHJRDXWRUDSRGDüOLF]E VSU]HGDQ\FKNVL

HN/LVWDPDE\üXSRU] GNRZDQD

PDOHM FRZJOLF]E\VSU]HGDQ\FKNVL

HN

'ODND GHJRW\WXáXSRGDüOLF]E VSU]HGDQ\FKNVL

HN/LVWDPDE\üXSRU] GNRZDQD

PDOHM FRZJOLF]E\VSU]HGDQ\FKNVL

HN

-DNLSURFHQWVWDQRZL ]DPyZLHQLDRSáDFDQHNDUW NUHG\WRZ 

'ODND GHJRGRVWDZF\SRGDüOLF]E GRVWDUF]DQ\FKW\WXáyZ

3RGDüW\WXá\NVL

HNNWyU\FKEUDNXMHZPDJD]\QLH

3RGDüLQIRUPDFMHR]DPyZLHQLDFKQLH]UHDOL]RZDQ\FK QXPHU]DPyZLHQLDW\WXáGDQHR

NOLHQFLH 

6SUDZG]LüUR]NáDGLOR FLVSU]HGDQ\FKNVL

HNZSRV]F]HJyOQ\FKPLHVL FDFKURNX

6SUDZG]LüUR]NáDGSU]\FKRGyZZSRV]F]HJyOQ\FKPLHVL FDFKURNX

background image

)RUPXODU]H



8WZRU]\üIRUPXODU]GRSU]HJO GDQLDGDQ\FKRGRVWDZFDFK )'RVWDZF\ 







8WZRU]\üIRUPXODU]GRSU]HJO GDQLDGDQ\FKRNVL

NDFK QDSRGVWDZLHWDEHOL.VL

NL 

IRUPXODU]PDE\üZ\ ZLHWODQ\ZSRVWDFLDUNXV]DGDQ\FK ).VL

NL 







:IRUPXODU]X)'RVWDZF\XPLH FLüSU]\FLVNRWZLHUDM F\IRUPXODU]).VL

NL

:IRUPXODU]X)'RVWDZF\XPLH FLüSRGIRUPXODU]).VL

NL

8WZRU]\üIRUPXODU]HGRZSURZDG]DQLDGDQ\FKGODWDEHO$XWRU]\:\GDZF\'RVWDZF\L

.OLHQFL)RUPXODU]HWHSRZLQQ\XPR OLZLDüZSURZDG]DQLHQRZ\FKUHNRUGyZMDNUyZQLH 

SU]HJO GDQLHLHG\FM LVWQLHM F\FKMX GDQ\FK

8WZRU]\üIRUPXODU]GRSU]HJO GDQLDGDQ\FKRNVL

NDFKZSRGIRUPXODU]XWHJRIRUPXODU]D

QDOH \Z\ ZLHWOLüLPLRQDLQD]ZLVNDDXWRUyZGDQHMNVL

NL UyGáHPGDQ\FKSRGIRUPXODU]D

SRZLQQRE\ü]DS\WDQLH 

background image





8WZRU]\üIRUPXODU]GRZSURZDG]DQLDGDQ\FKGODWDEHO.VL

NLL$XWRU]\.VL

NL'ODSyO

Z\GDZFDGRVWDZFDRUD]DXWRU]\XWZRU]\üOLVW\Z\ERUX

8WZRU]\üIRUPXODU]GRZSURZDG]DQLDGDQ\FKGODWDEHO=DPyZQLHQLDL=DPyZLRQH.VL

NL

'ODSRODQUBNOLHQWDXWZRU]\üOLVW Z\ERUX3U]\ZSURZDG]DQLXSR]\FML]DPyZLHQLDQDOH \

Z\ ZLHWODüGDQHRNVL

NDFK W\WXáVWDQZPDJD]\QLH 

background image

7ZRU]HQLH5DSRUWyZ



8WZRU]\üSU]HGVWDZLRQHSRQL HMUDSRUW\



:\ND]NOLHQWyZ





:\ND]GRVWDZFyZ





$XWRU]\





=DPyZLHQLD





:\UD HQLD

'DWD DNWXDOQDGDWD

1RZ DNWXDOQDGDWDLF]DV

)RUPDW >QD]ZDBNROXPQ\@UUUU Z\VZLHWODURN QD]ZDBNROXPQ\MHVWGDWD 

/HIW >QD]ZDBNROXPQ\@Q Z\VZLHWODQSLHUZV]\FK]QDNRZGDQHJRWHNVWX ]OHZHMVWURQ\ 

5LJKW >QD]ZDBNROXPQ\@Q Z\VZLHWODQSLHUZV]\FK]QDNRZGDQHJRWHNVWX ]SUDZHM

VWURQ\ 



7ZRU]HQLH0DNU

8WZRU]\üIRUPXODU]]JUXS SU]\FLVNyZSROHFHQLDRWZLHUDM F\FKIRUPXODU]H DNFMD

2WZyU])RUPXODU] 

1DSLVDüPDNURRWZLHUDM FHIRUPXODU]]SDUDPHWUHP0DNURSRZLQQRRWZLHUDüIRUPXODU]

]GDQ\PLRNVL

NDFKGDQHJRZ\GDZF\0DNURSRZLQQRE\üXUXFKDPLDQHSU]H]SU]\FLVN

SROHFHQLDZIRUPXODU]X:\GDZF\

1DSLVDüPDNURNWyUHE G]LHXVWDZLDüZDUWR FLZQRZ\FKUHNRUGDFK0DNURSRZLQQR

XáDWZLüGRGDZDQLHQRZ\FKNVL

HNGODGDQHJRGRVWDZF\0DNURWRSRZLQQRE\ü

XUXFKDPLDQH]SR]LRPXIRUPXODU]DÄ'RVWDZF\´SRZLQQRRWZLHUDüIRUPXODU]Ä'RGDM.VL

N ´L

DXWRPDW\F]QLHXVWDZLüZDUWR üNRGXGRVWDZF\GODQRZHMNVL

NL QDOH \VNRU]\VWDü]DNFML

2WZyU])RUPXODU]8VWDZ:DUWR ü 

1DSLVDüPDNURNWyUHXPR OLZL]QDMGRZDQLHRGSRZLHGQLFKUHNRUGyZ]DSRPRF 

Z\ELHUDQLDZDUWR FL]OLVW\/LVWDPDVWDQRZLüGDQHRDXWRUDFK LPL LQD]ZLVNR :

]DOH QR FLRGZ\EUDQHJRDXWRUDZIRUPXODU]XSRZLQQ\E\üZ\ ZLHWODQHGDQHRMHJR

W\WXáDFKNVL

NRZ\FK1DOH \VNRU]\VWDü]DNFML,G 'R(OHP6WHUL=QDMG 5HNRUG




Wyszukiwarka

Podobne podstrony:
cwiczonko drugie z baz danych na stopieniek
Analiza baz danych na temat materiałów betonopodobnych
Analiza baz danych na temat materiałów betonopodobnych
Systemy Baz Danych (cz 1 2)
bd cz 2 jezyki zapytan do baz danych
Modele Baz Danych 2

więcej podobnych podstron