gestrion de bases de données s5 mail

Upload: encgccomputing

Post on 04-Apr-2018

215 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    1/32

    8

    BCQZFKI JC DHQCQ JC JKIICQ

    CIAB AHQHDGHIAHQcncqztc 3

    Vhqqfic CG BMKSNHTF @ 4084

    Fiektnhzfxsc jc bcqzfki? Jef i fzfki

    Tcaksutc gcq akiihfqqhiacq cz

    Vhqqfic Cg Bmksnhtf

    aknpzciacq xsf qc ztksuciz gfizctqcazfki jcq jfqafpgficq jcgfiektnhzfxsc cz jc gh bcqzfki)

    4

    Fiektnhzfxsc > Fiektnhzfki , Hszknhzfxsc

    Fiektnhzfxsc? Jef i fzfki

    Vhqqfic Cg Bmksnhtf

    zthfzcnciz hszknhzfxsc jc gfiektnhzfkipht jcq nhamficq

    1

    Bcqzfki? Jef i fzf ki

    \MHAM.60 ^

    Vhqqfic Cg Bmksnhtf

    'ciztcptfqc&

    :

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    2/32

    4

    Gfiektnhzfxsc jc bcqzfki cqz gh jfqafpgfic jszthfzcnciz jc gfiektnhzfki szfgc cz iacqqhftc

    Xscqz.ac xsc g f iektnhzf xsc jc bcqzfki ;

    Vhqqfic Cg Bmksnhtf

    hs knh qct ks ks pht c c h n i q th kijcq fiztzq ks jcq heehftcq jcq ciztcptfqcq

    3

    G"fiektnhzfxsc jc bcqzfki cqz gc jknhfic jcg"fiektnhzfxsc qc akiacizthiz qst gh

    Fiek tnhz fxsc j c Bcqz fk i

    bcqzfki ? aknpzhdfgfz' efihiacq' tcqqkstacqmsnhficq' bcqzfki jcq qzkalq' gkbfqzfxsc' bcqzfkijc gh ptkjsazfki')))

    Vhqqfic Cg Bmksnhtf5

    G f iektnhz fxsc jc bcqzfki -FB&

    Gfiektnhzfxsc hs qctufac jc gh bcqzfki Pfgkzhbc jc gciztcptfqc Bcqzfki jc gh ptkjsazfki jc dfciq cz jc

    qctufacq Bcqzfki hjnfifqzthzfuc jc gciztcptfqc

    2

    G f iektnhzfki jh iq gciz tcpt fqc

    Kdqctuhzfkijc ehfzq

    JKIICC Zthfzcnciz FIEKTNHZFKI

    Vhqqfic Cg Bmksnhtf

    FizctptzhzfkiQztsazstc

    Nnktfqhzfki

    AKIIHFQQHIAC

    =

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    3/32

    1

    GFIEKTNHZF KI CZ GCQ AKIACPZQHQQKAFCQ? Jkiic q

    Qghdktciz phtzft jc gkdqctuhzfki jc ehfzq)

    Sic jkiic cqz sic fiektnhzfki dtszc qhiq szfgfz fnnjfhzc)

    Vhqqfic Cg Bmksnhtf

    Ehafgc nhifpsgct cz qzkalct qst si ktjfihzcst)

    Acqz sic fiektnhzfki qsqacpzfdgc jsi zthfzcnciz hszknhzfxsc)

    6

    GFIEKTNHZF KI CZ GCQ AKIACPZQHQQKAFCQ? Fiektn hz fki

    Zthiqektnhzfki jcq jkiicq ci fizctptzhzfkiq)

    Gc qsppktz xsc iksq szfgfqkiq pkst c}ptfnct cz aknnsifxsct hs qcfi jcq ciztcptfqcq cz jhiq gh ufc jc zksq gcq okstq)

    Vhqqfic Cg Bmksnhtf

    G"fiektnhzfki h pgsq jc uhgcst xsc gcqjkiicq phtac xs"cggc h z zthfzc)

    80

    GFIEKTNHZF KI CZ GCQ AKIACPZQHQQKAFCQ? Akiihfqqh ia c

    Szfgfqhzfki $fizcggfbcizc$ jc g"fiektnhzfki)

    Gh uhgcst jcq akiihfqqhiacq cqz gcuc' phtac xsc' btac

    Vhqqfic Cg Bmksnhtf

    cggcq' g"mknnc h jc iksucggcq fjcq' jc iksucggcq fizsfzfkiq czjc iksucggcq fizctptzhzfkiq)

    Ptfqc jc jafqfki

    88

    Gc Qvqzn c jFiektn hzfki jc

    gCiztcptfqc

    84

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    4/32

    :

    Qvqznc jFiektnhz fki jc gCiztcpt fqc

    8) Qvqznc

    Xsc tcaksutc amhasic jcq ikzfkiq;

    Vhqqfic Cg Bmksnhtf

    4) Fiektnhzfki1) Ciztcptfqc

    81

    Xscq xss i Qvqzn c

    Ciqcndgc jgncizqCgncizq fizcthbfqqciz ciztc cs}Tbgcq ef}ciz gcq fizcthazfkiq

    Vhqqfic Cg Bmksnhtf8:

    Si ciqcndgc jgncizq nhztfcgq ks fnnhztfcgq-mknncq' nhamficq' tbgcq&Ci fizcthazfki' ktbhifq ci ekiazfki jsi kdocazfe hzzcfijtc

    Xscq xss i Qvqzn c

    thiq ktnhi si ciqcn c nci q tcsq ci ci t cci si ciqcndgc jgncizq ci qktzfc)

    Vhqqfic Cg Bmksnhtf83

    Ekiazfki jczthiqektnhzfki QktzfcqCiztcq

    Sic akndfihfqki jc aknpkqhizcq pmvqfxscqtcgfcq jc zcggc qktzc xscggcq hbfqqcizciqcndgc'

    Xscq xss i Qvqzn c

    K gcq ptkptfzq jc gciqcndgc qkiz gc tqsgzhzjcq tcghzfkiq ciztc gcq phtzfcq xsf gc aknpkqciz'

    Xscgxsc amkqc xsf h si kdocazfe qpafefxsc' ksptqcizc si fiztz pkst xscgxssi)

    Vhqqfic Cg Bmksnhtf85

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    5/32

    3

    Qvqz nc? c} cnpgc

    Pmvqfxsc ? qvqznc qkghftc' qvqznc nztfxscNhzmnhzfxsc ? qvqznc jc isnthzfki' qvqznc jh}cq)))Nahifxsc ? qvqznc jc etcfihbc -hszknkdfgc&Fiektnhzfxsc ? qvqznc jc}pgkfzhzfkiDfkgk fc? q qznc ictucs} q qznc j f cqzfe

    Vhqqfic Cg Bmksnhtf

    ' Qkafhg ? qvqznc jsahzfe' qvqznc jc qhiz

    82

    C}cnpgc ? Sic sqfic jc nkizhbc jcukfzstcq)

    Pfacq jzhamcq

    Qvqz nc? c}cn pgc

    8=

    Nkjgc jsi hzcgfct jc ehdtfahzfki ?

    QvqzncNhzftcq ptcnftcq Ptkjsfzq efifqCiztcq Qktzfcq

    QvqzncCiztcq Qktzfcq

    Vhqqfic Cg Bmksnhtf

    Qvqz nc? c} cnpgc

    aknpkq jc pgsqfcstq phtzfcq xsf hbfqqciz ciqcndgcNhfq si ciqcndgc jc pfacq jzhamcq icqz phq si qvqznc

    86Vhqqfic Cg Bmksnhtf

    Qvqzncq? Ptkpt fzq

    Gfnfzcq?Ac icqz phq ufjciz jc jafjct ac xsf ehfz phtzfc js qvqznc)C}cnpgc? f)c) Ukfzstc cz fiethqztsazstc tkszftc

    Fizthizq cz C}zthizq ? f)c) Ukfzstc ? cqqciacEccjdhal tztkhazfki

    Vhqqfic Cg Bmksnhtf

    Si amhibcnciz cizthic si hsztcMfthtamfc ? aknpkq jc pgsq qksq.qvqznc ? f)c)< Ukfzstc cz nkzcst Ptkptfzq nctbcizcq? ahthaztfqzfxscq jfeefafgcq h jzcazct qst si

    qcsg qksq.qvqznc f)c) pctektnhiac jsic xsfpc qpktzfuc

    40

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    6/32

    5

    Fiek tnhz fk i

    Ahthaztfqzfxsc jsic fiektnhzfki?

    Ptkjsazfki qkafhgcJkiicq uscq qcgki si pkfiz jc uscGcq ktjfihzcstq ht cs}.nncq ic tkjsfqciz hq jfiektnhzfki

    Vhqqfic Cg Bmksnhtf

    48

    Ciztcpt fqc

    Ahthaztfqzfxsc jsic ciztcptfqc -ktbhifqhzfki&?

    Qvqznc qkafhg xsf h aknnc efihgfz jc ptkjsftc jcq dfciq ksjcq qctufacq

    Vhqqfic Cg Bmksnhtf

    vq nc aknpc}c qksuci akiq s c qksq.qvq ncq xsakiakstciz ci phtzfc ks fijftcazcnciz gh efihgfz jc ptkjsazfkijc gciztcptfqc

    44

    Gc qvqznc akttcqpkijhiz ghazfufz jcgciztcptfqc -zthiqektnhzfki jc egs}& cqz

    hppcgqvqznc kpthiz -QK&)

    Ciztcpt fqc

    41

    Gciztcptfqc h hsqqf dcqkfi jsi qvqznc jcptfqc jc jafqfki gsf pctnczzhiz jc thgfqct gcq kdocazfeq ef}q) Ac qvqznc cqz hppcgqvqznc jc pfgkzhbc -QP&)

    Vhqqfic Cg Bmksnhtf

    Gc QP ptkajc gh tbsghzfki cz hs akiztgcjs qvqznc kpthiz ci jafjhiz jsaknpktzcnciz jc acgsf.af)

    Ciztcpt fqc

    4:

    Qvqznc jc Pfgkzhbc

    Qvqznc Kpthiz

    Jafqfki qst gc QKFiektnhzfkiqqst gzhz js QK

    Egs} cizthiz Egs} qktzhiz

    Vhqqfic Cg Bmksnhtf

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    7/32

    2

    Huca ghsbncizhzfki ci xshizfzcz ciaknpgc}fzjcq fiektnhzfkiq amhibcqciztc acq jcs} qvqzncq' ki h dcqkfi

    Ciztcpt fqc

    43

    zthfzcjc ehki pgsq ceefahac acqfiektnhzfkiq) Ac qvqznc cqz hppcgqvqznc jfiektnhzfki -QF&)

    Vhqqfic Cg Bmksnhtf

    Nkjgc jsic ktbhifqhzfki -ks ciztcptfqc&qcgki gh zmktfc jcq qvqzncq ?

    Qvqznc jc Pfgkzhbc

    45

    Qvqznc KpthizCiztc Qktzfc

    Qvqznc jFiektnhzfki

    Vhqqfic Cg Bmksnhtf

    I fuchs} jSzfg fqhz fk i j c gFiek tnhz fk i

    Vhqqfic Cg Bmksnhtf42

    Qvqznc jFiektnhz fki -QF&

    Gc QF cqz aknpkq jgncizq jfuctq-cnpgkvq' ktjfihzcstq' tbgcq cz

    nzmkjcq' cza)& amhtbq jcqzkalct cz jc

    4=

    zthfzctgcq fiektnhzfkiq tcghzfucq hsqvqznc kpthiz -QK& hefi jc gcq nczztc gh jfqpkqfzfki js qvqznc jc pfgkzhbc-QP&)

    Vhqqfic Cg Bmksnhtf

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    8/32

    =

    C}cnpgc jsi nkjgc qcgki qvqznfxsc jsicciztcptfqc xsf hqqcndgc cz aknnctafhgfqc jcq PA ?

    Jftcazfki

    Qzhzfqzfxscq jc ucizcqIksuchs} ptkjsfzq

    46 Hzcgfct

    Qctufac aknnctafhg cz aknpzhdgc

    Ekstifqqcst AgfcizPfacq Gfuthfqki

    PA Hqqcndgq

    cz gfutqKtjtc jcehdtfahzfki

    AknnhijcqPhfcnciz

    Phiic

    Ehazstc

    Vhqqfic Cg Bmksnhtf

    Gc QF pkqqjc jcs} hqpcazq ? Hqpcaz qzhzfxsc -ks hqpcaz jkiicq& ? dhqc jfiektnhzfki'

    Qvqznc jFiektnhz fki -QF&

    10

    )

    Hqpcaz jvihnfxsc -ks hqpcaz zthfzcnciz& ? aftasghzfki jc gfiektnhzfki ciztc gcq jfeetcizq

    hazcstq'

    ukgszfki amtkikgkbfxsc cz ahsqhgc jcqkpthzfkiq ptkukxscq pht jcq uicncizq)

    Vhqqfic Cg Bmksnhtf

    QF' pkst xs kf ehf tc ;Jfeetcizcq nfqqfkiq js QF Akggcazct -qkstacq c}zcticq cz fizcticq& Qhfqfc' isntfqhzfki C}zthazfki' ucfggc

    Qzkalct

    18

    Qsppktzq jfuctq cz nsgzfpgcq Fijc}hzfki' nkzq agq' zmcqhstsq Nhfizcift ci zhz jszfgfqhzfki qst sic ptfkjc gkibsc

    Zthfzct Ptkjsftc jcq fiektnhzfkiq qksq gh ektnc hpptkptfc hs}

    dcqkfiq jc gszfgfqhzcst Tcqzfzsct' jfeesqct -qksq jfeetcizcq ektncq& gcaztkifxsc ks phpfct Fnpktzhiac jcq ektnhzq jc efamfctq Qsppktzq jc aknnsifahzfki -efghftc' iki.efghftc&

    Vhqqfic Cg Bmksnhtf

    Gcq : ek i az fk iq j s qvqz n c j " f i ektnhz fk i

    Gh ekiazfki j"haxsfqfzfki

    Aczzc ekiazfki ctncz j"fiztkjsftc jcq fiektnhzfkiq

    Vhqqfic Cg Bmksnhtf

    jhiq gc qvqznc j"fiektnhzfki

    C}cnpgc? atfzstc pht gc ptphthzcst jc gh ecsfggcjcq hamhzq

    14

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    9/32

    6

    Gcq : ek i az fk iq j s qvqz n c j " f i ektnhz fk i

    Gh ekiazfki jc nnktfqhzfki

    Vhqqfic Cg Bmksnhtf

    Gcq jfeetcizq gncizq' xsf qkiz qzkalq' pctqfqzcizhs akstq js zcnpq

    Acq fiektnhzfkiq pctqfqzhizcq qkiz bithgcnciztcbtkspcq jhiq jcq jkqqfctq

    11

    Gcq : ek i az fk iq j s qvqz n c j " f i ektnhz fk i

    Gh ekiazfki jc zthfzcnciz + j"hihgvqc

    Ptcijtc sic fiektnhzfki cz gh zthiqektnct kst

    Vhqqfic Cg Bmksnhtf

    ptkjsftc sic hsztc fiektnhzfki

    C}cnpgc? gh tcqpkiqhdgc jcq hamhzq zthfzc gh ecsfggcjcq hamhzq cz ptkjsfz jcq dkiq jc aknnhijc pkst gcq ekstifqqcstq

    1:

    Gcq : ek i az fk iq j s qvqz n c j " f i ektnhz fk i

    Gh ekiazfki jc jfeesqfki

    Aknnsif sct g"fiektnhzfki sic ks gsqfcstq

    Vhqqfic Cg Bmksnhtf

    pctqkiicq

    C}cnpgc? gc amce j"hzcgfct jfeesqc jcq amhibcncizq jcekiazfkiicnciz hs ifuchs jc g"hzcgfct pht g"fizctnjfhftcj"sic ikzc jc qctufac

    13

    Akiacpzf ki js i QF

    Gh akiacpzfki jsi QF akiqfqzc ci sic nkjgfqhzfki jc gciztcptfqc -pkst sic

    ufqfki bgkdhgc ? nkjgc qvqznfxsc&'

    -jkiicq ? cizfzq cz hqqkafhzfki fizct.cizfzq&< sic nkjgfqhzfki jc qcq hqpcazq jvihnfxscq

    -zthfzcncizq ? kpthzfkiq jagciamcq pht jcquicncizq&)

    Aczzc akiacpzfki iacqqfzc sic hpptkamcptkbtcqqfuc -ifuchs} jhdqzthazfki&)

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    10/32

    80

    Si QFB jkfz ztc jsthdgc cz hjhpzhdgc hs}amhi cncizq)

    Akiacpz fki js i QFI fuchs jhdqz thaz fk i

    12

    Pht c}cnpgc' si amhibcnciz jc nhamfic ic jkfz phq

    cizthict sic nkjfefahzfki nhocstc js qvqznc)

    Akiacpz fki js i QF?I fuchs ak iacpz scg H ac ifuchs' qkiz tcptqcizcq gcq fiektnhzfkiq cz gcstq tcghzfkiq' gcq szfgfqhzfkiq xsf ci qkiz ehfzcq cz gcq akizthfizcq hqqkafcq)

    Ac ifuchs jefifz gcq efihgfzq jc gciztcptfqc' a)..j) ghtpkiqc gh xscqzfki xsc ehfz gc qvqznc; Acqz gc ifuchsgc pgsq qzhdgc' fg cqz fiuhtfhiz)

    Nkjgc Akiacpzscg jc Zthfzcnciz

    Tcascfggft' ktbhifqct cz qztsazstct gfiektnhzfki

    Atct ghtamfzcazstcAtct ghtamfzcazstc

    Nkjgc Akiacpzscg jc Jkiic

    Akiacpz fki js i QF?I fuchs k tbhi fqhzfki icg -ks gkbfxsc&

    Ac ifuchs cqz nkfiq qzhdgc)Fg jefifz gktbhifqhzfki nczztc ci pghac jhiqgciztcptfqc ? fg tpkij hs} xscqzfkiq aknnciz;' xsf ecth xskf' k cz xshij;

    Nkjgc Gkbfxsc jc Jkiic

    Nkjgc Ktbhifqhzfkiicg jc Zthfzcnciz

    Ciufqhbct gcq qkgszfkiqCiufqhbct gcq qkgszfkiqktbhifqhzfkiicggcq cz gkbfxscqktbhifqhzfkiicggcq cz gkbfxscq

    pkqqfdgcq ehac hs} akizthfizcq pkqcqpkqqfdgcq ehac hs} akizthfizcq pkqcq

    Akiacpz fki js i QF?I fuchs Kpthzfki icg -Zcamifxsc ks Pmvqfxsc&

    Ac ifuchs cqz gc nkfiq qzhdgc)Fg cqz qksuciz nfq ci ahsqc pht gc amhibcnciz jsnhztfcg cz+ks jcq gkbfafcgq)Fg jefifz gciqcndgc jcq nkvciq zcamifxscq' aknpkq jc

    nhamficq' jc ptkbthnncq cz jc efamfctq' pkst tpkijtchs} kdocazfeq pkqq)Nkjgc Pmvqfxsc jc Jkiic

    Nkjgc Pmvqfxsc jc Zthfzcnciz

    Ehftc gc amkf} js nhztfcg cz jcqEhftc gc amkf} js nhztfcg cz jcqgkbfafcgq aknphzfdgcq huca gcqgkbfafcgq aknphzfdgcq huca gcq

    qkgszfkiq ptkpkqcq)qkgszfkiq ptkpkqcq)

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    11/32

    88

    Ifuchs Jkiicq ZthfzcncizqAkiacpzscg NAJ NAZGkbfxsc cz

    Akiacpz fki js i QF?1 I f uchs}

    KtbhifqhzfkiicgPmvqfxsc

    -kpthzfkiicg kszcamifxsc&

    NPJ NPZ

    Hihgvqc jcqacijhizc ? fiektnhzfki bgkdhgc

    fiektnhzfki gncizhftc

    Jfeetciafct jkiicq cz zthfzcncizq

    cizfz > kdocz' fijfufjs js qvqznc

    hqqkafhzfki > gfci' tcghzfki ciztc acq cizfzq

    cza

    Jkiic ?

    kpthzfki jagciamc pht si uicnciz

    ehfz qstucihiz

    Zthfzcnciz ?

    Cuicnciz ?

    Akiacpz fki js i QF?CuicncizSic ciztcptfqc h dcqkfi jamhibct jcq fiektnhzfkiq ciztcjsic phtz' gcq aknpkqhizq js QF cz jhsztc phtz' ciztc gc QFcz gsifuctq c}zctic) Acq fiektnhzfkiq qkiz pktzcq pht jcquicncizq )

    Jefifzfki ? ki phtgc jsi uicnciz gktqxsc xscgxscamkqc qstufciz cz gktqxski qci hpctkfz) Si uicncizjagciamc sic kpthzfki)C}cnpgc ? phqqhzfki jc aknnhijc jfzfki jsi dki jc

    aknnhijc' httfuc js dki jc aknnhijc hs qctufac aknnctafhg

    akiqsgzhzfki js qzkal' cza)

    Akiacpz fki js i QF? Zthfz cnciz q

    Gcq zthfzcncizq qkiz jcq kpthzfkiq js QF jagciamcq pht ghttfuc juicncizq)

    C}cnpgc ? ghttfuc jsic aknnhijc jsi agfcizjagciamcth gh nnktfqhzfki jc acggc.af cz gh tcamctamcjcq ptkjsfzq aknnhijq)

    C}cnpgc ? ghttfuc jc guicnciz Jaghthzfki jcqfifqztc jagciamc gkpthzfki Utfefct gh bhthizfc )

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    12/32

    84

    Cizfz -kdocz ks fijfufjs&)Tcptqcizhzfki jhiq si QF jsikdocz jc gciztcptfqc)C}cnpgc ? agfciz' aknnhijc' ptkjsfz' cza)Hqqkafhzfki ks tcghzfki )Gfci ciztc gcq cizfzq

    Akiacpz fki js i QF? Jki icq

    )C}cnpgc ? agfcizphqqc sic aknnhijc)Hzztfdsz -ptkptfz ks jkiic&)Tsdtfxsc jc jcqatfpzfkijsic cizfz ks jsic hqqkafhzfki)C}cnpgc ? ikn cz hjtcqqc js agfciz -hzztfdsz jc gcizfz

    agfciz&< jhzc jc gh aknnhijc -hzztfdsz jc ghqqkafhzfkiphqqhzfki jc aknnhijc&)

    Nkj gcAkiacpz scg j cJkiicq -NAJ&

    Ptkpkqct sic tcptqcizhzfki qamnhzfxsc jc gh phtzfcqzhzfxsc jc gciztcptfqc -jkiicq cz gfciq&

    Ci szfgfqhiz gc ektnhgfqnc jcizfz+hqqkafhzfki

    NAJ? Kdocaz feq

    Hdktjhdgc pht zksz szfgfqhzcst pctnczzhiz si jfhgkbsc aghft huca gcq akiacpzcstq)

    Gc NAJ kdzcis ic jkfz fiagstc xsc jcq jkiicqiacqqhftcq hs ekiazfkiicnciz jc gciztcptfqc

    NAJ? c}cn pgcQkfz gh gfqzc jcq jkiicq tcaciqcq jhiq sizhdgfqqcnciz qakghftc ? hjtcqqc jc gguc' nhzftcciqcfbic' ikndtc jmcstcq' ikn jc gh aghqqc' ikn jsptkecqqcst' ikn jc gguc' ptikn jc gguc' ikzc'

    isntk jc qhggc)Qkfciz gcq tbgcq jc bcqzfki ? T8 ? amhxsc aghqqc cqz hzztfdsc sic cz sic qcsgc qhggc) T4 ? amhxsc nhzftc cqz ciqcfbic pht si cz si qcsg ptkecqqcst) T1 ? pkst amhxsc aghqqc cz amhxsc nhzftc cqz jefif si ikndtc

    ef}c jmcstcq jc akstq) T: ? amhxsc guc cqz hzztfdsc -hs pgsq& sic qcsgc ikzc pht

    nhzftc) T3 ? gzhdgfqqcnciz btc gcq cnpgkfq js zcnpq jcq ptkecqqcstq cz

    jcq gucq hfiqf xsc gc akiztgc jcq akiihfqqhiacq)

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    13/32

    81

    Tcbtkspcnciz jcq jkiicq ? jkiicq gfcq gh aghqqc ? ikn jc gh aghqqc' isntk jc gh qhggc)

    NAJ? c}cn pgc

    jkiicq gfcq gguc ? ikn jc gguc ptikn jc gguc hjtcqqc jc gguc

    jkiicq gfcq gh nhzftc ? nhzftc ciqcfbic ikn js ptkecqqcst)

    Ztkfq kdoczq fijpcijhizq ? aghqqc' guc cz nhzftc)Gcq jkiicq aknnc ikzc' ikndtc jmcstcqqcsgcq ikiz phq jc qfbifefahzfki ci zhiz xsc zcggcq ? gh ikzc j cij gh ekfq jc gguc cz jc gh

    NAJ? c}cn pgc

    30

    nhzftc) gc ikndtc jmcstcq jpcij gh ekfq jc gh aghqqc

    cz jc gh nhzftc)Gcq jkiicq xsf jpcijciz jc pgsq xsc jsi kdocz

    jatfuciz jcq gfciq ciztc acq kdoczq ? c}) guchukft pkst ikzc jhiq nhzftc)

    Cizfz ?tcptqcizhzfki akiatzc ks hdqzthfzc jsi kdoczhpphtzcihiz hs tcg pcts ptkpkq jc ghxscggc ki ucszcitcbfqztct jcq fiektnhzfkiq) C}cnpgc ? gkdocz guc)

    NAJ? Jef i f z fk iq - c i z f z ' hqqka fhz fk i czh z z t f d s z &

    38

    Hqqkafhzfki ? tcptqcizc si gfci ciztc jcs} kspgsqfcstq cizfzq -iki iacqqhftcnciz jfqzfiazcq&)C}cnpgc ? ghqqkafhzfki hukft pkst ikzc jhiq)

    Hzztfdsz -ptkptfz& ?ahthaztfqzfxsc ks xshgfz xsfjatfz sic cizfz ks sic hqqkafhzfki)C}cnpgc ? ghzztfdszptikn jc gguc jc gcizfz guc)

    Cizfz pctnhicizc)

    Akiqctuc ci pctnhiciac jhiq gh dhqc jfiektnhzfki

    Pcsz ztc nfqc okst zksz nknciz)

    NAJ? Aghqqfe fahz fk i j cq c i z f z q

    Gcq ptkptfzq jsic cizfz pctnhicizcpcsuciz amhibct nhfq gcizfz cggc.nnc cqzqzhdgc

    C}cnpgc ? Agfciz -Ikn' Hjtcqqc' AH js nkfq N'AH js nkfq N.8&

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    14/32

    8:

    Cizfz js zvpc nksucnciz)

    Qksucift jsi uicnciz' jhiq gc QF

    NAJ? Aghqqfe fahz fk i j cq c i z f zq

    31

    C}cnpgc ? Aknnhijc -I Ajc' Jhzc Ajc&nnktfqc jhiq gc QF cz fqqsc jc guicncizphqqhzfki jc aknnhijc)

    ki ic pcsz pgsq nkjfefct sic aknnhijc sic ekfqxscggc cqz phqqc

    Zvpc jsi hzztfdsz ? hgpmhdzfxsc -H&' hgpmh.isntfxsc -HI& ksisntfxsc -I&)

    Ektnhz ? Cizfct' tcg -}}}}}'}}&' jhzc -oo+nn+hh&)Jfnciqfki jsi hzztfdsz ? ikndtc jc ahthaztcq iacqqhftcq pkst

    NAJ? Aghqqfe fahz fk i j cq hzz t fdszq

    3:

    gc akjct) C}cnpgc ? Jfn-Ikn&>80' Jfn-AHn&>6)Ihzstc jsi hzztfdsz ? si hzztfdsz pcsz ztc qkfzgncizhftc -C&qkfzakiahzi -AKI&-qfg cqz js zvpc HI

    pht c}cnpgc&) qkfzgncizhftc -C&qkfzahgasg -AHG&-qfg cqz js zvpc I&) qfbihgzfxsc -QFB&ks jc qfzshzfki -QFZ&-qfg qc ztksuc jhiq

    sic cizfz pctnhicizc&) nksucnciz -N& -qfg qc ztksuc jhiq sic cizfz jc zvpcnksucnciz&)

    Hzztfdsz aknpkq- hzztfdsz akiahzi&c}cnpgc ? Hjtcqqc > |I~, |Tsc~, |Akjc pkqzhg~,

    |ufggc~)

    NAJ? Aghqqfe fahz fk i j cq hzz t fdszq

    33

    Hzztfdsz jtfu- hzztfdsz ahgasg&c}cnpgc ? Gbc phtzft jc gh jhzc jc ihfqqhiac)

    Jfazfkiihftc jcq jkiicq ? gfqzc jcq hzztfdszq

    iacqqhftcq pkst gh bcqzfki ufqc' huca

    NAJ? Jfazfki ihf tc jcq jk i icq

    35

    ptafqfki qst gcst zvpc' ihzstc' jfnciqfki'ektnhz hfiqf xsc qst gcst qfbifefahzfki)

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    15/32

    83

    NAJ? Jfazfki i hf tc jcq jk i icqQFBIFEFAHZFKI ZVPC -8& GKIBSCST IHZSTC

    -4& -1&TCBGC JC AHGASGKS FIZCBTFZC -:&

    IkDkiJhzc

    /AkAgfIknAgfHjtcqqcTscAgfUfgagf/AkTcpIknTcp

    I jc dki jc AjcJhzc Ajc

    Akjc agfcizIkn agfcizHjtcqqc agfcizTsc agfcizUfggc agfcizAkjc tcptqcizhizIkn tcptqcizhiz

    II

    ;HHIHIH;H

    :5

    ;10501010;10

    CC

    CCAKICCCC

    NN

    QFBQFBQFBQFBQFBQFBQFB

    Ektnc oo+nn+hh -3&

    H atct

    Tsc , Ufggc

    H atct

    32

    Te JqfbiXzPSNkizhizZkzhg

    Te) jc ptkjsfzJqfbihzfki ptkjsfzXshizfz aknnhijcPtf} sifzhftcNkizhiz gfbicZkzhg aknnhijc

    HIHIIII

    31012=6

    CCCCAHGAHG

    QFBQFBNQFBNN

    8 gczztc , 1 amfeetcq

    Cizfct 9 0Ektnc ? 6666'66PS XzQknnc jcq nkizhizq

    -8& H-gpmhisntfxsc& I-sntfxsc& H-gpmh&I-sntfxsc&-4& C-gncizhftc& AKI-ahzi& AHG-asg&

    -1& N-ksucnciz& QFB-ihgzfxsc& QFZ-shzfki&-:& Tbgc jc ahgasg pkst gcq hzztfdszq ahgasgq ks akizthfizcq jfizbtfz qvizh}fxsc ucizscggcq-3& oo ? 08 18' nn? 08 84' hh ? 00 66)

    Kaasttciacq jsic cizfz ? uhgcstq ptfqcq pht siccizfzC}cnpgc ? gcizfz guc hsth xshztc kaasttciacq ?

    Hgdctz Jspkiz

    NAJ? Kaas t t c i acq

    Ohncq RcqzIknfc JspkizQkpmfh Jhgf

    Kaasttciacq jsi hzztfdsz ? Gcq ptkptfzq -hzztfdszq&ptciiciz jcq uhgcstq hppcgcq bhgcnciz kaasttciacqjc gh ptkptfz)C}cnpgc ? ghzztfdsz ptikn jc gguc ptcij gsicjcq uhgcstq ? |Qkpmfh' Iknfc' Ohncq' Hgdctz~

    Kaasttciacq jsic cizfz ? uhgcstq ptfqcq pht siccizfzC}cnpgc ? gcizfz guc hsth xshztc kaasttciacq ?

    Hgdctz Jspkiz

    NAJ? Kaas t t c i acq

    Ohncq RcqzIknfc JspkizQkpmfh Jhgf

    Kaasttciacq jsi hzztfdsz ? Gcq ptkptfzq -hzztfdszq&ptciiciz jcq uhgcstq hppcgcq bhgcnciz kaasttciacqjc gh ptkptfz)C}cnpgc ? ghzztfdsz ptikn jc gguc ptcij gsicjcq uhgcstq ? |Qkpmfh' Iknfc' Ohncq' Hgdctz~

    Hzztfdsz Uhgcst

    Ikn JspkizPtikn Hgdctz

    Hjtcqqc 1 tsc jc Ukgzhftc' 3::00 Gkibrv Hbc 85

    Hiic jzsjc[ Qcakijccza)

    Cizfz

    Hzztfdsz Uhgcst

    Ikn OhncqPtikn Rcqz

    Hjtcqqc 1 tsc jc Ukgzhftc' 3::00 Gkibrv Hbc 85

    Cizfz

    Hzztfdsz UhgcstCizfz

    50

    ii c s c[ caki ccza) Ikn JspkizPtikn Iknfc

    Hjtcqqc 1 tsc jc Ukgzhftc' 3::00 Gkibrv Hbc 85

    Hiic jzsjc[ Qcakijccza)

    Hzztfdsz Uhgcst

    Ikn JhgfPtikn Qkpmfh

    Hjtcqqc 1 tsc jc Ukgzhftc' 3::00 GkibrvJhzc jc ihfqqhiac 80+0=+86=6 Hiic jzsjc Qcakijc

    cza)

    Cizfz

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    16/32

    85

    Ikn cizfzIkn ptkptfz 8Ikn ptkptfz 4

    NAJ? Ektnhgfqnc

    58

    )

    CzsjfhizIknPtikn

    Jhzc jc ihfqqhiac Hjtcqqc Hiic j zsjc

    Sic cizfz jkfz ztc jkzc jsi fjcizfefhiz )

    NAJ? Fjc i z fe fh i z j s ic c i z f z

    54

    ) Qh uhgcst jkfz ztc jfeetcizc pkst amhxsc

    kaasttciac jc gcizfz ? fg jatfz amhxsc kaasttciacjc gcizfz jsic ehki sifxsc)

    Ikn Ptikn Jhzc jc ihfqqhiac cza)JspkizRcqzJspkizJhgf

    HgdctzOhncqIknfcQkpmfh

    08+05+==82+04+=:86+02+=580+0=+=6

    ))))))))))))

    51

    ' Isntk jguc )

    Isntk jguc Ikn Ptikn Jhzc jc ihfqqhiac cza841:

    JspkizRcqzJspkizJhgf

    HgdctzOhncqIknfcQkpmfh

    08+05+==82+04+=:86+02+=580+0=+=6

    ))))))))))))

    Gcizfz huca qcq ptkptfzq -jkiz gfjcizfefhiz&cqz qamnhzfqc ?

    NAJ? Ektnhgfqnc

    5:

    Ikn cizfzFjcizfefhizIkn hzztfdsz 8Ikn hzztfdsz 4cza)

  • 7/31/2019 Gestrion de Bases de donnes S5 MAIL

    17/32

    82

    Si fjcizfefhiz jsic cizfz jkfz ztc

    Sifuhgs cz iki isg ? sic kaasttciac jc gcizfzakttcqpkij sic cz sic qcsgc uhgcst jsi fjcizfefhiz