VIII.2. MLD DU MCD VALIDE
Facture_type (Numfact type, libellefact_type)
Facture (Numfact, Designationfacture, Quantite_facture,
Prix_unitaire_facture, Datefact, #Facture_type, #Matricule)
Produit_type(Numpt, Libellept)
Magasinier (Matricule, Prenom_M, Nom_M, Tel_M, Adresse_M)
Concerner 1 (Numfact, Nump, Quantitefact)
137
Produit(Nump,Designationp,Quantite_stock,Prix_unitairep,
Date_mise_en_stock, #Numpt, # Numstock, #Num_tva)
Stock (Numstock, Libelle_stock)
Etablir 4 (Matricule, NumBS)
Bordereau_sorties (NumBS, DateBS, #Numfs)
Fiche_stock (Numfs, Rubrique_budgetaire, Designationfs,
Quantitefs, Prix_unitairefs, Datefs, Sortiefs, Entreefs)
Bordereau_Entrees (NumBE, DateBE, #Numfs)
Etablir 2 (Matricule, NumBE)
Concerner (Nump, NumBE, QuantiteBE)
Concerner 3 (Nump,Numapoff)
Contenir (NumBP, NumBL, Quantite,prix_unitaire,Date)
Bon_paiement (NumBP, LibelleBP, DateBP)
Bon_Livraison (NumBL, DesignationBL, #Numfour)
Fournisseur (Numfour, Prenomfour,
Nomfour,Tel_four,Adressefour, E_mail_four, Site_web_four)
Recevoir (Numfour,Numapoff)
Appel offre (Numapoff, Libelleapoff, Dateapoff)
Soumission (Nums, Designations, Quantites, Prix_unitaires,
Dates, #Numapoff)
Bon_commande (NumBC, DesignationBC, QuantiteBC,
Prix_unitaireBC, DateBC, #Numapoff, #NumEMD, #Numfour)
Etat mensuel des depensees (NumEMD, Libelle) Commande_type
(Numcomtype, Libellecomtype) Concerner 5 (Numcomtype,NumBC, Nump,
QuantiteBC)
138
Service(Numserv, Nomserv,Tel_Major, Tel_Secretaire)
Etablir 1 (Numserv,NumBC)
Commander (Nump, Numserv,Qtecmd,Qteservi) Fournir
(Nump,Numfour,Qte_fourni,Prix_uitaire,Date) TVA (Num tva, Taux_TVA)
Bon d'achat (NumBA, DesignationBA,QuantiteBA, #NumBC)
Concerner (NumBA,Nump)
139
| 
