{"id":406,"date":"2014-01-05T13:45:10","date_gmt":"2014-01-05T04:45:10","guid":{"rendered":"http:\/\/www.uturtle.com\/blog\/?p=406"},"modified":"2014-01-05T14:02:44","modified_gmt":"2014-01-05T05:02:44","slug":"%ec%98%9b%eb%82%a0%ec%97%90-%ea%b3%bc%ec%a0%9c%eb%a5%bc-%eb%8f%84%ec%99%80%ec%a3%bc%eb%a9%b4%ec%84%9c-%ec%9d%bc%ec%96%b4%eb%82%9c-er%eb%8b%a4%ec%9d%b4%ec%96%b4%ea%b7%b8%eb%9e%a8-%ec%9d%b4%ec%95%bc","status":"publish","type":"post","link":"https:\/\/www.jinukbaek.com\/blog\/ko\/archives\/406","title":{"rendered":"\uc61b\ub0a0\uc5d0 \uacfc\uc81c\ub97c \ub3c4\uc640\uc8fc\uba74\uc11c \uc788\uc5c8\ub358 ER\ub2e4\uc774\uc5b4\uadf8\ub7a8 \uc774\uc57c\uae30"},"content":{"rendered":"

\uc608\uc804\uc5d0 \ub300\ud559\uad50\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc218\uc5c5\uc744 \ub4e4\uc744 \ub54c \uc600\ub2e4. \ub098\ub294 \uc774\ub860\uacfc\ubaa9\uc744 \uc88b\uc544\ud588\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \uc218\uc5c5\ub3c4 \uc7ac\ubbf8\uc788\uac8c \ub4e4\uc744 \uc218 \uc788\uc5c8\ub2e4. \uc8fc\uc5b4\uc9c4 \uc694\uad6c\uc0ac\ud56d\uc73c\ub85c\ubd80\ud130 \uc5b4\ub5a4 \uacfc\uc815\uc744 \ud1b5\ud574\uc11c \uc2e4\uc81c MySQL, OracleDB\uc758 \ud14c\uc774\ube14, \ub9b4\ub808\uc774\uc158, \ud2b8\ub9ac\uac70, \ud504\ub85c\uc2dc\uc838, \uc778\ub371\uc2a4 \ub4f1\ub4f1\uc758 \ubb3c\ub9ac\uc801\uc778 \uc124\uacc4\uae4c\uc9c0 \uc624\uac8c \ub418\ub294\uc9c0 \ubcf4\ub294 \uac83\uc740 \ub9e4\uc6b0 \ud765\ubd84\ub418\ub294 \uc77c\uc774\uc600\ub2e4. \ud558\uc9c0\ub9cc \uc218\uc5c5\uc744 \ub4e3\ub294 \ub2e4\ub978 \uc0ac\ub78c\ub4e4\uc740 \ubcc4 \uc0dd\uac01\uc5c6\uc774 \uc218\uc5c5\uc744 \ub4e3\uace0 \uc788\ub294 \ub4ef \ud558\uc600\uc73c\uba70 \ub098\ub294 \uadf8\ub7f0 \ubaa8\uc2b5\uc774 \uc774\ud574\uac00 \ub418\uc9c0 \uc54a\uc558\ub2e4. \ubb34\uc5b8\uac00\ub97c \ub9cc\ub4e0\ub2e4\uba74 \ub370\uc774\ud130\uac00 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc77c\uc778\ub370 \ub2e4\ub978 \ud559\uc0dd\ub4e4\uc740 \uadf8\ub807\uac8c \uc0dd\uac01\ud558\uc9c0 \uc54a\ub294 \ub4ef \ud588\ub2e4. <\/p>\n

ER\ub2e4\uc774\uc5b4\uadf8\ub7a8\uc5d0 \ub300\ud558\uc5ec \ubc30\uc6b0\uace0 \ub098\uc11c \uad50\uc218\ub2d8\uaed8\uc11c \uc2e4\uc81c\ub85c \uc694\uad6c\uc0ac\ud56d\uc744 \uc8fc\uace0 \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc744 \uadf8\ub824\uc624\ub77c\ub294 \uacfc\uc81c\ub97c \ub0b4\uc8fc\uc168\uc5c8\ub2e4. \uacfc\uc81c\ub97c \ub05d\ub0b4\uace0 \uc26c\uace0 \uc788\ub294\ub370 \uc5b4\ub5a4 \uce5c\uad6c\uac00 \uc640\uc11c \uacfc\uc81c \uc124\uba85 \uc880 \ud574\uc8fc\uace0 \ub3c4\uc640\ub2ec\ub77c\uace0 \ubd80\ud0c1\uc744 \ud558\uc600\ub2e4. \uadf8\ub7f0\ub370 \uadf8 \uce5c\uad6c\ub294 \uc124\uba85\uc744 \ud558\uace0 \ub098\uc11c \ubc29\ud5a5\uc131\uc744 \uc81c\uc2dc\ud574 \uc8fc\uc5c8\ub294\ub370 \ub2f9\ud669\uc2a4\ub7fd\uac8c\ub3c4 \ub0b4 \ub9d0\uc744 \ub4e4\uc73c\ub824\uace0 \ud558\uc9c0\ub97c \uc54a\uc558\ub2e4. \uc624\ud788\ub824 \uc790\uae30\ub9d0\uc774 \ub9de\ub2e4\ub294 \uac83\uc774\uc5c8\ub2e4. <\/p>\n

\"Erd\"
\uc9c1\uc0ac\uac01\ud615\uc740 \uac1c\uccb4, \ub9c8\ub984\ubaa8\ub294 \uad00\uacc4 \uadf8\ub9ac\uace0 \ube68\uac15\uc0c9\uc740 \ub9f5\ud551 \uce74\ub514\ub0a0\ub9ac\ud2f0<\/figcaption><\/figure>\n

ER\ub2e4\uc774\uc5b4\uadf8\ub7a8\uc740 Entity-Relationship Diagram(ERD)1<\/a><\/sup>\uc758 \uc904\uc784\ub9d0\uc73c\ub85c\uc368 \uac1c\uccb4\uc640 \uad00\uacc4\ub97c \ud1b5\ud574\uc11c \ub370\uc774\ud130 \ubaa8\ub378\ub9c1\uc744 \ud558\uae30\uc704\ud55c \ub3c4\uad6c\uc774\ub2e4. \uc774\ub984\uc5d0\ub3c4 \ub098\uc640 \uc788\ub4ef\uc774 \uac1c\uccb4(\ubb3c\uccb4, \ub300\uc0c1, \uba85\uc0ac \ub4f1\uc744 \uc758\ubbf8)\uc640 \uad00\uacc4(2\uac1c\uc774\uc0c1\uc758 \uc5d4\ud2f0\ud2f0 \uc0ac\uc774\uc758 \uad00\uacc4, \ub3d9\uc0ac \ub4f1\uc744 \uc758\ubbf8)\ub97c \uc774\uc6a9\ud55c \ubaa8\ub378\ub9c1\uc774\ub2e4. \uadf8\ub7f0\ub370 \uad00\uacc4\ub97c \ub9cc\ub4ec\uc5d0 \uc788\uc5b4\uc11c \uc5d4\ud2f0\ud2f0\uc640 \uc5d4\ud2f0\ud2f0 \uc0ac\uc774\uc5d0\uc11c \uc11c\ub85c \ub370\uc774\ud130\uac00 \uc5b4\ub5bb\uac8c \ucc38\uc5ec\ud558\uace0 \uc788\ub294\uc9c0\uc5d0 \ub300\ud55c \uac83\ub3c4 \ud3ec\ud568\ub41c\ub2e4. \uc608\ub97c \ub4e4\uc5b4 "\ubc18(\u73ed, class)"\uc5d0 \ub300\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9cc\ub4e0\ub2e4\uace0 \ud588\uc744 \ub54c \ubc18<\/strong>\uc774\ub77c\ub294 \uc5d4\ud2f0\ud2f0\uc640 \ud559\uc0dd<\/strong>\uc774\ub77c\ub294 \uc5d4\ud2f0\ud2f0\uac00 \uc874\uc7ac\ud558\uac8c \ub418\uba70 \ud559\uc0dd\uacfc \uad50\uc2e4\uac04\uc5d0\ub294 \uc18d\ud55c\ub2e4<\/strong>\ub77c\ub294 \uad00\uacc4\ub97c \ub9fa\uac8c \ub41c\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c 1 \uac1c \ubc18\uc5d0 1\uacf3\uc5d0 \ub300\ud558\uc5ec \uc5ec\ub7ec\uba85\uc758 \ud559\uc0dd\uc774 \uc18d\ud560 \uc218 \uc788\uc744 \uac83\uc774\ub2e4. \uc704\uc758 \uc608\uc81c\uc758 \uacbd\uc6b0 \ubc18\uacfc \ud559\uc0dd\uc740 1:N\uc758 \uad00\uacc4\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4. \uc774 1:N\uc774\ub77c\uace0 \ud558\ub294 \uac83\uc744 \ub9f5\ud551 \uce74\ub514\ub0a0\ub9ac\ud2f0(Mapping Cardinality)\ub77c\uace0 \ubd80\ub978\ub2e4. \ub9f5\ud551 \uce74\ub514\ub0a0\ub9ac\ud2f0\uac00 \ud45c\ud604\ub418\uc9c0 \uc54a\uc740 ER \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc740 \uadf8\ub9ac\ub2e4 \ub9cc \uac83\uacfc \ub3d9\uc77c\ud558\ub2e4. ER \ub2e4\uc774\uc5b4\uadf8\ub7a8\uc73c\ub85c \uadf8\ub824\uc9c4 \ub0b4\uc6a9\uc740 \ucd94\ud6c4 \ub17c\ub9ac\uc801 \ubaa8\ub378\ub85c \ubcc0\ud658\ud558\ub294 \uacfc\uc815\uc744 \uac70\uce58\uac8c \ub41c\ub2e4. \ub17c\ub9ac\uc801 \ubaa8\ub378\ub9c1\uc740 \uc6b0\ub9ac\uac00 \uc798 \uc54c\uace0 \uc788\ub294 \ud14c\uc774\ube14\uc744 \uc774\uc6a9\ud558\uc5ec \ubaa8\ub378\ub9c1\uc744 \ud558\ub294 \uac83\uc744 \ub9d0\ud55c\ub2e4. \uadf8\ub807\uac8c \ubcc0\ud654\ud558\ub294 \uacfc\uc815\uc5d0\uc11c \ub9f5\ud551 \uce74\ub514\ub0a0\ub9ac\ud2f0\ub294 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \uc218\ud589\ud55c\ub2e4. \uad00\uacc4\ub97c \ud14c\uc774\ube14\uacfc \uad00\uacc4\ub85c \ud45c\ud604\ud558\uae30 \uc704\ud574\uc11c \uc5b4\ud2b8\ub9ac\ubdf0\ud2b8\ub97c \uc5b4\ub5bb\uac8c \ud560 \uac83\uc778\uc9c0(1:N, 1:1), \uc5d4\ud2f0\ud2f0 \ubcc0\ud658 \uacfc\uc815\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \ud569\uccd0\uc57c \ud558\ub294\uc9c0(1:1), \ucd94\uac00\uc801\uc73c\ub85c \ub9f5\ud551 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc57c\ud558\ub294\uc9c0(N:M)\uc640 \uac19\uc740 \uac83\ub4e4\uc774 \uacb0\uc815\ub41c\ub2e4. \uad00\uacc4\uc5d0 \ub9f5\ud551 \uce74\ub514\ub0a0\ub9ac\ud2f0\ub97c \uc801\ub294 \uac83\uc774 \uc5bc\ub9c8\ub098 \uc911\uc694\ud55c\uc9c0\ub294 \ub354 \uc774\uc0c1 \ub9d0\ud560 \ud544\uc694\ub3c4 \uc5c6\uc744 \uac83\uc774\ub2e4.<\/p>\n

\ub2e4\uc2dc \ub3cc\uc544\uc640\uc11c \uadf8 \uce5c\uad6c\uc774\uc57c\uae30\ub97c \uacc4\uc18d \ud574\ubcf4\uba74 \uadf8 \uce5c\uad6c\ub294 \ub9f5\ud551\uce74\ub514\ub0a0\ub9ac\ud2f0\ub97c ER\ub2e4\uc774\uc5b4\uadf8\ub7a8\uc758 \uad00\uacc4\uc5d0 \uc801\uc744 \ud544\uc694\uac00 \uc5c6\ub2e4\ub294 \uc774\uc57c\uae30\uc600\ub2e4. \ud544\uc790\ub294 \ucda9\ubd84\ud788 \ub9f5\ud551\uce74\ub514\ub0a0\ub9ac\ud2f0\uc758 \uc911\uc694\uc131\uc744 \ub9d0\ud55c \uac83 \uac19\ub2e4. \ud544\uc790\uc758 \uc0dd\uac01\uc5d0 \uadf8 \uce5c\uad6c\ub294 \uad50\uc218\ub2d8\uc758 \ub9d0\uc500\uc744 \uc81c\ub300\ub85c \uc548\ub4e4\uc5c8\uc744 \uac83\uc774\ub2e4. \uad50\uc218\ub2d8\uaed8\uc11c \uc124\uba85\ud558\uc2e4 \ub54c \ubd84\uba85\ud788 \uad00\uacc4\ub97c \ud45c\ud604\ud560 \ub54c \uad00\ub828\ub41c \uc5d4\ud2f0\ud2f0\ub97c \uac01\uac01 \uc120\uc73c\ub85c \uc5f0\uacb0\ud558\uace0 \ub9f5\ud551 \uce74\ub514\ub0a0\ub9ac\ud2f0\ub97c \uc801\uc73c\ub77c\ub294 \uc774\uc57c\uae30\ub97c \ud558\uc168\ub2e4. \uadf8\ub54c \uc5f4\uc2ec\ud788 \ub4e3\uc9c0\ub3c4 \uc54a\uace0 \ud544\uc790\uac00 \uc5f4\uc2ec\ud788 \uc124\uba85\ud574\uc8fc\uace0 \uc99d\uac70\ub97c \uc81c\uc2dc\ud574\ub3c4 \uc790\uae30\uac00 \ub9de\ub2e4\uba74\uc11c \uc2dc\uac04\uc744 \ube7c\uc557\uc740 \uac83\uc774\ub2e4. \ubb3c\ub860 \ub0b4\uac00 \uc124\uba85\uc744 \uc798 \ubabb\ud588\uc744 \uc218\ub3c4 \uc788\ub2e4\ub294 \uac83\uc744 \uc54c\uace0 \uc788\uae30\ub294 \ud558\ub2e4. \uc99d\uac70\uc81c\uc2dc\ub97c \ud574\ub3c4 \ub4e3\uc9c0 \uc54a\uc558\ub2e4\ub294 \uac83\uc740 \ubcc0\uba85\uac70\ub9ac\ub3c4 \uc5c6\uc744 \uac83 \uac19\ub2e4. \ubb3c\ub860 \uacb0\uacfc\uc801\uc73c\ub85c \uadf8 \uce5c\uad6c\ub294 \uacfc\uc81c \uc131\uc801\uc744 \uc88b\uac8c \ubc1b\uc9c0 \ubabb\ud588\ub2e4. <\/p>\n

\ud544\uc790\ub3c4 \uc0ac\ub78c\uc774\uae30 \ub54c\ubb38\uc5d0 \ud2c0\ub9b4 \uc218 \uc788\uc73c\uba70 \uc5b8\uc81c\ub098 \uadf8 \uac00\uc815\uc744 \uc544\ub798\uc5d0 \uae54\uace0 \uc774\uc57c\uae30\ub97c \ud55c\ub2e4. \uc5b4\ub5a4 \uc9c0\uc2dd\uc774\ub77c\ub3c4 \ub0b4\uac00 \uc798 \ubabb \uc0dd\uac01\ud558\uace0 \uc788\ub2e4\ub294 \uc99d\uac70(\ubb3c\uc801 \uc99d\uac70, \ub17c\ub9ac\uc801 \uc99d\uac70, \uc815\ud669 \uc99d\uac70, \ub2e4\ub978 \uac00\ub2a5\uc131 \ub4f1)\ub97c \uc81c\uc2dc\ud558\uba74 \uc5bc\ub9c8\ub4e0\uc9c0 \uc778\uc815\ud560 \uc218\ub3c4 \uc788\ub2e4. \ud558\uc9c0\ub9cc \uc0c1\ub300\ubc29\uc5d0\uac8c \ucc45\uc5d0 \ub098\uc640\uc788\ub2e4\ub294 \uc99d\uac70\ub97c \uc81c\uc2dc\ud558\uba74\uc11c \uc124\ub4dd\uc744 \ud588\ub294\ub370\ub3c4 \ub4e3\uc9c0\ub97c \uc54a\uc558\ub2e4. \uadf8 \uc774\ud6c4 \ub9d0\uc744 \ub4e3\uc9c0 \uc54a\uc744 \uac83 \uac19\uc73c\uba74 \ub0b4\ucabd\uc5d0\uc11c \uadf8\ub0e5 \ud3ec\uae30\ud574 \ubc84\ub9b0\ub2e4. \uc790\uae30\uac00 \ubb34\uc870\uac74\uc801\uc73c\ub85c \ub9de\ub2e4\ub294 \uc0ac\ub78c\ub4e4\uc740 \uc5b4\ub5a4 \uc99d\uac70\ub97c \uc81c\ucd9c\ud558\ub354\ub77c\ub3c4 \ub4e4\uc744 \uc0dd\uac01\uc744 \uc548\ud55c\ub2e4\ub294 \uc0dd\uac01\uc744 \uac00\uc9c0\uac8c \ub418\uc5c8\uae30 \ub54c\ubb38\uc774\ub2e4. \uc774\uc804\uc5d0\ub294 \ubaa8\ub4e0 \uc0ac\ub78c\ub4e4\uc774 \uc798 \ubabb \uc0dd\uac01\ud558\uace0 \uc788\ub294 \uac83\uc5d0 \ub300\ud574\uc11c \uc99d\uac70\ub97c \ub300\uace0 \ub530\uc9c0\uace0 \ubc14\ub85c \uace0\uce58\uae30 \uc704\ud574\uc11c \ub178\ub825\ud588\uc9c0\ub9cc \uc774\uc81c\ub294 \uadf8\ub7f0 \ubb34\uc758\ubbf8\ud55c \uc124\ub4dd\uc744 \uc704\ud55c \uc2dc\uac04 \ub0ad\ube44\uac00 \ubd88\ud544\uc694\ud558\ub2e4\uace0 \uc0dd\uac01\ud558\uac8c \ub41c \uac83\uc774\ub2e4.<\/p>\n

\ucc38\uace0\uc790\ub8cc<\/h4>\n
    \n
  1. Wikipedia (Entity-Relationship model) ,http:\/\/en.wikipedia.org\/wiki\/Entity%E2%80%93relationship_model<\/a> ↩<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    \uc608\uc804\uc5d0 \ub300\ud559\uad50\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc218\uc5c5\uc744 \ub4e4\uc744 \ub54c \uc600\ub2e4. \ub098\ub294 \uc774\ub860\uacfc\ubaa9\uc744 \uc88b\uc544\ud588\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \uc218\uc5c5\ub3c4 \uc7ac\ubbf8\uc788\uac8c \ub4e4\uc744 \uc218 \uc788\uc5c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[43],"tags":[173,247,175],"class_list":["post-406","post","type-post","status-publish","format-standard","hentry","category-computer-science","tag-er","tag-computer-database","tag-175"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8gT1J-6y","_links":{"self":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts\/406","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/comments?post=406"}],"version-history":[{"count":2,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts\/406\/revisions"}],"predecessor-version":[{"id":408,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts\/406\/revisions\/408"}],"wp:attachment":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/media?parent=406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/categories?post=406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/tags?post=406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}