L' entreprise Adélaïde fabrique et commercialise des meubles ... - Free
Il est chargé d'alimenter le livret de correction de TD du groupe. ... la conception
des modèles de communications : contenu, tableau des événements, règles.
part of the document
r\tsbrdrdgl\tsbrdrdgr\tsbrdrh\tsbrdrv
\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs20\lang1024\langfe1024\cgrid\langnp1024\langfenp1024 \snext11 \ssemihidden Normal Table;}{\s15\qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0
\f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 \sbasedon0 \snext15 Body Text;}{\s16\ql \li0\ri0\widctlpar\tqc\tx4536\tqr\tx9072\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 \sbasedon0 \snext16 header;}{
\s17\ql \li0\ri0\widctlpar\tqc\tx4536\tqr\tx9072\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 \sbasedon0 \snext17 footer;}{\*\cs18 \additive \sbasedon10 page number;}}{\*\rsidtbl \rsid2238478\rsid4721918\rsid5517580
\rsid7893062\rsid10445119\rsid10760843\rsid11758286\rsid11862520\rsid12678181}{\*\generator Microsoft Word 10.0.2627;}{\info{\title L\'92 entreprise Ad\'e9la\'efde fabrique et commercialise des meubles de chambres pour enfants.}
{\author Maryline ESTIVALET}{\operator MASTERVANOU}{\creatim\yr1998\mo2\dy3\hr18\min49}{\revtim\yr2003\mo6\dy12\hr9\min38}{\printim\yr1998\mo2\dy11\hr9\min19}{\version14}{\edmins24}{\nofpages3}{\nofwords579}{\nofchars3186}{\*\company LE CASTEL}
{\nofcharsws3758}{\vern16437}}\paperw11907\paperh16840\margl1418\margr1418\margt1134\margb993 \deftab708\widowctrl\ftnbj\aenddoc\hyphhotz425\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\hyphcaps0\formshade\horzdoc\dghspace120\dgvspace120
\dghorigin1701\dgvorigin1984\dghshow0\dgvshow3\jcompress\viewkind1\viewscale100\nolnhtadjtbl\rsidroot10445119 \fet0\sectd \psz9\linex0\headery454\footery454\colsx709\endnhere\sectdefaultcl\sectrsid2238478\sftnbj {\header \pard\plain
\s16\ql \li0\ri0\widctlpar\tqc\tx4536\tqr\tx9072\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\b\f37\fs16\insrsid4721918 Devoir }{\b\f37\fs16\insrsid2238478 MCD}{\b\f37\fs16\insrsid4721918\charrsid5517580 \tab \tab
IG1}{\insrsid4721918
\par }}{\footer \pard\plain \s17\qr \li0\ri0\widctlpar\tqc\tx4536\tqr\tx9072\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\field{\*\fldinst {\cs18\insrsid10445119 PAGE }}{\fldrslt {
\cs18\lang1024\langfe1024\noproof\insrsid2238478 1}}}{\insrsid10445119
\par }}{\*\pnseclvl1\pnucrm\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl3\pndec\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl4\pnlcltr\pnstart1\pnindent720\pnhang {\pntxta )}}
{\*\pnseclvl5\pndec\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl8
\pnlcltr\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}\pard\plain \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid7893062
\f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\b\insrsid2238478 EXERCICE 1}{\b\insrsid7893062 : MOD\'c8LE CONCEPTUEL DES DONN\'c9ES
\par }{\insrsid7893062
\par }\pard \qj \li0\ri0\widctlpar\tx284\faauto\rin0\lin0\itap0\pararsid7893062 {\insrsid7893062 La Soci\'e9t\'e9 CHAUSSANT s'approvisionne en mati\'e8res premi\'e8res en respectant les r\'e8gles de gestion suivantes : }{\b\insrsid7893062
un fournisseur assure la livraison d'au moins une mati\'e8re premi\'e8re ;}{\insrsid7893062 par contre, }{\b\insrsid7893062 une mati\'e8re premi\'e8re n'est achet\'e9e qu'\'e0 un et un seul fournisseur.}{\insrsid7893062
\par }\pard\plain \s15\qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid7893062 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid7893062 \tab Les informations de la Soci\'e9t\'e9 CHAUSSANT sont structur\'e9es dans un mod\'e8
le conceptuel des donn\'e9es.
\par }\pard\plain \qj \li0\ri0\widctlpar\tx567\faauto\rin0\lin0\itap0\pararsid7893062 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid7893062 \tab L'achat d'une mati\'e8re premi\'e8re fait r\'e9f\'e9rence \'e0 l'extrait suivant :
\par }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid7893062 {\insrsid7893062
\par }\trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw45 \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45
\cltxlrtb\clftsWidth3\clwWidth2480\clshdrawnil \cellx2410\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1418\clshdrawnil \cellx3828\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb
\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1984\clshdrawnil \cellx5812\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1134\clshdrawnil \cellx6946\clvertalt\clbrdrt
\brdrs\brdrw45 \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2194\clshdrawnil \cellx9140\pard \qc \li0\ri0\sa40\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {
\lang1024\langfe1024\noproof\insrsid7893062 {\shp{\*\shpinst\shpleft3478\shptop273\shpright6070\shpbottom1200\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz20\shplid1047
{\sp{\sn shapeType}{\sv 3}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8212\dpellipse
\dpx3478\dpy273\dpxsize2592\dpysize927\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}}{\b\insrsid7893062 MATI\'c8REPREMI\'c8RE\cell }\pard
\qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\insrsid7893062 \cell \cell \cell }\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\insrsid7893062 FOURNISSEUR\cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\b\insrsid7893062 \trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw45 \clbrdrl
\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2480\clshdrawnil \cellx2410\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1418\clshdrawnil
\cellx3828\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1984\clshdrawnil \cellx5812\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone
\cltxlrtb\clftsWidth3\clwWidth1134\clshdrawnil \cellx6946\clvertalt\clbrdrt\brdrs\brdrw45 \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2194\clshdrawnil \cellx9140\row }\trowd \irow1\irowband1\lastrow
\ts11\trgaph70\trleft-70\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrnone \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2480\clshdrawnil \cellx2410
\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1418\clshdrawnil \cellx3828\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone
\cltxlrtb\clftsWidth3\clwWidth1984\clshdrawnil \cellx5812\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1134\clshdrawnil \cellx6946\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrs\brdrw45 \clbrdrb
\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2194\clshdrawnil \cellx9140\pard \qj \li0\ri0\sa40\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\lang1024\langfe1024\noproof\insrsid7893062
{\shp{\*\shpinst\shpleft36\shptop301\shpright1857\shpbottom302\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz18\shplid1045{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8210\dpline\dpptx0\dppty0\dpptx1821\dppty1\dpx36\dpy301\dpxsize1821\dpysize1\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft7036\shptop301\shpright8213\shpbottom302\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz19\shplid1046{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8211\dpline\dpptx0\dppty0\dpptx1177\dppty1\dpx7036\dpy301\dpxsize1177\dpysize1\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft6070\shptop418\shpright6934\shpbottom418\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz22\shplid1049{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8214\dpline\dpptx0\dppty0\dpptx864\dppty0\dpx6070\dpy418\dpxsize864\dpysize0\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft2470\shptop418\shpright3478\shpbottom418\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz21\shplid1048{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8213\dpline\dpptx0\dppty0\dpptx1008\dppty0\dpx2470\dpy418\dpxsize1008\dpysize0\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}}
{\b\insrsid7893062 CODE_MAT_PREM
\par
\par NOM_MAT_PREM\cell }\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\insrsid7893062 1,n\cell }\pard \qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\insrsid7893062
\par }\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\insrsid7893062 LIVRER\cell 1,1\cell }\pard \qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\insrsid7893062 NUM_FOUR
\par
\par NOM_FOUR\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\b\insrsid7893062 \trowd \irow1\irowband1\lastrow \ts11\trgaph70\trleft-70\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt
\clbrdrt\brdrnone \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2480\clshdrawnil \cellx2410\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone
\cltxlrtb\clftsWidth3\clwWidth1418\clshdrawnil \cellx3828\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1984\clshdrawnil \cellx5812\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb
\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1134\clshdrawnil \cellx6946\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2194\clshdrawnil \cellx9140\row }\pard
\qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid7893062 {\insrsid7893062
\par
\par }{\b\insrsid7893062 Dictionnaire des donn\'e9es
\par }{\insrsid7893062
\par }\trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823
\clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx4535\clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr
\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx9140\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\insrsid7893062 DONN\'c9ES\cell SIGNIFICATION\cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\b\insrsid7893062 \trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15
\trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx4535
\clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx9140\row }\trowd \irow1\irowband1\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl
\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15
\clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx4535\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx9140\pard
\qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\insrsid7893062 CODE_MAT_PREM\cell Code de la mati\'e8re premi\'e8re\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid7893062
\trowd \irow1\irowband1\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823
\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx4535\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr
\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx9140\row }\pard \qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\insrsid7893062 NOM_MAT_PREM\cell Nom de la mati\'e8re premi\'e8re\cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid7893062 \trowd \irow2\irowband2\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15
\trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx4535
\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx9140\row }\pard \qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\insrsid7893062
NUM_FOUR\cell Num\'e9ro du fournisseur\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid7893062 \trowd \irow3\irowband3\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb
\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx4535\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx9140\row }\trowd \irow4\irowband4\lastrow
\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt
\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx4535\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw30
\cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx9140\pard \qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\insrsid7893062 NOM_FOUR\cell Nom du fournisseur\cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid7893062 \trowd \irow4\irowband4\lastrow \ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh
\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil
\cellx4535\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4605\clshdrawnil \cellx9140\row }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid7893062 {
\insrsid7893062
\par
\par }\trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823
\clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9211\clshdrawnil \cellx9141\pard \qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\i\insrsid7893062 TRAVAIL
}{\i\insrsid7893062 }{\b\i\insrsid7893062 \'c0 FAIRE}{\i\insrsid7893062 \cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid7893062 \trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl
\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15
\clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9211\clshdrawnil \cellx9141\row }\trowd \irow1\irowband1\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15
\trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9211\clshdrawnil \cellx9141
\pard \qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\insrsid7893062
\par 1 - Le mod\'e8le conceptuel des donn\'e9es ci-dessus est-il juste ? Expliquer.
\par \cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid7893062 \trowd \irow1\irowband1\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh
\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9211\clshdrawnil
\cellx9141\row }\pard \qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\insrsid7893062
\par 2 - Rep\'e9rer l'identifiant de chacune des entit\'e9s.
\par \cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid7893062 \trowd \irow2\irowband2\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh
\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9211\clshdrawnil
\cellx9141\row }\trowd \irow3\irowband3\lastrow \ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15
\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9211\clshdrawnil \cellx9141\pard
\qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\insrsid7893062
\par 3 - Expliquer pourquoi la propri\'e9t\'e9 NOM_FOUR n'est pas l'identifiant de l'entit\'e9 FOURNISSEUR.
\par \cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid7893062 \trowd \irow3\irowband3\lastrow \ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30
\trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw30
\cltxlrtb\clftsWidth3\clwWidth9211\clshdrawnil \cellx9141\row }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\insrsid10445119
\par
\par
\par }{\b\insrsid2238478 EXERCICE 2}{\b\insrsid10445119 : GESTION D\rquote UNE BASE DE DONN\'c9ES
\par }{\insrsid10445119
\par
\par Le service achats de l\rquote entreprise Ad\'e9la\'efde a con\'e7u une base de donn\'e9es. Vous disposez des \'e9l\'e9ments suivants :
\par
\par }\pard \qj \li1416\ri0\widctlpar\faauto\rin0\lin1416\itap0 {\b\insrsid10445119 Annexe }{\b\insrsid2238478 1}{\insrsid10445119 : mod\'e8le entit\'e9-association,
\par }{\b\insrsid10445119 Annexe }{\b\insrsid2238478 2}{\insrsid10445119 : sch\'e9ma relationnel.
\par }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\insrsid10445119
\par
\par
\par }\trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt
\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9439\clshdrawnil \cellx9369\pard \qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\b\i\insrsid10445119 TRAVAIL \'c0 FAIRE}{
\insrsid10445119 \cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr
\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30
\cltxlrtb\clftsWidth3\clwWidth9439\clshdrawnil \cellx9369\row }\trowd \irow1\irowband1\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15
\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9439\clshdrawnil \cellx9369\pard
\qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\fs22\insrsid10445119
\par 1 - \'c0 partir de l\rquote annexe }{\fs22\insrsid2238478 1}{\fs22\insrsid10445119 , interpr\'e9ter les cardinalit\'e9s entre PRODUIT et FAMILLE.
\par }{\insrsid10445119 \cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow1\irowband1\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr
\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30
\cltxlrtb\clftsWidth3\clwWidth9439\clshdrawnil \cellx9369\row }\trowd \irow2\irowband2\lastrow \ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv
\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9439\clshdrawnil \cellx9369\pard
\qj \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\fs22\insrsid10445119
\par 2 - Compl\'e9ter le tableau d\rquote analyse des requ\'eates (}{\b\fs22\insrsid10445119 document }{\b\fs22\insrsid2238478 A}{\fs22\insrsid10445119 ) en vous appuyant sur le sch\'e9ma relationnel pr\'e9sent\'e9 en annexe }{\fs22\insrsid2238478 3}{
\fs22\insrsid10445119 .
\par \cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow2\irowband2\lastrow \ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30
\trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth9439\clshdrawnil
\cellx9369\row }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\insrsid10445119
\par }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid2238478 {\fs22\insrsid10445119 \page }{\b\fs24\insrsid10445119 Annexe }{\b\fs24\insrsid2238478 1}{\b\fs24\insrsid10445119 : Sch\'e9ma entit\'e9-association}{\b\fs22\insrsid10445119
\par }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\fs22\insrsid10445119
\par }{\lang1024\langfe1024\noproof\insrsid2238478 {\shp{\*\shpinst\shpleft312\shptop1\shpright2041\shpbottom1877\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz0\shplid1027
{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lTxid}{\sv 131072}}{\sp{\sn dxTextLeft}{\sv 0}}{\sp{\sn dyTextTop}{\sv 0}}{\sp{\sn dxTextRight}{\sv 0}}{\sp{\sn dyTextBottom}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}
{\sp{\sn lineWidth}{\sv 12700}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\shptxt \pard\plain \qc \li0\ri0\widctlpar\brdrb\brdrs\brdrw15\brsp20 \faauto\rin0\lin0\itap0
\f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\lang2057\langfe1036\langnp2057\insrsid10445119\charrsid4721918 FOURNISSEUR
\par }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\lang2057\langfe1036\langnp2057\insrsid10445119\charrsid4721918 NUM_FOUR
\par
\par NOM_FOUR
\par RUE_FOUR
\par VILLE_FOUR
\par CP_FOUR
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8192\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \qc \li0\ri0\widctlpar\brdrb\brdrs\brdrw15\brsp20 \faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {
\lang2057\langfe1036\langnp2057\insrsid10445119\charrsid4721918 FOURNISSEUR
\par }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\lang2057\langfe1036\langnp2057\insrsid10445119\charrsid4721918 NUM_FOUR
\par
\par NOM_FOUR
\par RUE_FOUR
\par VILLE_FOUR
\par CP_FOUR
\par }}\dpx312\dpy1\dpxsize1729\dpysize1876\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinew20\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft5208\shptop1\shpright6649\shpbottom1331\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz1\shplid1028{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn lTxid}{\sv 196608}}{\sp{\sn dxTextLeft}{\sv 0}}{\sp{\sn dyTextTop}{\sv 0}}{\sp{\sn dxTextRight}{\sv 0}}{\sp{\sn dyTextBottom}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}{\sp{\sn lineWidth}{\sv 12700}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}
{\sp{\sn fLayoutInCell}{\sv 0}}{\shptxt \pard\plain \qc \li0\ri0\widctlpar\brdrb\brdrs\brdrw15\brsp20 \faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 PRODUIT
\par }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\insrsid10445119 REF_PDT
\par
\par DESIGN_PDT
\par PU_PDT
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8193\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \qc \li0\ri0\widctlpar\brdrb\brdrs\brdrw15\brsp20 \faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 PRODUIT
\par }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\insrsid10445119 REF_PDT
\par
\par DESIGN_PDT
\par PU_PDT
\par }}\dpx5208\dpy1\dpxsize1441\dpysize1330\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinew20\dplinecor0\dplinecog0\dplinecob0}}}}{\fs22\insrsid10445119
\par }{\lang1024\langfe1024\noproof\insrsid2238478 {\shp{\*\shpinst\shpleft4488\shptop197\shpright5065\shpbottom630\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz10\shplid1029
{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lTxid}{\sv 262144}}{\sp{\sn dxTextLeft}{\sv 0}}{\sp{\sn dyTextTop}{\sv 0}}{\sp{\sn dxTextRight}{\sv 0}}{\sp{\sn dyTextBottom}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}
{\sp{\sn lineWidth}{\sv 0}}{\sp{\sn fLine}{\sv 0}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\shptxt \pard\plain \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0
\f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 1,1
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8202\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 1,1
\par }}\dpx4488\dpy197\dpxsize577\dpysize433\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinehollow}}}
{\shp{\*\shpinst\shpleft2328\shptop197\shpright3049\shpbottom630\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz9\shplid1030{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn lTxid}{\sv 327680}}{\sp{\sn dxTextLeft}{\sv 0}}{\sp{\sn dyTextTop}{\sv 0}}{\sp{\sn dxTextRight}{\sv 0}}{\sp{\sn dyTextBottom}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}{\sp{\sn lineWidth}{\sv 0}}{\sp{\sn fLine}{\sv 0}}{\sp{\sn fShadow}{\sv 0}}
{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\shptxt \pard\plain \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 1,n
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8201\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 1,n
\par }}\dpx2328\dpy197\dpxsize721\dpysize433\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinehollow}}}
{\shp{\*\shpinst\shpleft3048\shptop183\shpright4489\shpbottom760\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz4\shplid1031{\sp{\sn shapeType}{\sv 3}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fFilled}{\sv 0}}{\sp{\sn lineWidth}{\sv 12700}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8196\dpellipse\dpx3048\dpy183\dpxsize1441\dpysize577
\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinew20\dplinecor0\dplinecog0\dplinecob0}}}}{\fs22\insrsid10445119
\par }{\lang1024\langfe1024\noproof\insrsid2238478 {\shp{\*\shpinst\shpleft5276\shptop21\shpright6061\shpbottom22\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz13\shplid1032
{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lineWidth}{\sv 12700}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8205
\dpline\dpptx0\dppty0\dpptx785\dppty1\dpx5276\dpy21\dpxsize785\dpysize1\dplinew20\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft425\shptop49\shpright1581\shpbottom54\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz17\shplid1033{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 1}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8209\dpline\dpptx1156\dppty0\dpptx0\dppty5\dpx425\dpy49\dpxsize1156\dpysize5\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft4488\shptop221\shpright5209\shpbottom222\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz8\shplid1034{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn lineWidth}{\sv 12700}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8200\dpline\dpptx0\dppty0\dpptx721\dppty1\dpx4488\dpy221\dpxsize721\dpysize1
\dplinew20\dplinecor0\dplinecog0\dplinecob0}}}{\shp{\*\shpinst\shpleft2040\shptop221\shpright3049\shpbottom222\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz7\shplid1035
{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lineWidth}{\sv 12700}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8199
\dpline\dpptx0\dppty0\dpptx1009\dppty1\dpx2040\dpy221\dpxsize1009\dpysize1\dplinew20\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft3192\shptop77\shpright4345\shpbottom366\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz5\shplid1036{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn lTxid}{\sv 393216}}{\sp{\sn dxTextLeft}{\sv 0}}{\sp{\sn dyTextTop}{\sv 0}}{\sp{\sn dxTextRight}{\sv 0}}{\sp{\sn dyTextBottom}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}{\sp{\sn lineWidth}{\sv 0}}{\sp{\sn fLine}{\sv 0}}{\sp{\sn fShadow}{\sv 0}}
{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\shptxt \pard\plain \qc \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 Livrer
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8197\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \qc \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 Livrer
\par }}\dpx3192\dpy77\dpxsize1153\dpysize289\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinehollow}}}}{\fs22\insrsid10445119
\par
\par
\par }{\lang1024\langfe1024\noproof\insrsid2238478 {\shp{\*\shpinst\shpleft4313\shptop29\shpright6041\shpbottom461\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz16\shplid1037
{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 1}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8208\dpline\dpptx1728\dppty0\dpptx0\dppty432
\dpx4313\dpy29\dpxsize1728\dpysize432\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}{\shp{\*\shpinst\shpleft4454\shptop34\shpright5175\shpbottom323\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz12\shplid1038
{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lTxid}{\sv 458752}}{\sp{\sn dxTextLeft}{\sv 0}}{\sp{\sn dyTextTop}{\sv 0}}{\sp{\sn dxTextRight}{\sv 0}}{\sp{\sn dyTextBottom}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}
{\sp{\sn lineWidth}{\sv 0}}{\sp{\sn fLine}{\sv 0}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\shptxt \pard\plain \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0
\f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 1,1
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8204\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 1,1
\par }}\dpx4454\dpy34\dpxsize721\dpysize289\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinehollow}}}}{\fs22\insrsid10445119
\par }{\lang1024\langfe1024\noproof\insrsid2238478 {\shp{\*\shpinst\shpleft2870\shptop216\shpright4167\shpbottom505\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz6\shplid1039
{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lTxid}{\sv 524288}}{\sp{\sn dxTextLeft}{\sv 0}}{\sp{\sn dyTextTop}{\sv 0}}{\sp{\sn dxTextRight}{\sv 0}}{\sp{\sn dyTextBottom}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}
{\sp{\sn lineWidth}{\sv 0}}{\sp{\sn fLine}{\sv 0}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\shptxt \pard\plain \qc \li0\ri0\widctlpar\faauto\rin0\lin0\itap0
\f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 Appartenir
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8198\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \qc \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 Appartenir
\par }}\dpx2870\dpy216\dpxsize1297\dpysize289\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinehollow}}}
{\shp{\*\shpinst\shpleft2582\shptop72\shpright4455\shpbottom649\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz3\shplid1040{\sp{\sn shapeType}{\sv 3}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fFilled}{\sv 0}}{\sp{\sn lineWidth}{\sv 12700}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8195\dpellipse\dpx2582\dpy72\dpxsize1873\dpysize577
\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinew20\dplinecor0\dplinecog0\dplinecob0}}}}{\fs22\insrsid10445119
\par
\par }{\lang1024\langfe1024\noproof\insrsid2238478 {\shp{\*\shpinst\shpleft1862\shptop149\shpright3159\shpbottom438\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz14\shplid1041
{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 1}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lineWidth}{\sv 12700}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8206
\dpline\dpptx1297\dppty0\dpptx0\dppty289\dpx1862\dpy149\dpxsize1297\dpysize289\dplinew20\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft1718\shptop5\shpright2727\shpbottom438\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz11\shplid1042{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn lTxid}{\sv 589824}}{\sp{\sn dxTextLeft}{\sv 0}}{\sp{\sn dyTextTop}{\sv 0}}{\sp{\sn dxTextRight}{\sv 0}}{\sp{\sn dyTextBottom}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}{\sp{\sn lineWidth}{\sv 0}}{\sp{\sn fLine}{\sv 0}}{\sp{\sn fShadow}{\sv 0}}
{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\shptxt \pard\plain \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 1,n
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8203\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 1,n
\par }}\dpx1718\dpy5\dpxsize1009\dpysize433\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinehollow}}}}{\fs22\insrsid10445119
\par }{\lang1024\langfe1024\noproof\insrsid2238478 {\shp{\*\shpinst\shpleft998\shptop187\shpright2439\shpbottom1374\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz2\shplid1043
{\sp{\sn shapeType}{\sv 1}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lTxid}{\sv 655360}}{\sp{\sn dxTextLeft}{\sv 0}}{\sp{\sn dyTextTop}{\sv 0}}{\sp{\sn dxTextRight}{\sv 0}}{\sp{\sn dyTextBottom}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}
{\sp{\sn lineWidth}{\sv 12700}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\shptxt \pard\plain \qc \li0\ri0\widctlpar\brdrb\brdrs\brdrw15\brsp20 \faauto\rin0\lin0\itap0
\f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 FAMILLE
\par }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\insrsid10445119 CODE_FAM
\par
\par NOM_FAM
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8194\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \qc \li0\ri0\widctlpar\brdrb\brdrs\brdrw15\brsp20 \faauto\rin0\lin0\itap0 \f1\fs20\lang1036\langfe1036\cgrid\langnp1036\langfenp1036 {\insrsid10445119 FAMILLE
\par }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\insrsid10445119 CODE_FAM
\par
\par NOM_FAM
\par }}\dpx998\dpy187\dpxsize1441\dpysize1187\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinew20\dplinecor0\dplinecog0\dplinecob0}}}}{\fs22\insrsid10445119
\par
\par }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\lang1024\langfe1024\noproof\insrsid2238478
{\shp{\*\shpinst\shpleft992\shptop229\shpright2288\shpbottom229\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz15\shplid1044{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8207\dpline\dpptx0\dppty0\dpptx1296\dppty0\dpx992\dpy229\dpxsize1296\dpysize0\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}}{
\b\fs24\ul\insrsid10445119
\par
\par
\par }{\b\fs24\insrsid10445119
\par
\par Dictionnaire des donn\'e9es
\par }{\b\insrsid10445119
\par }\trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt
\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30
\cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\b\insrsid10445119 DONN\'c9ES\cell SIGNIFICATION\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {
\b\insrsid10445119 \trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15
\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw30 \clbrdrl
\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\row }\trowd \irow1\irowband1\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr
\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\pard
\ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 NUM_FOUR\cell Num\'e9ro du fournisseur\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow1\irowband1\ts11\trgaph70\trleft-70
\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb
\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368
\row }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 NOM_FOUR\cell Nom du fournisseur\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow2\irowband2
\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15
\clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30
\cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\row }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 RUE_FOUR\cell Adresse rue du fournisseur\cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow3\irowband3\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15
\trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt
\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\row }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 VILLE_FOUR\cell
Adresse ville du fournisseur\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow4\irowband4\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30
\trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\row }\pard
\ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 CP_FOUR\cell Code postal du fournisseur\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow5\irowband5\ts11\trgaph70\trleft-70
\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb
\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368
\row }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 REF_PDT\cell R\'e9f\'e9rence du produit\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow6\irowband6
\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15
\clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30
\cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\row }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 DESIGN_PDT\cell D\'e9signation du produit\cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow7\irowband7\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15
\trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt
\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\row }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 PU_PDT\cell Prix unitaire du produit
\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow8\irowband8\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh
\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649
\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\row }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 CODE_FAM\cell
Code de la famille de produits\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow9\irowband9\ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30
\trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\row
}\trowd \irow10\irowband10\lastrow \ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3
\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw30 \clbrdrr
\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 NOM_FAM\cell Nom de la famille de produits\cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow10\irowband10\lastrow \ts11\trgaph70\trleft-70\trbrdrt\brdrs\brdrw30 \trbrdrl\brdrs\brdrw30 \trbrdrb\brdrs\brdrw30 \trbrdrr\brdrs\brdrw30 \trbrdrh
\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw30 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx4649
\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw30 \clbrdrr\brdrs\brdrw30 \cltxlrtb\clftsWidth3\clwWidth4719\clshdrawnil \cellx9368\row }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\b\insrsid10445119
\par
\par }{\b\fs24\insrsid10445119 Annexe }{\b\fs24\insrsid2238478 2}{\b\fs24\insrsid10445119 : Sch\'e9ma relationnel
\par }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\insrsid10445119
\par }\pard \qj \li708\ri0\widctlpar\faauto\rin0\lin708\itap0 {\insrsid10445119 FOURNISSEUR (NUM_FOUR, NOM_FOUR, RUE_FOUR, VILLE_FOUR, CP_FOUR)
\par
\par PRODUIT (REF_PDT, DESIGN_PDT, PU_PDT, #CODE_FAM, #NUM_FOUR)
\par
\par FAMILLE (CODE_FAM, NOM_FAM)
\par }{\fs22\insrsid10445119
\par }{\fs22\insrsid2238478
\par }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0 {\b\fs24\insrsid7893062 }{\b\fs24\insrsid10445119 Document }{\b\fs24\insrsid2238478 A}{\b\fs24\insrsid10445119 : }{\b\fs22\insrsid10445119 Tableau d\rquote analyse des requ\'eates\tab (\'e0 compl\'e9
ter)
\par }\pard \qj \fi-708\li708\ri0\widctlpar\faauto\rin0\lin708\itap0 {\fs22\insrsid10445119
\par }\trowd \irow0\irowband0\ts11\trgaph71\trleft-71\trbrdrt\brdrs\brdrw15 \trbrdrl\brdrs\brdrw15 \trbrdrb\brdrs\brdrw15 \trbrdrr\brdrs\brdrw15 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15
\trftsWidth3\trwWidth9581\trftsWidthB3\trftsWidthA3\trpaddl71\trpaddr71\trpaddfl3\trpaddfr3\tblrsid2238478 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2056\clshdrawnil \cellx1985\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1487\clshdrawnil \cellx3472\clvertalt\clbrdrt\brdrs\brdrw15
\clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth2098\clshdrawnil \cellx5570\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2098\clshdrawnil \cellx7668\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1842\clshdrawnil \cellx9510\pard
\qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 Formulation de la requ\'eate\cell Table(s) source(s)\cell Crit\'e8re de s\'e9lection\cell Crit\'e8re de jointure\cell Attributs projet\'e9s\cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow0\irowband0\ts11\trgaph71\trleft-71\trbrdrt\brdrs\brdrw15 \trbrdrl\brdrs\brdrw15 \trbrdrb\brdrs\brdrw15 \trbrdrr\brdrs\brdrw15 \trbrdrh\brdrs\brdrw15
\trbrdrv\brdrs\brdrw15 \trftsWidth3\trwWidth9581\trftsWidthB3\trftsWidthA3\trpaddl71\trpaddr71\trpaddfl3\trpaddfr3\tblrsid2238478 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2056\clshdrawnil \cellx1985\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1487\clshdrawnil \cellx3472\clvertalt\clbrdrt\brdrs\brdrw15
\clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth2098\clshdrawnil \cellx5570\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2098\clshdrawnil \cellx7668\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1842\clshdrawnil \cellx9510\row }\pard
\ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 Liste des noms et adresses compl\'e8tes des fournisseurs domicili\'e9s \'e0 Paris\cell \cell \cell \cell \cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow1\irowband1\ts11\trgaph71\trleft-71\trbrdrt\brdrs\brdrw15 \trbrdrl\brdrs\brdrw15 \trbrdrb\brdrs\brdrw15 \trbrdrr\brdrs\brdrw15 \trbrdrh\brdrs\brdrw15
\trbrdrv\brdrs\brdrw15 \trftsWidth3\trwWidth9581\trftsWidthB3\trftsWidthA3\trpaddl71\trpaddr71\trpaddfl3\trpaddfr3\tblrsid2238478 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2056\clshdrawnil \cellx1985\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1487\clshdrawnil \cellx3472\clvertalt\clbrdrt\brdrs\brdrw15
\clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth2098\clshdrawnil \cellx5570\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2098\clshdrawnil \cellx7668\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1842\clshdrawnil \cellx9510\row }\pard
\ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0 {\insrsid10445119 Liste des produits (r\'e9f\'e9rence et d\'e9signation) appartenant \'e0 la famille dont le nom est IRIS\cell \cell \cell \cell \cell }\pard
\ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\insrsid10445119 \trowd \irow2\irowband2\lastrow \ts11\trgaph71\trleft-71\trbrdrt\brdrs\brdrw15 \trbrdrl\brdrs\brdrw15 \trbrdrb\brdrs\brdrw15 \trbrdrr\brdrs\brdrw15 \trbrdrh
\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth3\trwWidth9581\trftsWidthB3\trftsWidthA3\trpaddl71\trpaddr71\trpaddfl3\trpaddfr3\tblrsid2238478 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2056\clshdrawnil \cellx1985\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1487\clshdrawnil \cellx3472\clvertalt\clbrdrt\brdrs\brdrw15
\clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth2098\clshdrawnil \cellx5570\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2098\clshdrawnil \cellx7668\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1842\clshdrawnil \cellx9510\row }\pard
\qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid10445119 {\b\fs24\ul\insrsid10445119 \page }{\b\caps\fs24\insrsid4721918\charrsid4721918 corrige}{\b\caps\fs24\insrsid10445119
\par }{\b\fs22\ul\insrsid4721918
\par }\pard \ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid7893062 {\b\insrsid7893062
\par }{\b\insrsid2238478 EXERCICE 1}{\b\insrsid7893062 : MOD\'c8LE CONCEPTUEL DES DONN\'c9ES.
\par }{\insrsid7893062
\par }{\b\insrsid7893062 Question 1
\par }{\insrsid7893062
\par Le M.C.D. n'est pas juste car les cardinalit\'e9s ont \'e9t\'e9 invers\'e9es !
\par
\par
\par }\trowd \irow0\irowband0\ts11\trgaph70\trleft-70\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw45 \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45
\cltxlrtb\clftsWidth3\clwWidth2622\clshdrawnil \cellx2552\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1062\clshdrawnil \cellx3614\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb
\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth2056\clshdrawnil \cellx5670\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1276\clshdrawnil \cellx6946\clvertalt\clbrdrt
\brdrs\brdrw45 \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2194\clshdrawnil \cellx9140\pard \qc \li0\ri0\sa40\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {
\lang1024\langfe1024\noproof\insrsid7893062 {\shp{\*\shpinst\shpleft3336\shptop300\shpright5926\shpbottom1164\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz25\shplid1052
{\sp{\sn shapeType}{\sv 3}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn fFilled}{\sv 0}}{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8217\dpellipse
\dpx3336\dpy300\dpxsize2590\dpysize864\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr255\dpfillbgcg255\dpfillbgcb255\dpfillpat0\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}}{\b\insrsid7893062 MATI\'c8REPREMI\'c8RE\cell }\pard
\qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\insrsid7893062 \cell \cell \cell FOURNISSEUR\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\b\insrsid7893062 \trowd \irow0\irowband0
\ts11\trgaph70\trleft-70\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw45 \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2622\clshdrawnil \cellx2552
\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1062\clshdrawnil \cellx3614\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone
\cltxlrtb\clftsWidth3\clwWidth2056\clshdrawnil \cellx5670\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1276\clshdrawnil \cellx6946\clvertalt\clbrdrt\brdrs\brdrw45 \clbrdrl\brdrs\brdrw45
\clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2194\clshdrawnil \cellx9140\row }\trowd \irow1\irowband1\lastrow \ts11\trgaph70\trleft-70\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt
\brdrnone \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2622\clshdrawnil \cellx2552\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone
\cltxlrtb\clftsWidth3\clwWidth1062\clshdrawnil \cellx3614\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth2056\clshdrawnil \cellx5670\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb
\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1276\clshdrawnil \cellx6946\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2194\clshdrawnil \cellx9140\pard
\qc \li0\ri0\sa40\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\lang1024\langfe1024\noproof\insrsid7893062
{\shp{\*\shpinst\shpleft2528\shptop377\shpright3335\shpbottom383\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz27\shplid1054{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8219\dpline\dpptx0\dppty0\dpptx807\dppty6\dpx2528\dpy377\dpxsize807\dpysize6\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft5926\shptop377\shpright6925\shpbottom383\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz26\shplid1053{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 1}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8218\dpline\dpptx999\dppty0\dpptx0\dppty6\dpx5926\dpy377\dpxsize999\dpysize6\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft7456\shptop321\shpright8962\shpbottom323\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz24\shplid1051{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8216\dpline\dpptx0\dppty0\dpptx1506\dppty2\dpx7456\dpy321\dpxsize1506\dpysize2\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}
{\shp{\*\shpinst\shpleft428\shptop293\shpright2157\shpbottom294\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz23\shplid1050{\sp{\sn shapeType}{\sv 20}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}
{\sp{\sn fShadow}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}{\sp{\sn fLayoutInCell}{\sv 0}}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8215\dpline\dpptx0\dppty0\dpptx1729\dppty1\dpx428\dpy293\dpxsize1729\dpysize1\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}}{
\b\insrsid7893062 CODE_MAT_PREM
\par
\par NOM_MAT_PREM\cell }\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\insrsid7893062 1,n\cell
\par LIVRER\cell 1,1\cell NUM_FOUR
\par
\par NOM_FOUR\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\b\insrsid7893062 \trowd \irow1\irowband1\lastrow \ts11\trgaph70\trleft-70\trftsWidth1\trpaddl70\trpaddr70\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt
\clbrdrt\brdrnone \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2622\clshdrawnil \cellx2552\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone
\cltxlrtb\clftsWidth3\clwWidth1062\clshdrawnil \cellx3614\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth2056\clshdrawnil \cellx5670\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrnone \clbrdrb
\brdrnone \clbrdrr\brdrnone \cltxlrtb\clftsWidth3\clwWidth1276\clshdrawnil \cellx6946\clvertalt\clbrdrt\brdrnone \clbrdrl\brdrs\brdrw45 \clbrdrb\brdrs\brdrw45 \clbrdrr\brdrs\brdrw45 \cltxlrtb\clftsWidth3\clwWidth2194\clshdrawnil \cellx9140\row }\pard
\ql \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid7893062 {\insrsid7893062
\par
\par }{\b\insrsid7893062 Question 2
\par }{\insrsid7893062
\par }\pard \ql \li0\ri0\widctlpar\tx567\faauto\rin0\lin0\itap0\pararsid7893062 {\insrsid7893062 L'identifiant de l'entit\'e9 MATI\'c8REPREMI\'c8RE est }{\b\insrsid7893062 CODE_MAT_PREM}{\insrsid7893062 .
\par L'identifiant de l'entit\'e9 FOURNISSEUR est }{\b\insrsid7893062 NUM_FOUR.
\par }{\insrsid7893062
\par
\par }{\b\insrsid7893062 Question 3
\par }{\insrsid7893062
\par }\pard \qj \li0\ri0\widctlpar\tx567\faauto\rin0\lin0\itap0\pararsid7893062 {\insrsid7893062 La propri\'e9t\'e9 }{\b\insrsid7893062 NOM_FOUR}{\insrsid7893062 ne peut \'eatre utilis\'e9e comme identifiant de l'entit\'e9
FOURNISSEUR car l'identifiant d'une entit\'e9 est la propri\'e9t\'e9 qui permet de rep\'e9rer de fa\'e7on s\'fbre et certaine les individus. Or, deux fournisseurs peuvent avoir le m\'eame nom !
\par }\pard \ql \li0\ri0\widctlpar\tx567\faauto\rin0\lin0\itap0\pararsid12678181 {\insrsid12678181
\par }{\insrsid2238478
\par }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid2238478 {\b\insrsid2238478 EXERCICE 2 : GESTION D\rquote UNE BASE DE DONN\'c9ES
\par }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid12678181 {\b\fs22\insrsid12678181
\par Question 1
\par }{\b\fs24\insrsid12678181
\par }\pard \qj \li708\ri0\widctlpar\faauto\rin0\lin708\itap0\pararsid12678181 {\fs22\insrsid12678181 Un produit appartient \'e0 une et une seule famille.
\par Une famille contient au moins un produit.
\par }\pard \qj \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid12678181 {\b\fs24\insrsid12678181
\par
\par }{\b\fs22\insrsid12678181 Question 2}{\b\fs24\insrsid12678181
\par
\par }{\b\fs22\insrsid12678181 Document }{\b\fs22\insrsid2238478 A}{\b\fs22\insrsid12678181
\par
\par }\pard \qc \li0\ri0\widctlpar\faauto\rin0\lin0\itap0\pararsid12678181 {\b\fs22\insrsid12678181 Tableau d\rquote analyse des requ\'eates
\par }\trowd \irow0\irowband0\ts11\trgaph71\trleft-71\trbrdrt\brdrs\brdrw15 \trbrdrl\brdrs\brdrw15 \trbrdrb\brdrs\brdrw15 \trbrdrr\brdrs\brdrw15 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl71\trpaddr71\trpaddfl3\trpaddfr3\tblrsid7551823
\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1842\clshdrawnil \cellx1771\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr
\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1490\clshdrawnil \cellx3261\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth2551\clshdrawnil \cellx5812\clvertalt\clbrdrt
\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth2268\clshdrawnil \cellx8080\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth1418\clshdrawnil \cellx9498\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\fs22\insrsid12678181 Formulation de la requ\'eate\cell Table(s) source(s)\cell Crit\'e8re de s\'e9lection\cell Crit\'e8
re de jointure\cell Attributs projet\'e9s\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\fs22\insrsid12678181 \trowd \irow0\irowband0\ts11\trgaph71\trleft-71\trbrdrt\brdrs\brdrw15 \trbrdrl\brdrs\brdrw15 \trbrdrb
\brdrs\brdrw15 \trbrdrr\brdrs\brdrw15 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl71\trpaddr71\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth1842\clshdrawnil \cellx1771\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1490\clshdrawnil \cellx3261\clvertalt\clbrdrt\brdrs\brdrw15
\clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth2551\clshdrawnil \cellx5812\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2268\clshdrawnil \cellx8080\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1418\clshdrawnil \cellx9498\row }\pard
\ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\fs22\insrsid12678181 Liste des noms et adresses compl\'e8tes des fournisseurs domicili\'e9s \'e0 Paris\cell }\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {
\b\fs18\insrsid12678181
\par
\par
\par FOURNISSEUR\cell }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\fs18\insrsid12678181
\par
\par
\par }\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\fs18\insrsid12678181 VILLE_FOUR= PARIS
\par }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\fs18\insrsid12678181 \cell \cell }{\b\fs18\lang2057\langfe1036\langnp2057\insrsid12678181\charrsid4721918
\par NOM_FOUR
\par RUE_FOUR
\par VILLE_FOUR
\par }{\b\fs18\insrsid12678181 CP_FOUR
\par
\par \cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\fs22\insrsid12678181 \trowd \irow1\irowband1\ts11\trgaph71\trleft-71\trbrdrt\brdrs\brdrw15 \trbrdrl\brdrs\brdrw15 \trbrdrb\brdrs\brdrw15 \trbrdrr\brdrs\brdrw15
\trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl71\trpaddr71\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth1842\clshdrawnil \cellx1771\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1490\clshdrawnil \cellx3261\clvertalt\clbrdrt\brdrs\brdrw15
\clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth2551\clshdrawnil \cellx5812\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2268\clshdrawnil \cellx8080\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1418\clshdrawnil \cellx9498\row }\pard
\ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\fs22\insrsid12678181 Liste des produits (r\'e9f\'e9rence et d\'e9signation) appartenant \'e0 la famille dont le nom est IRIS\cell }\pard
\qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\fs18\insrsid12678181
\par
\par PRODUIT
\par
\par
\par FAMILLE\cell }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\fs18\insrsid12678181
\par
\par
\par
\par
\par }\pard \qc \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\fs18\insrsid12678181 NOM_FAM = IRIS)\cell }\pard \ql \li0\ri0\widctlpar\intbl\faauto\rin0\lin0\pararsid7551823 {\b\fs18\insrsid12678181
\par
\par
\par PRODUIT.CODE_FAM =
\par FAMILLE.CODE_FAM \cell
\par
\par REF_PDT
\par DESIGN_PDT\cell }\pard \ql \li0\ri0\widctlpar\intbl\aspalpha\aspnum\faauto\adjustright\rin0\lin0 {\fs22\insrsid12678181 \trowd \irow2\irowband2\lastrow \ts11\trgaph71\trleft-71\trbrdrt\brdrs\brdrw15 \trbrdrl\brdrs\brdrw15 \trbrdrb\brdrs\brdrw15 \trbrdrr
\brdrs\brdrw15 \trbrdrh\brdrs\brdrw15 \trbrdrv\brdrs\brdrw15 \trftsWidth1\trpaddl71\trpaddr71\trpaddfl3\trpaddfr3\tblrsid7551823 \clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth1842\clshdrawnil \cellx1771\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1490\clshdrawnil \cellx3261\clvertalt\clbrdrt\brdrs\brdrw15
\clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth2551\clshdrawnil \cellx5812\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15
\cltxlrtb\clftsWidth3\clwWidth2268\clshdrawnil \cellx8080\clvertalt\clbrdrt\brdrs\brdrw15 \clbrdrl\brdrs\brdrw15 \clbrdrb\brdrs\brdrw15 \clbrdrr\brdrs\brdrw15 \cltxlrtb\clftsWidth3\clwWidth1418\clshdrawnil \cellx9498\row }\pard \ql \li0\ri0\widctlpar
\tx567\faauto\rin0\lin0\itap0\pararsid12678181 {\insrsid12678181
\par }}
