Generate CDM, PDM, and SQL using PowerDesigner

Source: Internet
Author: User
Tags sql using powerdesigner


1, Personnel organization structure

Entity Note
Organization (ID, name)

Department (ID, name) A body has multiple departments
Person (ID, name) A person belongs to a department, and there are multiple people under one department.
Leadership Leadership is also a person
Role (ID, name) A role can correspond to multiple people, one person has multiple roles
Permissions (ID, name) A role can have multiple permissions, and one permission corresponds to multiple roles


2. Conceptual model

New conceptual model

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/4E/wKiom1e7t8LTL8RRAAA9Kjc_geI673.png "title=" 001. PNG "alt=" Wkiom1e7t8ltl8rraaa9kjc_gei673.png "/>


650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/4D/wKioL1e7uB7Qkh55AADnaWvAC3g875.png "title=" 002. PNG "alt=" Wkiol1e7ub7qkh55aadnawvac3g875.png "/>


650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/86/4D/wKioL1e7uHfz0UJbAACbMJ1Kr8M793.png "title=" 003. PNG "alt=" Wkiol1e7uhfz0ujbaacbmj1kr8m793.png "/>


2.1. Institutions

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/86/4E/wKiom1e7uXuQeF0uAAA3Iyq-grg461.png "title=" 004. PNG "alt=" Wkiom1e7uxuqef0uaaa3iyq-grg461.png "/>


650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/86/51/wKiom1e76oLgT_DtAABiF_HOcYo095.png "title=" 005. PNG "alt=" Wkiom1e76olgt_dtaabif_hocyo095.png "/>


650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/50/wKioL1e76pPy0UjIAABfmpZdOvk116.png "title=" 006. PNG "alt=" Wkiol1e76ppy0ujiaabfmpzdovk116.png "/>



2.2. Department


650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/51/wKiom1e76sPQhdGAAAA3UENuGLQ686.png "title=" 007. PNG "alt=" Wkiom1e76spqhdgaaaa3uenuglq686.png "/>


650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/86/51/wKiom1e76tfC_vyfAABXq3vlhss631.png "title=" 008. PNG "alt=" Wkiom1e76tfc_vyfaabxq3vlhss631.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/86/50/wKioL1e76ujhcyeBAABnS5aIcgo428.png "title=" 009. PNG "alt=" Wkiol1e76ujhcyebaabns5aicgo428.png "/>


2.3. Personnel


650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/86/51/wKiom1e76xfTHPYFAAAvgPO5eXs828.png "title=" 010. PNG "alt=" Wkiom1e76xfthpyfaaavgpo5exs828.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/86/50/wKioL1e76yWi_iN0AABWmZ7mJLw566.png "title=" 011. PNG "alt=" Wkiol1e76ywi_in0aabwmz7mjlw566.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/86/51/wKiom1e76zSCyWn4AACAOAKh-GE110.png "title=" 012. PNG "alt=" Wkiom1e76zscywn4aacaoakh-ge110.png "/>


2.4. Leadership


650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/51/wKiom1e764Xz28Z4AAAvvcQllXw934.png "title=" 013. PNG "alt=" Wkiom1e764xz28z4aaavvcqllxw934.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/86/50/wKioL1e765XRtsg-AABUDmUyVrI706.png "title=" 014. PNG "alt=" Wkiol1e765xrtsg-aabudmuyvri706.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/86/50/wKioL1e766byo5ERAAB67ZQDrDo688.png "title=" 015. PNG "alt=" Wkiol1e766byo5eraab67zqdrdo688.png "/>


2.5. Role


650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/86/50/wKioL1e76-bzbNnXAAAujTaotZc168.png "title=" 016. PNG "alt=" Wkiol1e76-bzbnnxaaaujtaotzc168.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/86/51/wKiom1e76_Sgpa1_AABWprXRnVs099.png "title=" 017. PNG "alt=" Wkiom1e76_sgpa1_aabwprxrnvs099.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/50/wKioL1e77AOSd7PlAACTsC4zyRM239.png "title=" 018. PNG "alt=" Wkiol1e77aosd7plaactsc4zyrm239.png "/>


2.6. Permissions



650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/51/wKiom1e77D6R-D41AAAyMhTIxI4737.png "style=" float: none; "title=" 019.PNG "alt=" Wkiom1e77d6r-d41aaaymhtixi4737.png "/>


650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/86/51/wKioL1e77D2yyT7ZAABZE4l-4UA507.png "Title=" 020. PNG "style=" Float:none; "alt=" Wkiol1e77d2yyt7zaabze4l-4ua507.png "/>


650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/86/51/wKiom1e77D3THEEZAACTz_viMRM222.png "title=" 021. PNG "style=" Float:none; "alt=" Wkiom1e77d3theezaactz_vimrm222.png "/>


2.7. Institutional-Departmental relations



650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/86/51/wKiom1e77NrxY9UpAACaiuLHNP0157.png "style=" float: none; "title=" 022.PNG "alt=" Wkiom1e77nrxy9upaacaiulhnp0157.png "/>


650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/51/wKioL1e77NriDKTJAABX2GGhlQ0742.png "title=" 023. PNG "style=" Float:none; "alt=" Wkiol1e77nridktjaabx2gghlq0742.png "/>


650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/86/51/wKiom1e77NnAPl7RAABR7L0GzX0483.png "title=" 024. PNG "style=" Float:none; "alt=" Wkiom1e77nnapl7raabr7l0gzx0483.png "/>


650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/86/51/wKioL1e77NmziyCPAACQ3ctvDvY799.png "title=" 025. PNG "style=" Float:none; "alt=" Wkiol1e77nmziycpaacq3ctvdvy799.png "/>


