Appunti Fondamenti di informatica e programmazione

Fondamenti di informatica e programmazione

Indice

• L’informatica .................................................................................................................................................. 2-6
• Introduzione e architettura di Van Neumann ...................................................................................................
• CPU e linguaggio macchina ............................................................................................................................ 7-9
• Linguaggi, Codifica e rappresentazione dell’informazione ...................................................................... 10-15
• Problemi, Soluzioni, Algoritmi ................................................................................................................... 16-19
• Strutture iterative e selettive ............................................................................................................... 20a-20b
• Introduzione alla programmazione ........................................................................................................... 21-24
• Matlab ........................................................................................................................................................ 25-30
• Strutturazione del codice sorgente ........................................................................................................... 31-33
• Strutture selettive e iterative Matlab ....................................................................................................... 34-37
• Gestione file in Matlab .................................................................................................................................... 37
• Introduzione ai DBMS ed al Modello E-R .................................................................................................. 38-41
• Introduzione a SQL ..................................................................................................................................... 42-44
• Funzioni di aggregazioni e raggruppamenti in SQL ........................................................................... 44°-44b-45

Appunti e contenuti

I9-a-IIL-.:--J-= W^*L,o,lAdtJL vl-nt*,n*LyM"'1 -,'4 J,,, r,"1-È** t.Srfrl"tl*p'rr.*.;n.cìy oi,a,, ),./ *,,,."r,,.". s,u;,;"t*,,'Y r,Ay,y**| #f4T*"*n71T Lrff u. L!§ì(r1 'VW,'t*yurto,*T? tuo,.^;^.*,t:.:L-,ttr,,.aynJn;We#M{ttr,'..yq,n-,* ,.Li.',o,,:*r-5, il"ll$ilrtL r,t"tut*c,,t1:- temperaturaLa di Tiziodicorporea 39,5 (A» Ilenperalurèlàun fe I r.considerata slraléstanzè gradila èviene me erale.e^i tempèr€turè puòa-adi lonsideraia lroppoess€ ed'allarmesegnale r" ri o ,\b, .8uds! .. ve.lichedatef sere etc.)evÒ-{ temperaturaLa (A»èdiatemleGrura nella €l Fts!EtaStanza è in CradTiziodieorporea 39'5ègradiinmisurata-1 centigradiI 39.5-{aF=- \it=,r**9llL)l*oo{ t, ùt-'frnlJùt =-tL'*l&,!,1*r"* eqtifli**a OU.Nfu !Cp =-svurl.l4ao't&-oÀ'rl"0*u,* ,,^uÀ'rAflr*fi ,rt,ry!*,u lcts&.o"4"va'-4r$uorv§- =!,t*, wti A^lh)U,lrrt* lq?,*tlu;^.t +,àtbGL =l)op'r- l,rrry;h''d-t'ìEi0.** ,!"r* \'no-, ^ {o,a.--'* ,r^,4^Z#i"'"ÈJJM^Al'. * bet*;{^h*t*-rn,,n;*Jfry4 :,«; !,rW* "'+r',4[.,\*Jbo =*"'tE**r*;*lrrr* q*rlrld*.;ai ;*f,it''* *éiah(w u'ttt' wywtt;%LrtJerfrd", qfl#" ayo,pt4,*1ì,''t* tl;,rn*l;** qr.,Jr" y,tinnd;ll" rt r* I&,,(ì- &<n*,* ,, #,,r,*=*nì^"o&t,r;M^*,-,1)---*;-*,^ilh" t!* I/r**=t!*&*v*"*nì^",&t"ilh"^ri* *l*'l,,!&MLry.",^.rl,'?funu,:rh i"/trnt"^lru*"* oi!"""'"'-'rW,*ff;. J,ù"* ** 0A=*',lL'*", ^p"J l'*';=r*'*io; :oi'o\rtnJLa.0'-'h*rrrr*r^^!;L t d;16 ^'*\il*u';'*rj"ù,ono,,r*,;Gam :Wffilitt[.ffi*;W;W|"'J, ,,',iI*iino^*:;,W"ÀJh ù!,,*r,,*r,il,.§"'lJ*""'*t"#*a*,rtn;-*lf"-r^^^,;artt;ar,.,l;^ùt/,* eqa-L t'*l"lt* JU qrrr,,,,rr,*f,, ,*to.0c,il/.r*,,*,r,1fgaJ|ù, l*\'rlrrul,* r$)-t ^ll*,**t'D,.,,,y *ry,*t* At h/rru*h^i\*F*re*) r;*Jt'n*wddnuda;o,*Éu. ùdi.o;J; ,uoilLW ,rA À;Akryì .t"d,d*J*,*/t wJ.',,,,*,r*n;* +*o,J,iin ;.,*rt!a',1"-* )' ^^tt-"II t* lr*";L* ALu*'t"tLr#[MrJl"rM.,,* , yrrnJ,,rroln'\^,w'aroilrm,lr/* tur ,rr*r,m*nsr;rutatriont I-l*;NtWhtr:im*,J/*L',-*tu 0 w, §k'oL*"LL,l,*,Jy*A.{.iou" yy:f,*ru-,,h',tiln,*lr^r:f*1" ! r r n fr.rr t/t (rfr, ,.9**#rw-l-\.I t lll*f r@-l (,Yl.*f rÈcenrra,er*tàL Éf-drylI l*l,*,* *tfuI-tfr,* l)* ffiL, t) | r,*r?"[Vr,^!il-omnL= rrnW;;;V^!fuo,wn r"{"L' ":)^' #r:.,ffilrffi\à[:.l'lk iilu 6.1 fi-o ,t.ey,*l.--l ) A*ffi&;#i-I*t,*fit *,4 y*W)i 4+r,d, "th;Lu\,W.ffi r {:k#=W M,rffi'#,ffix f.:fri, yun.*",, e/*"fl! lbfint^l,'ry,lt n@ fu#" &=Wrn,,b*u*;^-,r**,o' w6fi,ryl Pr^yo,*7-fr n*l,l*Lth^)^!,*;*o!^ i're',Jl,illr,#,J,Jfu^oL; fi4 l-;W*if u r*,il,-.,,,*)), W+f,":tl'"' ;rr**a*rnW,9 "l*h.,* ^fl,ny*,l, 1É\ u' '-"{''"1.| ,r*rrr"l*r^il* alt,u* L olrlv/Af,*t-tw. ,JLiJ,. rrugq;rla. ,r,,J-Lr,e,, oL^;-0t**"*Àb r,*fr;,F t l;r*r*/-^"ir*A l^,-rr^t*r!,#n,m.,J l,.tno-*tt,,,(,l"rk1.A ^,{,*lr*1,l}fr^J^*^xF ***o,*r,**t.!; Lr"^ *a,r..'É1r*irre*.ho;',i,ta*r1,,L.^{)*nt" '*,r*^i. *hl *,,Àl,,L Jr*i*#.rLJ,I JL o*,,,a6{,v,wi!r]Et W.:hlr;i,,^U^1'.f,i;;,E k"".1;r1*,ffifr1{1":ffi;*:i,;l$r,:*i:Ifi":f,,,*:i""ratiai'ponrorr" J'r rico'iatovianee neri':;::'iijT::ìij:1ii:'ofv il-t o*l*rr-J"]"..- -.J!,.*.-!'^n^;n.'..*,-.--.-.-. .*,^;L'rlr^*,1"^--*nnvst;t*+esr;w --!EÈ-t'pya=-_=A,Àe, L* /:'bilrr*r*-*rf;*ilnt. 'rllo*',*dv,t ,0twlggt-ù*o- lLlLfr^wyd;yt -i- -rrSn- ;--krfl*;,eL M*b',** JLy--Il,-.Ua_[,LLtr "Il:g1ffi3;'fl:,}'I €t'ifL i§ir^ r*i,- !!ìs *;;,liL: -..-,,-L *{ rll ;-'^'-'-:----i§ §i=*+::ffi,ruL#r#l:l_ .,n,o,n"rE wr* IL.L j^ p*^11,- *'.1* wV-tlttvtOrt;OO.,---.-.,-tt*,:.,-*-.'-. *Orrr"_ ..ovirnttlL_ )lt *yr*t t./* e* tua.foYt=-= fL rbL- yt l""El"daYroL-- trnhdta, *wrJ-a:u ; fiytanwr;-L'. i rmwot;* (PU\r**ùd*Vil(oGL . .,,t,r,L- t ), ,.,n,\1.'"tìrr::i; *rrut)t='L rrLlr#*"^**trr;^'ru ^t,*LL-LL.L *,,ir,*l *rrrt-r;aio,rr,L' ^LItlthJlwo+tiLl-,LLL'L.L- a-il .I Iri-.:\- ,1."k',1r.', dle"J,," ='hL*L*L.-lt^ i.,,^,",,,,,,-ryw*c,;.,. §a.,1.-,.. ,,ll ,'^,;lil).,,..,. ,,,,,.0-- ,o&§tiooe fuai "f*l=.,''!, 1.,.t,.'ì.,..'.,.,. I-Ià Memoria 2^k (ciascunacellecon di bit)hI: kL l*rrmA*&^Ltl" t*,/,ilù JJt*J/ M,^,,J^,,*JÀ' u r/8,,fi ."! j;#t*, Ji,U !' *L Jrl1 J-fl',,*Lol ka J/fi,;L- ,,^t"A,--,,n ,.,au,,,e'd.!v"d'**'%Mm#rr#xffiillffi"nlL4 f^ffi^!^!Jr"fll',Ì=l),0Gatub:q,afiItc,r.OI-;" t o't*,r*,"!.. yrlWilll,*,,uL*L. t lr*w*'*1, &,;,"#d**),rcnodmt:,:J-'fu^,* /il",(N t*lr q;;* I(W), *4,,r,-lf/,,;.ù*W,i l"rp{",Q,w;,-; ,t UL "{,;*É-"o"^-tt il:at *ry LlW l*t^a yn,, 4*(,r-,r*o-1ù* 4J *,..t&r,aÀlU)^, (itrdf W*,*, J,il* J +,,,.*,,,,"trnunot*a vi.,,*r^ Jil,,h*i-.! ryht tpu= "T,l4y,y,h ltll" 0u"il" t*,JL".) Indirizri^rr-twrto,,= Memoriaur cW o oloooooooolmmul*oo- l*h*J ry-t'J r^ I oloooooooorooor= staepnarw- I2 orooooooooiooro3 Ioloooooùcotoon )An*J-t, Ismrionrz l^'fu**,n*,t r:^6:*ù,;,-W oooouoooooroooo"t * *,.-lJ@é,r,-LJrWfo) 1)lfiw*1,* ll< i,^,^^^^^^^^--- ,)ii ,p1nmi,*;W;'ffphr;\h"*->(o&1'-Q: #ilil#ffi=r-,tr^$'il" ,I Da(g*yb+ l'rh^,* L'fr r*g*.\"a,.-,*,1,1il,,^* *:fr*t tr:,,** yil,o r^Wto t',,iAw,* I,r'i*,:kr,^*,),^ I " ^"1,;6l^l^*** #*AW;kl,l W,wtnait !q*l ;w(,ra ;;,$r?ry"o* a il,,' ^,**r:: fflwm't'-Ll,tr,bl,lL*,,h. #-'X*!h*Wf,Y\W:M".-YH *J*,{J$ y,,fu.o*Lltr*Lbh,^,*o.W*,Jry$- 4rfuyeono*héYfi,yF*ù" l i*![ *W)l*\. ;,(A J[;*yn* {a"r-l,l"*,.+Jb W J;Jl n*L",-n; ^.-,,koSreo!;o^a;lWrJ*"}**t^*r,**,*J*W,[el?ry)***'^{*;*E: J**+2 t "Ì--ruì-= LI=l;:/t*l; *'!*"au:,*ùr'0,"/*/" *,*^ r-h 'l*ttv'-'u-1, l,t^LuJh;o,he 'cqr7w'o-'a/ 'L"Jhilffif,#*^ a,yr*,AZ;^il 'bt;/L J/e.-!"*l^,iilL eù s*y,,-,***1,1, iJil'trffiL Md*/m"e u;[;*# ;#*,;u !,;,vù1,,.,J^ à, 1oftD 'ÉJa"'trdtb*U^'^Jfi'-*-'-fu"''^do***', ,Lr*-XlJrf,,;lrr,*^)'-,rr',n oT-l#,4'*iltJqr:ru r-,r""/"*)"),r!* "i*ld*;*fiw{zywe. ?to;ir;, A*t*t- qA,!" o*y,,"-L Jiy*Ln**aU tJ,.,;y,,,,*f tr)(o*t,mo,(ia ^oL " =-k,br^/,L,J^*f ttiozl=wtyJl, (",J-*#L ;*,-.,*t ,"(Ér,*'*Jr!" J,u,u,*,- r.^, "i)/,LtJ F, , r,,n,,^r^;JrJr/L,:ot*t",,n ^^^ .i"*:'*'fu*'kTW E*,*,rT'gr*n ..!.,r*""WT*T 1"ful,,l .,,t*aa* r r+'+, ,j*É,4L#,ffi ,r!;;; st?r,y|o r"&^&* ry-tl*,,,,1r".1i Cn I(K b,a dW-nM^; ; Ar*Jl- (z-)l:tr *ilr'A ll1^,***,,,* kry)^A;tffi Jfl'*^;h,,,*' eu;d64, ;JìÀ *,t,,,;"^t,à;"p*L* 1=l".";Jm;h [,r*lil J,t^ÉWf^"- l,Llt o,/.$w r'.,id,",-1,1,t, g*'ltWl I lLlrf,"ù^e,,=c,i ,n)mtn^hu I',,.ln,^;",* -furi,itC4""L;Ì*. w, ^*'rli,*oi_' *./. o"l'*Fi&il"* y,*,rLLÀ rthi 3|r.,- ,,^ru,*fl*;rJn*,,* Jr]fl'ilnin cÉJ, l',rnf;,,* ^rr1*" N"4'=tr"* J" Et"l,s"'2t ipi ^1,**i"#,*lrk,l^l,-?...,,.- /r-*r,-r "ilL l,l^L[,A;A F-,,*b*la e"ht':h;;,*l' k,,rk''"1,,^,,,^\'!L: l"l;;;"À IJLwJii+,w,it*f **L'J[,*,!\1"**.10*ìLfl. =n,i.rn ^r!.[.'«(,'1""{*\,ÀLr,,*Jry,{rhdr'k&- "!^A +*th»;nqrlTJ !'ùl** Jrfl'rf'.,-l; ;^,r,*Lr!"'o ,!*,1n vc =,*.,.ur',-*1. ^Gi*t,,,',*A, * &L"'\lnfu x* ,r*"'w: )L Ì*,Vnn*,t;'!,Jrt)'*r",*l l'rl,,n;,f,,*o;*,L o,n*yr*J^ &"oeu =L,nb, *lj f',qh wy; l'^h*;'*.,'fitllr:tJtf,,*::0^*;^",,t Jrl*cw,oa,4m,"r"".qw| ,.,,.^u,lJ,*r*'!'rl"w,*4trrrn;'R-*lJl"b-L =ut*l"r* *+;,;,1;+;o"L,U* 1,*']}_2É)-E-''*-§ I_È! t*;^*^-- n- 0.,-1.' 2*74=? -E;23 O?000,001,010,011,1m,101, 8;2F ;- d n L l"y...110,111 ft t) -..-'|,oo J:d; Érr..r,^or;.*r,iÀb, -:Lht16=2r txj Ém00,mol,ml*ffi1,01m, - &J*tfii'L'»Ntsu'x;t10Ùi,0111,10@,ù101, 10,01 -.-1010,1011,1100,1101,1110,,11'11lllt §à-b =osaoqooml'080:Io"" -- ;-,* ;;tilM*JY'*yP,P=r,,'*-rLz c-",t'rr* k{"1';}'t'*lk* b"J;ru"; :'[ri rcalnr ff "ò'r,ry.'']"-,t*0:'ilff:ff\r;tr"!--.-qe,,ro.-J'U'q :- A"*,,,,sr''J';,r*6 Yi*o*d'" >BllÉrYèoCharactsrCode.ÀsCII:-,,-. «rt'l-f*rr** EC,..r^L '5a'J"rrrr* Lr"'!1ro, :I .rm uor -,\ .- u- ZoQf zo =il*lj*ktJffitr ii=iirt"r"'L?Nr'!*l*l;""*"'*M\è\-*Vul^rLn**,oJ; -X fi*[^J;+X}où1<aJ-"L{.,{';,y' zv st L-14*+l.l, g*,1,-?0rM4.0;L=I'n Jc 1g'.,1f,,rr"-lrLro,-\,r,pdoJ1,1 , o,-\,r,prdo7+L=t,f, =r":L h*r l<rllta*A], r.*i,*,*, p,rt -[" l*,a,y,u,,t' $tlL thh,ilry#r?U"à ol;" ^, \*rru-;; ^"W-,t ;;;;;W;i.; i;i ",*'w&7:**"t,ÉauL^a**,M4 " >E*!t-lr* I*t-,,;,'*J-J sìal,tini*u"Lu ,3',U^Uoo) r,fu'.-i!^M; ilW*J" ry=c"oz)tq'o,uh'a, )nanlxltr.luaq*.,Jr.ìt,,.*rr, "f"'l'"t^ai- o4;n".+to #=**. z,l*;,*J,(rJra*fr"Jil, !*J.,*,*-t »gtnat)-; -.A@,À'.'J*;Uu ""É*tfu,*'Nl-oq J-*;,P* L#o*IJ",ilr;*'L*06,*^,'-*,*ti,y,d )o^4.*,.//1'*rJ*r.e =^"*t,lllilw,,$,r =zlr. (",. F0Qrnrri*.OR ,5(,^,n.o**-il*-tro-,rr.^ xro'4'q**/r,,o tF(,.r * 'rbrrljÀxà &-u,^i*.)btlltcj, l1** Lb'.t+L aL o rywvan^*t"Ul0,;*l*,*-\pr"Juo0,,,,r,,- 2 ^,0$,"W*.* =, LtoI §, n lt qn!<i<rv'r;d )k4;=xzz,lJt*ls, ""-4r-llAL'-ya*m1,a.u"*xiril"lxt+t<a+-.-*\arOB, xvyoxvl,rq{t *k,r)ox#/ er.og*4,rJll-l*"*lOR ,. xly ,r,"L ,,x+ff.*/r} n eJo )d1o =ylqrl (,fi,-tri,*l,;*lLLJlwJ.il 7{lttl 7x1'x1 Jtllitoo**.*l zF(*",*.)rc*./-fub'to ="p*h+o t/*'l\É.nt"'