{"id":445,"date":"2015-09-07T03:46:57","date_gmt":"2015-09-07T03:46:57","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=445"},"modified":"2015-09-07T03:46:57","modified_gmt":"2015-09-07T03:46:57","slug":"%ec%a0%95%ea%b7%9c%ed%99%94-normalization","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=445","title":{"rendered":"\uc815\uaddc\ud654 ( Normalization )"},"content":{"rendered":"<ul>\n<li>\n<div><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>\uc815\uaddc\ud654<\/strong><br \/>\n\t\t\t\t<\/span><\/div>\n<ul>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>\uc815\uaddc\ud654\uc758 \uc815\uc758<\/strong><br \/>\uc815\uaddc\ud654 \uc791\uc5c5\uc740 \ubd88\ud544\uc694\ud558\uac8c \uac19\uc740 \ub370\uc774\ud130\uac00 \ubc18\ubcf5\ub418\uc5b4 \ub098\ud0c0\ub098\ub294 \uac83\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud55c \uc791\uc5c5\uc73c\ub85c E-R Diegram\uc758 \uac80\uc99d \ubc0f \uc6d0\uc2dc\ub370\uc774\ud130\uc758 \uad00\uacc4\ud615 \ud14c\uc774\ube14 \uc804\ud658\uc2dc \uc0ac\uc6a9\ub41c\ub2e4. \uc815\uaddc\ud654 \uc791\uc5c5\uc740 \ucd1d 6\ub2e8\uacc4 \ub610\ub294 7\ub2e8\uacc4\ub85c \uad6c\ubd84 \ub420 \uc218 \uc788\ub2e4. \ud558\uc9c0\ub9cc \uc77c\ubc18\uc801\uc73c\ub85c 3\ub2e8\uacc4\uae4c\uc9c0\ub9cc \uc9c4\ud589\ud558\uba74 \ucda9\ubd84\ud558\ub2e4\uace0 \ubcfc \uc218 \uc788\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>\uc815\uaddc\ud654\uc758 \uc774\uc810<\/strong><br \/>\ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \ubc18\ubcf5\uc744 \uc81c\uac70\ud568\uc73c\ub85c\uc368 \uc800\uc7a5\uacf5\uac04\uc744 \ucd5c\uc18c\ud654 \ud560 \uc218 \uc788\uc73c\uba70, \ub370\uc774\ud130\uc758 \ubcc0\uacbd \uc2dc \ub370\uc774\ud130\uc758 \ubd88\uc77c\uce58\uc131\uc744 \ucd5c\uc18c\ud654\ud558\uace0, \uc5f0\uc0b0\uc791\uc5c5\uc744 \ucd5c\uc18c\ud654 \ud560 \uc218 \uc788\ub2e4.<br \/>\n<\/span><\/li>\n<li>\n<div><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>\uc6a9\uc5b4 \uc815\uc758<\/strong><br \/>\n\t\t\t\t\t\t<\/span><\/div>\n<ul>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Nomal Form ( \uc815\uaddc\ud615 ) : \uc218\ud559\uc790\uc778 Codd\uc758 \uc774\ub860\uc73c\ub85c \uad00\uacc4\ud615 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uae30 \uc704\ud574 \uc9c0\ucf1c\uc57c \ud558\ub294 \uc77c\ub828\uc758 \uaddc\uce59\uc774\ub2e4. \uc774\ub860\uc801\uc73c\ub85c\ub294 \ub2e4\uc591\ud55c \uc815\uaddc\ud615\uc774 \uc788\uc9c0\ub9cc \uc77c\ubc18\uc801\uc778 \uc5c5\ubb34\uc5d0\uc11c\ub294 3\ucc28 \uc815\uaddc\ud615\uc774\uba74 \ucda9\ubd84\ud558\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Key : \ub370\uc774\ud130\uc758 \uadf8\ub8f9\uc744 \uc720\uc77c\ud558\uac8c \uc2dd\ubcc4\ud558\uae30 \uc704\ud55c \ub370\uc774\ud130\uc774\ub2e4. Primary key<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Repeating Group : \ub370\uc774\ud130\uc758 \uc77c\ubd80\uac00 \uc8fc\uc5b4\uc9c4 key\uc758 \uac12\uc5d0 \ub300\ud574 \uc5ec\ub7ec \uac1c\uc758 \uac12\uc744 \uac00\uc9c8 \uc218 \uc788\uc744 \ub54c \ubc1c\uc0dd\ud558\ub294 \ub370\uc774\ud130\uc758 \uc9d1\ud569\uc774\ub2e4. \uc989 \ubc18\ubcf5\uadf8\ub8f9\uc740 \ud558\ub098 \uc774\uc0c1\uc758 \uac12\uc774 \uc874\uc7ac\ud558\ub294 \ub370\uc774\ud130 \uadf8\ub8f9\uc774\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Dependency : \ub370\uc774\ud130 \ud56d\ubaa9\uc758 \uc874\uc7ac\uac00 \ub2e4\ub978 \ub370\uc774\ud130 \ud56d\ubaa9\uc5d0 \uc758\uc874\ub420 \ub54c \uc774 \ub370\uc774\ud130\ub294 \uc774 \ud56d\ubaa9\uc744 \uacb0\uc815\ud558\ub294 \ub370\uc774\ud130 \ud56d\ubaa9\uc5c6\uc774\ub294 \uc758\ubbf8\ub97c \uac16\uc9c0 \ubabb\ud55c\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><br \/>A.<strong> 1NF ( First Normal Form ) &#8211; Remove Repeating Group<\/strong><br \/>\ud14c\uc774\ube14\uc5d0\uc11c \ubc18\ubcf5\ub418\ub294 \uc5ec\ub7ec \uac1c\uc758 \ud56d\ubaa9\ub4e4\uc744 Repeating group \uc774\ub77c \ud558\uace0, \uc774\ub97c \ubcc4\ub3c4\uc758 Row\ub85c \ubd84\ub9ac\ud558\ub294 \uc791\uc5c5\uc774 1NF \uc774\ub2e4. \ub2e4\uc74c \uc608\uc81c\ub294 \uc2a4\ud3ec\uce20 \ud074\ub7fd\uc758 \ud68c\uc6d0 \ud14c\uc774\ube14\uc774\ub2e4. \uac01 \ud68c\uc6d0\ub4e4\uc740 \ucd5c\ub300 \ub450\uac00\uc9c0 \ud65c\ub3d9\uc744 \ud560 \uc218 \uc788\ub2e4\uace0 \uac00\uc815\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile27.uf.271ED13D55ED08AB20DB8D.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\uc704\uc758 \ud14c\uc774\ube14\uc5d0\uc11c \uc911\ubcf5\ub418\ub294 \ub370\uc774\ud130\ub97c \ubd84\ub9ac\ud558\uc5ec \uac01\uac01 \ub2e4\ub978 Row\ub97c \ub9cc\ub4e4\uc5b4 1NF\uc758 \uc870\uac74\uc5d0 \ub9de\ub294 \ud14c\uc774\ube14\uc744 \ub2e4\uc2dc \uc791\uc131\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.210E9D3E55ED08AC1E3EC8.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">B.<strong> 2NF ( Second Normal Form ) &#8211; Remove Part Key Dependevcies<\/strong><br \/>2NF\ub294 1NF \uc870\uac74\uc744 \ub9cc\uc871\ud558\uba74\uc11c Key\uac00 \uc544\ub2cc \ub2e4\ub978 Column \ub4e4\uc740 \uae30\ubcf8 Key\uc5d0 \uc758\uc874\uc131\uc774 \uc788\uc5b4\uc57c \ud55c\ub2e4. \ub530\ub77c\uc11c \uc758\uc874\uc131\uc774 \uc5c6\ub294 \ub370\uc774\ud130 \ud56d\ubaa9\ub4e4\uc744 \uc81c\uac70\ud558\uc5ec \ubd84\ub9ac\ud558\ub294 \uc791\uc5c5\uc774 2NF \uc774\ub2e4. \uc704\uc758 \ub370\uc774\ud130\ub97c 2NF \uc870\uac74\uc5d0 \ub9de\uac8c \ubcc0\ud615\ud55c \uac83\uc774\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile30.uf.230C9C3455ED08AC277C49.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><\/p>\n<p><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.271DA83D55ED08AD22FED6.png?w=640\" data-recalc-dims=\"1\" \/><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\ud14c\uc774\ube14\uc744 \ubd84\ub9ac \ud568\uc73c\ub85c\uc368 2NF\uc758 \uc870\uac74\uc778 \uae30\ubcf8 Key\uc758 \uc758\uc874\uc131\uc740 \ud655\ubcf4\ud588\ub2e4. \ud558\uc9c0\ub9cc \ud604\uc7ac \ud68c\uc6d0\uc758 \ud65c\ub3d9 \uc0c1\ud0dc\ub97c \ud30c\uc545\ud558\uc9c0 \ubabb\ud558\ub294 \ub2e8\uc810\uc774 \uc788\uc73c\ubbc0\ub85c \uc774 \ub450 \ud14c\uc774\ube14\uc758 \uad00\uacc4\ub97c \uc815\uc758\ud558\ub294 \ud14c\uc774\ube14\uc774 \ud544\uc694\ud558\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile26.uf.243CAF4355ED08AE0841BF.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">C. <strong>3NF ( Third Normal Form ) &#8211; Remove non-key dependencies<\/strong><br \/>3NF\ub294 2NF\uc758 \uc870\uac74\uc73c\ub85c \ub9cc\uc871\ud558\uba74\uc11c Key\uac00 \uc544\ub2cc \ud56d\ubaa9\ub4e4\uac04\uc758 \uc885\uc18d\uc131\uc744 \uc81c\uac70\ud558\ub294 \uc791\uc5c5\uc774\ub2e4. \uc704\uc758 \ud68c\uc6d0 \uc0c1\ud0dc \ud14c\uc774\ube14\uc5d0\uc11c \uc9c0\uc5ed\ucf54\ub4dc\ub294 \ud68c\uc6d0ID\uc5d0 \uc758\uc874\uc131\uc744 \uac00\uc9c0\uace0, \uac70\uc8fc\uc9c0\ub294 \uc9c0\uc5ed\ucf54\ub4dc\uc5d0 \uc758\uc874\uc131\uc744 \uac00\uae30\ubbc0\ub85c \uac70\uc8fc\uc9c0\ub294 \ud68c\uc6d0ID\uc5d0 \uc758\uc874\uc131\uc744 \uac00\uc9c4\ub2e4. \ub530\ub77c\uc11c Key\uac00 \uc544\ub2cc \ub370\uc774\ud130 \ud56d\ubaa9\uc774 \ub2e4\ub978 \ud56d\ubaa9\uc758 \uacb0\uc815\uc694\uc18c\uac00 \ub418\ubbc0\ub85c \uc774\uac83\uc744 \uc81c\uac70\ud558\uae30 \uc704\ud574 \uc774\uc640 \uac19\uc740 \ud56d\ubaa9\ub4e4\uc744 \ubd84\ub9ac\ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile10.uf.2160814055ED08AF0BB7A7.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile28.uf.2629433D55ED08AF17F683.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><br \/>\n\t\t\t\t\t\t<\/span><\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\uc5ec\uae30\uc5d0\uc11c &#8216;\ucd1d\ube44\uc6a9&#8217; Column\uc740 \ubcc4\ub3c4\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uae30 \uc54a\uc544\ub3c4 \uac01 \ud14c\uc774\ube14\uc758 \uc870\uc778 \uc5f0\uc0b0\uc73c\ub85c \ud1b5\ud574 \uc27d\uacc4 \uacc4\uc0b0\uc774 \uac00\ub2a5\ud558\ubbc0\ub85c \ubcc4\ub3c4\uc758 \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4.<br \/>\n<\/span><\/p>\n<\/li>\n<li>\n<div><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>Structured Query Language ( SQL )<\/strong><br \/>\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc870\uc791\ud558\uae30\uc5d0 \uac00\uc7a5 \uc54c\ub9de\uc740 \uc5b8\uc5b4\ub85c\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \uc5ed\ud560\uc744 \uc218\ud589\ud55c\ub2e4.<br \/>\n<\/span><\/div>\n<ul>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\ub370\uc774\ud130 \ucffc\ub9ac<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\ud14c\uc774\ube14\uc5d0 \uc788\ub294 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc0bd\uc785, \ubcc0\uacbd, \uc0ad\uc81c ( \ub370\uc774\ud130 \uad00\ub9ac )<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\uc2a4\ud0a4\ub9c8 \uc624\ube0c\uc81d\ud2b8\uc5d0 \ub300\ud55c \uc0dd\uc131, \ubcc0\uacbd<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\ub370\uc774\ud130\ubca0\uc774\uc2a4, \uc2a4\ud0a4\ub9c8 \uc624\ube0c\uc81d\ud2b8 \uad00\ub9ac<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\ub370\uc774\ud130 \ubb34\uacb0\uc131 \ubcf4\uc7a5<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\uc815\uaddc\ud654 \uc815\uaddc\ud654\uc758 \uc815\uc758\uc815\uaddc\ud654 \uc791\uc5c5\uc740 \ubd88\ud544\uc694\ud558\uac8c \uac19\uc740 \ub370\uc774\ud130\uac00 \ubc18\ubcf5\ub418\uc5b4 \ub098\ud0c0\ub098\ub294 \uac83\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud55c \uc791\uc5c5\uc73c\ub85c E-R Diegram\uc758 \uac80\uc99d \ubc0f \uc6d0\uc2dc\ub370\uc774\ud130\uc758 \uad00\uacc4\ud615 \ud14c\uc774\ube14 \uc804\ud658\uc2dc \uc0ac\uc6a9\ub41c\ub2e4. \uc815\uaddc\ud654 \uc791\uc5c5\uc740 \ucd1d 6\ub2e8\uacc4 \ub610\ub294 7\ub2e8\uacc4\ub85c \uad6c\ubd84 \ub420 \uc218 \uc788\ub2e4. \ud558\uc9c0\ub9cc \uc77c\ubc18\uc801\uc73c\ub85c 3\ub2e8\uacc4\uae4c\uc9c0\ub9cc \uc9c4\ud589\ud558\uba74 \ucda9\ubd84\ud558\ub2e4\uace0 \ubcfc \uc218 \uc788\ub2e4. \uc815\uaddc\ud654\uc758 \uc774\uc810\ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \ubc18\ubcf5\uc744 \uc81c\uac70\ud568\uc73c\ub85c\uc368 \uc800\uc7a5\uacf5\uac04\uc744 \ucd5c\uc18c\ud654 \ud560 \uc218 \uc788\uc73c\uba70, \ub370\uc774\ud130\uc758 \ubcc0\uacbd \uc2dc \ub370\uc774\ud130\uc758 \ubd88\uc77c\uce58\uc131\uc744 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":446,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[11],"tags":[212,213],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.271DA83D55ED08AD22FED6.png?fit=235%2C117","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/445"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=445"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/445\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/446"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=445"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}