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

I9-

a-

I

I

L-

.:

--J

-= W^*L,

o,lA

dtJL vl-nt*,n*L

yM"

'1 -,'4 J,,, r,"1-

È** t.

Srfrl"tl*p'rr.*.;n.cìy oi,

a,, ),./ *,,,."

r,,.". s,u;,

;

"t*,,'Y r,Ay,y**| #f

4T*

"*n71T L

rff u

. L

!§ì(r1 'VW,'t*yurto,*

T? tuo,.^;

^.*,t:.:L-,t

tr,,.aynJn;We#M{ttr,'..yq,n-,* ,.Li.',o,,:

*r-5, il"ll$ilrtL r,t"tut*c

,,t1:

- temperatura

La di Tizio

di

corporea 39,5 (A» I

lenperalurè

là

un fe I r.

considerata slralé

stanzè gradi

la è

viene m

e e

rale

.e^i tempèr€turè può

a-adi lonsideraia lroppo

ess€ e

d'allarme

segnale r" ri o ,\b, .8uds

! .. ve.licheda

tef sere etc.)

evÒ

-{ temperatura

La (Aȏd

iatemleGrura nella €l Fts!Eta

Stanza è in Crad

Tizio

di

eorporea 39'5

è

gradi

in

misurata

-1 centigradi

I 39.5

-{

a

F=- \

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$u

orv§- =

!,t*, wt

i A^lh)

U,lrrt* lq?,*

tlu;^.t +,à

t

b

GL =

l)op'r- l,rrry;h''d-t'ìE

i

0.** ,!"r* \'no-, ^ {o,a

.--'* ,r^,4^Z

#i"'"ÈJJ

M^Al'. * bet*;

{^h*

t*-rn,,n;*Jfry4 :,

«; !,rW* "'+r',4[.,\*Jbo =

*"'tE

**

r*;*lrrr* q*rlrld*.;a

i ;*f,it''* *éi

ah(w u'ttt' wywtt;%

Lrt

Jerfrd"

, qfl#" ayo,pt4,*1ì,''t

* tl;,rn*l;** qr.,Jr" y,tin

n

d;

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, ,,',i

I

*iino^*:;,W"ÀJh ù!,,*r,,*

r,il,.§"

'lJ*""'*t"#*

a*,rtn;-*lf"-r^^^,;artt;ar,.,

l;

^ùt/,* e

q

a

-

L t'*l"lt* JU qrrr,,,,rr,*

f,, ,*to.0c,il/.r*,,*,r,1fga

J

|ù, l*

\'rlrrul,* r

$)-t ^ll*,**

t'D,.,,,

y *ry,*t* A

t h/rru*

h^i\*

F*re*) r;*Jt'

n*wddnuda;o,*

Éu. ùd

i.o

;J; ,uoilL

W ,rA À;A

kryì .t"d,d*

J*,*/t wJ.',,,,*,r*n;* +*

o,J,iin ;.,*rt

!a',1"-* )' ^^tt-

"

I

I t

* lr*";L* A

Lu*'t"tLr#[Mr

Jl"rM.,,* , yrrnJ,,rroln'

\^,w'aroilrm,lr/* tu

r ,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 (,Y

l.*f rÈcenrra,e

r*tàL Éf-dry

lI l*

l,*,* *tfuI-

tfr,* l

)* ffi

L, t

) | r,*r?"[

Vr,^!il-omn

L= rrn

W;;;

V^!fuo,wn r"{"

L' ":

)^' #r:.,ffilrffi\à

[:.l'lk ii

lu 6.1 f

i-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'#,

ffi

x f

.:fri, y

un.*",, e/*"fl

! lbfint^l,'ry,lt n@ fu

#" &

=W

rn,,b*u*;^-,r**,o' w6

fi,ryl P

r^yo,*7-fr n*l,l*L

th^)^!,*;*o!^ i're',Jl,illr,#,J,Jfu^

o

L; fi4 l-

;W*

i

f u r*,il,-.,,,*)), W+f,":

t

l'"' ;rr**a*rn

W,

9 "l*h.,* ^fl,ny*,l, 1

É\ u

' '-"{''"1.

| ,r*rrr"l*

r^il* alt,u* L olrl

v/Af,*t-tw. ,JL

i

J,. rr

ugq;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^*^x

F ***o,*r,

**t.!; L

r"^ *a,r..'É1r*

irre*.ho;',i,ta*r1,,L.^{)*n

t" '*,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""rati

ai'ponrorr" J'r rico'iato

viane

e ner

i':;::'iijT::ìij:1ii:'o

f

v i

l-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 ,0

