PowerDesignerå¿«éçå建åºæ°æ®åº
1.使ç¨PowerDesignerå建æ°æ®åº,é¦å è¿è¡ç¨åº,è¿å ¥ä¸»çé¢:
2.FileâNew ModelâPhysical Data ModelâPhysical DiagramâModel name 设置为test,DBMSå±æ§è®¾ç½®ä¸ºMicrosoft SQL Server 2005:
3.é¦å ç¨è¡¨æ ¼å·¥å ·å建ä¸ä¸ªè¡¨æ ¼æ¨¡æ¿:
4.åå»è¡¨æ ¼æ¨¡æ¿,设置å±æ§,æ们é¦å 设置Major表:
5.设置好表å,ç¹å»Columnsæ ç¾,设置å段å±æ§,设置å¦å¾æ示:
6.å 为MajorIDå段æ们è¦è®¾ç½®ä¸ºèªå¨å¢é¿,æ以è¦è®¾ç½®å®çé«çº§å±æ§,éæ©MajorIDå段,ç¹å»å±æ§æé®,å¨Generalé¢æ¿ä¸å¾éä¸Identityå¤éæ¡:
7.ç¡®å®ååå建ä¸ä¸ªStudent表,å段设置å¦å¾æ示:
8.æ¥çæ¯ä¸ºStudentå建ä¸ä¸ªMajorIDå¤é®,使ç¨PowerDesignerå¯ä»¥å¾è½»æ¾çå®æè¿ä¸ªå·¥ä½,éæ©å ³ç³»è®¾ç½®å·¥å ·,å¨Student表ä¸æä½å·¦é®ä¸æ¾,ææ½è³Major表,便å¯ä¸ºStudent表添å ä¸ä¸ªMajorIDçå¤é®:
9.ç°å¨æµè¯è¡¨å·²ç»è®¾ç½®å¥½äº,æ¥ç设置ä¸ä¸è¦çæçæ°æ®åº,è¿äºè¡¨é½å°è¢«å建å°è¯¥æ°æ®åºä¸,å¨è®¾è®¡é¢æ¿ç©ºç½å¤å³é®âProperties,å¨å¼¹åºçå±æ§è®¾ç½®å¯¹è¯æ¡è®¾ç½®å¦ä¸:
10.å¨æ¤å¯¹æ°æ°æ®åºç设置已ç»å®æ,ä½æ¯å¨SQLä¸è¿æ¯ç©ºç©ºå¦ä¹,æä¹æè¿è¾¹è®¾è®¡å¥½çç»æ移æ¤å°SQLServer 2005ä¸å¢?
æ§è¡æä½:DatabaseâGenerate Database,设置好åå¨è¿ç¨å¯¼åºç®å½åæ件å,ç¹å»ç¡®å®å³å¯:
11.å°å¯¼åºç®å½,å°±å¯ä»¥çè§å¯¼åºçæ°æ®åºå建åå¨è¿ç¨äº,æå¼SQL,æ§è¡ä¸ä¸,å°±ä¼çå°æ°æ®åºè¢«å建好äº: