cwiczonko drugie z baz danych na stopieniek


&ZLF]HQLH ,,
8WZyU] ED] GDQ\FK ZJ ]Dá F]RQHJR VFKHPDWX RNUH O NOXF]H JáyZQH Z SRV]F]HJyOQ\FK
WDEHODFK RUD] UHODFMH PL G]\ WDEHODPL
3RV]F]HJyOQH SROD SRZLQQ\ VSHáQLDü QDVW SXM FH ZDUXQNL
XVWDOLü PDVNL ZSURZDG]DQLD GOD SyO NWyUH VWDQRZL NRG SRF]WRZ\
GOD ND GHJR SROD Z SRV]F]HJyOQ\FK WDEHODFK XVWDOLü ZDUWR ü DWU\EXWX µ:\PDJDQHÅ›
XVWDOLü UHJXá SRSUDZQR FL ZUD] ] RGSRZLHGQLP NRPXQLNDWHP R Eá G]LH GOD QDVW SXM F\FK
SyO LOR ü =DPyZLRQH.VL NL FHQD .VL NL GDWD=DP =DPyZLHQLH GDWD:\V
=DPyZLRQH.VL NL
GOD Z\EUDQ\FK SyO Z WDEHODFK RNUH OLü ZDUWR FL GRP\ OQH
RNUH OLü IRUPDW Z\ ZLHWODQLD GOD SyO NWyU\FK ZDUWR FL E G QLHRNUH ORQH GOD QLHRNUH ORQ\FK
SyO WHNVRZ\FK SRZLQLHQ E\ü Z\ ZLHWODQ\ WHNVW Ä1LH]QDQH´ GOD SyO OLF]ERZ\FK Ä1XOO´
GOD Z\EUDQ\FK SyO XVWDOLü DWU\EXW µ,QGHNVRZDQHÅ›
XWZRU]\ü LQGHNV ZLHORSRORZ\
'RGDM GR SRV]F]HJyOQ\FK WDEHO UHNRUG\
3RPRF
7DEHOH L 5HODFMH
&R WR MHVW WDEHOD"
7DEHOD MHVW SRMHPQLNLHP QD GDQH GRW\F] FH NRQNUHWQHJR WHPDWX QS LQIRUPDFMH GRW\F] FH
SUDFRZQLNyZ OXE IDNWXU VSU]HGD \ : ED]LH GDQ\FK PR H E\ü ZLHOH WDEHO ] NWyU\FK ND GD
SU]HFKRZXMH LQIRUPDFMH GRW\F] FH LQQHJR WHPDWX .D GD ] WDEHO PR H ]DZLHUDü GDQH ZLHOX
W\SyZ Zá F]QLH ] WHNVWHP OLF]EDPL GDWDPL L REUD]DPL
7ZRU]HQLH WDEHOL
8WZRU]RQD WDEHOD MHVW SXVW\P SRMHPQLNLHP QD GDQH 7DEHO SURMHNWXMH VL ]D]Z\F]DM ] P\ O
R SU]HFKRZ\ZDQLX Z QLHM GDQ\FK RNUH ORQHJR URG]DMX QD SU]\NáDG QD]ZLVN L DGUHVyZ 3R
]DFKRZDQLX WDEHOL PR QD GR QLHM ZSURZDG]Lü GDQH
1DMSURVWV]\P VSRVREHP WZRU]HQLD W\SRZ\FK WDEHO GR FHOyZ ]DZRGRZ\FK OXE SU\ZDWQ\FK
MHVW X \FLH .UHDWRUD WDEHO
$E\ XWZRU]\ü WDEHOH ]D SRPRF NUHDWRUD WDEHO
: RNQLH ED]\ GDQ\FK NOLNQLM SU]\FLVN Å‚7DEHOD´ OXE ] PHQX :LGRN Z\ELHU] SROHFHQLH
7DEHOD
:\ELHU] SU]\FLVN Å‚1RZ\´
:\ELHU] SU]\FLVN Å‚.UHDWRU\ WDEHO´
$E\ GRGDü SROD GR WZRU]RQHM WDEHOL SRVW SXM ]JRGQLH ]H ZVND]yZNDPL Z\ ZLHWODQ\PL Z
SRODFK GLDORJRZ\FK .UHDWRUD WDEHO
3R ]DNR F]HQLX WZRU]HQLD WDEHOL PR QD Z\EUDü MHGQ ] GZyFK RSFML RWZRU]\ü WDEHO Z
ZLGRNX 3URMHNW FHOX Z\ ZLHWOHQLD L PRG\ILNDFML SURMHNWX WDEHOL OXE RWZRU]\ü MD Z ZLGRNX
$UNXV] GDQ\FK DE\ UR]SRF] ü ZSURZDG]DQLH GDQ\FK 0R QD WDN H Z\EUDü RSFM WZRU]HQLD
QRZHJR IRUPXODU]D GR Z\ ZLHWOHQLD GDQ\FK Z WDEHOL
7DEHO PR QD WDN H XWZRU]\ü LPSRUWXM F GDQH OXE ]Dá F]DM F ]HZQ WU]Q WDEHO GR ZáDVQHM
ED]\ GDQ\FK
$E\ XWZRU]\ü WDEHO EH] SRPRF\ NUHDWRUD WDEHO
: RNQLH ED]\ GDQ\FK NOLNQLM SU]\FLVN Å‚7DEHOD´ OXE ] PHQX :LGRN Z\ELHU] SROHFHQLH
7DEHOD
:\ELHU] SU]\FLVN Å‚1RZ\´
:\ELHU] SU]\FLVN Å‚1RZD WDEHOD´
=RVWDQLH RWZDUWH SXVWH RNQR WDEHOL Z ZLGRNX 3URMHNW
: WUDNFLH SURMHNWRZDQLD OXE PRG\ILNDFML WDEHOL Z JyUQHM F] FL RNQD WDEHOL RNUH OD VL SROD
NWyUH PD ]DZLHUDü WDEHOD : GROQHM F] FL RNQD PR QD RNUH OLü ZáD FLZR FL ND GHJR ] SyO
'RGDZDQLH SyO
5HNRUG\ Z WDEHOL PRJ ]DZLHUDü Uy QH NDWHJRULH LQIRUPDFML 'R WDEHOL QDOH \ GRGDü SROH GOD
ND GHM NDWHJRULL LQIRUPDFML NWyUH PDM E\ü Z QLHM SU]HFKRZ\ZDQH QD SU]\NáDG WDEHOD
SU]HFKRZXM FD UHNRUG\ SUDFRZQLNyZ PR H ]DZLHUDü SROD SU]H]QDF]RQH QD QD]ZLVNR DGUHV
L QXPHU WHOHIRQX SUDFRZQLND
7ZRU]HQLH WDEHOL UR]SRF]\QD VL RG RNUH OHQLD SyO SRF] ZV]\ RG SLHUZV]HJR ZLHUV]D JyUQHM
F] FL RNQD WDEHOL 'R ND GHJR ZLHUV]D QDOH \ ZSURZDG]Lü QD]Z SROD L W\S GDQ\FK PR QD
WDN H GRá F]\ü RSFMRQDOQ\ RSLV SROD SRMDZLDM F\ VL QDVW SQLH QD SDVNX VWDQX Z WUDNFLH
ZSURZDG]DQLD GDQ\FK GR SROD
.RU]\VWDQLH ] JHQHUDWRUD SyO
-H OL EUDN SHZQR FL MDN QD]ZDü SROH OXE MDNLHJR X \ü W\SX GDQ\FK ZDUWR VNRU]\VWDü ]
ZF]H QLHM SU]\JRWRZDQHM OLVW\ SyO :\NRU]\VWXM F *HQHUDWRU SyO PR QD GRNRQDü Z\ERUX ]
W\FK VDP\FK OLVW SyO NWyUH V GRVW SQH Z WUDNFLH NRU]\VWDQLD ] .UHDWRUD WDEHO SyO ]
SU]\NáDGRZ\FK WDEHO GRW\F] F\FK WDNLFK G]LHG]LQ MDN NRQWDNW\ KDQGORZH Z\SRVD HQLH
GRPX OXE NDUWRWHND PHG\F]QD
$E\ GRGDü SROH ]D SRPRF *HQHUDWRUD SyO
: RNQLH WDEHOL NOLNQLM ZLHUV] Z NWyU\P FKFHV] GRGDü SROH
.OLNQLM SUDZ\P SU]\FLVNLHP P\V]\ Z FHOX Z\ ZLHWOHQLD PHQX SRGU F]QHJR D QDVW SQLH
Z\ELHU] SROHFHQLH %XGXM OXE NOLNQLM SU]\FLVN Å‚%XGXM´ QD SDVNX QDU] G]L
=D]QDF] WDEHO Z SROX Å‚7DEHOH SU]\NáDGRZH´
=D]QDF] QD]Z SROD Z SROX Å‚3U]\NáDGRZH SROD´
:\ELHU] SU]\FLVN Å‚2. ´
'R ELH FHJR ZLHUV]D Z RNQLH WDEHOL ]RVWDQLH ZVWDZLRQD Z\EUDQD QD]ZD SROD XVWDZLRQ\
RGSRZLHGQL W\S GDQ\FK SROD RUD] ZáD FLZR FL WHJR SROD -H OL ELH F\ ZLHUV] MX ]DZLHUD
SROH ]RVWDQLH ZVWDZLRQ\ QRZ\ ZLHUV]
1D]\ZDQLH SyO
3LHUZV] F]\QQR FL ]ZL ]DQ ] GRGDZDQLHP SROD MHVW ZSLVDQLH MHJR QD]Z\ Z NROXPQLH
Å‚1D]ZD SROD´ 1D]Z\ SyO PRJ ]DZLHUDü PDNV\PDOQLH ]QDNL OLWHU\ OXE F\IU\ ]H VSDFMDPL
Zá F]QLH
:\ELHUDQLH W\SyZ GDQ\FK
SR QD]ZDQLX SROD QDOH \ Z\EUDü W\S GDQ\FK NWyUH PDM E\ü SU]HFKRZ\ZDQH Z SROX
:\ELHUDM F W\S GDQ\FK MHGQRF]H QLH RNUH OD VL
! 5RG]DM ZDUWR FL NWyUH PRJ E\ü SU]HFKRZ\ZDQH Z SROX 1D SU]\NáDG QLH PR QD
SU]HFKRZ\ZDü WHNVWX Z SROX R W\SLH GDQ\FK /LF]ED
! 5R]PLDU REV]DUX SDPL FL SU]\G]LHORQHJR GOD ZDUWR FL SU]HFKRZ\ZDQ\FK Z SROX 1D
SU]\NáDG ND GD ZDUWR ü W\SX :DOXWD ]DMPXMH EDMWyZ SDPL FL
! 7\S RSHUDFML NWyUH PRJ E\ü Z\NRQ\ZDQH QD ZDUWR FLDFK SU]HFKRZ\ZDQ\FK Z W\P
SROX 1D SU]\NáDG PR QD REOLF]\ü VXP ZDUWR FL Z SROX R W\SLH /LF]ED OXE :DOXWD DOH QLH
QD ZDUWR FLDFK W\SX 7HNVW OXE RELHNW 2/(
! &]\ PR QD Z\NRQ\ZDü LQGHNVRZDQLH OXE VRUWRZDQLH ZDUWR FL Z SROX QLH PR QD
VRUWRZDü DQL WZRU]\ü LQGHNVyZ GOD SyO W\SX 0HPR OXE RELHNW 2/(
7\S\ GDQ\FK
7HNVW ]QDNL DOIDQXPHU\F]QH UR]PLDU GR EDMWyZ
0HPR ]QDNL DOIDQXPHU\F]QH GR EDMWyZ
/LF]ED ZDUWR FL OLF]ERZH OXE EDMWyZ
'DWD *RG]LQD GDW\ L JRG]LQ\ EDMWyZ
:DOXWD ZDUWR FL SLHQL QH EDMWyZ
/LF]QLN ZDUWR FL OLF]ERZH ]ZL NV]DQH DXWRPDW\F]QLH GOD ND GHJR QRZHJR UHNRUGX EDMW\
7DN 1LH ZDUWR FL ORJLF]QH ELW
2ELHNW 2/( 2ELHNW\ 2/( JUDILND OXE LQQH GDQH ELQDUQH GR JLJDEDMWD
: SU]\SDGNX W\SX WHNVW L /LF]ED PR QD SUHF\]\MQLHM RNUH OLü W\S GDQ\FK L UR]PLDU SROD
2SLV\ZDQLH SyO
$E\ WDEHOH E\á\ EDUG]LHM F]\WHOQH L áDWZLHMV]H GR DNWXDOL]DFML GR ND GHJR SROD Z WDEHOL PR QD
GRá F]\ü RSLV : WUDNFLH ZSURZDG]DQLD GDQ\FK GR SROD OXE GR HOHPHQWX VWHUXM FHJR
]ZL ]DQHJR ] SROHP MHJR RSLV MHVW Z\ ZLHWODQ\ QD SDVNX VWDQX
8VWDZLHQLH NOXF]D SRGVWDZRZHJR
3URJUDP 0LFURVRIW $FFHVV G]LDáD HIHNW\ZQLHM MH OL MHVW RNUH ORQ\ NOXF] SRGVWDZRZ\ .OXF]
SRGVWDZRZ\ WDEHOL VNáDGD VL ] MHGQHJR OXE ZLHOX SyO MHGQR]QDF]QLH LGHQW\ILNXM F ND G\
UHNRUG SU]HFKRZ\ZDQ\ Z WDEHOL
NOXF]HP SRGVWDZRZ\P PR H E\ü QXPHU SRU] GNRZ\ OXE NRG SRQLHZD ZDUWR ü WHJR W\SX
MHVW ]DZV]H LQQD GOD ND GHJR UHNRUGX 1D SU]\NáDG Z WDEHOL Å‚3UDFRZQLF\´ Z ED]LH GDQ\FK
1RUWKZLQG ND G\ PD MHGQR]QDF]Q\ QXPHU SRU] GNRZ\ .OXF]HP SRGVWDZRZ\P WHM WDEHOL
MHVW SROH Å‚1U 3UDFRZQLND´
7DEHOD ] RNUH ORQ\P NOXF]HP SRGVWDZRZ\P PD QDVW SXM FH ]DOHW\
: SURJUDPLH 0LFURVRIW $FFHVV MHVW DXWRPDW\F]QLH WZRU]RQ\ LQGHNV GOD NOXF]D
SRGVWDZRZHJR ,QGHNV SU]\ SLHV]D G]LDáDQLH ]DS\WD L LQQ\FK RSHUDFML
MH OL UHNRUG\ V SU]HJO GDQH Z IRUPXODU]X OXE DUNXV]X GDQ\FK WR V RQH GRP\ OQLH
Z\ ZLHWODQH Z SRU] GNX ZHGáXJ VZ\FK NOXF]\ SRGVWDZRZ\FK
'RGDQLH GR WDEHOL UHNRUGX R ZDUWR FL NOXF]D SRGVWDZRZHJR NWyUD MX LVWQLHMH Z WDEHOL QLH
MHVW DNFHSWRZDQH ']L NL WHPX ND G\ UHNRUG MHVW LGHQW\ILNRZDQ\ MHGQR]QDF]QLH
0R OLZH MHVW WDN H XWZRU]HQLH ZLHORSRORZHJR NOXF]D SRGVWDZRZHJR Z SU]\SDGNX JG\ DGQH
SRMHG\QF]H SROH Z WDEHOL QLH ]DZLHUD XQLNDWRZ\FK ZDUWR FL
'RGDZDQLH UHNRUGyZ
3R ]DSURMHNWRZDQLX WDEHOL PR QD UR]SRF] ü GRGDZDQLH UHNRUGyZ
8VWDZLHQLH UHODFML SRPL G]\ WDEHODPL
0LFURVRIW $FFHVV MHVW UHODF\MQ ED] GDQ\FK PR QD ]DWHP UyZQRF]H QLH Z\NRU]\VW\ZDü
GDQH ] ZLHOX WDEHO OXE ]DS\WD -H OL ED]D GDQ\FK ]DZLHUD WDEHOH ] SRZL ]DQ\PL GDQ\PL
PR QD Z QLHM RNUH OLü UHODFMH UHODFMH XPR OLZLDM
WZRU]HQLH SRá F]H Z QRZ\FK ]DS\WDQLDFK
Z\ ZLHWODQLH SRZL ]DQ\FK UHNRUGyZ SRGIRUPXODU]X OXE SRGUDSRUFLH
Z\PXV]DQLH ZL ]yZ LQWHJUDOQR FL Z FHOX RFKURQ\ UHODFML PL G]\ WDEHODPL Z WUDNFLH
GRGDZDQLD ]PLDQ\ OXE XVXZDQLD UHNRUGyZ
3RZL ]DQLH ]H VRE WDEHO OXE ]DS\WD QDVW SXMH Z Z\QLNX XVWDOHQLD MHGQHJR OXE ZLHOX SyO
]DZLHUDM F\FK WH VDPH ZDUWR FL Z SRZL ]DQ\FK UHNRUGDFK 1RZR XWZRU]RQD WDEHOD QLH MHVW
]ZL ]DQD ] DGQD LQQ WDEHO $E\ XWZRU]\ü UHODFM QDOH \ ]DF] ü RG RWZDUFLD RNQD UHODFML L
GRGDQLD WDEHO OXE ]DS\WD NWyUH PRJ E\ü SRZL ]DQH 1DVW SQLH QDOH \ VDPRG]LHOQLH
]GHILQLRZDü UHODFM
: SU]\SDGNX QLHNWyU\FK UHODFML SU]\ GRGDZDQLX OXE XVXZDQLX UHNRUGyZ ] SRZL ]DQ\FK WDEHO
PRJ E\ü Z\PXV]RQH ZL ]\ LQWHJUDOQR FL =DSHZQLDM RQH SRSUDZQR ü UHODFML PL G]\
UHNRUGDPL RUD] SR]ZDODM XQLNQ ü SU]\SDGNRZHJR XVXQL FLD SRZL ]DQ\FK GDQ\FK 0R QD MH
Z\PXVLü MH HOL VSHáQLRQH V QDVW SXM FH ZDUXQNL
2GSRZLDGDM FH SROH ] WDEHOL SRGVWDZRZHM MHVW NOXF]HP SRGVWDZRZ\P OXE PD XQLNDWRZ\
LQGHNV
3RZL ]DQH SROD PDM WHQ VDP W\S GDQ\FK
2E\GZLH WDEHOH QDOH GR WHM VDPHM ED]\ GDQ\FK 0LFURVRIW $FFHVV -H OL WDEHOH V
]Dá F]RQH PXV] QDOH Hü GR WHM VDPHM ED]\ GDQ\FK 0LFURVRIW $FFHVV
-H OL V Z\PXV]RQH ZL ]\ LQWHJUDOQR FL QDOH \ SU]HVWU]HJDü QDVW SXM F\FK ]DVDG
*G\ GR ]ZL ]DQHM WDEHOL MHVW GRGDZDQ\ UHNRUG L MHVW RNUH ODQD ZDUWR ü Z ]ZL ]DQ\P SROX
SRODFK Z WDEHOL SRGVWDZRZHM PXVL MX LVWQLHü UHNRUG ] W ZDUWR FL
8VXQL FLH UHNRUGX ] WDEHOL SRGVWDZRZHM MHVW QLHPR OLZH MH OL Z WDEHOL ]ZL ]DQHM LVWQLHM
RGSRZLDGDM FH PX UHNRUG\
7\S\ UHODFML
: SU]\SDGNX UHODFML GOD NWyU\FK ]RVWDá\ Z\PXV]RQH ZL ]\ LQWHJUDOQR FL QDOH \ RNUH OLü F]\
UHODFMD ]D SRPRF NWyUHM PDM E\ü SRZL ]DQH GZLH WDEHOH MHVW W\S MHGHQ GR ZLHOX F]\ MHGHQ
GR MHGQHJR : QDMF] VWV]\P SU]\SDGNX Ä… UHODFML W\SX MHGHQ GR ZLHOX Ä… ND G\ UHNRUG Z WDEHOL
SRGVWDZRZHM PR H E\ü ]ZL ]DQ\ ] ZLHORPD UHNRUGDPL ] WDEHOL ]ZL ]DQHM ND GD ZDUWR ü
NOXF]D SRGVWDZRZHJR PR H VL ZLHORNURWQLH SRMDZLDü Z WDEHOL ]ZL ]DQHM 1D SU]\NáDG ND G\
UHNRUG GRVWDZF\ PR H E\ü ]ZL ]DQ\ ] ZLHORPD UHNRUGDPL SURGXNWyZ
: UHODFML W\SX MHGHQ GR MHGQHJR ND G\ UHNRUG Z WDEHOL SRGVWDZRZHM PR H E\ü ]ZL ]DQ\ W\ONR
] MHGQ\P UHNRUGHP Z WDEHOL ]ZL ]DQHM : ZLHOX SU]\SDGNDFK RGSRZLDGDM FH VRELH SROD SR
REX VWURQDFK UHODFML V NOXF]DPL SRGVWDZRZ\PL OXE PDM XQLNDWRZ\ LQGHNV
2SHUDFMH XVXZDQLD L DNWXDOL]DFML NDVNDGRZHM
'OD UHODFML GOD NWyU\FK V Z\PXV]DQH ZL ]\ LQWHJUDOQR FL PR QD RNUH OLü F]\ PDM E\ü
Z\NRQ\ZDQH DXWRPDW\F]QH RSHUDFMH Å‚NDVNDGRZHJR´ XVXZDQLD L DNWXDOL]DFML ]ZL ]DQ\FK
UHNRUGyZ -H OL WH RSFMH V ]D]QDF]RQH RSHUDFMH XVXZDQLD L DNWXDOL]DFML NWyUH QRUPDOQLH
áDPDá\ E\ ]DVDG\ ZL ]yZ LQWHJUDOQR FL VWDMD VL GRSXV]F]DOQH : FHOX LFK ]DFKRZDQLD Z
SU]\SDGNX XVXZDQLD UHNRUGyZ OXE ]PLDQ\ ZDUWR FL NOXF]D SRGVWDZRZHJR Z WDEHOL GR
]ZL ]DQ\FK WDEHO V DXWRPDW\F]QLH ZSURZDG]DQH QLH]E GQH ]PLDQ\
8VWDZLDQLH ZáD FLZR FL SROD
8 \WNRZQLN PR H XVWDODü Z\JO G GDQ\FK ]DSRELHJDü ZSURZDG]DQLX QLHSRSUDZQ\FK
GDQ\FK RNUH OLü ZDUWR FL GRP\ OQH RUD] SU]\VSLHV]Dü Z\V]XNLZDQLH L VRUWRZDQLH XVWDZLDM F
ZáD FLZR FL SROD Z ZLGRNX 3URMHNW WDEHOL 1D SU]\NáDG PR QD IRUPDWRZDü OLF]E\ DE\ E\á\
EDUG]LHM F]\WHOQH OXE XVWDZLü ZDUXQNL NWyUH PXV] VSHáQLDü GDQH DE\ PRJá\ E\ü
ZSURZDG]RQH GR SROD
8VWDZLHQLD ZáD FLZR FL SROD V Z\NRU]\VW\ZDQH Z WUDNFLH SU]HJO GDQLD L HG\FML GDQ\FK
8VWDZLRQH ZáD FLZR FL Å‚)RUPDW´ Å‚0DVND ZSURZDG]HQLD´ L Å‚7\WXá´ SRMDZLDM VL Z DUNXV]DFK
GDQ\FK WDEHO L ]DS\WD D WDN H Z HOHPHQWDFK VWHUXM F\FK IRUPXODU]\ L UDSRUWyZ
Z\NRU]\VWXM F\FK WDEHO MDNR SRGVWDZ L SU]HMPXM F\FK GRP\ OQLH WH ZáD FLZR FL ,QQH
ZáD FLZR FL V Z\NRU]\VW\ZDQH GR XVWDZLDQLD UHJXá GRW\F] F\FK ZSURZDG]DQLD GDQ\FK OXE
RNUH OHQLD Z\PDJD ZSURZDG]HQLD GDQ\FK GR SyO 6 RQH DNW\ZQH SRGF]DV ND GHJR
ZSURZDG]DQLD OXE HG\FML GDQ\FK Z WDEHOL
:áD FLZR FL SROD L ]DVWRVRZDQLD
5R]PLDU SROD Ä… 8VWDZLDQLH UR]PLDUX SROD 7HNVW OXE RJUDQLF]HQLH ]DNUHVX GRSXV]F]DOQ\FK
ZDUWR FL Z SROX W\SX /LF]ED 1D SU]\NáDG GR SROD WHNVWRZHJR R UR]PLDU]H SROD QLH PR QD
SU]\SDGNRZR ZSURZDG]Lü ZL FHM QL V]H FLX ]QDNyZ
)RUPDW Ä… :\ ZLHWODQLH GDW L OLF]E Z SHZQ\P IRUPDFLH WDNLP MDN IRUPDW GDW\ 'DWD SHáQD OXE
IRUPDW 3URFHQW
0LHMVFD G]LHVL WQH Ä… :\ ZLHWODQLH RNUH ORQHM OLF]E\ PLHMVF SR SU]HFLQNX G]LHVL WQ\P Z
SU]\SDGNX ]DVWRVRZDQLD IRUPDWX GOD SROD W\SX /LF]ED OXE :DOXWD
0DVND ZSURZDG]DQLD :\ ZLHWOHQLH ]QDNyZ IRUPDWXM F\FK Z SROX DE\ E\áR ]E GQH LFK
ZSURZDG]DQLH L ]DSHZQLHQLH H ZSURZDG]RQH GDQH SDVXM GR PDVNL
7\WXá Ä… 2NUH OHQLH HW\NLHW LQQ\FK QL GRP\ OQH QD]ZD SROD GOD QRZ\FK IRUPXODU]\ L
UDSRUWyZ
:DUWR ü GRP\ OQD Ä… $XWRPDW\F]QH ZSLV\ZDQLH SHZQHM ZDUWR FL GR SROD Z QRZ\FK
UHNRUGDFK GRGDZDQ\FK GR WDEHOL
5HJXáD SRSUDZQR FL Ä… 2JUDQLF]HQLH GDQ\FK ZSURZDG]DQ\FK GR SROD GR ZDUWR FL
VSHáQLDM F\FK SHZQH Z\PDJDQLD 3RPRFQ\ SU]\ ZSURZDG]DQLX Z\UD HQLD VSUDZG]DM FHJR
MHVW *HQHUDWRU Z\UD H PR H NRU]\VWDü ] IXQNFML VWDá\FK L RSHUDWRUyZ $FFHVV D RUD]
XWZRU]RQ\FK SU]H] VLHELH RELHNWyZ Z IRUPXODU]DFK WDEHOH ]DS\WDQLD IRUPXODU]H
UDSRUW\
.RPXQLNDW R Eá G]LH Ä… 7UH ü NRPXQLNDWX NWyU\ PD VL SRMDZLü MH OL Z\VW SLá Eá G
QLHVSHáQLHQLD UHJXá\ SRSUDZQR FL
:\PDJDQH Ä… :\PDJDQLH ZSURZDG]HQLD GDQ\FK GR SROD
=HURZD GáXJR ü Ä… 'RSXV]F]HQLH SU]HFKRZ\ZDQLD FL JyZ ]QDNyZ R ]HURZHM GáXJR FL Z
SRODFK W\SX 7HNVW L 0HPR -H OL XVWDZLP\ Å‚7$.´ WR SU]HFKRZ\ZDQH V FL JL ]QDNyZ R
GáXJR FL ]HURZHM ]DPLDVW ZDUWR FL 1XOO OXE SU]HFKRZ\ZDQH V ]DUyZQR ZDUWR FL 1XOO MDN L
FL JL ]QDNyZ R GáXJR FL ]HURZHM
,QGHNVRZDQH Ä… 3U]\VSLHV]HQLH Z\V]XNLZDQLD Z F] VWR SU]HV]XNLZDQ\FK SRODFK
)RUPDW\ GDQ\FK Ä… VSRVyE Z\ ZLHWODQLD GDQ\FK Z WU\ELH :LGRN
)RUPDW\ $FFHVV D
GOD W\SX /LF]ED RJyOQ\ SURFHQWRZ\ QDXNRZ\ ZDOXWD IL[HG VWDQGDUG
GOD W\SX 'DWD *RG]LQD RJyOQ\ GDWD F]DV GáXJD UHGQLD NUyWND
GOD W\SX ORJLF]QHJR 7DN 1LH :á :\á 2Q 2II
)RUPDW\ ZáDVQH
GOD W\SyZ WHNVWRZ\FK SROD RGG]LHORQH UHGQLNDPL
VSRVyE Z\ ZLHWODQLD
FR SRMDZL VL JG\ SROH ]DZLHUD áD FXFK ]HURZ\ QDOH \ Zá F]\ü DWU\EXW =HURZD Gá
FR SRMDZL VL JG\ SROH ]DZLHUD QXOO SXVWR
QS # ´1LH SRGDQR´>&]HUZRQ\@ ´1LH ]QDQ\´
]QDNL IRUPDWRZDQLD
! Z\ ZLHWODQLH GX \PL OLWHUDPL Z\ ZLHWODQLH PDá\PL OLWHUDPL
# UHSUH]HQWXMH WHNVW ]QDN MH OL QLH PD ]QDNX Z\ ZLHWODQD MHVW VSDFMD
UHSUH]HQWXMH WHNVW ]QDN MH OL QLH PD ]QDNX QLF QLH MHVW Z\ ZLHWODQH
? ZVWDZLDQ\ SU]HG P\ OQLNLHP V\JQDOL]XMH H QDVW SXM F\ SR QLP SRMHG\QF]\ ]QDN QLH MHVW
]QDNLHP NRQWUROQ\P L PD E\ü Z\ ZLHWORQ\
3U]\NáDG\ #? ##? ## WHOHIRQ
##? ### NRG SRF]WRZ\
?´ ?´ SROH Z FXG]\VáRZDFK ]QDNyZ W\OH MDND Gá
SROD
Å‚XO Å‚ SROH ] GRSLVNLHP VWDá\P
GOD W\SyZ OLF]ERZ\FK SROD RGG]LHORQH UHGQLNDPL
FR SRMDZL VL JG\ SROH ]DZLHUD ZDUWR FL GRGDWQLH
FR SRMDZL VL JG\ SROH ]DZLHUD ZDUWR FL XMHPQH
FR SRMDZL VL JG\ SROH ]DZLHUD ]HUR
FR SRMDZL VL JG\ SROH ]DZLHUD QXOO SXVWR
]QDNL IRUPDWRZDQLD
MHGQD F\IUD MH OL MHM EUDN Z\ Z MHVW ]HUR
MHGQD F\IUD MH OL MHM EUDN Z\ Z MHVW VSDFMD
IRUPDW SURFHQWRZ\
( OXE H ( OXE H Z\ Z Z SRVWDFL HNVSRQHQFMDOQHM QS (
SU]HFLQHN VHSDUDWRU F] FL G]LHVL WQHM
VSDFMD VHSDUDWRU W\VL F\
QS ? ´1LH SRGDQR´
GOD W\SyZ ORJLF]Q\FK
SUDZGD IDáV] QS ´]DSáDFRQR´>=LHORQ\@ ´GR ]DSáDW\´>&]HUZRQ\@
GOD W\SyZ GDW\ F]DVX
]QDNL IRUPDWRZDQLD
VHSDUDWRU F]DVX
VHSDUDWRU GDW\
F GDWD RJyOQD
G G]LH PLHVL FD
W QU GQLD W\JRGQLD ZHUVMD DQJ Z
GG G]LH PLHVL FD
WW QU GQLD W\JRGQLD Z URNX
GGG VNUyW QD]Z\ GQLD W\JRGQLD
P QU PLHVL FD
GGGG QD]ZD GQLD W\JRGQLD
PP QU PLHVL FD
GGGGG GDWD NUyWND
PPP VNUyW QD]Z\ PLHVL FD
GGGGGG GDWD SHáQD
PPPP QD]ZD PLHVL FD
JJ JRG]LQD
J JRG]LQD ZHUVMD DQJ K
N QU NZDUWDáX ZHUVMD DQJ T
U QU GQLD Z URNX ZHUVMD DQJ \
UU URN
P PLQXWD ZHUVMD DQJ Q
UUUU URN
PP PLQXWD
V VHNXQGD
VV VHNXQGD
OOOOO JRG]LQD SHáQD ZHUVMD DQJ W
$0 30 OXE DP SP D S DPSP SU]HG SR SRáXGQLX
0DVND ZSURZDG]DQLD GDQ\FK
6SRVyE ZSURZDG]DQLD QLH]DOH QLH RG IRUPDWX ]QDN VWDQGDUGRZ\ Å‚B´ SROD RGG]LHORQH
UHGQLNDPL
SRVWDü PDVNL
F]\ ]QDNL PDVNL QS P\ OQLNL E G SU]HFKRZ\ZDQH Z WDEHOL ZUD] ] ZSLVDQ ZDUWR FL
GRP\ OQLH MH OL ]QDNL PDVNL E G ]DSLVDQH Z WDEHOL
LQQ\ QL VWDQGDUGRZ\ ]QDN GR ZVND]DQLD PLHMVFD NWyUH QDOH \ Z\SHáQLü
1S GR ZSURZDG]DQLD GDW\ BB BB BB OXE B
6\PEROH GOD PDVNL ZSURZDG]DQLD
GRZROQD F\IUD EH] ]QDNX NW PXVL E\ü ZSLVDQD
GRZROQ\ ]QDN PXVL E\ü ZSLVDQ\
GRZROQD F\IUD EH] ]QDNX OXE SXVWH PLHMVFH
& GRZROQ\ ]QDN OXE QLF
GRZROQD F\IUD OXE QLF ]QDN GR]ZRORQ\ SXVWH PLHMVFD ]DPLHQLDQH QD VSDFMH
]QDN G]LVL WQ\ VHSDUDWRU\ W\VL F\ GDW\ L F]DVX SDWU] 3DQHO 6WHURZDQLD
/ OLWHUD PXVL E\ü ZSLVDQD
]PLDQD QDVW SR QLP OLWHU QD PDáH
" OLWHUD OXE QLF
! ]PLDQD QDVW SR QLP OLWHU QD GX H
$ OLWHUD OXE F\IUD PXVL E\ü ZSLVDQD
D OLWHUD F\IUD OXE QLF
Z\SHáQLHQLH PDVNL RG SUDZHM GR OHZHM VWURQ\
? SR]ZDOD X \ü Z PDVFH MHGQHJR ] Z Z ]QDNyZ NRQWUROQ\FK
3DVVZRUG KDVáR 8WDMQLHQLH GDQ\FK JZLD]GNL
:SURZDG]DQLH Z\UD HQLD VSUDZG]DM FHJR
5HJXá\ SRSUDZQR FL ]DSLVXMH VL Z SRVWDFL Z\UD H
QS GOD SROD SURFBZ\Vá ! $QG 2U
PR QD X \ZDü IXQNFML QS 'DWH
RSHUDWRUyZ /LNH ,Q %HWZHHQ $QG
RSHUDWRU /LNH ] V]DEORQHP ]H ]QDNDPL JOREDOQ\PL
" ]QDN QD RNUH O PLHMVFX GRZROQ\ FL J ]QDNyZ
SRMHG\QF]D F\IUD >D N@ GRZROQ\ ]QDN ] ]DNUHVX
> D N@ GRZROQ\ ]QDN VSR]D ]DNUHVX
3U]\NáDG\ /LNH Å‚>D ]@>D ]@ ´ GRZyG RVRELVW\
8ZDJD 6DPH ]QDNL JOREDOQH PRJ Z\VW SLü MDNR OLWHUDá\ ZH Z]RUFX PXV] MHGQDN E\ü
RWRF]RQH QDZLDVDPL SURVWRN WQ\PL
RSHUDWRU ,Q ]DZLHUD OLVW PR OLZ\FK ZDUWR FL GOD SROD RGG]LHORQ\FK UHGQLNDPL
QS ,Q OXE ,Q Å‚:DUV]DZD´ ´.UDNyZ´ ´*GD VN´
RSHUDWRU %HWZHHQ $QG SRGDMH PR OLZ\ ]DNUHV GOD ZDUWR FL SROD
QS %HWZHHQ DQG OXE %HWZHHQ $QG
5HJXáD SRSUDZQR FL GOD WDEHOL XVWDZLDQD ZH ZáD FLZR FLDFK WDEHOL ZyZF]DV JG\ ZDUWR ü
MHGQHJR SROD ]DOH \ RG ZDUWR FL LQQHJR QLH PR QD WHJR ]URELü ] SR]LRPX SROD
QS >GDWDBZ\VW@ >GDWDBVSU]HG@ QD]Z\ SyO WDEHOL Z QDZLDVDFK NZDGUDWRZ\FK
.ZHUHQG\
3RGDü OLVW NOLHQWyZ QU LPL QD]ZLVNR DGUHV
3RGDü OLVW GRVWDZFyZ L W\WXá\ NVL HN NWyUH V SU]H] QLFK GRVWDUF]DQH OLVWD SRZLQQD
]DZLHUDü LGHQW\ILNDWRU L QD]Z GRVWDZF\ ,6%1 L W\WXá NVL NL
'OD ND GHJR DXWRUD SRGDü OLVW MHJR NVL HN /LVWD PD ]DZLHUDü QD]ZLVNR L LPL DXWRUD
,6%1 W\WXá L FHQ NVL NL
3RGDü LQIRUPDFMH R ]DPyZLHQLDFK GDWD QXPHU L ZDUWR ü ]DPyZLHQLD
8WZRU]\ü ]DS\WDQLH PRG\ILNXM FH FHQ NVL HN
= WDEHOL 'RVWDZF\ QDOH \ XVXQ ü WH UHNRUG\ GOD NWyU\FK SROH µQD]ZD'RVWDZF\Å› QLH MHVW
RNUH ORQD
3RGDü OLVW NVL HN W\WXá ,6%1 DXWRU]\
3RGDü OLF]E W\WXáyZ NVL NRZ\FK RSXEOLNRZDQ\FK SU]H] NROHMQH Z\GDZQLFWZD QD]ZD
Z\GDZF\ OLF]ED W\WXáyZ
3RGDü W\WXá\ NVL HN NWyU\FK OLF]ED VSU]HGDQ\FK HJ]HPSODU]\ QLH SU]HNUDF]D
3RGDü W\WXá L DXWRUyZ QDMGUR V]HM NVL NL
3RGDü QD]ZLVNR L LPL NOLHQWD NWyU\ QDMF] FLHM ]DPDZLD NVL NL
3RGDü QD]ZLVNR L LPL NOLHQWD NWyU\ Z\GDá QDMZL FHM Z ELH F\P URNX
3RGDü UHGQL OLF]E ]DNXSLRQ\FK NVL HN QD NOLHQWD
'OD ND GHJR DXWRUD SRGDü OLF]E VSU]HGDQ\FK NVL HN /LVWD PD E\ü XSRU] GNRZDQD
PDOHM FR ZJ OLF]E\ VSU]HGDQ\FK NVL HN
'OD ND GHJR W\WXáX SRGDü OLF]E VSU]HGDQ\FK NVL HN /LVWD PD E\ü XSRU] GNRZDQD
PDOHM FR ZJ OLF]E\ VSU]HGDQ\FK NVL HN
-DNL SURFHQW VWDQRZL ]DPyZLHQLD RSáDFDQH NDUW NUHG\WRZ
'OD ND GHJR GRVWDZF\ SRGDü OLF]E GRVWDUF]DQ\FK W\WXáyZ
3RGDü W\WXá\ NVL HN NWyU\FK EUDNXMH Z PDJD]\QLH
3RGDü LQIRUPDFMH R ]DPyZLHQLDFK QLH]UHDOL]RZDQ\FK QXPHU ]DPyZLHQLD W\WXá GDQH R
NOLHQFLH
6SUDZG]Lü UR]NáDG LOR FL VSU]HGDQ\FK NVL HN Z SRV]F]HJyOQ\FK PLHVL FDFK URNX
6SUDZG]Lü UR]NáDG SU]\FKRGyZ Z SRV]F]HJyOQ\FK PLHVL FDFK URNX
)RUPXODU]H
8WZRU]\ü IRUPXODU] GR SU]HJO GDQLD GDQ\FK R GRVWDZFDFK )'RVWDZF\
8WZRU]\ü IRUPXODU] GR SU]HJO GDQLD GDQ\FK R NVL NDFK QD SRGVWDZLH WDEHOL .VL NL
IRUPXODU] PD E\ü Z\ ZLHWODQ\ Z SRVWDFL DUNXV]D GDQ\FK ).VL NL
: IRUPXODU]X )'RVWDZF\ XPLH FLü SU]\FLVN RWZLHUDM F\ IRUPXODU] ).VL NL
: IRUPXODU]X )'RVWDZF\ XPLH FLü SRGIRUPXODU] ).VL NL
8WZRU]\ü IRUPXODU]H GR ZSURZDG]DQLD GDQ\FK GOD WDEHO $XWRU]\ :\GDZF\ 'RVWDZF\ L
.OLHQFL )RUPXODU]H WH SRZLQQ\ XPR OLZLDü ZSURZDG]DQLH QRZ\FK UHNRUGyZ MDN UyZQLH
SU]HJO GDQLH L HG\FM LVWQLHM F\FK MX GDQ\FK
8WZRU]\ü IRUPXODU] GR SU]HJO GDQLD GDQ\FK R NVL NDFK Z SRGIRUPXODU]X WHJR IRUPXODU]D
QDOH \ Z\ ZLHWOLü LPLRQD L QD]ZLVND DXWRUyZ GDQHM NVL NL UyGáHP GDQ\FK SRGIRUPXODU]D
SRZLQQR E\ü ]DS\WDQLH
8WZRU]\ü IRUPXODU] GR ZSURZDG]DQLD GDQ\FK GOD WDEHO .VL NL L $XWRU]\.VL NL 'OD SyO
Z\GDZFD GRVWDZFD RUD] DXWRU]\ XWZRU]\ü OLVW\ Z\ERUX
8WZRU]\ü IRUPXODU] GR ZSURZDG]DQLD GDQ\FK GOD WDEHO =DPyZQLHQLD L =DPyZLRQH.VL NL
'OD SROD QUBNOLHQWD XWZRU]\ü OLVW Z\ERUX 3U]\ ZSURZDG]DQLX SR]\FML ]DPyZLHQLD QDOH \
Z\ ZLHWODü GDQH R NVL NDFK W\WXá VWDQ Z PDJD]\QLH
7ZRU]HQLH 5DSRUWyZ
8WZRU]\ü SU]HGVWDZLRQH SRQL HM UDSRUW\
:\ND] NOLHQWyZ
:\ND] GRVWDZFyZ
$XWRU]\
=DPyZLHQLD
:\UD HQLD
'DWD DNWXDOQD GDWD
1RZ DNWXDOQD GDWD L F]DV
)RUPDW >QD]ZDBNROXPQ\@ UUUU Z\VZLHWOD URN QD]ZDBNROXPQ\ MHVW GDWD
/HIW >QD]ZDBNROXPQ\@ Q Z\VZLHWOD Q SLHUZV]\FK ]QDNRZ GDQHJR WHNVWX ] OHZHM VWURQ\
5LJKW >QD]ZDBNROXPQ\@ Q Z\VZLHWOD Q SLHUZV]\FK ]QDNRZ GDQHJR WHNVWX ] SUDZHM
VWURQ\
7ZRU]HQLH 0DNU
8WZRU]\ü IRUPXODU] ] JUXS SU]\FLVNyZ SROHFHQLD RWZLHUDM F\FK IRUPXODU]H DNFMD
2WZyU])RUPXODU]
1DSLVDü PDNUR RWZLHUDM FH IRUPXODU] ] SDUDPHWUHP 0DNUR SRZLQQR RWZLHUDü IRUPXODU]
] GDQ\PL R NVL NDFK GDQHJR Z\GDZF\ 0DNUR SRZLQQR E\ü XUXFKDPLDQH SU]H] SU]\FLVN
SROHFHQLD Z IRUPXODU]X :\GDZF\
1DSLVDü PDNUR NWyUH E G]LH XVWDZLDü ZDUWR FL Z QRZ\FK UHNRUGDFK 0DNUR SRZLQQR
XáDWZLü GRGDZDQLH QRZ\FK NVL HN GOD GDQHJR GRVWDZF\ 0DNUR WR SRZLQQR E\ü
XUXFKDPLDQH ] SR]LRPX IRUPXODU]D Ä'RVWDZF\´ SRZLQQR RWZLHUDü IRUPXODU] Ä'RGDM.VL N ´ L
DXWRPDW\F]QLH XVWDZLü ZDUWR ü NRGX GRVWDZF\ GOD QRZHM NVL NL QDOH \ VNRU]\VWDü ] DNFML
2WZyU])RUPXODU] 8VWDZ:DUWR ü
1DSLVDü PDNUR NWyUH XPR OLZL ]QDMGRZDQLH RGSRZLHGQLFK UHNRUGyZ ]D SRPRF
Z\ELHUDQLD ZDUWR FL ] OLVW\ /LVWD PD VWDQRZLü GDQH R DXWRUDFK LPL L QD]ZLVNR :
]DOH QR FL RG Z\EUDQHJR DXWRUD Z IRUPXODU]X SRZLQQ\ E\ü Z\ ZLHWODQH GDQH R MHJR
W\WXáDFK NVL NRZ\FK 1DOH \ VNRU]\VWDü ] DNFML ,G 'R(OHP6WHU L =QDMG 5HNRUG


Wyszukiwarka

Podobne podstrony:
Analiza baz danych na temat materiałów betonopodobnych
KOMENDY PSQL NA KOLOKWIUM Z BAZ DANYCH
Wprowadzenie do baz danych
Podstawy baz danych zajecia 2 z SQL Tabela Biblioteka
2004 11 Porównanie serwerów relacyjnych baz danych Open Source [Bazy Danych]
IWZ 2 Podstawy baz danych
test na I stopień
wprowadzenie do baz danych
system baz danych
Karta próby na stopień Ćwika
Administrator baz danych!3101
22 Część VII Udostępnianie baz danych w sieci WWW Podsta

więcej podobnych podstron