Bases de données
11/10/2016 Initiation aux Bases de Données 1
RÉFÉRENCE: ATLANTIC-83/DOCTECH /
!"
! " #$"%&
11/10/2016 Initiation aux Bases de Données 2
#
"#'##()(()(*#
+,,&&-,+)'
(.(#(#'##+,,&&-,+##''
#. #/ # 01 /2 ( (. * /# # #.
3,45&&,4
#1##(6#2)#/6(#
/#6.###/.##78
●%#."(79
●%#.479
●%#.6
#'':#;<(26.
# # # #1 ( (. +=4 * 2 /
%6+=4####2((#>
11/10/2016 Initiation aux Bases de Données 3
$%&&'&'&
$($&)
$*$&+,-#)#
$.$))&,&
$/$0'1','''
$'0'##'&2#
$($'&
$*$'#
$.$'#+&&2#
$/$'#1,01)
$'0''%-
$($&1&)'
$*$&1#
$.$&1#%3*
$/$')'
$4$'%&-
$5$''
$6$'%0'##'0''%-
$'0'+,-&!"
$($)
$*$',0%&
$.$'$$%&
$/$'$+$%&
$4$0'+,-'&'+0-
$7'%%-'
$($#
$*$#'#1&
$.$)#'#1&
$/$)##1&
$4$'-8'#
$5$'-8
$'1,-'
$($&'1,-'
$*$)%&&'''19-'+
$.$&#&'#)0'#
$/$''19-'
$4$'1'9-'
11/10/2016 Initiation aux Bases de Données 4
$%''
$($)
$($($,01)
46.#/'#/:(1#1<(;#2#)
(#78
●4/% +1 #
1*(1*(21*/1*#'')#
''##(279
●',0)-1''*#'#(
$($*$,0)-
/#/#6':(#21216#/(16#
1 1 <1 ) 6 #/ ( 3-+,?@
&A3%5=?,+ 4 6. ' ( ) 1 ( /# # +5,+ ,
534&A3%5=?,+78
●/(#/#)#)2'#(B79
●/ (1 # 2# # 2) # * #( #
#2
4/ ",&534 #/ 6. ' : # < +, ,
&&-,+:/###<1C/##3-%&,&5,+
(# ( / " # 53%&, %%5-3,4 #(
' # /7 ( # (1 / 2 # ' # ( #
:;< :( #/' 2#<1 # <= : # 1
21<#=:2##(<
"/ ( D' E2 # +6. # $ # #
A4+-+1+5&3+-++-"?3+-+(C1#
11/10/2016 Initiation aux Bases de Données 5
$%''
$($)!;"
$($.$&>
? # :< # # ;<?; ;?; # 'F
4((#(#78
●4/?&"5-##8##'1;@;#9
●4/+,&", G%$?H5- # : # # (2 ; (
#'2##<79
●4 "I-3,&", # # 7: # # ( ; <:< 2
##<9
●4/&5-$35-##:?##(''*# A;:
"$
$($/$,%&>
? +J+5K%, , $,+5& , +,+ , &&-,+ :+$< 3$",4 ( #
#/###1/*#8
●"3-,3##79
●%&+53,379
●4-53?3,79
●)(#/,@533,#/6&+-3,3,+&A3%5&+79
?54+5,?3
?54+5,?3
?54+5,?3
+$
:4<
,)78%6+=4
#
#
0A
0A
0A
L
3;
:)78+=4<
A
((#
'
((':.#
'1#(###(<
3;
:)78+=4<
3(
)
3;
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
1
/
83
100%
