{"id":8541,"date":"2020-10-31T15:23:00","date_gmt":"2020-10-31T06:23:00","guid":{"rendered":"https:\/\/yorozu.cloudfree.jp\/wordpress\/?p=8541"},"modified":"2025-11-01T15:19:53","modified_gmt":"2025-11-01T06:19:53","slug":"%e6%ad%a3%e8%a6%8f%e5%8c%96%e6%8a%80%e8%a1%93","status":"publish","type":"post","link":"https:\/\/yorozu.cloudfree.jp\/wordpress\/?p=8541","title":{"rendered":"\u30c7\u30fc\u30bf\u6b63\u898f\u5316\u6280\u8853"},"content":{"rendered":"\n<p>\u30c7\u30fc\u30bf\u306e\u91cd\u8907\u3092\u306a\u304f\u3057\u6574\u5408\u7684\u306b\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u6271\u3048\u308b\u3088\u3046\u306b\uff24\uff22\u3092\u8a2d\u8a08\u3059\u308b<br>\u3000\u3000\u5f62\u5f0f\u3070\u3063\u305f\u7528\u8a9e\u304c\u4e26\u3076\u304c\u3001\u666e\u901a\u306e\u8003\u3048\u65b9\u3067\u5341\u5206\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u8a08\u304c\u3067\u304d\u307e\u3059<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\uff11\uff0e\u6b63\u898f\u5316\u306e\u6bb5\u968e<\/strong><\/h4>\n\n\n\n<p>\u3000\u5404\u6bb5\u968e\u3092\u7d4c\u3066\u30c7\u30fc\u30bf\u306f\u6b63\u898f\u5316\u3055\u308c\u3066\u3044\u304f<br><br>\u3000<strong>\u7b2c1\u6b63\u898f\u5f62(first normal form 1NF)<\/strong><br>\u3000\u3000\u3000\u95a2\u4fc2\u304c\u30b9\u30ab\u30e9\u5024\u306e\u307f\u3092\u6301\u3064<br>\u3000\u3000\u3000\u3000\u3000\u5c5e\u6027\u306e\u5024\u3068\u3057\u3066\u7e70\u308a\u8fd4\u3057\u306a\u3069\u306e\u96c6\u5408\u3084\u8907\u5408\u5024\u3092\u6301\u305f\u306a\u3044\u8868<br><br>\u3000\u3000\u3000\u30b9\u30ab\u30e9\u5024\u3068\u306f<br>\u3000\u3000\u3000\u3000\u3000\u5358\u4e00\u306e\u6570\u5024\u3084\u5024\u3067\u8868\u73fe\u3055\u308c\u308b\u300c\u5927\u304d\u3055\u300d\u306e\u307f\u3092\u6301\u3064\u6570\u5024<br><br>\u3000<strong>\u7b2c2\u6b63\u898f\u5f62(second normal form 2NF)<\/strong><br>\u3000\u3000\u3000\u95a2\u4fc2\u304c\u3001\u7b2c1\u6b63\u898f\u5f62\u3067\u3001<br>\u3000\u3000\u3000\u3059\u3079\u3066\u306e\u975e\u30ad\u30fc\u5c5e\u6027\u304c\u3001\u3059\u3079\u3066\u306e\u5019\u88dc\u30ad\u30fc\u306b\u5bfe\u3057\u3066\u5b8c\u5168\u95a2\u6570\u5f93\u5c5e\u3059\u308b<br><br>\u3000\u3000\u3000\u5b8c\u5168\u95a2\u6570\u5f93\u5c5e\u3068\u306f<br>\u3000\u3000\u3000\u3000\u3000\u5c5e\u6027\uff08\uff38\uff09\u306e\u5024\u3092\u5b9a\u3081\u308b\u3068\u3001\u5c5e\u6027\uff08\uff39\uff09\u306e\u5024\u304c\u4f4d\u7f6e\u7684\u306b\u5b9a\u307e\u308b\u3068\u304d\u3001<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\uff39\u306f\uff38\u306b\u95a2\u6570\u5f93\u5c5e\u3067\u3042\u308b\u3068\u3044\u3044\u3001\uff38\u2192\uff39\u3068\u8868\u8a18\u3059\u308b<br>\u3000\u3000\u3000\u3000\u3000\uff38\u306e\u3044\u304b\u306a\u308b\u771f\u90e8\u5206\u306b\u3064\u3044\u3066\u3082\u95a2\u6570\u5f93\u5c5e\u6027\u304c\u6210\u308a\u7acb\u305f\u306a\u3044\u5834\u5408\u3001<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\uff38\u304c\u95a2\u6570\u5f93\u5c5e\u6027\u3092\u6210\u308a\u7acb\u305f\u305b\u308b\u6700\u5c0f\u306e\u5c5e\u6027\u96c6\u5408\u3067\u3042\u308b\u5834\u5408\u3092<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u5b8c\u5168\u95a2\u6570\u5f93\u5c5e\u306e\u72b6\u614b\u3068\u3044\u3046<br>\u3000\u3000\u3000\u3000\u3000\uff38\u306e\u3046\u3061\u306e\u771f\u90e8\u5206\u3068\u306f\uff38\u304c\u8907\u6570\u306e\u90e8\u5206\u306b\u5206\u5272\u3067\u304d\u308b\u5834\u5408\u3092\u8003\u3048\u308b<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\uff21\u3001\uff22\u3001\uff39\u3068\u3044\u3046\u5c5e\u6027\u304c\u3042\u3063\u3066\uff22\u2192\uff23\u3067\u3042\u308b\u3068\u304d\u306b\u3001<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\uff21\u3068\uff22\u3068\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\uff38\u3068\u3059\u308b\u3068\uff38\u2192\uff39\u3068\u306a\u308b\u304c\u3001<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\uff38\u306e\u3046\u3061\u306e\uff22\u3059\u306a\u308f\u3061\uff38\u306e\u771f\u90e8\u5206\u3068\u95a2\u6570\u5f93\u5c5e\u6027\u304c\u6210\u308a\u7acb\u3064<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\uff39\u304b\u3089\u307f\u305f\u5834\u5408\u3001\uff21\u306e\u90e8\u5206\u306b\u3064\u3044\u3066\u306f\u5197\u9577\u306a\u95a2\u4fc2\u306b\u3042\u308b<br><br>\u3000<strong>\u7b2c3\u6b63\u898f\u5f62(third normal form 3NF)<\/strong><br>\u3000\u3000\u3000\u95a2\u4fc2\u304c\u3001\u7b2c2\u6b63\u898f\u5f62\u3067\u3001<br>\u3000\u3000\u3000\u975e\u30ad\u30fc\u5c5e\u6027\u304c\u3042\u308b\u306a\u3089\u3070\u3001\u5168\u3066\u304c&nbsp;\u5019\u88dc\u30ad\u30fc\u306b\u975e\u63a8\u79fb\u7684\u306b\u95a2\u6570\u5f93\u5c5e\u3059\u308b<br><br>\u3000<strong>\u30dc\u30a4\u30b9\u30fb\u30b3\u30c3\u30c9\u6b63\u898f\u5f62(Boyce\/Codd normal form BCNF)<\/strong><br>\u3000\u3000\u3000\u95a2\u4fc2\u4e0a\u306b\u5b58\u5728\u3059\u308b\u81ea\u660e\u3067\u306a\u3044\u5168\u3066\u306e\u95a2\u6570\u5f93\u5c5e\u6027\u306e\u6c7a\u5b9a\u9805\u304c\u5019\u88dc\u30ad\u30fc<br><br>\u3000<strong>\u7b2c4\u6b63\u898f\u5f62(fourth normal form 4NF)<\/strong><br>\u3000\u3000\u3000\u5019\u88dc\u30ad\u30fc\u3067\u306f\u306a\u3044\u5c5e\u6027\u3078\u306e\u591a\u5024\u5f93\u5c5e\u6027\u3092\u3082\u3063\u305f\u5c5e\u6027\u304c\u3042\u3063\u3066\u306f\u306a\u3089\u306a\u3044<br><br>\u3000<strong>\u7b2c5\u6b63\u898f\u5f62(fifth normal form 5NF)<\/strong><br>\u3000\u3000\u3000\u95a2\u4fc2\u304c\u7b2c4\u6b63\u898f\u5f62\u3067\u3042\u308a\u3001<br>\u3000\u3000\u3000\u305d\u306e\u95a2\u4fc2\u306b\u542b\u307e\u308c\u308b\u7d50\u5408\u5f93\u5c5e\u6027\u306e\u6c7a\u5b9a\u9805\u304c\u5019\u88dc\u30ad\u30fc\u306e\u307f\u3067\u3042\u308b<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\uff12\uff0e\u6b63\u898f\u5316\u3068\u5c5e\u6027\u306e\u5909\u5316<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2025\/10\/\u6b63\u898f\u5316.jpg\" rel=\"lightbox[8541]\"><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2025\/10\/\u6b63\u898f\u5316-150x150.jpg\" alt=\"\" class=\"wp-image-8546\"\/><\/a><figcaption class=\"wp-element-caption\">\u6b63\u6c17\u304b\u306b\u3088\u308b\u5c5e\u6027\u306e\u5909\u5316<\/figcaption><\/figure>\n\n\n\n<p>\u3000\u6b63\u898f\u5316\u306e\u4f8b<br>\u3000\u3000\u3000\u7b2c\u4e00\u6b63\u898f\u5316\uff1a\u4ed5\u5165\u5148\u3068\u5165\u8377\u65e5\u30fb\u6570\u91cf\u7b49\u306e\u30c7\u30fc\u30bf\u3092\u6b63\u898f\u5316<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u7e70\u308a\u8fd4\u3057\u9805\u76ee\u3092\u6301\u305f\u305a\u3001\u5c0e\u51fa\u9805\u76ee\u306e\u6392\u9664\u3055\u308c\u305f\u8868<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2020\/10\/\u7b2c\u4e00\u6b63\u898f\u5316.jpg\" rel=\"lightbox[8541]\"><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"129\" src=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2020\/10\/\u7b2c\u4e00\u6b63\u898f\u5316-150x129.jpg\" alt=\"\" class=\"wp-image-8563\"\/><\/a><\/figure>\n\n\n\n<p>\u3000\u3000\u3000\u7b2c\u4e8c\u6b63\u898f\u5316\uff1a\u5546\u54c1\u8868\u3068\u5165\u8377\u8868\u306b\u6574\u7406\u3059\u308b<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u975e\u30ad\u30fc\u5c5e\u6027\u306f\u4e3b\u30ad\u30fc\u306b\u5f93\u5c5e\u3059\u308b\u3001\u5b8c\u5168\u95a2\u6570\u5f93\u5c5e\u3068\u547c\u3076<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2020\/10\/\u5546\u54c1.jpg\" rel=\"lightbox[8541]\"><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"103\" src=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2020\/10\/\u5546\u54c1-150x103.jpg\" alt=\"\" class=\"wp-image-8568\"\/><\/a><figcaption class=\"wp-element-caption\">\u3000\u5546\u54c1\u8868<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2020\/10\/\u5165\u8377.jpg\" rel=\"lightbox[8541]\"><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"128\" src=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2020\/10\/\u5165\u8377-150x128.jpg\" alt=\"\" class=\"wp-image-8569\"\/><\/a><figcaption class=\"wp-element-caption\">\u3000\u3000\u5165\u8377\u8868<\/figcaption><\/figure>\n\n\n\n<p class=\"has-text-align-right\"><a href=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2020\/10\/\u5546\u54c1.jpg\" style=\"font-size: revert;\" rel=\"lightbox[8541]\"><\/a><\/p>\n\n\n\n<p>\u3000\u3000\u3000\u7b2c\u4e09\u6b63\u898f\u5316\uff1a\u4ed5\u5165\u5148\u8868\u3068\u96fb\u8a71\u5e33\u3092\u8ffd\u52a0\u3059\u308b<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u9805\u76ee\u540c\u58eb\u3067\u4f9d\u5b58\u95a2\u4fc2\u3092\u6301\u3063\u3066\u3044\u308b\u3082\u306e\u3092\u5225\u30c6\u30fc\u30d6\u30eb\u306b\u3059\u308b<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u975e\u30ad\u30fc\u5c5e\u6027\u304c\u3059\u3079\u3066\u4e3b\u30ad\u30fc\u306b\u5b8c\u5168\u95a2\u6570\u5f93\u5c5e\u3057\u3001<br>\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u63a8\u79fb\u7684\u95a2\u6570\u5f93\u5c5e\u6027\u306e\u6392\u9664\u3055\u308c\u305f\u5f62\u5f0f<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2025\/11\/\u4ed5\u5165\u5148\u8868.jpg\" rel=\"lightbox[8541]\"><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"78\" src=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2025\/11\/\u4ed5\u5165\u5148\u8868-150x78.jpg\" alt=\"\" class=\"wp-image-8575\"\/><\/a><figcaption class=\"wp-element-caption\">\u4ed5\u5165\u5148\u8868<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><a href=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2025\/11\/\u96fb\u8a71\u5e33.jpg\" rel=\"lightbox[8541]\"><img loading=\"lazy\" decoding=\"async\" width=\"124\" height=\"78\" src=\"https:\/\/yorozu.cloudfree.jp\/wordpress\/wp-content\/uploads\/2025\/11\/\u96fb\u8a71\u5e33.jpg\" alt=\"\" class=\"wp-image-8576\"\/><\/a><figcaption class=\"wp-element-caption\">\u3000\u96fb\u8a71\u5e33<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30fb\u6b63\u898f\u5316\u6280\u8853\u306b\u3064\u3044\u3066<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[99],"class_list":["post-8541","post","type-post","status-publish","format-standard","hentry","category-99_","tag-99"],"_links":{"self":[{"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/8541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8541"}],"version-history":[{"count":19,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/8541\/revisions"}],"predecessor-version":[{"id":8582,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/8541\/revisions\/8582"}],"wp:attachment":[{"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yorozu.cloudfree.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}