0'1234&'567&'8&'8#99:&7'0';2

19
!"#$%& ()*+,-./* 0 1234& 567& 8& 8#99:&7 0 ;2"<7=96 >296<77&" &? @$A @6B#<& CDEF0DG0HE I9<B&"7<?: 8& J2&"K"##L& 0 M6A$N?: 8&7 7A<&9A&7 0 O:%6"?&4&9? 8P<9Q#"46=R$& E

Transcript of 0'1234&'567&'8&'8#99:&7'0';2

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' E'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' C'

!"#$%&'(&%$)*(&+&&!"#$%&',$-&.($*&%$)*(&&!"#$%&',$-&%$)*(&/&)0121&',$-(&1(3$4%(&&!"#$%.&5$*2)*(.&&6*&(.%&7#1%(5(-%&1(8#550-'9&'(&%#$"#$1.&'#--(1&(:)*;8;%(5(-%&*0&*;.%(&'(.&8#*#--(.<&&&&

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' H'

==&!"#$%(1&$-&-#$>(0$&%?)(&',9>0*$02#-&INSERT INTO TypeEvaluation(code, description) VALUES ('TD', 'Travail dirigé'); &==&!"#$%(1&$-(&-#$>(**(&082>;%9&0$&)1#@1055(&INSERT INTO Activite(sigle, titre) VALUES ('IFT339', 'Structure de données'); &==&!"#$%(1&*(&19.$*%0%&'(&*,(:05(-&A-0*&'(&B0$*&INSERT INTO Resultat VALUES ('15113150', 'FI', 'IFT187', '20133', 75)&

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' S'

