II.4.4. Matrice de dépendance fonctionnelle
|
N°
|
IDENTIFICATION
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
|
1
|
cliId
|
*
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2
|
cliNom
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3
|
cliPreno
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4
|
cliVille
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5
|
cliTel
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6
|
cliEse
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7
|
cliEseContact
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8
|
frsDenom
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9
|
frsVille
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10
|
frsPays
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11
|
frsTel
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12
|
NumCmd
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
13
|
cmdDate
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14
|
cmdQte
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15
|
cmdDescript
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
16
|
cmdComment
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
17
|
EqpCode
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
*
|
|
|
1
|
|
|
|
|
|
|
|
|
|
18
|
Design
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
19
|
EqpPU
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
20
|
numLivr
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*
|
|
|
|
|
|
1
|
|
|
|
21
|
dateLivr
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
22
|
refCmd
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
23
|
expNom
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
24
|
QteLivr
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
25
|
PU
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
|
|
|
|
|
|
26
|
NumFact
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*
|
|
|
|
27
|
dateFact
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
|
28
|
Ref
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
|
|
Genre
Date_Nais
Adress_compl
Nom_Entreprise
Teleph
Adress_Email
Image_Acheteur
Prenom
Nom
Postnom
Id_Acheteur
Id_Catego_Equip
Num_Commande
Num_Paiement
Date_Commande
Date_Paie Montant_Paie Enregister_Par
Designation
CodeEquipement
Designation Marque Performance
Num Livraison
Date_Livraison Effectuer_Par
Présenté par Emile Amani Digadiga en
vue de l'obtention du diplôme de gradué en Informatique de
gestion
Travail de fin de cycle - Informatique de gestion - ISIG
GOMA 2013-2014
II.4.5. Graphe de dépendance fonctionnelle
Présenté par Emile Amani Digadiga en
vue de l'obtention du diplôme de gradué en Informatique de
gestion
Travail de fin de cycle - Informatique de
gestion - ISIG GOMA 2013-2014
CategAcheteur
Code,
Designation
0,n
Appartenir
1,1
Client
ID,
Nom, Adresse, Tel E_mail
Commande
numCmd, Desciption, dateCommande
Concerner
Qte, PU
QteLivr, PU, DateLivr
Engendrer
1,1
Paiement
Equipements
eqCode, Design, Marque, Performance
Livraison
numLivr, Description,
1,n
1,n
1,n
Effectuer
Effectuer
1,n
1,1 1,n
Appartenir
1,n
0,n
Num, dateRegl, Montant
Categorie Code,
Intitule
| 
