View
0
Download
0
Category
Preview:
Citation preview
h, \\, o* .L'1y' 'rr'AL
p c"vxra
a,trll)oÿ,ùtJ)t,j- ),,,_,,, ) i
\9 3» c.su-r
-L )r. )*.
Ag:Jé
1,3<'3cc t'
'3 3o 3r,r,
:1 Laéi
J , 'tc1l, atc'
Â,,3c], t'c'u
fô , o.*
), 4{b ,
tA /1-'xt('
4" / .--l ,',aJ' /,
<)//')
(zo *y-)ir,,
:. n$t';)2\,-, lJ[1 ,-,
L,Lt. ,,-e)\ -,/' ./
)-..)tJ-
t,
j,',b ÿt
iI t .,'- )L)
;I
_//'
5 ry:) Yl
i'4' J
or:,J),.)l-rr
)C,,rli)\ 11 -lQ
{t,')'gJ)
i
bra,,
, YrJ\tJ lj-*- )t,t- i,, t- \i^tl, ,5\JL
JtY--,
,Ç,
r(r-__. x t
( .rJ J,Lt
K, t'r Ç(/
l^ ,1 ttur"u'l
"*- 1,-' ) h---,-._l t .^c,l I tt"à'rZu.1 |
lrt,L\Ii'a.Aï
*/§l. e '; l{, (
U';)t ';iJ t/ r;.rs,)\u
,)Plt ,\r,'Xi 77':)i.,dl.,
" ";l
t')t{lÜ l-P ,, '- )
(-.t'r , I
l:i
.5.,?:
ly -:-t-
J,)\ rll ")l #- ;_t-, x{r {J , J--r ',J
{};*Ât tl. Ll;Xi g \,,7,1t
rit\ f I
, jj:I
r'-\ ,3 t l, tztoJ ',.;;)\I- - -' ''/àJ-," - . J=ti (r;J\
, &-zJ \ ,;)t);-t
; l" /t a-:i,U)t l,L* Çt4orFJi};,)f , 22jJt,
Iu:ÿJ:-t
-ÿ'-* )l
,-----\
(L',-1,,r, ; yr'r) ,:-
i /§ ,1J1 .1uj'.
_)Jr,:t dl___l\ ,_1, ;..,_, ,\
7\r's 8l
, tl l
'J--j ",-, )
),J
,J\_)-.--t.--L r1) /'/-l-;-''u-/-.'
-l.,tL .r., /r ,,_
-.-/ J
C'J --,J
'5*r-. ,'''rJ'r '','
('7r ) )':_'1
"'a
1
îo, -r''-rr-ÿI\- iJ-
(/
-J _v. ?/'o r,.l.)
ll'
i,l,l()y:
) r yrlLi \
,.J i!;' L r*st*Ji _ q
..i. jtt
..,r-lrjl ,',-it[, sJtrll fllldll l,,lUJ
4i1l+ - 2ai.J 6tsJt ie.o§
J#dll esbs L;hsl! çt,.aiÊYl ÊJldl 4S
z}lst}strs ôsYl
I p rJ c*4 a-lltlt Â.:-,:t - L:h:Jl ÊJlrll È*I_ÉJ_o*d '-!.êr.êii
l*., 14:00-lr.r12:30
gùAt *1ll,bl la.T I o,t*fl ti Z.r-rtel t !t3, t
(!tij 04) ... r,J3ItJt-l*Jt
(e*:,-ur) 1.:1.:.Yl ALJ-J rl:^Yl ;;u ôill l- .lÎâ*jdl os Ujrr^ .-Éo é1 e\iÀr:ll 3fi 1yt .2
(Cy.»+) ff\,jl ùü,"311 .:l:.! üü,.111 rlr.ol g+r Ôi]l 1* .3
(!rii 07) ... I çjrirr dü*Jt
.,e,J:s::t r.!ill lra .:U.-- *1 JSli .Ê\c Jis-ir rl:.Yl u.lJ,/ J#st.Jq ,r*ir§ill Êsill *L. .1
.'lLq-*ll i+.à!-il èJ.:]l ]qUS 4- Gordon Moore e;E Lrjia^ Jt-i:1, -JÉl .2
.RFID 3çr!1 el:5!, ;r..:Jl â-.tr'lir Code à barres ré:Ul a^}'ri ++ -d-i:+ çf- ol§ .3
(a.Lii 09) ... rriltit.Jti*Jt
é\ Â-iX\ ji)) qrl:-yl ,:LyJ,^ll e!=.!-i:S:: a-},lT o*.+ dL--r ôl),-:i- Ê-4 ,t'Jb CSI .il+Jl al^S1 .1
, jrnjl JL 1{Yl
WMS
TMS
YMS
VAN
'('''j'"ir
dr.tll JL 1rYl
CRM
SCP
SCE
N/ ES
(eE Js Jtsll ,,l' JÀ-i 5) .EAl ,SCEM , ERP :a,rJ\iil q,il*r'tl\ Â-liiY\ th*! C!l rc;*-.I\ i-r-j;:ll a;+=ü113-l :L-ct -: -+:Î-;.d! :o-iJ\ L
.2
.3
,IFJiJs
Jéhàü.#tit/i
lll a*i:,âl
oJrjl ,'.-,.rg Ctrll Èlrill lrfu+!jq - ."irii rlrlt qroLr
J#./:ll fsb: L-ltdl! çt,a:!Yl pst:t 4S
t-+qt t-iï."cr p J cr.,'rÇ ai:tilt Àilt- L..,hill ÊJl'Jt Ê-"1
é-,.i tÇ?.ai3
pj+,1 t ï+J t*'l9 r I $I I ü* rri Lr_r lrJ I 4 elU 4t il,O t 4 g I I
(!tii 04) ... r(,lgïtdtj*Jt
.:.,1':,J1 ",^
JLJf gli\L\ a+1r1 "Yl ,JJ .-i.<+ Â*1Jl ,J.J^lS3. âjü- : r1r^)1 ;1 .5o :h^Yl 4LL: :1:.Y1 ;p ,j»ll .1
.:$^,J1 6++ r\:"Yl --+.:;S,* ailsi JL.J â-,.3lt^li ôr3ç.J1-r.3,,' .\.i^ll ..,Sl-t,,' ,1j^11 d-'!rl a»ÀJ 4+-U^ll é!^Sl! i,ri-t^ll
.-i!À!l 4c.r^+- o+ rlr,Yl Âl-L Li ,e;éb il:[^Jb ,-]*>.jjlr Ji.,tl_r +;Xt_r ,!r:l§ L.rùul ôLJr^ll +s,r-, Â!.t!lü1^'-ii{+,k+ L1À CJb 6U,V5 rldll âI^t:i \Jàii J+-;+ tsl"1!.(a**3Jl üjU.a*iJl ri .,3.J1 31j^) ;"!!uJl
/rr 'l ,. ,,,l§:' ,.zi.i^Jl qs)É ,\!l ,Jl YJ-J Ë-i\l ÂL-» ù^ el$J ell.riJ1 dp$r ü5LJJI oi4lti" i;$\:l/ s:1ai"; gr A*3Jl q,s ,:tiàsll u^ tbliâr, rr# _.*y!r iS+ .2
:1")' $ .:L:iJrr -,\;iJl tfi .'5,;!t, .-uej!SlUr!' .r'rJt aS;s <;rLJr .:uÀJl -§ :Physique L:'*Jl .:,riÀ-t]r
@lU\ L\: eiliriJb L:*il , ;. i ôlsir^lb 6tl)t rri .a1.riJl,
i_É él éIr ri Â*j^! É.:lJt LJ- Jt dr .''E .lt ot JJt 6:^+t ;*Vt gJ,i,- :l
),5
nfTpatons éLi-jl ii):
OYnrr L,-i,Jr Jiir
u-r+ -.-r-Ul slr\L* .,J. .:lu:dJflnôL i+r3 d,t- 1965 â:- Gordon Earle Moore -,D. ôSrtSè ôiri J+L .2
"i g;;t arü§.1965â;rJ.,+Hiy40;r^1 1:a3rO,-e-tii:b1+r-
"=Ee,;Si-(§L.Ji:G..1 .",*,Âils
,2020rl.c,ri:;r.:-1 ;i i-:.--l ,ii*40;rJ;Ë-t a:i J+è(LlÂ.:]ei-10ôr^llirL;3,^;yli *:-+
6,?t" ÿn = ÿox 2n:;r^ ;yl§ rrÀ, l!i*,J!:lr »,1 t*;uJl ai,-llY/) _,/
L:c) \ryJl i;ill n ,Lji,LJt l:t"Jt ;2:;;Jt!,-t!yl--21rllt ». ÿo ,LsNl à:i.jJt ,Jill é ,'1Lj't üJü;tt ilD yn:,'t,^
té él! +-.i"ill rlr^1 ui g 6Lll ..*x,ill r[^! ,.,l+.rill r[^l ô]i ü!\ .3
rS iâ*,J\ os L;]ry\ ÂL;:\ Lj)Ut aili-Jl rbJt ,,,ri,,!,L+ el,.ll ;-_iJl
(.Ltij07) ... I (,Jri:rrJt-l.Jt
.2 *,ir (o!*-tt
n = Co x 2n :l:r ,tyE ,:i-: diEJl-Il 4-Ê1i- ljl$l 4+^à!.,11 L+Jl.4 a+d:i PAI .tt) &1 ;till n rifll-Jl li"Jt e;;Jt o: iilsiJlCo ,Lstj;Jl ;'+4Jt ÿrrJt ,; l;lSltCn :,,'t:-
.RFID it â*l:iL Code à barres rét$l a^f,:I a-UI alr turbJl .3
llla--,a,ast
Y
Y
\tÀ
v
Y
\v
;§LJl6!l i,b, ir JKi;"!s +",:ts.l
rl-call ,slr-r "t-üi
;rlill aiLUl
§-',,;ül ;rtc] +,atS"J
sc!.!lJ Iine-of-sight r-,ll -L: i rL;, .sr^
1*ll 4-,j,Jl . iq-Èll eli5i .:t5Jl e=6lS^l
ol;Jl 4!.; ç.rJl , rttll LrtL,rJo 1il1
ar'- ,!t cJ3ls .,3rr .r-,»Jl açlS.l
. i:dl ._J' çrTrg-r qrsj çts.l
(!lÂi 09) ... ! &JüJt drj*Jl:ia!-âii.oll cj:+ .1
Warehouse Management System Customer Relationship Management
Transport Management System Supply Chain Planning
Yard Management System Supply Chain Execution
Value Added Network Manufacturi ng Execution System
:EAl , ERP ,:\-j-Jl Â^l:jÏ .2
,r-rrtll ,,u*ill) â*jll dü,.;\::.0 g.+ g.; UL,r\* i^l:Ji l.6ji crlc ERp L*3Jl ù!,^ \jL-l Â-"hi :ERp
Lliji J^,J 'BDD;r-! ôuLlr Ërcti alr:-i.1 j)i.;^,(d1... ,)!t{b 4:lU1 4irÀll r!:Jl râ:tl \1 ,ejé1 ij-»jll
: 1 r.=! 1 rF y l ùr,i *! i1r rr -,, o,r s u p p r y c h a i n E ve n t r' #r.i "Tî ; :i=: :îÏiï ;ïtf-ll; çl*r-iiJl l+Ul !\:^+ JÉ,i ,',J- r1:^)l iJ*J- q:l§ir: . ;lii q (Sl.d Ji T:!_r" -isy ,i æ:-) l§ ,t\ ÇL: .r^ ét.:ir-.Î ;;lr1 i^f;i e^; +- ,(CSE) rlr.Yl iJ-l- .+x rllr/-{RqP) r[^yt i]*!- L.,L:.r
euâj e.u+ (lien opérationnel)
W:./.ç uu.
" ;*è èh-i t.ie_r {Jr=.rr Ji$t+ rtr^yi Âl-LJ^1S1" JS*t J^,j ùi 1.€i+ Y ,â;Li. uc_r,-.:,,+ll 1*'- crr a-\s,:* t:!;rÿol^r[^;,^làJi Â*3^Jl 6,rii ,r l-r-jc rEAl
(EAl) i*}Jl ,:!+{r+ ùK ch,,.L em,ERP â*j,^Jl r;Ç ljLir a^bî .:6-! {..,*.1T.., JlJl ,o LS Ërs! 6,-r<,
ci.JlJl ; !i 1l .:1i'Çlr-: '1
CL y *>-..it ê.-rêr i5jli-l :l*br +;
6 rlr 6j_l,* crlc -EU.ll U q+iilt 51. 'yJ1
.,IÉrllt
;.4àiü1.JLit /i
ll2z=;ualt
a,ilt3lt iitt - sJYt Ê)eYl ô.rL gr-r oy s+lJ^jlt Cl.lt
U-9r ôJW +#J-i +6$i lL,ailt gara§
ê U rSJ,.,olj+-ll .ra 6ai 61 &UlryJl tct_9i rt.t;:*,t ûlJb,.a -(Idiül+ll _,,1_r$ ç# éJti,jt<"J J J! Sjll6Jù _
oül-ull!*: cl l _
â:r. r:l:-)- Êe+ -1n3ii ) gçrll ô!o\ii..Jl ,È .gl1 É-,p -
i.l $(-{ ol-rtlill ;r.u 6rîzJl otil,ll ,JS^J _
d,*Ui^ J Jt" JS& HJi \^:É drUt+Jl cJ.lS _
full^ tl d Âl.eJl -r,sy _
eül3Jl ùu:-l ,lrrï."1 .r-â;q$lt fu:_*ll _
Date de vente
02/01./201402/011207402/01/20L402/07/207402/01./2014 '
02/0rl2ot4
Départemenl
D1
D3
D5
D1
DB
D3
| &üAl relJt W 7,X*; y rfl ayill u.o h_
t:,l*tt e.-: ir;q ÇLc rlrc)l iils eilS lri t^ ilt^ çr -
aI* _l A!*r o§ldl _e ou!r.!l ôrct! clts h1 l- rJl_:; _
ç)rÿ glSô, l'. e;Jl- Lt.r,,1a§! eU+ 8_r-,*tl 615 ti1 -
Paradox -MS-Access -Oracle . ûüAt ,rt§ lLil (2
Point de vente
x4/P1.xt/PtY21./P4
x4/P1.x1-/P5
xzo/Pt
Représenta nt
R1
R2
R3
R1
R4
R5
Produit vendu
P1
P1
P4
P4
P5
P6
t 4i,r-lt
crt+iJt ôÊ ill"oyt oà+ _
Client Montantc1 72s7c2 507c3 800c2 44c5 87347c6 990
4r*..ttt4+i,lt-
El*-çD*: r+. dl_rriYl u 3 qitr^ll4:ùll ,Jlâ+^t*ill4+iijl .!J=i tlttd i-ÂJJ"-ll rcl_eill gJr*,iLr. e$lilf 4#f _
Departement (UgrrSdgp, nomdep, adrdep, numsoc)Societé (numsoc , nomsoc, cap, fax)Point-vente (numptv, nomptv, adrptv, representant, numdep)Produit (numpfqd, nomprod, qstock, pu)Client (!Urngl, nomcl, adrcl)Livrer (numptv. numproa. n , datevent)
: .*!- J
p.*sJl ulJlc3 edl e-l , fdl é-l :numdep, nomdep, adrdepU eull u,,SlJl I islll cJl-.ri,, :
ErSt ê-l , ASJ",ill i_., :numsoô, ,o*roô, cap,faxÉJ-ll e-l: erllaln gl3Éc , e.*llÂË ê-l ,ë+lla§j ÉJ :numptv. nomptv, adrptv, representant
ôr-3Jl i*.,3 fujÂ^lr 1J^sll, eJij"rl Ê-r ( e cjj^rr p'l :numpiod, nomprod, qstock,puürjjUllo: Orjle-l , .t-r+-il| C-,r :numcl, nomcl, adicl
ërll gjJU:Datevent
FJJ.Llli i,atÂll4{+lJ,Jl cJS- -
. il==t 11. sql
UuiltEr I."-._.1.. .
. - Point Vente
clL-
: ê+i^ LiiS 16 i6+Ul ç's4++l-rll os a+l^ltL),l! ciÜl+Jll+-».rt- DBLabel' tt' .r 3-
' i{+l-rll ,1gt-ll j,.r.l" 1+,:Ul+=rlll+: crl= DBEdit,-iüs ü^ 3-
(Saisirf )':UÇJl 6l!a â-U' (Evènements ) dil':=ioo 6lG ry': Button' tt .r 5-
ok,i_r (Inventorier) oq{t , ,, _r âiU+.;";o ,(Valider0)ilrl-Jlc (Annulerg)o1JYl,
'(Quitter)ü+l;lt6rollill ,r-à ôU!$,J-r-rll ,J+i .x Al^,j*ll JlJJYlj+-* ir-r+ crl- DBNavigator qiis tJ^l-
6roljill ,r-è.6rjr;ll oülJl &_§ crl- Table , ;i. U l-i6l,!l i;r3ç.ll ctl-ulSJl cJS .!+t aJ"+ eé-l iDJr^+.Il
"s ".""u;Jt J.-i*ll ,tÉ,5 Datasource ' ii' gvl-
i6l-,Il ,/.È!l e--.:.i-ll ,:l-rl;rJl r-rtr;-l .,i ot-1. üéJ DBGrid ' tt .r1-SQL 4iJ.o-i oLJllllt§l,J-r:F $ -r Query r*ir:s rr l-
?éEd.dl i prâ é§l e ir,^Xl ,àii: ô.tcLül
dllllLll .-i!i- a+ljs J[il!_, sQL êlJ..l Dii-Y U] e^: '''t-l Query ]3. 1n$1 Ërçlill ê)rirL Â-1j.ll
SOL atÀi .,.à L.JiS^ll dir!'lLll o. âlLYl LA -
o)-ll 6^+ ou-L a-iLE (l
«PRODUITS AURASSIENS DE COSMETIQUES v ô;hll ç-rx isJ*,,rY (+
0ll01l20l4 ettr «LOKMANE ABDELLATIF »ü:+il LÀtJi,il élôl+rr,Jla.iG (e
SQL {rl é Ô1ilL\l oia i'-} ê 'u -r
a) Select *
From client
b) Select nomsocFrom Societe, DePartementWhere Societe.numsoc:Departement.numsoc and nomdep:«PRODUITS
AURASSIENS DE COSMETIQUES »
c) Select x
From Produit, Client , LivrerWhere Produit.numprod:Livre.numprod and Livre.numcl:Client.numcl and
nomcl:«LOKMANE ABDELLATIF » and datevent:«0110112014 »
ôlçl4iiÉl
-j
\
- e$ç ,r"àil tLrlr igr+J*J*üll e.det +ubiJt., qrt zriiyl fJbJt +ts
2015 /5127 r ,rrâ A-iJç
ü iJ iet* 3 ô.ull . 6;r*Jt rÉLIsr i_.rt+i :Âitritt ii"tt
crt*lâ srt !,Ul §jrJl gLrirlqll,,ai§Yl Éy§]Jt
.A+Xill ili-,Tt dp ç+tftj;st.crilret Lfu l§uJr J$ir JU"*r,r g;-r -l
f;[rt*lr aJ., q, ;1..a.- ,"5-iJr sÿAr Crtr -2
*v ,s;*\r ioi"r6etr c/tta:Jr rJfîJ"l"!l,Jr(C, d., .j q.{.r.)-r'Tl z.r.*dtgt* ."r- CÉl _3
ÎÇult J3.tJt;ry
S,Jrt,tJ' Cel ,r,,il ar-ri;Jt ôr,-JJl reL*s ,§ 7ÿr -4
Wl,tî jl1ït Aftr;Jt rlrôr .rorl .1S -s
,i i.:Jtv -J
: Ç,\/, Jtÿ, y- y,y,\"#/,d_tHÉJl _
\i t'.f"r-l.a ar: Lé5ÿ' (C!,o a- tü, -
dî",' \4 ; (»-,\ù::'L-;;'i a;ê -- Virlt lst)tLç "5s
. lr W\ >/t*\ d ÿ;t I :t*' -ç\,èe k ,
d ,r, +: üq \ÿ'/ | tt-ru ] € ^s -
2, vüJtÿ t§;l\ c_'rç nf ;>r 1; tr )\
CèH :rVü Jn)t t *rr trÿt P,_?*r, . +Ç ü;)i,C it :ü2tÿ,-; l),
à:*g7Ç'A;"r;xlô ÿ'V ürâ\:.)'(§r' tès *S t )\rrbNr '{t't:,--t)r
''' ï '-,'+^r, É 3+ &,?,?5 ÿt?ré 4.'t*' ?ê 14'i, Q r ' ;) t3t, v\) t
: 522k,'*;3t. J,tj;,gzr;Jr -
. )'u«, t *,è--rwia;ÿ/,Y',t\ -
- "u'
uC 4: ; t;-- . a utüYy /j'tt
: ÿr/)\1-V 1 § qGllPj 'd'P t-é '-?Y' -- l-) i
r'Ui t"i )l i 'ÿ-c 1 t-, r-'"t J\t;' Cu{t't':'u ;..
r)\ -\y't:7jÿ:rÀr'§'ÿ;rÉç;
\' C=*) : ù
'§ r,?, Y€' 2èJ \"t' J; z' Cn* \
.t'
Recommended