2.8. Department-Personnel Relations


650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/51/wKioL1e77VqS-qN_AACS852xPac568.png "style=" float: none; "title=" 026.PNG "alt=" Wkiol1e77vqs-qn_aacs852xpac568.png "/>


650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/52/wKiom1e77VrxjzUHAABWCvD5rco485.png "title=" 027. PNG "style=" Float:none; "alt=" Wkiom1e77vrxjzuhaabwcvd5rco485.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/51/wKioL1e77Vmj8lg4AABPum3n66U156.png "title=" 028. PNG "style=" Float:none; "alt=" Wkiol1e77vmj8lg4aabpum3n66u156.png "/>



650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/52/wKiom1e77VmxsU0cAACUdFi11CA018.png "title=" 029. PNG "style=" Float:none; "alt=" Wkiom1e77vmxsu0caacudfi11ca018.png "/>

2.9. Personnel-Leadership relationship


650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/86/51/wKioL1e77dbyCLrbAACWp7VYGKk819.png "style=" float: none; "title=" 030.PNG "alt=" Wkiol1e77dbyclrbaacwp7vygkk819.png "/>


650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/86/52/wKiom1e77dayZr0kAAA14GTVlr0016.png "title=" 031. PNG "style=" Float:none; "alt=" Wkiom1e77dayzr0kaaa14gtvlr0016.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/51/wKioL1e77dXwRlgYAABL6a4gjos496.png "title=" 032. PNG "style=" Float:none; "alt=" Wkiol1e77dxwrlgyaabl6a4gjos496.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/52/wKiom1e77dXB3LaCAACXFidiVVg238.png "title=" 033. PNG "style=" Float:none; "alt=" Wkiom1e77dxb3lacaacxfidivvg238.png "/>


2.10. Personnel-Role relationship


650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/51/wKioL1e77mGQD107AACzVgS7-mM617.png "style=" float: none; "title=" 034.PNG "alt=" Wkiol1e77mgqd107aaczvgs7-mm617.png "/>


650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/86/52/wKiom1e77mCBXpCLAAAvtw4vhqU996.png "title=" 035. PNG "style=" Float:none; "alt=" Wkiom1e77mcbxpclaaavtw4vhqu996.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/86/51/wKioL1e77mCjoLe7AABSP2u6R88854.png "title=" 036. PNG "style=" Float:none; "alt=" Wkiol1e77mcjole7aabsp2u6r88854.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/86/52/wKiom1e77mDiW0PxAAC2GPiuBro633.png "title=" 037. PNG "style=" Float:none; "alt=" Wkiom1e77mdiw0pxaac2gpiubro633.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/86/52/wKiom1e77tvCCm4IAABEcGmRg4c166.png "title=" 038. PNG "alt=" Wkiom1e77tvccm4iaabecgmrg4c166.png "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/86/52/wKiom1e77unwk_CNAABGb_1hD3M040.png "title=" 039. PNG "alt=" Wkiom1e77unwk_cnaabgb_1hd3m040.png "/>


2.11. Role-Permission relationship


650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/86/52/wKioL1e77vaB_FhbAAC6L3yqM1E410.png "title=" 040. PNG "alt=" Wkiol1e77vab_fhbaac6l3yqm1e410.png "/>



650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/86/52/wKioL1e771uD3nOsAABSV3Bzo20300.png "style=" float: none; "title=" 041.PNG "alt=" Wkiol1e771ud3nosaabsv3bzo20300.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/86/53/wKiom1e771uQkmKVAABLYT-0hnc007.png "title=" 042. PNG "style=" Float:none; "alt=" Wkiom1e771uqkmkvaablyt-0hnc007.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/52/wKioL1e771rwpAlaAAC61XLH2ag927.png "title=" 043. PNG "style=" Float:none; "alt=" Wkiol1e771rwpalaaac61xlh2ag927.png "/>


3. Physical model

Generate a physical model

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/53/wKiom1e78B_whKRdAABXwHpxrD0282.png "style=" float: none; "title=" 044.PNG "alt=" Wkiom1e78b_whkrdaabxwhpxrd0282.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/53/wKiom1e78B_Rp_6FAABDq5v6jCM919.png "title=" 045. PNG "style=" Float:none; "alt=" Wkiom1e78b_rp_6faabdq5v6jcm919.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/52/wKioL1e78B7Ty8-1AAAhZ0OD4ls928.png "title=" 046. PNG "style=" Float:none; "alt=" Wkiol1e78b7ty8-1aaahz0od4ls928.png "/>

The physical model generated by the conceptual model :

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/86/53/wKiom1e78B6hHY_uAAC7PhI6Rmw248.png "title=" 047. PNG "style=" Float:none; "alt=" Wkiom1e78b6hhy_uaac7phi6rmw248.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/53/wKiom1e78JXx52DsAAB2CqOvdkY983.png "title=" 048. PNG "alt=" Wkiom1e78jxx52dsaab2cqovdky983.png "/>


4. Generate SQL


650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/86/53/wKiom1e78L7wcXXwAAA8-Ihq3rU511.png "style=" float: none; "title=" 049.PNG "alt=" Wkiom1e78l7wcxxwaaa8-ihq3ru511.png "/>


650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/52/wKioL1e78L2wfvnGAABFJEC1EwI130.png "title=" 050. PNG "style=" Float:none; "alt=" Wkiol1e78l2wfvngaabfjec1ewi130.png "/>



Generate CDM, PDM, and SQL using PowerDesigner

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.