30åã§ãããERå³ã®æ¸ãæ¹ (1)
ER図生成ツールã®ä½ææã«ERå³ã®æ¸ãæ¹ã調ã¹ãã®ã§ãããã£ãäºãã¾ã¨ãã¾ããè¨äºæ°ã¯10ãããã«ãªãäºå®ã§ãã*1
ããã¾ã§ãERå³ã®è¡¨è¨æ¹æ³ã«ã¤ãã¦ã®èª¬æã§ããããã¼ã¿ã¢ããªã³ã°ãDBè¨è¨ã«é¢ãã説æã¯å«ã¿ã¾ããããã®ãããªæ å ±ã欲ããæ¹ã¯ãå¥ã®ãµã¤ããæ¸ç±ãåèã«ãã¦ãã ãããã¾ããERå³ã®è¡¨è¨æ³ã¯ãIEå½¢å¼ã¨IDEF1Xå½¢å¼ãã¡ã¤ã³ã«ãã¾ãã
ãªãããã®ãã¼ã¸ã¯ç§ã®å人çãªç解ã«åºã¥ãã¦è¨è¿°ãã¦ãã¾ãã®ã§ãç´°ããé¨åã§ééããããããããã¾ããã
åå: -
次å: id:simply-k:20100704:1278214995
ç®æ¬¡: id:simply-k:20100716:1279237959
ERã¢ãã«
ERã¢ãã«(Entity Relationship Model)*2ã¯ãæ¦å¿µãã¼ã¿ã¢ãã«ã®ä¸ç¨®ã§ãã1976å¹´ã«ãã¼ã¿ã¼ã»ãã§ã³(Peter Chen)å士ã«ãã£ã¦ææ¡ããã¾ãããERã¢ãã«ã§ã¯ãã¢ãã«å対象ã®ä¸çãã¨ã³ãã£ãã£(entity)*3ã¨ãªã¬ã¼ã·ã§ã³ã·ãã(relationship)*4ã§è¡¨ç¾ãã¾ãã
- ã¨ã³ãã£ãã£*5
- åããããªç¹å¾´ãæã£ãç©äºãã²ã¨ã¾ã¨ãã«ãããã®ãã·ã¹ãã ã®ä¸ã§ã¯ããã¼ã¿ã¨ãã¦è¡¨ç¾ããã¾ãã
- ãªã¬ã¼ã·ã§ã³ã·ãã
- ã¨ã³ãã£ãã£ã¨ã¨ã³ãã£ãã£ã®é¢é£æ§ã表ç¾ãããã®ãã·ã¹ãã ã®ä¸ã§ã¯ããã¼ã¿éã®ã«ã¼ã«ã¨ãã¦è¡¨ç¾ããã¾ãã
ã¨ã³ãã£ãã£ã¯ã¤ã³ã¹ã¿ã³ã¹ãæã¡ã¾ãã*6 ä¾ãã°ãã社å¡ãã¨ã³ãã£ãã£ã«å¯¾ãã社å¡ã®ãAãããããBãããã¯ã¤ã³ã¹ã¿ã³ã¹ã«ãªãã¾ããã¾ããã¨ã³ãã£ãã£ã¨ãªã¬ã¼ã·ã§ã³ã·ããã¯ãå±æ§(attribute)ã«ãã£ã¦ç¹å¾´ã¥ãããã¾ãã
ã¨ã³ãã£ãã£ã¨ãªã¬ã¼ã·ã§ã³ã·ãããRDBMSãåæã«ãã¦èª¬æããã¨ã次ã®ããã«ãªãã¾ãã
- ã¨ã³ãã£ãã£
- ãã¼ãã«ããã¥ã¼ã§è¡¨ç¾ããããã®ã
- ãªã¬ã¼ã·ã§ã³ã·ãã
- å¤é¨ãã¼å¶ç´ã§è¡¨ç¾ããããã®ã*7
ERå³
ERå³(Entity Relationship Diagram)*8ã¯ãå ã ã¯ERã¢ãã«ã表è¨ããããã®å³ã§ããããããããªã¬ã¼ã·ã§ãã«ã»ãã¼ã¿ãã¼ã¹ã¨ã®ç¸æ§ãè¯ããã¨ãããRDBMSãåæã¨ãããã¼ã¿ã¢ãã«ã®è¡¨è¨ã«ã使ç¨ãããããã«ãªãã¾ããããã®éãIEå½¢å¼ãIDEF1Xå½¢å¼ã¨ãã£ãããªãªã¸ãã«ã¨ã¯å¥ã®è¡¨è¨æ³ãããã¤ãèæ¡ãããç¾å¨ã«è³ã£ã¦ãã¾ãã
ãã¼ã¿ã¼ã»ãã§ã³ã®è¡¨è¨æ³
å®éã®ã·ã¹ãã éçºã§ã¯ãã»ã¨ãã©ä½¿ããã¾ãããããã§ã¯æ¦ç¥ã ã説æãã¾ãã次ã®å³ã¯ããã¼ã¿ã¼ã»ãã§ã³ã®è¡¨è¨æ³ã«ããERå³ã®ä¸ä¾ã§ãã
- é·æ¹å½¢
- ã¨ã³ãã£ãã£
- è±å½¢
- ãªã¬ã¼ã·ã§ã³ã·ãã
- æ¥å
- ã¨ã³ãã£ãã£ã¾ãã¯ãªã¬ã¼ã·ã§ã³ã·ããã®å±æ§ (ä¸ç·ãå¼ããã¦ããã®ã¯ä¸»ãã¼)
ä»ã«ã表è¨ã«ã¼ã«ã¯ããã®ã§ããçç¥ãã¾ãã
次åããã¯ãå®éã®ã·ã¹ãã éçºã§ãã使ããããIEå½¢å¼ãIDEF1Xå½¢å¼ã®èª¬æã«å
¥ãã¾ãã
åå: -
次å: id:simply-k:20100704:1278214995
ç®æ¬¡: id:simply-k:20100716:1279237959
*1:1è¨äº3åÃ10åã§30åã«ãã¾ããã
*2:ERMã¨ãå®ä½é¢é£ã¢ãã«ã¨ãå¼ã°ãã¾ãã
*3:ãå®ä½ãã¨ãå¼ã°ãã¾ã
*4:ãé¢é£ãã¨ãå¼ã°ãã¾ãããªãããªã¬ã¼ã·ã§ã³ã¨çç¥ããã®ã¯ããã¾ããããæå³ãå¤ãã£ã¦ãã¾ãã¾ãã
*5:å³å¯ã«ã¯ã¨ã³ãã£ãã£ã»ã¿ã¤ãã¨å¼ã¶ã¹ãã§ãããä¸è¬çã«ã¨ã³ãã£ãã£ã¨ãã£ããã¨ã³ãã£ãã£ã»ã¿ã¤ããªã®ã§ãããã§ãã¨ã³ãã£ãã£ã¨å¼ã³ã¾ãã
*6:ãã¨ã³ãã£ãã£â(ããã°ã©ãã³ã°è¨èªã®)ãã¼ã¿åãã¨ãã£ãæãã§ãã
*7:å ´åã«ãã£ã¦ã¯ä»ã®å¶ç´ãããªã¬ã¼ãã¢ããªã±ã¼ã·ã§ã³ã®å¦çã§è¡¨ç¾ããã¾ããã¾ããå¤å¯¾å¤ã®ãªã¬ã¼ã·ã§ã³ã·ããã®å ´åã¯ãã¼ãã«ã対å¿ãã¾ãã
*8:ERDã¨ãå®ä½é¢é£å³ã¨ãå¼ã°ãã¾ãã