UMLã§è¡¨ç¾ãã
åæã®ããã®ã¢ããªã³ã°
ãä»åç´¹ä»ãã表ç¾æ¹æ³ã¯ãåæã®ææ³ã¨ãã¦æ´»ç¨ãããã®ã§ããã¤ã¾ãã調ã¹ã⇒åæãã⇒çµæãè¨è¿°ãããã¨ããæµãã§ã¯ãªããã調ã¹ã⇒è¨è¿°ãã⇒åæãããã¨ãããµã¤ã¯ã«ãåæã«ãã¦ãã¾ããéãããã¢ã¤ã³ã³ã使ãããã¿ã¼ã³ã«å¾ã£ã¦è¨è¿°ãããã¨ãåæã«ã¤ãªããã¾ããåã ã®è¦ç´ ãã¤ãªãããåé¡ããã¨ããè¡çºãç¹°ãè¿ããã¨ãã対象ãæ·±ãç¥ããã¨ã«ãªãã®ã§ãããã¤ã³ãã¯ãééã£ã¦ãã¦ãããã®ã§ãã¨ã«ããè¨è¿°ãããã¨ã§ããééãã¯æ°ã¥ããã¨ãã«ç´ãã°ããã®ã§ãã
ã以ä¸ã«è¡¨ç¾æ¹æ³ãç´¹ä»ãã¾ãããçµæãæ´çããã®ã§ã¯ãªããæ¸ããªããèãããã¨ãããã¨ãæèããªãã使ã£ã¦ãã ãããããããã¨ãå°æ°ã®è¨å·ã¨æ±ºã¾ã£ããã¿ã¼ã³ã§è¡¨ç¾ãããã¨ã®ä¾¡å¤ãå®æã§ããã¨æãã¾ãã
表ç¾æ¹æ³
ãã·ã¹ãã ã®å°å³ã¯6種é¡ã®ãã¼ã¿ã¨2ã¤ã®ã¢ãã«ã§è¡¨ç¾ãã¾ãã
- 誰ã«ï¼ãããã¢ã¯ã¿ã¼ãããå¤é¨ã·ã¹ãã ã
- ä½ãè¡ãï¼ããç»é¢ã»å¸³ç¥¨ãããå¤é¨ã·ã¹ãã ã¨ã®å ¥åºåãããæ©è½ããããã¼ã¿ã
- ä½ã®ããã«ï¼ãã¹ãã¼ããã·ã³å³ããç¨èªéãï¼ãæ¦å¿µã¢ãã«ããããã¡ã¤ã³ã¢ãã«ãï¼
ããä½ãè¡ããã®é¨åã7種é¡ã®ã¢ã¤ã³ã³ï¼å³1ï¼ã§è¡¨ç¾ãã¾ããããããçµã¿åããã¦ã·ã¹ãã å ¨ä½ã表ãã¾ããé²ãæ¹ã¯ç¬¬2話ã®å³3ã«ãã¨ã¥ãã¦è¡ãã¾ãã
ãæåã¯ãææãéããããã¨ããå§ãã¾ããå ¥åºåæ å ±ã¨ãªãç»é¢ã帳票ãã¤ãã³ããã¤ãã³ããã¼ã¿ã¨ãã¼ã¿ï¼RDBããã¡ã¤ã«ï¼ã調ã¹ããã®çµæãUMLãã¼ã«ã«ç»é²ãã¾ãã
ã注æãå¿ è¦ãªã®ã¯ååã®ä»ãæ¹ã§ãã第1話ã®å³4ã§ãæ´ãåºãæ å ±ã¯å®ä½ã«ã¤ãªããã¨ãã説æããã¾ãããå®ä½ã¨ããã®ã¯ãã®ã·ã¹ãã ã§ç®¡çããã¦ããåä½ãæããå¾ã§ããã¥ã¡ã³ããããã°ã©ã ã調ã¹ãã¨ãã®å ¥å£ã«ãªããã®ã§ããç»é¢ã»å¸³ç¥¨ãã¤ãã³ããã¤ãã³ããã¼ã¿ããã¼ã¿ã«ã¤ããååã¯ãã®ç®¡çããã¦ããååãä»ãã¾ãããã®ååãä½ç³»ã ã£ãçªå·ï¼K123123...ï¼ãªã©ã§ç®¡çããã¦ããå ´åã¯åãããããååãä¸ç·ã«ä»ãããã¨ã大äºã§ãã
ãç»é¢ã¨å¸³ç¥¨ãã¤ãã³ããã¼ã¿ã¯ã¯ã©ã¹ã¢ã¤ã³ã³ã§è¡¨ç¾ããåã ã®é ç®ãæ´ãåºããã¨ãã¯ã¯ã©ã¹ã®å±æ§ã¨ãã¦è¡¨ç¾ãã¾ãã
ãã¤ãã³ãã¢ã¤ã³ã³ã¯å¤é¨ã®ã·ã¹ãã ã¨ã®å ¥åºåã表ç¾ããããã«ä½¿ããã·ã¹ãã ã¢ã¤ã³ã³ã¯é¢ä¿ããå¤é¨ã®ã·ã¹ãã ã表ãã¦ãã¾ããã¤ãã³ããå¤é¨ã·ã¹ãã ã¨ã¤ãªãããã¨ã§ã¤ãã³ãã®å¸°å±ããããã¾ãã
ããã¼ã¿ã¯ã¯ã©ã¹ã¢ã¤ã³ã³ã§è¡¨ç¾ãããã¼ãã«ã®ã«ã©ã ã¯ã¯ã©ã¹ã®å±æ§ã¨ãã¦è¡¨ç¾ãã¾ãããã¡ã¤ã«ã¯ãã¼ã¿ã®å ¥åºåãªã©ã«ä½¿ç¨ãããã®ã表ããä¸æãã¡ã¤ã«ã¯å¯¾è±¡å¤ã¨ãã¾ãããã®éãããã¢ã¤ã³ã³ã§è¡¨ç¾ãããã¨ã§ã·ã¹ãã ã®æ§ã ãªå®ç¾æ段ã«æãããããã¨ãªãã·ã¹ãã ã表ç¾ã§ããããã«ãªãã¾ãã
ã¢ã¤ã³ã³ã®ã¤ãªãæ¹ã決ãã
ãã·ã¹ãã ã表ç¾ããããã«ã¢ã¤ã³ã³ã®ã¤ãªãæ¹ããã¿ã¼ã³åï¼å³2ï¼ãã¾ããæ¥åç³»ã®ã·ã¹ãã ã¯å ¥åºåããã¼ã¿ãä»ãã¦ç¸äºã«é¢ä¿ï¼ç¬¬2話ã®å³1åç §ï¼ãæã¡ã¾ããã·ã¹ãã ã®å°å³ã¯ãã®ç¸äºã®é¢ä¿ã示ãããã®ã§ãã
ãåºæ¬ã¯å ¥åºåï¼ç»é¢ã»å¸³ç¥¨ãã¤ãã³ããã¤ãã³ããã¼ã¿ï¼ã¨ãã¼ã¿ããæ©è½ãä»ãã¦ã¤ãªãã¾ããç»é¢ã»å¸³ç¥¨ãã¤ãã³ãããã¼ã¿ã¯æ´ãåºãããã®ããã®ã¾ã¾ã¢ã¤ã³ã³ã¨ãã¦è¨è¿°ãã¾ããå®éã®ã¢ããªã³ã°ã®ä½æ¥ã¯ããããã®å ¥åºåã¨ãã¼ã¿ãæ©è½ã§ã¤ãªãä½æ¥ãä¸å¿ã«ãªãã¾ãããã®æã®æ©è½ã¯è«ççãªãã®ã§ããã°ã©ã ã§ã¯ããã¾ãããããã¾ã§ãã·ã¹ãã ã®å ¥åºåã¨ãªãç»é¢ã»å¸³ç¥¨ãã¤ãã³ãã¨ãã¼ã¿ãè«ççãªæ©è½ã§ã¤ãªããã¨ã§æ´çãããå½¢ã«ã¾ã¨ãä¸ãã¾ãã
ãç»é¢ã®å¦çãä¾ã«ã¨ãã¨ç»é¢ã®ã¤ãã³ããæ©è½ãå¼ã³åºãããã¼ã¿ãæä½ãã¾ããåæ§ã«å¤é¨ã·ã¹ãã ã¨ã®ã¤ãã³ããæ©è½ã«ã¤ãªãããã¼ã¿ãæä½ãã¾ãããã¼ã¿ãä¸å¿ã«æ©è½ãå ¥åºåã¨ã¤ãªãã¦é¢ä¿æ§ãææ¡ãããã¨ã§ãã·ã¹ãã ã®å ¨ä½åãè¦ãã¦ãã¾ãã
ãç»é¢ã¨æ©è½ã®éã«ã¤ãã³ããç½®ãã®ã¯ãã·ã¹ãã ã®å ¥åºåãã¤ãã³ãã¨ãã¦çµ±ä¸çã«æ±ãããã§ãã
ãé常ç»é¢ãå¤é¨ã·ã¹ãã ã¨ã®ããã¨ãã«ã¯ç¸äºã«é¢ä¿ãããããã®é¢ä¿ãæ´çãããã¨ã§ãã·ã¹ãã ã§ç®¡çããæ¥åä¸ã®æç¶ããè¦ãã¦ãã¾ãããããæ´çãããã®ãæç¶ãã®ã«ã¼ã«ã«ãªãã¾ãããã®è¨è¿°æ¹æ³ã¨ãã¦ã¹ãã¼ããã·ã³å³ï¼å³3ï¼ã使ãã¾ãã
ããå®å¨æã¤ãã³ããã¨ããã®ã¯ç¹å®ã®æéã«èµ·åãããããªã¤ãã³ãã表ãã¾ããèµ·åã¿ã¤ãã³ã°ãæéã«èµ·å ãããã®ã¯å ¨ã¦å®å¨æã¤ãã³ãã¨ãã¦æ±ãã¾ãã
ãæ©è½ãããã°ã©ã ã¨å¯¾å¿ãããªãã®ããä»åç´¹ä»ãã¦ããææ³ã®ç¹å¾´ã§ãã対象ã¨ãªãããã°ã©ã ã¯æ··æ²ã¨ãã¦ããããã®ã¾ã¾ã§ã¯æçãªæ å ±ã«ãªãã¾ãããããã§ãç¾å®ã¨ã¤ãªãããªããç¾å®ã®æ··æ²ã«å½±é¿ãããã«æ´çãããï¼ç¬¬1話ã§èª¬æï¼ãã¨ãéè¦ã«ãªãã¾ããå ¥åºåã¨ãã¼ã¿ã¯å®éã®ã·ã¹ãã ã®æ å ±ã使ããªãããæ©è½ã¯è«ççã«æ½åºããæ´çãããç©ã¨ãã¦è¡¨ç¾ãã¾ããå®éã®ããã°ã©ã ã¨åãé¢ãã¦ãæ¬æ¥ã®æ©è½ãæ´ãåºããã¨ã§ãã·ã¹ãã ãåããããã表ç¾ã§ããããã«ãªãã¾ãã
ãã¸ãã¹ã«ã¼ã«ã®è¡¨ç¾
ãä¸è¨ã®ä½æ¥ã§ã·ã¹ãã ã®å ¨ä½åã¯è¦ãã¦ãã¾ããããã·ã¹ãã ãæ¯é ãã¦ããã«ã¼ã«ã¯è¦ãã¦ãã¾ãããã·ã¹ãã ãæ±ãæ å ±æ§é ãæ¯ãèãã¯ãã¸ãã¹ã«ã¼ã«ã¨ãã¦æ±ãã第2話ã§èª¬æããããã«3種é¡ã«åãã¦æ´çãã¾ãã
æç¶ãã«ã¨ããªãã«ã¼ã«
ãä»äºãé²ããããã«ç¾å ´ã®äººã¯ç¶æ ãèªèãã¦ãã¾ããä¾ãã°ããå注ã«å¯¾ãã¦ãå¨åº«å¼ãå½ã¦å¾ ã¡ããåºè·å¾ ã¡ããªã©å注ã®ç¶æ ã管çãã¦ãã¾ãããããã®ç¶æ ã®é·ç§»ãã«ã¼ã«åãããã®ãæç¶ãã«ä¼´ãã«ã¼ã«åã§ãã表ç¾æ¹æ³ã¨ãã¦UMLã®ã¹ãã¼ããã·ã³å³ã使ãã¾ãã
ãæ¥åä¸ã®ç¶æ ã¯ç¾å ´æ å½è ã使ã£ã¦ããè¨èãç»é¢ä¸ã®é ç®ãªã©ã«ç¾ãã¾ããæ å½è ãé¢å¿ãå¯ãã¦ãããã¨ã«çç®ããã¨ç¶æ ãè¦ãã¦ãã¾ããç»é¢ä¸ãXXXä¸ãã®ãããªè¡¨ç¤ºãããã°ç¶æ ãèå¥ãã¦ããå¯è½æ§ãããã¾ããç»é¢ã»å¸³ç¥¨ã®èª¿æ»ããã¢ãªã³ã°ã®ä¸ã§ç¶æ ã¨ãã¦èªèã§ãããã®ãåºã¦ããã¨ãã¯ã¹ãã¼ããã·ã³å³ã«è¨è¿°ãæ´çãã¾ãã
ã次ã«ã¤ãã³ããç¶æ å¤åã®é·ç§»ã«çµã³ã¤ãã¾ããç¶æ ãå¤ããã®ã¯ã¤ãã³ããèµ·ç¹ã«ãªãã¨èããããã§ãï¼ç¬¬2話ã®å³5åç §ï¼ã
ããã¸ãã¹ä¸ã§èªèããã¦ããç¶æ ã¨å ¥åºåãã¤ãªãããã¨ã§ããã¸ãã¹ã¨åç»é¢ãå¤é¨ã·ã¹ãã ã¨ã®é¢ãããç解ã§ããã·ã¹ãã ã®åããææ¡ã§ããããã«ãªãã¾ããåæã«é·ç§»ã«å¯¾å¿ããã¤ãã³ãããªãå ´åã¯ã調æ»ã足ãã¦ããªããã¨ããããã¾ãã
æ§é ã«ã¨ããªãã«ã¼ã«
ããã¼ã¿ã®æ§é ã調ã¹ãã¨èªãã¨æ§é ã«èµ·å ããå¶ç´ãè¦ãã¦ãã¾ããRDBã®å ´åã«ã¤ãã¦èª¬æãã¾ããã¾ãã¯ãã¼ãã«ã®ä¸»ãã¼ã調ã¹ããã¨ã§ãã©ã®åä½ã§ãã¼ã¿ãã¦ãã¼ã¯ã«ãªãããææ¡ã§ãã¾ãã
ã次ã«ããã¼ãã«éã®é¢ä¿ãæ´çãã¾ãããã¼ãã«Aãå¤é¨åç §ãããã¼ãã«Bãããå ´åã¯ãã¼ãã«Aã¨Bã¯1対1ãããã¯1対å¤ã®å¯è½æ§ãããã¾ããå¤é度ã¯ã¹ãã¼ãæ å ±ã ãã§ã¯å¤æã§ãã¾ããããéè¦ãªãã¼ãã«ã§ããã°ä¿å®æ å½è ã«ãã¢ãªã³ã°ãããã¨ã§1対1ã1対å¤ããç¥ããã¨ãã§ãã¾ãã主ã«ãã¼ã¿éã®å¤é度ã«ç¦ç¹ãå½ã¦ã¦æ§é çãªå¶ç´ãæ´çãã¾ãããã¼ã¿éã®å¶ç´ãå ã«ç»é¢ä¸ã§å¯¾è±¡ãã¼ã¿ã®æ±ãã調ã¹ããã¨ã§ãå¶ç´ããã®ã¾ã¾ã«ã¼ã«ã«ãªããå¦ããå¤æåºæ¥ã¾ãã
ãæç¶ãã®ã«ã¼ã«ã§æ´ãåºããç¶æ ã¯ãã¼ã¿ã®é¢ä¿ãããã¯å¤ã¨ãã¦å®ç¾ãããã¨èãã¾ãããã®èããæãããã«ç¶æ ã¨ãã¼ã¿ã®é¢ä¿ã調ã¹ããã¨ã§ãã·ã¹ãã ã®æ¯ãèãã«å¿ãããã¼ã¿ã®ä½¿ããæ¹ãè¦ãã¦ãã¾ãããã®ããã«å ¥åºåã¨ãã¼ã¿ã®é¢ä¿ããç¶æ ã使ã£ã¦æ´çãããã¨ã§ããã¼ã¿ã®å¤åãåæã§ãã¾ãã
æ¡ä»¶ä»ããããã«ã¼ã«
ã表形å¼ãç¨èªã¨ãã¦ã¾ã¨ããããã®ããã®ã«ã¼ã«ã§ãããããã®ã«ã¼ã«ã¯å³çãªè¡¨ç¾ã§ã¯ãªãã表形è¨ç®ãã¼ã«ã使ãä¸è¦§å½¢å¼ã§ç®¡çãã¾ãã