twlggt-ù*o- lLlLfr^

wyd;yt -i- -r

rSn

- ;--k

rfl*;,eL M

*b',*

* JLy-

-

I

l,-.

U

a_

[,

L

L

tr "Il:g1ffi3;'fl:,}'

I €t'i

f

L i§i

r

^ r*i,- !!ì

s *;;

,li

L: -..-,

,-

L *{ r

ll ;-'^'-'

-:----

i

§ §

i

=*+::

ffi,ruL#r#l:l_ .

,n,o,n"

r

E wr* I

L.

L j^ p*^11

,- *'.1* wV-tlttvtOrt;O

O

.,---.-.,-tt*,:.,-*

-.'-. *Orrr"_ ..ovirnt

tl

L_ )lt *yr*t t

./* e* tua.fo

Y

t=-= f

L rb

L- yt l""El"

daYro

L-- 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#*"

^**tr

r;^'ru ^t,*L

L-

L

L.

L *,,ir,*l *rrrt-r;aio,rr,

L' ^L

ItlthJlwo+ti

L

l-,

L

L

L'

L.

L- a-

il .

I I

ri-.:\

- ,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 (ciascuna

celle

con di bit)

h

I

: kL l*rrmA*&^

Ltl" t*,/,ilù JJt*

J/ M,^,,J^,,*J

À' u r/8,,fi .

"! j;

#t

*, J

i

,

U !' *L Jrl

1 J-fl',,*Lol ka J/fi,;L- ,,^t"A

,--,,n ,.,a

u,,,e

'd.!v"d'**'%Mm#rr#xffiillffi

"nlL

4 f^ffi

^!^!Jr"

fll',Ì

=l),0

Gatub:q,afiIt

c,r.OI

-;" t o

't*,r*,"!.. yrlWilll,*,,

uL*

L. t lr*

w*'*1, &,;,"#d**),rcnodmt

:,:J-'fu^,* /il",(N t*l

r q;;* I

(W), *4,,r,-lf/,,;.ù*

W,i l"rp{",Q,w;,-; ,t U

L "{,;*É-"o"^-t

t il

:at *ry Ll

W l

*t^a yn,, 4*

(,r-,r*o-1

ù* 4

J *,

..t

&r,a

ÀlU)

^, (itrd

f W

*,

*, J,il* J +,,,.*,,,,"t

rnunot*a vi.,,*r^ Jil,,

h*i-.! ryh

t tpu

= "

T,

l4y,y,h ltll" 0u"il" t*,JL".) Indirizri

^rr-twrto,,

= Memoria

ur cW o oloooooooolmm

ul*oo- l

*h*

J ry

-t'J r^ I oloooooooorooor

= staepnarw- I

2 orooooooooiooro

3 I

oloooooùcotoon )

A

n*J-t, Ismrionr

z l^'

fu**,n*,t r

:^6:*

ù,;,-W oooouoooooroooo

"t * *

,.-l

J@é,r,-LJrWfo) 1

)

lf

iw*1,* l

l< 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 t

r:,,** yil,

o r^Wto t',,iAw,* I,

r'i*,:kr,^*,),^ I " ^"1,;

6l^

l^**

* #*AW

;k

l,l W,

wtnait !

q*l ;

w(,ra ;

;,$r?ry"o* a il,,' ^,**r:

: fflw

m

't'-Ll,tr,bl,lL*,,h. #-'X*!h*Wf,Y\

W:M".-Y

H *J*,{J

$ y,,fu.

o*Lltr*Lbh,^,*o.W*,J

ry$- 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,[e

l?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

"Jh

ilffif,#*^ a,yr*,AZ;^il 'bt;/L J

/e.

-!"*l^,i

ilL eù s*y,,-,*

**1,1, iJ

il'

trffiL M

d*/m"e u;[;*

# ;

#*,;u !,;,vù1,,.,

J^ à, 1oftD 'É

Ja"'trdtb

*U^'^Jfi'-*-'-fu"''^d

o***', ,L

r*-Xl

Jrf,,;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

**a

U t

J,.,;y,,,,*f tr)

