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

NLFHQD.VL

NLGDWD=DP=DPyZLHQLHGDWD:\V

=DPyZLRQH.VL

NL

GODZ\EUDQ\FKSyOZWDEHODFKRNUH OLüZDUWR FLGRP\ OQH

RNUH OLüIRUPDWZ\ ZLHWODQLDGODSyONWyU\FKZDUWR FLE G QLHRNUH ORQHGODQLHRNUH 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%XGXMOXENOLNQLMSU]\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]QDNLOLWHU\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

SRODFKZWDEHOLSRGVWDZRZHMPXVLMX 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 ]DQHMND GDZDUWR ü

NOXF]DSRGVWDZRZHJRPR HVL ZLHORNURWQLHSRMDZLDüZWDEHOL]ZL ]DQHM1DSU]\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\ OQHQD]ZDSRODGODQRZ\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]VLHELHRELHNWyZZIRUPXODU]DFKWDEHOH]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]DZLHUDQXOOSXVWR

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

]QDNLIRUPDWRZDQLD

‡

Z\ ZLHWODQLHGX \PLOLWHUDPL

Z\ ZLHWODQLHPDá\PLOLWHUDPL

#UHSUH]HQWXMHWHNVW]QDNMH OLQLHPD]QDNXZ\ ZLHWODQDMHVWVSDFMD

UHSUH]HQWXMHWHNVW]QDNMH 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]QDNyZW\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]DZLHUDQXOOSXVWR

]QDNLIRUPDWRZDQLD

MHGQDF\IUDMH OLMHMEUDNZ\ ZMHVW]HUR

MHGQDF\IUDMH OLMHMEUDNZ\ ZMHVWVSDFMD

IRUPDWSURFHQWRZ\

(OXEH(OXEH Z\ ZZSRVWDFLHNVSRQHQFMDOQHMQS(

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\JRGQLDZHUVMDDQJZ

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]LQDZHUVMDDQJK

NQUNZDUWDáXZHUVMDDQJT

UQUGQLDZURNXZHUVMDDQJ\

UUURN

PPLQXWDZHUVMDDQJQ

UUUUURN

PPPLQXWD

background image

VVHNXQGD

VVVHNXQGD

OOOOOJRG]LQDSHáQDZHUVMDDQJW

$030OXEDPSPDSDPSPSU]HGSRSRáXGQLX

0DVNDZSURZDG]DQLDGDQ\FK

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

UHGQLNDPL

SRVWDüPDVNL

F]\]QDNLPDVNLQSP\ OQLNLE G SU]HFKRZ\ZDQHZWDEHOLZUD]]ZSLVDQ ZDUWR FL

GRP\ OQLHMH OL]QDNLPDVNLE G ]DSLVDQHZWDEHOL

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

1SGRZSURZDG]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]DVXSDWU]3DQHO6WHURZDQLD

/OLWHUDPXVLE\üZSLVDQD

]PLDQDQDVWSRQLPOLWHUQDPDáH

"OLWHUDOXEQLF

‡

]PLDQDQDVWSRQLPOLWHUQDGX H

$OLWHUDOXEF\IUDPXVLE\üZSLVDQD

DOLWHUDF\IUDOXEQLF

Z\SHáQLHQLHPDVNLRGSUDZHMGROHZHMVWURQ\

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

3DVVZRUGKDVáR8WDMQLHQLHGDQ\FKJZLD]GNL

:SURZDG]DQLHZ\UD HQLDVSUDZG]DM FHJR

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

QSGODSRODSURFBZ\Vá! $QG 2U

PR QDX \ZDüIXQNFMLQS'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,QOXE,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 FLLQQHJRQLHPR QDWHJR]URELü]SR]LRPXSROD

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

background image

.ZHUHQG\

3RGDüOLVW NOLHQWyZQULPL QD]ZLVNRDGUHV

3RGDüOLVW GRVWDZFyZLW\WXá\NVL

HNNWyUHV SU]H]QLFKGRVWDUF]DQHOLVWDSRZLQQD

]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]DPyZLHQLDFKGDWDQXPHULZDUWR ü]DPyZLHQLD

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

HN

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

RNUH ORQD

3RGDüOLVW NVL

HNW\WXá,6%1DXWRU]\

3RGDüOLF]E W\WXáyZNVL

NRZ\FKRSXEOLNRZDQ\FKSU]H]NROHMQHZ\GDZQLFWZDQD]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\FKQXPHU]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

NDFKQDSRGVWDZLHWDEHOL.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

NDFKW\WXáVWDQZPDJD]\QLH

background image

7ZRU]HQLH5DSRUWyZ

8WZRU]\üSU]HGVWDZLRQHSRQL HMUDSRUW\

:\ND]NOLHQWyZ

:\ND]GRVWDZFyZ

$XWRU]\

=DPyZLHQLD

:\UD HQLD

'DWDDNWXDOQDGDWD

1RZDNWXDOQDGDWDLF]DV

)RUPDW>QD]ZDBNROXPQ\@UUUUZ\VZLHWODURNQD]ZDBNROXPQ\MHVWGDWD

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

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

VWURQ\

7ZRU]HQLH0DNU

8WZRU]\üIRUPXODU]]JUXS SU]\FLVNyZSROHFHQLDRWZLHUDM F\FKIRUPXODU]HDNFMD

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

NLQDOH \VNRU]\VWDü]DNFML

2WZyU])RUPXODU]8VWDZ:DUWR ü

1DSLVDüPDNURNWyUHXPR OLZL]QDMGRZDQLHRGSRZLHGQLFKUHNRUGyZ]DSRPRF

Z\ELHUDQLDZDUWR FL]OLVW\/LVWDPDVWDQRZLüGDQHRDXWRUDFKLPL 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
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
Access 2002 Projektowanie baz danych Ksiega eksperta ac22ke
Opis baz danych zgodny z TERYT
Oracle8i Podrecznik administratora baz danych or8pab
System plików to sposób organizacji danych na dyskach, Notatki z systemów
Wymagania techniczne na stopień 5 KYU
EGZAMIN NA STOPIEŃ MŁODSZEGO RATOWNIKA WOPR test1, Test 1 i 2
Instrukcja korzystania z eduk baz danych iScala Enterprise WSB Wrocław
problematyka masoowego dostepu do baz danych mity i fakty mqsixoztwl26gv7afh6a6hsnoalkzz6a5q7na7a M
Zaswiadczenie o akceptacji komisji kwalifikacyjnej na stopien nauczyciela kontraktowego, kadry-i-awa
Próba na stopień pionierka odkrywca
Projektowanie baz danych

więcej podobnych podstron