PowerDesigner實(shí)體基數(shù)關(guān)系與數(shù)據(jù)表生成

11、非依賴性一對(duì)多關(guān)系(Independentone-to-manyrelationships)在非依賴性關(guān)系中，”一”端的實(shí)體主標(biāo)識(shí)符將轉(zhuǎn)化為：關(guān)系中”一(one)”端的實(shí)體生成的表的主鍵(Primarykey)關(guān)系中”多(many)”端的實(shí)體生成的表的外鍵(Foreignkey)。CDM中Independentone-to-manyrelationshiptF^iunnCdluinnn泄1HumiiiMBTOODaicripUflinWMBTfiOO甲則時(shí)?Tim?ETtF^iunnCdluinnn泄1HumiiiMBTOODaicripUflinWMBTfiOO甲則時(shí)?Tim?ET-CM>MrtMtbUbil4M>i<M)丁神祁呻站i<M>-ToUlPocIi：1酬創(chuàng)駅敘"爐前||口1VMBT2WM酬稅祝紡爐刖山■燒DT-CM>"APwfTlflii!LtslfttplyfimtNillEEndftdICLtCMHIrTcpPeirntIdtnMftM<poPartVMM啊IHfMBTICtfMBTJWBLSt即LBl!|Bl生成的PDM中的Independentone-to-manyrelationshipGeIu稻頁(yè)uii"uWBplBiM1■忒GeIu稻頁(yè)uii"uWBplBiM1■忒nvirchsr|3Q|Dl■如時(shí)?nWlittiirlSOO]U^slattfiime$m?iibd?q■耳imuhAw-kll-tbl*bktSvrtOndtrin4IrtiiU^picliMTHbIPecbhnAMaitfi.istRtPe-rtDl*FWtnvircliirlSWIMaihR?<tn+P字旳0jif?iFoi^mG^lumfi<FIPEMBfliniBigXI0ColumnlDInid)i訕rm電L?*RtpPyTFi*i<良?■加■蚩mId$Rt-adN^JfHInijgUttiNtminvjpch4if4-Q|LtfiR?pljUi?dDIMWilKhJf^OlTMtIcEnd?dbrll?LtEk4d訓(xùn)HlopbllIsFnmebliPaintirill||LYall4bl?bilQLUM512、依賴性一對(duì)多關(guān)系(Dependentone-to-manyrelationships)在依賴性關(guān)系中，被依賴端的主標(biāo)識(shí)符轉(zhuǎn)化為主鍵，依賴端則產(chǎn)生一個(gè)與被依賴端主標(biāo)識(shí)符同名稱的字段，同時(shí)作為依賴端的主鍵和外鍵，如果依賴端實(shí)體中已經(jīng)存在主標(biāo)識(shí)符轉(zhuǎn)化為主鍵，則該鍵同主鍵共同組成主鍵，同時(shí)作為外鍵。

L^AcliwilyDTH"L^AcliwilyDTH"朋1坐^MBT40VMEITM<*t*NickN?mtUMBT50-BLEffliilWMBTS5DF#ceWMBT?WEnnoneyl|l<M>ScqrtIIDieditIIIdNOLtv*?Up1□pd血TimeDTBLPklB_Ulf*i<ipi>1^.0.nnrhip1JJ!生成的PDM中的Dependentone-to-manyrelationshipIn!亡NLIRELSITICPaimoislNKkH-ime￡?EmiiilFk*Emon嚇Snn5前NLIRELSITICPaimoislNKkH-ime￡?EmiiilFk*Emon嚇Snn5前UpdfttTim*umiiMitii|fidlleiirnicbit3、非依賴性多對(duì)多關(guān)系(Independentmany-to-manyrelationships)在非依賴性多對(duì)多關(guān)系中，各實(shí)體的主標(biāo)識(shí)符(Primarykey)遷移至一個(gè)新生成的連接表中都作為外鍵，同時(shí)共同組成這個(gè)新連接表的主鍵，各實(shí)體的主標(biāo)識(shí)符也轉(zhuǎn)化為其所生成表的主鍵(Primarykey)。下圖所示CDM,每個(gè)雇員可以是一個(gè)或多個(gè)團(tuán)隊(duì)的成員，同時(shí)每個(gè)團(tuán)隊(duì)也可能包含一個(gè)或多個(gè)的雇員。CDM中Independentmany-to-manyrelationships生成的PDM中的Independentmany-to-manyrelationships44非依賴性一對(duì)一關(guān)系(Independentone-to-onerelationships)在非依賴性一對(duì)一關(guān)系中，如果沒(méi)有定義支配角色(Dominantrole)的方向,則各實(shí)體的主標(biāo)識(shí)符均自動(dòng)遷移轉(zhuǎn)化為另一實(shí)體生成的表的外鍵。TeamEitip1oyeeID<pi>Inteqer<M>ENarritjLongcharactersDatt!DateEID<pi>Integer<hj1>ENameLongcharactersSalaryMoney(8,2)ldentifier_1<pi>ldentifier_1<pi>Team#IDIntegeroEIDInttFeroENaitiaLongcharactersioDateDate-精山1==(K=1Employee#EIDIntegeroIDluteoENameLongcharactersoSalaryMoney(8,2)在非依賴性一對(duì)一關(guān)系中，如果定義了支配角色(Dominantrole)的方向，如Team>Emplyee,則主(支配)實(shí)體的主鍵轉(zhuǎn)化為從(被支配)主體的外鍵TeamID?=：口i：=?1「止已口已『?=：FdnENamaLongchararteisDateDateldentifier_1<pi>Emp