(

o

*t,mo,(ia ^oL " =-

k,br^/,

L,J^*f ttiozl=

wt

yJl, (",J-*

#L ;*,-.,*t ,"(Ér,*'*

Jr!" J,u,u,*,

- r.^

, "i)

/,LtJ F

, , r,,

n,,^r^;JrJr/L,:ot*t",,n ^^

^ .i"*:'*'fu*'kT

W E*,*,rT'g

r*n ..!.,r*"

"WT*T 1"fu

l,,l .

,,t*aa* r r+'+, ,j*É,4

L#,

ffi ,r!;;

; st?r,y|o r"&

^&* ry-tl

*,,,,1r".1

i 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*l

il J,t^É

W

f^"- l,L

lt 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'*F

i

&il"

* y

,*,

rLLÀ rt

hi 3|r.,

- ,,^ru,*

fl*

;rJn*,,* Jr]fl'iln

in cÉ

J, l',rn

f;,,* ^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"h

t':h;;,*l' k,,rk''"1,,^,,,^

\'!L: l"l

;;;"À IJL

w

Jii+,w,it*f **L'J[,*,!\1"**

.10*ìLfl. =

n,i.rn ^r!.[.'«(,'1""{*

\,ÀLr,,*J

ry,{rhdr'k&- "!^A +*th»;n

qrlTJ !'ùl** Jrfl'rf'.,-l

; ;^,r,*Lr!"

'o ,!

*,1n vc =

,*.,.ur',-*1. ^G

i*t,,,',*A

, * &L

"

'\lnfu x* ,r*"'w: )L Ì*

,Vnn*,t;'!,

Jrt)'*r",*l l'rl,,n

;,f,,*o;*

,L o,n*yr*

J^ &"oe

u =

L,n

b, *

lj f',

qh wy

; l'^h*;'*.

,'fitllr:

t

Jtf,,*::0^*;^",,t Jrl*cw

,oa,4

m,"r"".

qw| ,.,,.

^u

,lJ,*r*'!'rlr"w,*4trrrn;'R-

*l

Jl"b-L =

ut*l"r* *+;,;,1;+;o

"L,U* 1,

*'

]

}_

2

É

)-

E-''

*-

§ I

_È

! t*;^*^-

- n

- 0.,

-1.' 2*7

4=? -

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, -:L

ht

16=2r txj É

m00,mol,ml*ffi1,01m, - &J*tfii'L'»Ntsu'x;t

10Ùi,

0111,10@,

ù101, 10,

01 -.-

1010,1011,1100,1101,1110,

,11'11

lllt §à-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

èo

Charactsr

Code.

ÀsCII

:-,,-. «rt'l-

f

*rr** E

C,..r^L '5a'J"

rrrr* L

r"'

!1ro

, :

I .rm uor -

,\ .- u- ZoQf zo =

il*lj*

k

tJffitr ii=iirt"r"'L?Nr'!*l*l;""*"'*M

\

è\

-

*Vul^rL

n**,oJ; -X fi*[^J;+X

}où1<a

J-"L{.,{';,y' zv s

t L-14*+l.l, g*,1,-?0rM4.0;L=

I

'n J

c 1g'.,

1f,,rr"-lrLro,-\,r,pdoJ

1

,1 , o,-\,r,prdo

7+L

=t,f

, =r":L h*

r l<rllta*

A], r.*i,*

,*, p,rt -

[" l*,a,y,u,,t' $tlL t

h

h,ilry#r?

U"à ol;

" ^

, \*rru-;; ^

"W-,t ;;

;;;W;i.; i;i ",*'w&7:

**"t,Éau

L

^a**,M

4 " >

E

*

!t-lr* I*t-,,;

,'*J-J sìal,ti

ni*u"Lu ,3',U^

Uoo) r,fu'

.-i!^M

; ilW

*J" ry=

c"oz

)tq'o,uh'a, )n

anlx

ltr.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,*^,'-*

,*t

i,y,d )o^4.

*,.//1'*rJ*r.e =

^"*t,lllil

w,,$,r =

z

lr. ("

,. F

0Q

rnrri*.

OR ,5(

,^,n.o**-il*-tro-,rr.^ xr

o'4'q**/r,,o tF(,.r * 'rbrrljÀ

xà &-u,^i*.)

btllt

c

j, l1*

* Lb'

.t+

L aL o rywvan

^*t"Ul0,;*

l*,*-

\pr"J

uo0,,,,r,,- 2 ^,0$,"W*.* =

, Lt

o

I §, n lt qn!<i<rv'r;d )k4;=xzz

,

lJt*ls, ""-4r-llA

L'-ya*m1,a.u"*xiril"l

xt+t<a+-.-*\ar

OB, xvyoxvl

,rq{t *k,r)ox#/ er.og

*4,rJll

-l*"*lOR ,. xly ,r,"L ,,x+f

f.*/r} n e

Jo )d1o =

y

lqrl (,fi,-tri,*l

,;*lLL

JlwJ.il 7

{lttl 7

x1'x1 Jtll

itoo**.*l z

F(*",*.)

rc*./-

fub't

o =

"p*h+o t/*'

l\É.

nt"'