C-&)($%&1(21(1&+&&•! $-&%$)*(&)0128$*;(1&•! $-&(-.(5D*(&'(&%$)*(.&&8#-%(:%(&++E&&&&&F&G6HI&F&JKLMJN6OK&P&1(3$4%(QR;%S&FT&<<<P&P&8$1.($1&++E&&&&&GIKJK&LMJJKUH&CV&-#5Q8$1.($1&&.$;%(J(%10;%&++E&&&&&F&JKHMJU6UW&X&Y&(:)1(..;#-Q.#12(&F&F&!N&P&-#5Q.#12(&P&FT&<<<P&P&&&&

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' F'

J(21(1&*,082>;%9&6ZU&'$&80%0*#@$(&DELETE FROM Activite WHERE SUBTR(sigle, 1,3) = ‘IMN’; &J(21(1&*(&%?)(&',9>0*$02#-&HB& DELETE FROM TypeEvaluation WHERE code = 'TP'; !"#$%&#'()*%$#%'+&"$*(*%,%%%J(21(1&*(.&-#%(.&'(.&HB&DELETE FROM Resultat WHERE TE = ‘TP’; &

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' T'

Z([1(&/&"#$1&+&1(21(1&*,0-8;(-&(%&0"#$%(1&$-&-#$>(0$&•! $-&%$)*(&)0128$*;(1&•! $-&(-.(5D*(&'(&%$)*(&&S[)+\\RRR<)#.%@1(.3*<#1@\'#8.\]<^\.%028\.3*=$)'0%(<S%5*&&8#-%(:%(&++E&&&&&F&G6HI&F&JKLMJN6OK&P&1(3$4%(QR;%S&FT&<<<P&P&8$1.($1&++E&&&&&GIKJK&LMJJKUH&CV&-#5Q8$1.($1&&.$;%(Z;.(!_#$1&++E&&&&&F&JKHMJU6UW&X&Y&(:)1(..;#-Q.#12(&F&F&!N&P&-#5Q.#12(&P&FT&<<<P&P&

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' U'

==&!"#$%(1&`ab&)#$1&%#$.&*(.&9%$';0-%.&UPDATE Resultat SET note = note * 0,1; ==&J(21(1&c&)#;-%.&/&%#$.&*(.&9%$';0-%.&'(&*,082>;%9&d6VH`ef, UPDATE Resultat SET note = note – 5 FROM Etudiant WHERE activite = 'IFT187’; ==&J(21(1&c&)#;-%.&/&g*;0-(&)#$1&.#-&8#$1.&d6VH`ef,&UPDATE Resultat SET note = note – 5 FROM Etudiant WHERE nom = 'Éliane' AND etudiant.matricule = resultat.matricule AND activite = 'IFT187’;

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' G'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' V'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' ED'

-.*'()*&%/#%$(%01'2#%345%6789:;7<<%%HS(&8S(8h;-@&#7&0&8#-.%10;-%&'()(-'.&#-&;%.&8#-.%10;-%&5#'(&R;%S;-&%S(&8$11(-%&Nij=%10-.082#-<&67&%S(&8#-.%10;-%&5#'(&;.&;55(';0%(T&%S(-&%S(&8#-.%10;-%&;.&(k(82>(*?&8S(8h('&0%&%S(&(-'&#7&(08S&Nij=.%0%(5(-%<&&UCHK&l]&m&HS;.&;-8*$'(.&Nij=.%0%(5(-%.&%S0%&01(&(:(8$%('&0.&0&';1(8%&1(.$*%&#1&0-&;-';1(8%&1(.$*%&#7&(:(8$2-@&0&';k(1(-%&Nij=.%0%(5(-%<&&67&%S(&8#-.%10;-%&5#'(&;.&'(7(11('T&%S(-&%S(&8#-.%10;-%&;.&(k(82>(*?&8S(8h('&RS(-&%S(&8#-.%10;-%&5#'(&;.&8S0-@('&%#&;55(';0%(&(;%S(1&(:)*;8;%*?&D?&(:(8$2#-&#7&0&n.(%&8#-.%10;-%.&5#'(&.%0%(5(-%oT&#1&;5)*;8;%*?&0%&%S(&(-'&#7&%S(&8$11(-%&Nij=%10-.082#-<&&!&1(7(1(-20*&8#-.%10;-%&;.&.02.A('&;7&#-(&#7&%S(&7#**#R;-@&8#-';2#-.&;.&%1$(T&'()(-';-@&#-&%S(&n50%8S&%?)(o&.)(8;A('&;-&%S(&n1(7(1(-20*&8#-.%10;-%&'(A-;2#-o+&&

m&&67&-#&n50%8S&%?)(o&R0.&.)(8;A('&%S(-T&7#1&(08S&1#R&J`&#7&%S(&1(7(1(-8;-@&%0D*(T&(;%S(1&0%&*(0.%&#-(&#7&%S(&>0*$(.&#7&%S(&1(7(1(-8;-@&8#*$5-.&;-&J`&.S0**&D(&0&-$**&>0*$(T&#1&%S(&>0*$(&#7&(08S&1(7(1(-8;-@&8#*$5-&;-&J`&.S0**&D(&(3$0*&%#&%S(&>0*$(&#7&%S(&8#11(.)#-';-@&1(7(1(-8('&8#*$5-&;-&.#5(&1#R&#7&%S(&1(7(1(-8('&%0D*(<&&m&&67&Z!HLI&VMjj&R0.&.)(8;A('&%S(-T&7#1&(08S&1#R&J`&#7&%S(&1(7(1(-8;-@&%0D*(T&(;%S(1&%S(&>0*$(&#7&(>(1?&1(7(1(-8;-@&8#*$5-&;-&J`&.S0**&D(&0&-$**&>0*$(T&#1&%S(&>0*$(&#7&(>(1?&1(7(1(-8;-@&8#*$5-&;-&J`&.S0**&-#%&D(&-$**&0-'&%S(1(&.S0**&D(&.#5(&1#R&Jl&#7&%S(&1(7(1(-8('&%0D*(&.$8S&%S0%&%S(&>0*$(&#7&(08S&1(7(1(-8;-@&8#*$5-&;-&J`&;.&(3$0*&%#&%S(&>0*$(&#7&%S(&8#11(.)#-';-@&1(7(1(-8('&8#*$5-&;-&Jl<&&m&&67&Z!HLI&B!JH6!j&R0.&.)(8;A('&%S(-T&7#1&(08S&1#R&J`&#7&%S(&1(7(1(-8;-@&%0D*(T&%S(1(&.S0**&D(&.#5(&1#R&Jl&#7&%S(&1(7(1(-8('&%0D*(&.$8S&%S0%&%S(&>0*$(&#7&(08S&1(7(1(-8;-@&8#*$5-&;-&J`&;.&(;%S(1&-$**&#1&;.&(3$0*&%#&%S(&>0*$(&#7&%S(&8#11(.)#-';-@&1(7(1(-8('&8#*$5-&;-&Jl<&&

&UCHK&pa&m&67&Z!HLI&VMjj&#1&Z!HLI&B!JH6!j&;.&.)(8;A('&7#1&0&1(7(1(-20*&8#-.%10;-%&0-'&;7&%S(&1(7(1(-8;-@&%0D*(&S0.&#-*?&#-(&8#*$5-&.)(8;A('&;-&n1(7(1(-20*&8#-.%10;-%&'(A-;2#-o&7#1&%S0%&1(7(1(-20*&8#-.%10;-%T&#1&;7&%S(&1(7(1(-8;-@&%0D*(&S0.&5#1(&%S0-&#-(&.)(8;A('&8#*$5-&7#1&%S0%&n1(7(1(-20*&8#-.%10;-%&'(A-;2#-oT&D$%&-#-(&#7&%S#.(&8#*$5-.&;.&-$**0D*(T&%S(-&%S(&(k(8%&;.&%S(&.05(&0.&;7&-#&n50%8S&%?)(o&R(1(&.)(8;A('<&&

j(&70;%&3$(&*(.&0[1;D$%.&197919.&7#15(-%&$-(&8*9&'(&*0&%0D*(&197919(T&.;5)*;A(&@10-'(5(-%&*0&'(.81;)2#-&'$&8#5)#1%(5(-%&(%&.0&5;.(&(-&#($>1(q&0$..;&Nij&(-&0=%=;*&70;%&$-(&#D*;@02#-<&&

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' EE'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' EC'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' EH'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' ES'

EF'

CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&'0'@$A'@6B#<&'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&'

ET'

CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&'0'@$A'@6B#<&'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&'

EU'

CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&'0'@$A'@6B#<&'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' EG'

!"#$%&''()*+,-./*'0'1234&'567&'8&'8#99:&7'0';2"<7=96'>296<77&"'&?'@$A'@6B#<&' CDEF0DG0HE'

I9<B&"7<?:'8&'J2&"K"##L&'0'M6A$N?:'8&7'7A<&9A&7'0'O:%6"?&4&9?'8P<9Q#"46=R$&' EV'