{"id":9246,"date":"2019-04-10T02:57:01","date_gmt":"2019-04-09T18:57:01","guid":{"rendered":"https:\/\/mnya.tw\/cc\/?p=9246"},"modified":"2019-05-14T13:40:15","modified_gmt":"2019-05-14T05:40:15","slug":"1366","status":"publish","type":"post","link":"https:\/\/mnya.tw\/cc\/word\/1366.html","title":{"rendered":"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 &#038; \u7b46\u8a18"},"content":{"rendered":"<p>\u9019\u662f\u840c\u82bd\u7ad9\u9577\u7684\u5b78\u696d\u7b46\u8a18\uff0c\u8ab2\u7a0b\u70ba\u8cc7\u7ba1\u7cfb<strong>\u300c\u8cc7\u6599\u5eab\u7ba1\u7406\u300d<\/strong>\u3002\u7531\u65bc\u8ab2\u5802\u4e2d\u4e00\u4e0b\u5b50\u63d0\u53ca\u592a\u591a\u5c08\u6709\u540d\u8a5e\uff0c\u4f86\u4e0d\u53ca\u505a\u8a73\u7d30\u6574\u7406\uff0c\u56e0\u6b64\u4e00\u76f4\u62d6\u5ef6\u9019\u7bc7\u767c\u4f48\u7684\u6642\u9593\uff0c\u4e0d\u904e\u5e0c\u671b\u80fd\u5e6b\u52a9\u5230\u60a8\u5b78\u7fd2\uff01\u6211\u6574\u7406\u7684\u975e\u5e38\u8a73\u7d30\uff01\u6709\u4efb\u4f55\u932f\u8aa4\u90fd\u53ef\u4ee5\u5728\u672c\u6587\u672b\u7684\u7559\u8a00\u5340\u7559\u4e0b\u60a8\u7684\u60f3\u6cd5\u8207\u5efa\u8b70\uff01<\/p>\n<p>\u672c\u7bc7\u6587\u7ae0\u8457\u91cd\u57fa\u790e\u77e5\u8b58\u8207\u8cc7\u6599\u5eab\u8a2d\u8a08\u7684\u8aaa\u660e\uff0c\u6587\u7ae0\u7b2c\u56db\u7ae0\u7bc0\u5217\u51fa\u975e\u5e38\u591a\u63d0\u554f\u8207\u56de\u7b54\uff0c\u4e00\u5b9a\u80fd\u5e6b\u52a9\u60a8\u66f4\u4e86\u89e3\u8cc7\u6599\u5eab\u9019\u500b\u9818\u57df\uff0cSQL \u8a9e\u6cd5\u53ca\u8edf\u9ad4\u4f7f\u7528\u6559\u5b78\u5c07\u53e6\u5beb\u6587\u7ae0\u8aaa\u660e\u5537\uff01\ud83d\ude09<\/p>\n<p>\ud83d\udcdd \u60f3\u7528 SQL \u5efa\u7acb\u8cc7\u6599\u5eab\uff1f\u770b\u9019\u7bc7\uff1a<strong><a href=\"https:\/\/mnya.tw\/cc\/word\/1320.html\" target=\"_blank\" rel=\"noopener noreferrer\">SQL \u8a9e\u6cd5\u5efa\u7acb\u8cc7\u6599\u5eab\u3001\u8cc7\u6599\u8868\u53ca\u5176\u6b04\u4f4d\u3001\u8cc7\u6599\u7df4\u7fd2<\/a><\/strong><br \/>\n\ud83d\udcdd \u60f3\u7528 SQL \u505a\u67e5\u8a62\uff1f\u770b\u9019\u7bc7\uff1a<a href=\"https:\/\/mnya.tw\/cc\/word\/1375.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>SQL \u67e5\u8a62\uff08SQL Query\uff09\u7684\u57fa\u672c\u8a9e\u6cd5<\/strong><\/a><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1366-1.jpg\" width=\"1024\" height=\"768\" \/><br \/>\n\u25b2 \u9996\u5716\uff0c\u5fc3\u8840\u4f86\u6f6e\u756b\u500b 3D \u7684\u8cc7\u6599\u5eab\uff01\u89ba\u5f97\u4ee5\u5f8c\u6211\u6703\u641e\u66f4\u591a\u9019\u7a2e 3D \u7269\u4ef6\uff01\ud83d\ude02<\/p>\n<p>\u5ee2\u8a71\u4e0d\u591a\u8aaa\uff0c\u76f4\u63a5\u9032\u5165\u672c\u6587\u7ae0\u7bc0\u76ee\u9304\uff1a<\/p>\n<blockquote><p>&nbsp;<\/p>\n<h1><a id=\"index\"><\/a>\u672c\u6587\u7ae0\u7bc0\u76ee\u9304<\/h1>\n<p><a href=\"#ch1\">\u4e00\u3001\u8cc7\u6599\u5eab\uff08DataBase\uff09\u7c21\u4ecb<\/a><br \/>\n<a href=\"#ch2\">\u4e8c\u3001\u8cc7\u6599\u5eab\uff08DataBase\uff09 &amp; \u8cc7\u6599\u7d50\u69cb\uff08Data Structure\uff09 \u95dc\u4fc2\u662f\u4ec0\u9ebc\uff1f<\/a><br \/>\n<a href=\"#ch3\">\u4e09\u3001\u4f55\u8b02\u6b63\u898f\u5316\uff08Normalization\uff09\uff1f<\/a><br \/>\n<a href=\"#ch4\">\u56db\u3001\u9375\u503c\uff08Keys\uff09<\/a><br \/>\n<a href=\"#ch5\">\u4e94\u3001\u8cc7\u6599\u5eab\u9818\u57df\u7684\u5e38\u898b\u554f\u984c<\/a><\/p><\/blockquote>\n<h1><span style=\"color: #0000ff;\"><a id=\"ch1\"><\/a>\u4e00\u3001\u8cc7\u6599\u5eab\uff08DataBase\uff09\u7c21\u4ecb<\/span><\/h1>\n<p><strong>\u8cc7\u6599\u5eab<\/strong>\uff0c\u82f1\u6587\uff1a<strong>DataBase<\/strong>\uff0c\u901a\u5e38\u653e\u65bc\u4f3a\u670d\u5668\u63d0\u4f9b\u5132\u5b58\u8cc7\u6599\u7684\u7528\u9014\uff0c\u4e5f\u65b9\u4fbf\u4eba\u5011\u8ffd\u8e64\u4e8b\u7269\uff0c\u914d\u5408\u5f8c\u53f0\u7a0b\u5f0f\uff0c\u5982\uff1aPHP\u3001ASP\u3001JSP \u7b49\u4f86\u9023\u7dda\u5230\u8cc7\u6599\u5eab\u9032\u884c\u5b58\u53d6\uff0c\u518d\u52a0\u4e0a\u524d\u7aef\u7db2\u9801\u8a2d\u8a08\u8207\u64b0\u5beb\uff0c\u5c31\u53ef\u4ee5\u5f62\u6210\u4e00\u500b\u5b8c\u6574\u7684\u7db2\u7ad9\u3002\u9664\u6b64\u4e4b\u5916\uff0c\u8cc7\u6599\u5eab\u4e5f\u80fd\u7576\u4f5c\u4e00\u822c\u696d\u52d9\u53ca\u5546\u52d9\u4f7f\u7528\uff0c\u4f8b\u5982\uff1a\u9032\u92b7\u5b58\u3001\u6821\u52d9\u7cfb\u7d71\u3001\u501f\u66f8\u7cfb\u7d71\u7b49\u3002\u901a\u5e38\u6211\u5011\u4f7f\u7528 SQL \u4f86\u64cd\u4f5c\u8cc7\u6599\u5eab\uff0c\u53ef\u4ee5\u505a\u65b0\u589e\u3001\u4fee\u6539\u3001\u522a\u9664\u3001\u67e5\u8a62\u3002MySQL \u662f\u4e00\u7a2e\u5e38\u898b\u7684\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\uff08DBMS\uff09\uff0c\u672c\u6587\u4e3b\u8ef8\u4e5f\u6703\u662f\u5b83\uff0c\u5b83\u6709 MySQL Workbench \u9019\u500b\u5716\u50cf\u5316\u64cd\u4f5c\u4ecb\u9762\u53ef\u4ee5\u4f7f\u7528\uff0c\u76f8\u7576\u65b9\u4fbf\uff01\ud83d\ude09 <strong>\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab<\/strong>\u662f\u6700\u5e38\u7528\u7684\u8cc7\u6599\u5eab\u985e\u578b\uff0c\u672c\u6587\u4e3b\u8ef8\u4e5f\u662f<strong>\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab<\/strong>\u3002<\/p>\n<h1><span style=\"color: #0000ff;\"><a id=\"ch2\"><\/a>\u4e8c\u3001\u8cc7\u6599\u5eab\uff08DataBase\uff09 &amp; \u8cc7\u6599\u7d50\u69cb\uff08Data Structure\uff09 \u95dc\u4fc2\u662f\u4ec0\u9ebc\uff1f<\/span><\/h1>\n<p>\u8cc7\u6599\u7d50\u69cb\uff08Data Structure\uff09\u662f\u4e00\u7a2e\u5c07\u7d44\u7e54\u8cc7\u6599\u7684\u65b9\u5f0f\uff0c\u4e14\u901a\u5e38\u5b58\u653e\u6216\u8655\u7406\u65bc RAM \u6216\u66ab\u5b58\u8a18\u61b6\u9ad4\uff0c\u800c\u8cc7\u6599\u5eab\uff08DataBase\uff09\u7684\u89c0\u5ff5\u662f\u7d44\u7e54\u7684\u8cc7\u6599\u96c6\u5408\uff0c\u4e26\u5c07\u9019\u4e9b\u8cc7\u6599\u5132\u5b58\u6216\u8655\u7406\u65bc\u6c38\u4e45\u5132\u5b58\u7a7a\u9593\uff08\u786c\u789f\uff09\u3002\u5982\u6709\u5fc5\u8981\uff0c\u8cc7\u6599\u7d50\u69cb\u4e2d\u7684\u8cc7\u6599\u4e5f\u53ef\u4ee5\u4fdd\u5b58\u5230\u8cc7\u6599\u5eab\u4e2d\u6c38\u4e45\u5132\u5b58\u3002<\/p>\n<h1><span style=\"color: #0000ff;\"><a id=\"ch3\"><\/a>\u4e09\u3001\u4f55\u8b02\u6b63\u898f\u5316\uff08Normalization\uff09\uff1f<\/span><strong><span style=\"color: #993300;\"><a style=\"color: #993300;\" href=\"#index\">\u23cf<\/a><\/span><\/strong><\/h1>\n<p>\u5c07\u8cc7\u6599\u8868\u7d30\u5206\u6210\u66f4\u591a\u8868\u683c\uff0c\u8b93\u4e00\u500b\u8868\u683c\u53ea\u9673\u8ff0\u4e00\u7a2e\u4e8b\u5be6\u70ba\u6b62\uff0c\u9019\u4e00\u9023\u4e32\u8abf\u6574\u7684\u52d5\u4f5c\u5c31\u53eb\u505a\u6b63\u898f\u5316\u3002<\/p>\n<p><strong>\u2139\ufe0f \u6b63\u898f\u5316\uff08Normalization\uff09<\/strong><\/p>\n<p>1\ufe0f\u20e3 \u7576\u6210\u9375\u503c\u7684\u6b04\u4f4d\u4e0d\u53ef\u91cd\u8907<br \/>\n2\ufe0f\u20e3 \u8cc7\u6599\u91cd\u8907\u51fa\u73fe\u7684\u6b04\u4f4d\u62c6\u958b\u5230\u53e6\u4e00\u500b table<br \/>\n3\ufe0f\u20e3 \u6b04\u4f4d\u7684\u95dc\u806f\uff08Relation\uff09\u8981\u660e\u78ba<br \/>\n\u2198\ufe0f \u9078\u8ab2\u8cc7\u6599\uff1a\u5b78\u865f(\u9023\u63a5\"\u5b78\u751f\u57fa\u672c\u8cc7\u6599\u8868\")\u3001\u8ab2\u7a0b(\u9023\u63a5\"\u8ab2\u7a0b\u57fa\u672c\u8cc7\u6599\u8868\")<\/p>\n<p><strong>\u2139\ufe0f \u53cd\u6b63\u898f\u5316\uff08Denormalization\uff09<\/strong><\/p>\n<p>\u6b63\u898f\u5316\u53ea\u662f\u5275\u5efa\u8cc7\u6599\u8868\u7684\u539f\u5247\uff0c\u5982\u679c\u904e\u5ea6\u6b63\u898f\u5316\uff0c\u6703\u5c0e\u81f4\u67e5\u8a62\u4f86\u81ea\u65bc\u591a\u500b\u8cc7\u6599\u8868\u7684\u5927\u91cf\u8cc7\u6599\u6642\u9020\u6210\u6548\u80fd\u4e0b\u964d\u3002\u56e0\u6b64\uff0c\u82e5\u8981\u4ee5\u67e5\u8a62\uff08select\uff09\u7684\u6548\u80fd\u70ba\u8003\u91cf\uff0c\u5fc5\u9808\u9032\u884c\u9069\u7576\u7684\u53cd\u6b63\u898f\u5316\uff0c\u5373\u5c07\u539f\u4f86\u7684\u7b2c\u4e09\u6b63\u898f\u5316\u964d\u7d1a\u6210\u7b2c\u4e8c\u6b63\u898f\u5316\uff0c\u6216\u8005\u5c07\u7b2c\u4e8c\u6b63\u898f\u5316\u964d\u7d1a\u6210\u7b2c\u4e00\u6b63\u898f\u5316\u3002<\/p>\n<p><strong>\u2139\ufe0f \u6b63\u898f\u5316\u6b65\u9a5f\uff08\u57fa\u790e\u7b2c\u4e00\u6b63\u898f\u5316\uff5e\u7b2c\u4e09\u6b63\u898f\u5316\uff09<\/strong><\/p>\n<p>\u203b \u5fc5\u9808\u9010\u6b65\u52d5\u4f5c\uff0c\u4e0d\u53ef\u8df3\u904e\u3002<br \/>\n\u203b \u73fe\u5728\u8cc7\u6599\u5eab\u8a2d\u8a08\u6700\u591a\u6eff\u8db3 3NF \u5c31\u5dee\u4e0d\u591a\u8db3\u5920\u4e86\uff01<\/p>\n<p>\u5148\u7d66\u500b<strong>\u521d\u59cb\u7684\u8cc7\u6599\u8868<\/strong>\u505a\u7a0d\u5f8c\u8aaa\u660e\u8207\u8abf\u6574\u7528\uff1a<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>\u5b78\u865f<\/strong><\/td>\n<td><strong>\u59d3\u540d<\/strong><\/td>\n<td><strong>\u73ed\u7d1a<\/strong><\/td>\n<td><strong>\u73ed\u5c0e<\/strong><\/td>\n<td><strong>\u8ab2\u7a0b1<\/strong><\/td>\n<td><strong>\u8ab2\u7a0b2<\/strong><\/td>\n<td><strong>\u8ab2\u7a0b3<\/strong><\/td>\n<\/tr>\n<tr>\n<td>001<\/td>\n<td>\u840c\u840c<\/td>\n<td>\u8cc7\u7ba1\u4e8c\u7532<\/td>\n<td>\u9673\u6559\u6388<\/td>\n<td>A01<\/td>\n<td>A02<\/td>\n<td>A03<\/td>\n<\/tr>\n<tr>\n<td>002<\/td>\n<td>\u82bd\u82bd<\/td>\n<td>\u8cc7\u50b3\u4e00\u4e59<\/td>\n<td>\u9ec3\u6559\u6388<\/td>\n<td>B01<\/td>\n<td>B02<\/td>\n<td>B03<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>1\ufe0f\u20e3 <strong>\u7b2c\u4e00\u6b63\u898f\u5316<\/strong>\uff08First Normal Form, 1NF\uff09<br \/>\n\u6bcf\u500b\u6b04\u4f4d\u53ea\u80fd\u542b\u6709\u4e00\u500b\u503c\uff0c\u8981\u522a\u9664\u91cd\u8907\u7684\u6b04\u4f4d\u3002<\/p>\n<p>\u6839\u64da\u73fe\u6709\u7684\u8cc7\u6599\u8868\uff0c\u5f8c\u9762\u8ab2\u7a0b1~3\u660e\u986f\u91cd\u8907\u6b04\u4f4d\uff0c\u5fc5\u9808\u5148\u8a2d\u6cd5\u79fb\u9664\u6389\u9019\u500b\u72c0\u6cc1\uff0c\u66f4\u6539\u5f8c\u5982\u4e0b\uff1a<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>\u5b78\u865f<\/strong><\/td>\n<td><strong>\u59d3\u540d<\/strong><\/td>\n<td><strong>\u73ed\u7d1a<\/strong><\/td>\n<td><strong>\u73ed\u5c0e<\/strong><\/td>\n<td><strong>\u8ab2\u7a0b#<\/strong><\/td>\n<\/tr>\n<tr>\n<td>001<\/td>\n<td>\u840c\u840c<\/td>\n<td>\u8cc7\u7ba1\u4e8c\u7532<\/td>\n<td>\u9673\u6559\u6388<\/td>\n<td>A01<\/td>\n<\/tr>\n<tr>\n<td>001<\/td>\n<td>\u840c\u840c<\/td>\n<td>\u8cc7\u7ba1\u4e8c\u7532<\/td>\n<td>\u9673\u6559\u6388<\/td>\n<td>A02<\/td>\n<\/tr>\n<tr>\n<td>001<\/td>\n<td>\u840c\u840c<\/td>\n<td>\u8cc7\u7ba1\u4e8c\u7532<\/td>\n<td>\u9673\u6559\u6388<\/td>\n<td>A03<\/td>\n<\/tr>\n<tr>\n<td>002<\/td>\n<td>\u82bd\u82bd<\/td>\n<td>\u8cc7\u50b3\u4e00\u4e59<\/td>\n<td>\u9ec3\u6559\u6388<\/td>\n<td>B01<\/td>\n<\/tr>\n<tr>\n<td>002<\/td>\n<td>\u82bd\u82bd<\/td>\n<td>\u8cc7\u50b3\u4e00\u4e59<\/td>\n<td>\u9ec3\u6559\u6388<\/td>\n<td>B02<\/td>\n<\/tr>\n<tr>\n<td>002<\/td>\n<td>\u82bd\u82bd<\/td>\n<td>\u8cc7\u50b3\u4e00\u4e59<\/td>\n<td>\u9ec3\u6559\u6388<\/td>\n<td>B03<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>2\ufe0f\u20e3 <strong>\u7b2c\u4e8c\u6b63\u898f\u5316<\/strong>\uff08Second Normal Form, 2NF\uff09<br \/>\n\u8cc7\u6599\u8868\u5fc5\u9808\u6eff\u8db3\u7b2c\u4e00\u6b63\u898f\u5316\u689d\u4ef6\uff0c\u4e14\u975e\u4e3b\u9375\u6b04\u4f4d\u5fc5\u9808\u90fd\u8981\u5c0d\u4e3b\u9375\u6709\u300c\u5b8c\u5168\u5730\u529f\u80fd\u6027\u76f8\u4f9d\u300d\u3002\u6bcf\u500b\u975e\u4e3b\u9375\u5c6c\u6027\u5fc5\u9808\u7368\u7acb\u65bc\u4efb\u610f\u4e00\u500b\u5019\u9078\u9375\u7684\u4efb\u610f\u4e00\u90e8\u5206\u5c6c\u6027\u3002\u5982\u679c\u6709\u54ea\u4e9b\u8cc7\u6599\u53ea\u548c\u4e00\u500b\u9375\u7684\u4e00\u90e8\u4efd\u6709\u95dc\u7684\u8a71\uff0c\u5c31\u5f97\u628a\u5b83\u5011\u7368\u7acb\u51fa\u4f86\u8b8a\u6210\u53e6\u4e00\u500b\u8cc7\u6599\u8868\u3002<\/p>\n<p>\u6839\u64da\u73fe\u5728\u7684\u8cc7\u6599\u8868\uff0c\u8981\u8abf\u6574\u91cd\u8907\u7684\u8cc7\u6599\uff0c\u8abf\u6574\u7d50\u679c\u5982\u4e0b\uff1a<\/p>\n<p>1. \u5b78\u751f\uff1a<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>\u5b78\u865f<\/strong><\/td>\n<td><strong>\u59d3\u540d<\/strong><\/td>\n<td><strong>\u73ed\u7d1a<\/strong><\/td>\n<td><strong>\u73ed\u5c0e<\/strong><\/td>\n<\/tr>\n<tr>\n<td>001<\/td>\n<td>\u840c\u840c<\/td>\n<td>\u8cc7\u7ba1\u4e8c\u7532<\/td>\n<td>\u9673\u6559\u6388<\/td>\n<\/tr>\n<tr>\n<td>002<\/td>\n<td>\u82bd\u82bd<\/td>\n<td>\u8cc7\u50b3\u4e00\u4e59<\/td>\n<td>\u9ec3\u6559\u6388<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>2. \u9078\u8ab2\uff1a<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>\u5b78\u865f<\/strong><\/td>\n<td><strong>\u8ab2\u7a0b#<\/strong><\/td>\n<\/tr>\n<tr>\n<td>001<\/td>\n<td>A01<\/td>\n<\/tr>\n<tr>\n<td>001<\/td>\n<td>A02<\/td>\n<\/tr>\n<tr>\n<td>001<\/td>\n<td>A03<\/td>\n<\/tr>\n<tr>\n<td>002<\/td>\n<td>B01<\/td>\n<\/tr>\n<tr>\n<td>002<\/td>\n<td>B02<\/td>\n<\/tr>\n<tr>\n<td>002<\/td>\n<td>B03<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>3\ufe0f\u20e3 <strong>\u7b2c\u4e09\u6b63\u898f\u5316<\/strong>\uff08Third normal form, 3NF\uff09<br \/>\n\u8cc7\u6599\u8868\u5fc5\u9808\u6eff\u8db3\u7b2c\u4e00\u6b63\u898f\u5316\u8207\u7b2c\u4e8c\u6b63\u898f\u5316\u689d\u4ef6\uff0c\u4e14\u975e\u4e3b\u9375\u6b04\u4f4d\u4e4b\u9593\u6c92\u6709\u300c\u5b8c\u5168\u5730\u529f\u80fd\u6027\u76f8\u4f9d\u300d\uff0c\u4e5f\u5c31\u662f\u8aaa\u975e\u4e3b\u9375\u5c6c\u6027\u4e4b\u9593\u61c9\u8a72\u662f\u7368\u7acb\u7121\u95dc\u7684\u3002<\/p>\n<p>\u6839\u64da\u73fe\u6709\u7684\u8cc7\u6599\u8868\uff0c\u6211\u5011\u8981\u522a\u9664\u4e0d\u4f9d\u8cf4\u7d22\u5f15\u9375\u7684\u8cc7\u6599\uff1a<\/p>\n<p>1. \u5b78\u751f\uff1a<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>\u5b78\u865f<\/strong><\/td>\n<td><strong>\u59d3\u540d<\/strong><\/td>\n<td><strong>\u73ed\u7d1a<\/strong><\/td>\n<\/tr>\n<tr>\n<td>001<\/td>\n<td>\u840c\u840c<\/td>\n<td>\u8cc7\u7ba1\u4e8c\u7532<\/td>\n<\/tr>\n<tr>\n<td>002<\/td>\n<td>\u82bd\u82bd<\/td>\n<td>\u8cc7\u50b3\u4e00\u4e59<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>2. \u73ed\u7d1a\u8cc7\u6599\uff1a<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>\u73ed\u7d1a<\/strong><\/td>\n<td><strong>\u73ed\u5c0e<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u7ba1\u4e8c\u7532<\/td>\n<td>\u9673\u6559\u6388<\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u50b3\u4e00\u4e59<\/td>\n<td>\u9ec3\u6559\u6388<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u9019\u6a23\u5c31\u5b8c\u6210\u4e09\u500b\u6b63\u898f\u5316\u5566\uff01\u5207\u8a18\u9019\u53ea\u662f\u751f\u6210\u8cc7\u6599\u8868\u7684\u539f\u5247\u4e26\u975e\u898f\u5b9a\u5537\uff01<\/p>\n<p>\u203b <strong>Boyce-Codd\uff08Boyce-Codd normal form\uff0c\u7e2e\u5beb BCNF\uff09<\/strong>\uff0c\u662f\u8cc7\u6599\u5eab\u898f\u683c\u5316\u7684\u4e00\u7a2e\u6b63\u898f\u5f62\u5f0f\u3002\u662f\u5728\u7b2c\u4e09\u6b63\u898f\u5316\u7684\u57fa\u790e\u4e0a\u52a0\u4e0a\u7a0d\u5fae\u66f4\u56b4\u683c\u7d04\u675f\uff0c\u6bcf\u500b BCNF \u95dc\u4fc2\u90fd\u6eff\u8db3\u7b2c\u4e09\u6b63\u898f\u5316\u3002BCNF \u53bb\u9664\u4e86\u5c6c\u6027\u9593\u7684\u4e0d\u5fc5\u8981\u7684\u51fd\u5f0f\u4f9d\u8cf4\u3002\u7c21\u55ae\u4f86\u8aaa\uff0c\u6eff\u8db3 3NF \u4e26\u4e14\u6bcf\u500b\u6c7a\u5b9a\u6027\u5c6c\u6027\u90fd\u662f\u5019\u9078\u9375\u5c31\u662f\u7b26\u5408 BCNF\u3002<\/p>\n<p>\u203b \u88dc\u5145\uff1a<strong>\u6c7a\u5b9a\u6027\u5c6c\u6027\uff08Determinant\uff09<\/strong>\u7684\u503c\u5177\u6709\u4e0d\u91cd\u8907\u6027\uff0c\u4e14\u53ef\u6c7a\u5b9a\u6240\u6709\u5176\u4ed6\u5c6c\u6027\u7684\u503c\u3002<\/p>\n<h1><span style=\"color: #0000ff;\"><a id=\"ch4\"><\/a>\u56db\u3001\u9375\u503c\uff08Keys\uff09<\/span><strong><span style=\"color: #993300;\"><a style=\"color: #993300;\" href=\"#index\">\u23cf<\/a><\/span><\/strong><\/h1>\n<p>\u95dc\u4fc2\u9375\uff08\u9019\u88e1\u8aaa\u7684\u9375\u503c\uff09\u662f\u4e00\u500b\u8868\u4e2d\u7684\u4e00\u500b\u6216\u5e7e\u500b\u5c6c\u6027\uff0c\u662f\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7684\u91cd\u8981\u7d44\u6210\u90e8\u5206\u3002<\/p>\n<p><strong>\u4e3b\u9375\uff08Primary Key\uff09<\/strong><br \/>\n\u8cc7\u6599\u5eab\u8868\u4e2d\u5c0d\u5132\u5b58\u8cc7\u6599\u7269\u4ef6\u4e88\u4ee5\u552f\u4e00\u548c\u5b8c\u6574\u6a19\u8b58\u7684\u8cc7\u6599\u5217\u6216\u5c6c\u6027\u7684\u7d44\u5408\u3002\u4e00\u500b\u8cc7\u6599\u8868\u53ea\u80fd\u6709\u4e00\u500b\u4e3b\u9375\uff0c\u4e14\u4e3b\u9375\u7684\u53d6\u503c\u4e0d\u80fd\u70ba\u7a7a\u503c\uff08Null\uff09\u3002<br \/>\n\u203b \u7368\u4e00\u7d22\u5f15\uff08Unique key\uff09\u662f VFP \u70ba\u4e86\u8207\u820a\u7248\u76f8\u5bb9\u800c\u8a2d\u8a08\u7684\u3002<br \/>\nEx: \u8eab\u5206\u8b49\u5b57\u865f\u3001\u5b78\u865f\u7b49\u3002<\/p>\n<p><strong>\u8d85\u9375\uff08Super Key\uff09<\/strong><br \/>\n\u8cc7\u6599\u5eab\u95dc\u806f\u5f0f\u8a2d\u8a08\u4e2d\u80fd\u5920\u552f\u4e00\u6a19\u793a\u591a\u5143\u7d44\uff08\u5373\u300c\u884c\u300d\uff09\u7684\u5c6c\u6027\u96c6\uff0c\u5373\u6210\u70ba\u8d85\u9375\u5fc5\u8981\u7b26\u5408\u552f\u4e00\u6027\u3002<\/p>\n<p><strong>\u5019\u9078\u9375\uff08Candidate Key\uff09<\/strong><br \/>\n\u6210\u70ba\u5019\u9078\u9375\u5fc5\u8981\u7b26\u5408\u552f\u4e00\u6027\u8207\u6700\u5c0f\u6027\uff0c\u4e14\u6bcf\u500b\u9375\u503c\u90fd\u53ea\u80fd\u5c0d\u61c9\u81f3\u552f\u4e00\u7684\u4e00\u7b46\u8a18\u9304\u3002\u5019\u9078\u9375\u70ba\u6c7a\u5b9a\u6027\u5c6c\u6027\uff08Determinant\uff09\uff0c\u7528\u65bc\u78ba\u5b9a\u6240\u6709\u5176\u4ed6\u6b04\u4f4d\u4e4b\u9593\u7684\u95dc\u4fc2\u3002<br \/>\nEx: \u8eab\u5206\u8b49\u5b57\u865f\u3001\u5b78\u865f\ufe51\u59d3\u540d\uff08\u5047\u8a2d\u7121\u540c\u540d\u540c\u59d3\u8005\uff09<br \/>\n\u27a1 \u5019\u9078\u9375 = \u4e3b\u9375 + \u4ea4\u66ff\u9375<\/p>\n<p><strong>\u66ff\u4ee3\u9375\uff08Alternate Key\uff09<\/strong><br \/>\n\u5728\u5019\u9078\u9375\u4e2d\u4e0d\u662f\u4e3b\u9375\u7684\u5176\u4ed6\u5019\u9078\u9375\u90fd\u662f\u66ff\u4ee3\u9375\u3002<\/p>\n<p><strong>\u5916\u90e8\u9375\u3001\u5916\u9375\uff08Foreign Key\uff09<\/strong><br \/>\n\u63a5\u6536\u7531\u53e6\u4e00\u500b\u8cc7\u6599\u8868\u7684\u4e3b\u9375\u50b3\u4f86\u7684\u8cc7\u6599\uff0c\u63db\u53e5\u8a71\u8aaa\uff0c\u8cc7\u6599\u8868\u88e1\u7684\u67d0\u4e00\u6b04\uff0c\u5b83\u53c3\u7167\u5230\u53e6\u4e00\u500b\u8cc7\u6599\u8868\u7684\u4e3b\u9375\u3002<\/p>\n<p><strong>\u6b21\u8981\u9375\u3001\u6b21\u9375\uff08Secondary Key\uff09<\/strong><br \/>\n\u5019\u9078\u9375\u4e4b\u5916\u7684\u9375\u503c\uff0c\u4e3b\u8981\u7684\u529f\u80fd\u662f\u63d0\u4f9b\u8cc7\u6599\u7d22\u5f15\u3002<\/p>\n<p><strong>\u4ee3\u7406\u9375\uff08Surrogate Key\uff09<\/strong><br \/>\n\u7576\u8cc7\u6599\u8868\u4e2d\u7684\u5019\u9078\u9375\u90fd\u4e0d\u9069\u5408\u7576\u4e3b\u9375\u6642\uff0c\u4f8b\u5982\u8cc7\u6599\u592a\u9577\uff0c\u6216\u662f\u610f\u7fa9\u5c64\u9762\u592a\u591a\uff0c\u5c31\u6703\u8acb\u4e00\u500b\u7121\u610f\u7fa9\u7684\u4f46\u552f\u4e00\u7684\u6b04\u4f4d\u4f86\u4ee3\u70ba\u4f5c\u4e3b\u9375\u3002<\/p>\n<p><strong>\u81ea\u7136\u9375\uff08Natural Key\uff09<\/strong><br \/>\n\u8207\u4ee3\u7406\u9375\u76f8\u53cd\uff0c\u5b83\u662f\u5728\u81ea\u7136\u751f\u6d3b\u4e2d\u552f\u4e00\u78ba\u5b9a\u4e00\u500b\u4e8b\u7269\u7684\u6a19\u8b58\uff08\u4ee3\u865f\uff09\u3002\u8eab\u5206\u8b49\u865f\uff08\u5047\u8a2d\u7d55\u7121\u91cd\u8907\uff09\u5c31\u662f\u4e00\u500b\u81ea\u7136\u9375\uff0c\u7528\u65bc\u78ba\u5b9a\u4e00\u500b\u4eba\u3002<\/p>\n<p><strong>\u8907\u5408\u9375\uff08Composite Key\uff09<\/strong><br \/>\n\u82e5\u7121\u5019\u9078\u9375\uff0c\u53ef\u7531\u591a\u500b\u6b04\u4f4d\u5408\u8d77\u4f86\u7d44\u6210\u4e00\u500b\u9375\u503c\uff0c\u4e14\u80fd\u5c0d\u61c9\u81f3\u552f\u4e00\u7684\u4e00\u7b46\u8a18\u9304\u3002<\/p>\n<h1><span style=\"color: #0000ff;\"><a id=\"ch5\"><\/a>\u4e94\u3001\u8cc7\u6599\u5eab\u9818\u57df\u7684\u5e38\u898b\u554f\u984c <\/span><strong><span style=\"color: #993300;\"><a style=\"color: #993300;\" href=\"#index\">\u23cf<\/a><\/span><\/strong><\/h1>\n<p>\u8ab2\u672c\u7fd2\u984c\u5217\u5165\u6211\u5011\u671f\u4e2d\u8003\u7bc4\u570d\uff0c\u56e0\u6b64\u6211\u5c31\u81ea\u884c\u5c07\u8ab2\u672c\u7fd2\u984c\u4e2d\u7684\u984c\u76ee\u7ffb\u8b6f\u6210\u4e2d\u6587\uff0c\u53ea\u5c07\u81ea\u5df1\u89ba\u5f97\u91cd\u8981\u7684\u63d0\u554f\u63d0\u51fa\u4f86\uff0c\u7b54\u6848\u6709\u53c3\u8003\u7db2\u8def\u8cc7\u6599\u89e3\u7b54\uff0c\u4f46\u901a\u901a\u90fd\u6709\u7d93\u904e\u6211\u7684\u7406\u89e3\u8207\u4fee\u6b63\u5537\uff01\u50c5\u4f9b\u53c3\u8003\u3002<\/p>\n<p><strong>Q1\uff1a<\/strong>\u7576\u591a\u500b\u7528\u6236\u540c\u6642\u8655\u7406\u8cc7\u6599\u5eab\u6642\u53ef\u80fd\u6703\u51fa\u73fe\u4ec0\u9ebc\u554f\u984c\uff1f<br \/>\n<strong>A1\uff1a<\/strong>\u7576\u4e00\u500b\u8cc7\u6599\u5eab\u7531\u591a\u500b\u7528\u6236\u540c\u6642\u4f7f\u7528\u6642\uff0c\u4e00\u500b\u7528\u6236\u7684\u5de5\u4f5c\u53ef\u80fd\u6703\u5e72\u64fe\u53e6\u4e00\u500b\u7528\u6236\u7684\u5de5\u4f5c\u3002\u7ba1\u7406\u591a\u7528\u6236\u8cc7\u6599\u5eab\u53ef\u8aaa\u662f\u76f8\u7576\u91cd\u8981\u3002<\/p>\n<p><strong>Q2\uff1a<\/strong>\u70ba\u4f55<span style=\"color: #ff0000;\">\u6578\u4f4d\u5100\u8868\u677f\uff08Digital dashboard\uff09<\/span>\u548c<span style=\"color: #ff0000;\">\u8cc7\u6599\u63a2\u52d8\u7a0b\u5f0f\uff08Data mining applications\uff09<\/span>\u4e0d\u540c\u65bc<span style=\"color: #ff0000;\">\u4ea4\u6613\u8655\u7406\u7a0b\u5f0f\uff08Transaction processing applications\uff09<\/span>\uff1f<br \/>\n<strong>A2\uff1a<\/strong>\u6578\u4f4d\u5100\u8868\u677f\u548c\u8cc7\u6599\u63a2\u52d8\u7a0b\u5f0f\u4e0d\u6703\u751f\u6210\u65b0\u8cc7\u6599\uff0c\u800c\u662f\u7528\u65bc\u532f\u7e3d\u73fe\u6709\u8cc7\u6599\u4ee5\u5411\u7ba1\u7406\u8005\u63d0\u4f9b\u6709\u7528\u7684\u8a0a\u606f\u3002<\/p>\n<p><strong>Q3\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u7d50\u69cb\u5316\u67e5\u8a62\u8a9e\u8a00\uff08SQL\uff09<\/span>\uff0c\u70ba\u4ec0\u9ebc\u5b83\u5f88\u91cd\u8981\uff1f<br \/>\n<strong>A3\uff1a<\/strong>SQL \u662f\u4e00\u7a2e\u7279\u5b9a\u76ee\u7684\u7a0b\u5f0f\u8a9e\u8a00\uff0c\u7528\u65bc\u7ba1\u7406\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\uff0c\u5b83\u662f\u4e00\u500b\u570b\u969b\u516c\u8a8d\u7684\u6a19\u6e96\u8a9e\u8a00\u3002<\/p>\n<p><strong>Q4\uff1a<\/strong>DBMS \u4ee3\u8868\u4ec0\u9ebc\uff1f<br \/>\n<strong>A4\uff1a<\/strong><span style=\"color: #ff0000;\">D<\/span>ata<span style=\"color: #ff0000;\">B<\/span>ase <span style=\"color: #ff0000;\">M<\/span>anagement <span style=\"color: #ff0000;\">S<\/span>ystem\uff0c\u7e2e\u5beb\uff1a<span style=\"color: #ff0000;\">DBMS<\/span>\uff0c\u4e2d\u6587\u70ba\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\uff0c\u5982\uff1aMySQL \u7b49\u3002<\/p>\n<p><strong>Q5\uff1a<\/strong>DBMS \u7684\u529f\u80fd\u662f\u4ec0\u9ebc\uff1f<br \/>\n<strong>A5\uff1a<\/strong>DBMS \u7528\u65bc\u5275\u5efa\u3001\u8655\u7406\u548c\u7ba1\u7406\u5b83\u63a7\u5236\u4e0b\u7684\u8cc7\u6599\u5eab\u3002<\/p><div class=\"3a456c955cc9861673f62d33beb7714e\" data-index=\"2\" style=\"float: none; margin:0px;\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2683739050533486\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-2683739050533486\"\r\n     data-ad-slot=\"3270345536\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<p><strong>Q6\uff1a<\/strong>\u7c21\u55ae\u5217\u51fa\u4e94\u500b DBMS \u7522\u54c1\uff1f<br \/>\n<strong>A6\uff1a<\/strong>\u6709\u4e09\u500b DBMS \u7522\u54c1\u4f9b\u61c9\u5546\uff1a<span style=\"color: #ff0000;\">Microsoft<\/span>\uff08Microsoft Access \u548c SQL Server\uff09\uff0c<span style=\"color: #ff0000;\">Oracle Corporation<\/span>\uff08Oracle \u8cc7\u6599\u5eab\u548c MySQL\uff09\u548c <span style=\"color: #ff0000;\">IBM<\/span>\uff08DB2\uff09\u3002<\/p>\n<p><strong>Q7\uff1a<\/strong><span style=\"color: #ff0000;\">\u8cc7\u6599\u5eab\uff08DataBase\uff09<\/span>\u8207<span style=\"color: #ff0000;\">\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\uff08DBMS\uff09<\/span>\u6709\u4f55\u4e0d\u540c\u5462\uff1f<br \/>\n<strong>A7\uff1a<\/strong>\u8cc7\u6599\u5eab\u662f\u500b\u5132\u5b58\u8cc7\u6599\u7684\u5730\u65b9\uff0c\u4f46\u662f\u5982\u679c\u53ea\u662f\u5c07\u8cc7\u6599\u5132\u5b58\u5230\u96fb\u8166\u6216\u4f3a\u670d\u5668\u4e2d\uff0c\u5176\u6548\u7528\u4e26\u4e0d\u5927\uff0c\u56e0\u6b64\uff0c\u6211\u5011\u9084\u9700\u8981\u6709\u4e00\u5957\u80fd\u5920\u5e6b\u52a9\u6211\u5011\u66f4\u65b9\u4fbf\u5730\u7ba1\u7406\u53ca\u64cd\u4f5c\u8cc7\u6599\u5eab\u5167\u8cc7\u6599\u7684\u8edf\u9ad4\uff0c\u9019\u500b\u8edf\u9ad4\u5c31\u662f\u6240\u8b02\u7684<span style=\"color: #ff0000;\">\u300c\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\uff08DBMS\uff09\u300d<\/span>\u3002<\/p>\n<p><strong>Q8\uff1a<\/strong>\u70ba\u4ec0\u9ebc\u8cc7\u6599\u5eab\u88ab\u8a8d\u70ba\u662f<span style=\"color: #ff0000;\">\u81ea\u63cf\u8ff0\uff08Self-Describing\uff09<\/span>\u7684\uff1f<br \/>\n<strong>A8\uff1a<\/strong>\u8cc7\u6599\u5eab\u88ab\u8a8d\u70ba\u662f\u81ea\u63cf\u8ff0\u7684\uff0c\u56e0\u70ba\u5b83\u5305\u542b\u5c0d\u81ea\u8eab\u7684\u63cf\u8ff0\uff0c\u8209\u4f8b\u4f86\u8aaa\uff0c\u8cc7\u6599\u5eab\u4e2d\u7684\u8cc7\u6599\u8868\uff0c\u6bcf\u500b\u8868\u4e2d\u7684\u5217\u4ee5\u53ca\u6bcf\u5217\u4e2d\u5132\u5b58\u7684\u8cc7\u6599\u985e\u578b\u3002<\/p>\n<p><strong>Q9\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u5143\u8cc7\u6599\uff08metadata\uff09<\/span>\uff1f \u8a72\u8853\u8a9e\u8207\u8cc7\u6599\u5eab\u6709\u4f55\u95dc\u4fc2\uff1f<br \/>\n<strong>A9\uff1a<\/strong>\u5143\u8cc7\u6599\uff0c\u82f1\u6587\u70ba metadata\uff0c\u9084\u88ab\u7ffb\u8b6f\u6210<span style=\"color: #ff0000;\">\u300c\u8a6e\u91cb\u8cc7\u6599\u300d<\/span>\uff0c\u5b83\u662f\u63cf\u8ff0\u5176\u4ed6\u8cc7\u6599\u7684\u8cc7\u6599\uff0c\u5176\u5be6\u5c31\u662f\u76f4\u6307\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\u4e4b\u7db1\u8981\uff08schema\uff09\u3002<\/p>\n<p><strong>Q10\uff1a<\/strong>\u5728\u8cc7\u6599\u8868\u4e2d\u5132\u5b58\u5143\u8cc7\u6599\uff08metadata\uff09\u6709\u4ec0\u9ebc\u597d\u8655\uff1f<br \/>\n<strong>A10\uff1a<\/strong>\u5728\u8cc7\u6599\u8868\u4e2d\u5132\u5b58\u5143\u8cc7\u6599\u7684\u512a\u9ede\u662f\u6211\u5011\u53ef\u4ee5\u67e5\u8a62\u5143\u8cc7\u6599\u4ee5\u78ba\u5b9a\u8cc7\u6599\u5eab\u7684\u7d50\u69cb\u3002<\/p>\n<p><strong>Q11\uff1a<\/strong>\u8cc7\u6599\u5eab\u61c9\u7528\u7a0b\u5f0f\u4f7f\u7528\u7684<span style=\"color: #ff0000;\">\u8a9e\u8a00<\/span>\u662f\u4ec0\u9ebc\uff1f<br \/>\n<strong>A11\uff1a<\/strong><span style=\"color: #ff0000;\">Structured Query Language\uff08SQL\uff09<\/span>\uff0c\u5373\u7d50\u69cb\u5316\u67e5\u8a62\u8a9e\u8a00\u3002<\/p>\n<p><strong>Q12\uff1a<\/strong>\u5b9a\u7fa9<span style=\"color: #ff0000;\">\u8cc7\u6599\u5eab\u8a2d\u8a08<\/span>\uff1f<br \/>\n<strong>A12\uff1a<\/strong>\u4f9d\u64da\u8cc7\u6599\u5eab\u6a21\u578b\u7d44\u7e54\u8cc7\u6599\uff0c\u8a2d\u8a08\u8005\u5fc5\u9808\u78ba\u5b9a\u5132\u5b58\u54ea\u4e9b\u8cc7\u6599\u4ee5\u53ca\u8cc7\u6599\u5143\u7d20\u5011\u5982\u4f55\u76f8\u4e92\u95dc\u806f\u3002\u6709\u4e86\u9019\u4e9b\u8a0a\u606f\uff0c\u5b83\u5011\u5c31\u53ef\u4ee5\u958b\u59cb\u5c07\u8cc7\u6599\u8207\u8cc7\u6599\u5eab\u6a21\u578b\u76f8\u5339\u914d\u3002<\/p>\n<p><strong>Q13\uff1a<\/strong>\u63d0\u4f9b\u5169\u500b\u65b9\u6cd5\u8b93\u5df2\u5b58\u5728\u7684\u8cc7\u6599\u53ef\u4ee5\u751f\u6210\uff08\u8a2d\u8a08\uff09\u8cc7\u6599\u5eab\u3002<br \/>\n<strong>A13\uff1a<\/strong>\uff08\u4e00\uff09\u4f7f\u7528\u4f86\u81ea\u975e\u8cc7\u6599\u5eab\u7684\u4f86\u6e90\uff08\u5982\u96fb\u5b50\u8868\u683c\u6216\u6587\u672c\u6587\u4ef6\uff09\u7684\u8cc7\u6599\uff0f\uff08\u4e8c\uff09\u5c07\u73fe\u6709\u8cc7\u6599\u5eab\u4e2d\u7684\u8cc7\u6599\u63d0\u53d6\u51fa\u4f86\u3002<\/p>\n<p><strong>Q14\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u8cc7\u6599\u5009\u5132\uff08Data Warehouse\uff09<\/span>\uff1f\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u8cc7\u6599\u5e02\u96c6\uff08\u82f1\u8a9e\uff1aData Mart\uff09<\/span>\uff1f<br \/>\n<strong>A14\uff1a<\/strong>\u8cc7\u6599\u5009\u5132\u662f\u4e00\u7a2e\u8cc7\u8a0a\u7cfb\u7d71\u7684\u8cc7\u6599\u5132\u5b58\u7406\u8ad6\uff0c\u6b64\u7406\u8ad6\u5f37\u8abf\u5229\u7528\u67d0\u4e9b\u7279\u6b8a\u8cc7\u6599\u5132\u5b58\u65b9\u5f0f\uff0c\u8b93\u6240\u5305\u542b\u7684\u8cc7\u6599\uff0c\u7279\u5225\u6709\u5229\u65bc\u5206\u6790\u8655\u7406\uff0c\u4ee5\u7522\u751f\u6709\u50f9\u503c\u7684\u8cc7\u8a0a\u4e26\u4f9d\u6b64\u4f5c\u6c7a\u7b56\u3002\u8cc7\u6599\u5e02\u96c6\u662f\u8cc7\u6599\u5009\u5132\uff08Data Warehouse\uff09\u7684\u4e00\u7a2e\u7279\u6b8a\u5f62\u5f0f\uff0c\u901a\u5e38\u5177\u6709\u7279\u5b9a\u65bc\u67d0\u500b\u4e3b\u984c\u7684\u7248\u672c\u3002<\/p>\n<p><strong>Q15\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u8cc7\u6599\u5eab\u96c6\u6210\uff08Database Integration\uff09<\/span>\uff1f<br \/>\n<strong>A15\uff1a<\/strong>\u8cc7\u6599\u5eab\u96c6\u6210\u662f\u5c07\u4e0d\u540c\u4f86\u6e90\u8207\u683c\u5f0f\u7684\u8cc7\u6599\u5eab\u4ee5\u908f\u8f2f\u4e0a\u6216\u7269\u7406\u4e0a\u9032\u884c\u96c6\u6210\uff08\u5408\u4f75\uff09\u7684\u904e\u7a0b\u3002<\/p>\n<p><strong>Q16\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u8cc7\u6599\u5eab\u9077\u79fb\uff08Database Migration\uff09<\/span>\uff1f<br \/>\n<strong>A16\uff1a<\/strong>\u8cc7\u6599\u5eab\u9077\u79fb\u662f\u5c07\u4e00\u500b\u96fb\u8166\u5132\u5b58\u7a7a\u9593\u7684\u8cc7\u6599\u5eab\u85c9\u7531\u9078\u64c7\u3001\u6e96\u5099\u3001\u63d0\u53d6\u548c\u6c38\u4e45\u8f49\u63db\u8cc7\u6599\uff0c\u4e26\u5c07\u5176\u50b3\u8f38\u5230\u53e6\u4e00\u500b\u96fb\u8166\u5132\u5b58\u7a7a\u9593\u7684\u904e\u7a0b\u3002<\/p>\n<p><strong>Q17\uff1a<\/strong>\u5217\u51fa\u4e09\u500b\u65e9\u671f\u7684\u500b\u4eba\u96fb\u8166 DBMS \u7522\u54c1\u3002<br \/>\n<strong>A17\uff1a<\/strong>dBase\u3001R:base \u548c Paradox\u3002<\/p>\n<p><strong>Q18\uff1a<\/strong>\u4ec0\u9ebc\u662f <span style=\"color: #ff0000;\">OODBMS<\/span>\uff1f<br \/>\n<strong>A18\uff1a<\/strong><span style=\"color: #ff0000;\">Object-Oriented Database Management System<\/span>\uff0c\u5373<span style=\"color: #ff0000;\">\u7269\u4ef6\u5c0e\u5411\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71<\/span>\u3002<\/p>\n<p><strong>Q19\uff1a<\/strong><span style=\"color: #ff0000;\">OODBMS<\/span> \u7522\u54c1\u70ba\u4f55<span style=\"color: #ff0000;\">\u4e0d\u6210\u529f<\/span>\u7684\u539f\u56e0\uff1f<br \/>\n<strong>A19\uff1a<\/strong>OODBMS \u7522\u54c1\u4e26\u4e0d\u6210\u529f\uff0c\u56e0\u70ba\uff1a\uff08\u4e00\uff09\u5c07\u4ee5\u95dc\u4fc2\u683c\u5f0f\u5132\u5b58\u8f49\u63db\u70ba\u7269\u4ef6\u5c0e\u5411\u683c\u5f0f\u7684\u8cc7\u6599\u6210\u672c\u5f88\u9ad8\uff0f\uff08\u4e8c\uff09OODBMS \u7522\u54c1\u76f8\u5c0d\u65bc\u5546\u696d\u8cc7\u6599\u8655\u7406\u7684\u95dc\u806f\u5f0f DBMS \u7522\u54c1\u7f3a\u4e4f\u5be6\u8cea\u6027\u512a\u52e2\u3002<\/p>\n<p><strong>Q20\uff1a<\/strong><span style=\"color: #ff0000;\">HTTP<\/span> \u7684\u54ea\u4e9b\u7279\u5fb5\u662f\u8cc7\u6599\u5eab\u8655\u7406\u7a0b\u5f0f\u9700\u8981\u6ce8\u610f\u7684\uff1f<br \/>\n<strong>A20\uff1a<\/strong><span style=\"color: #ff0000;\">HTTP \u662f\u7121\u72c0\u614b\u7684\u5354\u5b9a<\/span>\uff0c\u9019\u610f\u5473\u8457 HTTP \u4e0d\u7dad\u8b77\u5ba2\u6236\u7aef\u548c\u670d\u52d9\u5668\u4e4b\u9593\u7684\u7db2\u8def\u9023\u7dda\u3002\u8a31\u591a\u8cc7\u6599\u5eab\u7684\u4ea4\u4e92\u662f\u591a\u968e\u6bb5\u7684\uff0c\u9700\u8981\u5ba2\u6236\u7aef\u548c\u670d\u52d9\u5668\u4e4b\u9593\u7684\u9023\u7e8c\u9023\u7dda\u3002<\/p>\n<p><strong>Q21\uff1a<\/strong>\u4ec0\u9ebc\u662f <span style=\"color: #ff0000;\">XML<\/span>\uff1f\u6bd4\u723e\u00b7\u84cb\u8332\u5c0d XML \u6709\u4f55\u8a55\u8ad6\uff1f<br \/>\n<strong>A21\uff1a<\/strong>XML \u662f HTML \u7684\u4e00\u7a2e\u8b8a\u5f62\uff0c\u76ee\u7684\u5728\u514b\u670d\u4f7f\u7528 HTML \u4ea4\u63db\u6587\u672c\u6240\u7522\u751f\u7684\u56fa\u6709\u554f\u984c\u3002\u6bd4\u723e\u00b7\u84cb\u8332\u8aaa\uff1a\u300cXML \u662f\u7db2\u969b\u7db2\u8def\u6642\u4ee3\u7684\u901a\u7528\u8a9e\u8a00\u300d\u3002<br \/>\n\uff08\u840c\u82bd\u7ad9\u9577\u63d2\u5634\uff1a\u4f46\u5be6\u969b\u4e0a\u56e0\u70ba\u6574\u500b\u7db2\u9801\u8207\u700f\u89bd\u5668\u7684\u767c\u5c55\uff0cXML \u4e26\u672a\u6210\u70ba\u4e3b\u6d41\uff0c\u73fe\u5728\u4e3b\u6d41\u7db2\u9801\u63a1\u7528\u7684\u7686\u662f HTML\uff09<\/p>\n<p><strong>Q22\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\"> NoSQL \u904b\u52d5<\/span>\uff1f\u8209\u4f8b\u4f9d\u8cf4 NoSQL \u8cc7\u6599\u5eab\u7684\u61c9\u7528\u3002<br \/>\n<strong>A22\uff1a<\/strong>NoSQL \u904b\u52d5\u5be6\u969b\u4e0a\u662f\u4e00\u500b\u300c\u4e0d\u50c5\u662f\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\uff08Not Only Relational Database\uff09\u300d\u904b\u52d5\uff0c\u56e0\u70ba\u5b83\u63d0\u5021\u4e0d\u540c\u65bc\u95dc\u806f\u5f0f\u7684\u8cc7\u6599\u5eab\u8a2d\u8a08\u3002Facebook \u548c Twitter \u5c31\u662f\u4f7f\u7528 NoSQL \u8cc7\u6599\u5eab\uff0c\u73fe\u5728\u8a31\u591a\u7d44\u7e54\u90fd\u4f7f\u7528 SQL \u548c NoSQL \u8cc7\u6599\u5eab\u3002<\/p>\n<p><strong>Q23\uff1a<\/strong>\u8209\u5169\u500b<span style=\"color: #ff0000;\">\u975e\u95dc\u806f\u5f0f\u8cc7\u6599\u8868<\/span>\u7684\u4f8b\u5b50\u3002<br \/>\n<strong>A23\uff1a<\/strong>\u9019\u908a\u5c31\u76f4\u63a5\u8209\u4f8b\u5566\uff01<br \/>\n1\ufe0f\u20e3 <span style=\"color: #ff0000;\">\u8ab2\u672c (ISBN, \u66f8\u540d, \u4f5c\u8005)<\/span><br \/>\n\u53ea\u8981\u4f5c\u8005\u6b04\u4f4d\u5167\u6709\u591a\u500b\u4f5c\u8005\u5c31\u662f\u975e\u95dc\u806f\u5f0f\u8cc7\u6599\u8868\u4e86\uff01<br \/>\n2\ufe0f\u20e3 <span style=\"color: #ff0000;\">\u5b78\u751f (\u5b78\u865f, \u59d3\u540d, \u6027\u5225, \u8208\u8da3)<\/span><br \/>\n\u53ea\u8981\u8208\u8da3\u6b04\u4f4d\u5167\u6709\u591a\u500b\u8208\u8da3\u5c31\u662f\u975e\u95dc\u806f\u5f0f\u8cc7\u6599\u8868\u4e86\uff01<\/p>\n<p><strong>Q24\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u8907\u5408\u5f0f\u6c7a\u5b9a\u6027\u5c6c\u6027\uff08Composite Determinant\uff09<\/span>\uff1f<br \/>\n<strong>A24\uff1a<\/strong>\u7531\u591a\u500b\u5c6c\u6027\u7d44\u6210\u51fd\u6578\u4f9d\u8cf4\u95dc\u4fc2\u7684\u6c7a\u5b9a\u6027\u5c6c\u6027\u3002<\/p>\n<p><strong>Q25\uff1a<\/strong>\u54ea\u7a2e\u9375\u503c\u6709\u5169\u500b\u6216\u591a\u500b\u6b04\u4f4d\uff1f<br \/>\n<strong>A25\uff1a<\/strong><span style=\"color: #ff0000;\">\u8907\u5408\u9375\uff08Composite Key\uff09<\/span>\uff0c\u82e5\u7121\u5019\u9078\u9375\uff0c\u53ef\u7531\u591a\u500b\u6b04\u4f4d\u5408\u8d77\u4f86\u7d44\u6210\u4e00\u500b\u9375\u503c\uff0c\u4e14\u80fd\u5c0d\u61c9\u81f3\u552f\u4e00\u7684\u4e00\u7b46\u8a18\u9304\u3002<\/p>\n<p><strong>Q26\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u5019\u9078\u9375\uff08Candidate Key\uff09<\/span>\uff1f<br \/>\n<strong>A26\uff1a<\/strong>\u5019\u9078\u9375\u70ba<span style=\"color: #ff0000;\">\u6c7a\u5b9a\u6027\u5c6c\u6027\uff08Determinant\uff09<\/span>\uff0c\u7528\u65bc\u78ba\u5b9a\u6240\u6709\u5176\u4ed6\u6b04\u4f4d\u4e4b\u9593\u7684\u95dc\u4fc2\u3002<\/p>\n<p><strong>Q27\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u4e3b\u9375\uff08Primary Key\uff09<\/span>\uff1f \u89e3\u91cb<span style=\"color: #ff0000;\">\u5be6\u9ad4\u5b8c\u6574\u9650\u5236\uff08Entity Integrity Constraint\uff09<\/span>\u5c0d\u4e3b\u9375\u7684\u91cd\u8981\u6027\u3002<br \/>\n<strong>A27\uff1a<\/strong>\u4e3b\u9375\u662f\u5f9e\u5019\u9078\u9375\u9078\u64c7\u51fa\u4f86\u7684\u4e00\u500b\u9375\u503c\uff0c\u662f\u8b58\u5225\u95dc\u806f\u5f0f\u6b04\u4f4d\u7684\u4e3b\u8981\u65b9\u6cd5\u3002\u4e3b\u9375\u7684\u6bcf\u4e00\u7b46\u8cc7\u6599\uff08\u884c\uff0c\u76f4\u5411\u6b04\u4f4d\uff09\u90fd\u662f\u88ab\u8981\u6c42\u70ba\u7368\u4e00\u7121\u4e8c\u7684\u503c\uff0c \u9019\u662f\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u6b63\u5e38\u904b\u884c\u7684\u57fa\u672c\u8981\u6c42\u3002<\/p>\n<p><strong>Q28\uff1a<\/strong>\u4ec0\u9ebc\u6642\u5019\u4f7f\u7528<span style=\"color: #ff0000;\">\u4ee3\u7406\u9375\uff08Surrogate Key\uff09<\/span>\uff1f<br \/>\n<strong>A28\uff1a<\/strong>\u5728\u7576\u8cc7\u6599\u8868\u4e2d\u7684\u5019\u9078\u9375\u90fd\u4e0d\u9069\u5408\u7576\u4e3b\u9375\u6642\uff0c\u4f8b\u5982\u8cc7\u6599\u592a\u9577\uff0c\u6216\u662f\u610f\u7fa9\u5c64\u9762\u592a\u591a\uff0c\u5c31\u6703\u8acb\u4e00\u500b\u7121\u610f\u7fa9\u7684\u4f46\u552f\u4e00\u7684\u6b04\u4f4d\u4f86\u4ee3\u70ba\u4f5c\u4e3b\u9375\u3002<\/p>\n<p><strong>Q29\uff1a<\/strong>\u54ea\u4e9b\u6b63\u898f\u5316\u8207<span style=\"color: #ff0000;\">\u529f\u80fd\u76f8\u4f9d\u6027\uff08Functional Dependencies\uff09<\/span>\u6709\u95dc\uff1f<br \/>\n<strong>A29\uff1a<\/strong><span style=\"color: #ff0000;\">1NF<\/span>\u3001<span style=\"color: #ff0000;\">2NF<\/span>\u3001<span style=\"color: #ff0000;\">3NF<\/span> \u548c <span style=\"color: #ff0000;\">BCNF<\/span>\u3002\u88dc\u5145\uff1a\u5c6c\u6027\u9593\u7684\u95dc\u4fc2\u5c31\u662f\u6240\u8b02\u7684\u529f\u80fd\u76f8\u4f9d\u6027\uff08Functional Dependencies\uff09\u3002<\/p>\n<p><strong>Q30\uff1a<\/strong><span style=\"color: #ff0000;\">\u591a\u503c\u4f9d\u8cf4\uff08Multivalued dependencies\uff09<\/span>\u662f\u4ec0\u9ebc\uff1f<br \/>\n<strong>A30\uff1a<\/strong>\u8209\u4f8b\u4f86\u8aaa\uff0c\u5047\u8a2d\u6709\u4e09\u500b\u5c6c\u6027\uff1a<span style=\"color: #ff0000;\">\u8ab2\u7a0b\u3001\u8001\u5e2b\u3001\u6559\u79d1\u66f8<\/span>\uff0c\u6dfb\u52a0\u4e86<span style=\"color: #ff0000;\">\u8ab2\u7a0b<\/span>\u5c31\u8981\u6709<span style=\"color: #ff0000;\">\u8001\u5e2b<\/span>\uff0c\u6dfb\u52a0\u4e86<span style=\"color: #ff0000;\">\u8001\u5e2b<\/span>\u5c31\u8981\u6709<span style=\"color: #ff0000;\">\u6559\u79d1\u66f8<\/span>\u3002\u5982\u679c\u8981\u5c07 BCNF \u7e7c\u7e8c\u5f80\u4e0b\u505a\u5230\u7b2c\u56db\u898f\u683c\u5316\uff084NF\uff09\uff0c\u5c31\u8981\u6709\u9019\u500b\u591a\u503c\u4f9d\u8cf4\u7684\u7279\u5fb5\u3002<\/p>\n<p><strong>Q31\uff1a<\/strong>\u7576\u60a8\u6536\u5230\u4e00\u7d44\u8868\u683c\u6642\uff0c\u60a8\u61c9\u8a72\u63a1\u53d6\u54ea\u4e9b\u6b65\u9a5f\u4f86\u8a55\u4f30\u5176\u7d50\u69cb\u548c\u5167\u5bb9\uff1f<br \/>\n<strong>A31\uff1a<\/strong><br \/>\n- \u8a08\u7b97\u5217\u6578\u4e26\u6aa2\u67e5\u6b04\u4f4d<br \/>\n- \u6aa2\u67e5\u8cc7\u6599\uff08\u503c\uff09\u4e26\u8207\u4f7f\u7528\u8005\u9762\u8ac7\u4ee5\u78ba\u5b9a\uff1a<br \/>\n\u25cb \u591a\u503c\u4f9d\u8cf4\uff08Multivalued Dependencies\uff09<br \/>\n\u25cb \u529f\u80fd\u76f8\u4f9d\u6027\uff08Functional Dependencies\uff09<br \/>\n\u25cb \u5019\u9078\u9375\uff08Candidate Key\uff09<br \/>\n\u25cb \u4e3b\u9375\uff08Primary Key\uff09<br \/>\n\u25cb \u5916\u90e8\u9375\u3001\u5916\u9375\uff08Foreign Key\uff09<br \/>\n- \u8a55\u4f30\u8cc7\u6599\u6703\u662f\u5b8c\u6574\u4e14\u6709\u6548\u7684\u3002<\/p>\n<p><strong>Q32\uff1a<\/strong>\u6558\u8ff0<span style=\"color: #ff0000;\">\u8cc7\u6599\u5eab\u6b63\u898f\u5316\uff08Normalized Tables\uff09<\/span>\u7684\u512a\u9ede\u3002<br \/>\n<strong>A32\uff1a<\/strong>\u6d88\u9664\u4fee\u6539\u7570\u5e38\u3001\u6e1b\u5c11\u91cd\u8907\u7684\u8cc7\u6599\u3001\u6d88\u9664\u8cc7\u6599\u5b8c\u6574\u6027\u554f\u984c\u3001\u7bc0\u7701\u6587\u4ef6\u7a7a\u9593\u3002<\/p>\n<p><strong>Q33\uff1a<\/strong>\u6558\u8ff0<span style=\"color: #ff0000;\">\u8cc7\u6599\u5eab\u6b63\u898f\u5316\uff08Normalized Tables\uff09<\/span>\u7684\u7f3a\u9ede\u3002<br \/>\n<strong>A33\uff1a<\/strong>1\ufe0f\u20e3 \u9700\u8981\u66f4\u8907\u96dc\u7684 SQL \u4f86\u67e5\u8a62\u591a\u500b\u5b50\u8868\u683c\u8207\u4f7f\u7528\u591a\u500b join\uff0f2\ufe0f\u20e3 \u589e\u52a0 DBMS \u7684\u984d\u5916\u5de5\u4f5c\u91cf\uff0c\u4f7f\u8edf\u9ad4\u6548\u7387\u8b8a\u5dee\u3002<\/p>\n<p><strong>Q34\uff1a<\/strong>SQL \u8a9e\u6cd5\u7df4\u7fd2\u984c<\/p>\n<p>\u5047\u8a2d\u60a8\u7372\u5f97\u4e86\u9019\u500b\u8868\u683c\uff1a<\/p>\n<pre class=\"line-numbers\"><code class=\"language-sql\">EMPLOYEE_DEPARTMENT (EmployeeNumber, EmployeeLastName, EmployeeFirstName, Email, DepartmentName, BudgetCode)<\/code><\/pre>\n<p>\u4e26\u4e14\u60a8\u5e0c\u671b\u5c07\u6b64\u8868\u8f49\u63db\u70ba\u5169\u500b\u8868\uff1a<\/p>\n<pre class=\"line-numbers\"><code class=\"language-sql\">DEPARTMENT (DepartmentName, BudgetCode)<\/code><\/pre>\n<pre class=\"line-numbers\"><code class=\"language-sql\">EMPLOYEE (EmployeeNumber, EmployeeLastName, EmployeeFirstName, Email, DepartmentName)<\/code><\/pre>\n<p>\u7de8\u5beb\u8f38\u51fa EMPLOYEE \u548c DEPARTMENT \u8868\u683c\u6240\u9700\u7684 SQL \u8a9e\u6cd5\uff0c\u4f7f\u7528 EMPLOYEE_DEPARTMENT \u8868\u683c\u7684\u8cc7\u6599\u3002<\/p>\n<p><strong>A34\uff1a<\/strong><\/p>\n<pre class=\"line-numbers\"><code class=\"language-sql\">INSERT INTO DEPARTMENT\r\nSELECT DISTINCT DepartmentName, BudgetCode\r\nFROM EMPLOYEE_DEPARTMENT;\r\n\r\nINSERT INTO EMPLOYEE\r\nSELECT EmployeeNumber, EmployeeLastName, EmployeeFirstName, Email, DepartmentName\r\nFROM EMPLOYEE_DEPARTMENT;<\/code><\/pre>\n<p><strong>Q35\uff1a<\/strong>\u89e3\u91cb\u70ba\u4f55\u4e0d\u5c07\u90f5\u905e\u5340\u865f\u653e\u5165 <span style=\"color: #ff0000;\">BCNF<\/span>\u3002<br \/>\n<strong>A35\uff1a<\/strong>\u90f5\u905e\u5340\u865f\u5e7e\u4e4e\u6c92\u8b8a\uff0c\u5047\u8a2d\u5982\u679c\u6709\u4eba\u8f38\u5165\u4e86\u932f\u8aa4\u7684\u57ce\u5e02\uff0c\u5247\u90f5\u905e\u5340\u865f\u5c07\u4e0d\u4e00\u81f4\u3002<\/p>\n<p><strong>Q36\uff1a<\/strong>\u70ba\u4f55\u5c07<span style=\"color: #ff0000;\">\u81ea\u5b9a\u7fa9\u91cd\u8907\u8868\uff08Customized Duplicated Table\uff09<\/span>\u7576\u4f5c\u662f<span style=\"color: #ff0000;\">\u53cd\u6b63\u898f\u5316\uff08Denormalization\uff09<\/span>\u7684\u6848\u4f8b\uff1f<br \/>\n<strong>A36\uff1a<\/strong>\u56e0\u70ba\u6bcf\u6b21\u5275\u5efa<span style=\"color: #ff0000;\">\u91cd\u8907\u8868<\/span>\u6642\u90fd\u6703\u9047\u5230<span style=\"color: #ff0000;\">\u8cc7\u6599\u5b8c\u6574\u6027\u554f\u984c\uff08Data Integrity Issues\uff09<\/span>\u3002<\/p>\n<p><strong>Q37\uff1a<\/strong>\u89e3\u91cb<span style=\"color: #ff0000;\">\u591a\u503c\u3001\u591a\u6b04\u4f4d<\/span>\u5f15\u8d77\u7684\u554f\u984c\u3002<br \/>\n<strong>A37\uff1a<\/strong>\u5982\u679c\u9280\u884c\u5e33\u6236\u8a0a\u606f\u53ea\u6709\u4e09\u500b\u6b04\u4f4d\uff0c\u5047\u8a2d\u4e00\u500b\u4eba\u6709\u56db\u500b\u9280\u884c\u5e33\u6236\uff0c\u90a3\u9ebc\u60a8\u5c31\u9047\u5230\u4e86\u554f\u984c\u3002\u6b64\u5916\uff0c\u5982\u679c\u60a8\u8981\u67e5\u8a62\u6578\u64da\u4e26\u4e14\u6b63\u5728\u67e5\u627e\u7279\u5b9a\u7684\u9280\u884c\u5e33\u6236\uff0c\u5247\u5fc5\u9808\u67e5\u8a62\u6bcf\u500b\u6b04\u4f4d\uff0c\u9019\u662f\u975e\u5e38\u8f9b\u82e6\u7684\u3002<\/p>\n<p><strong>Q38\uff1a<\/strong>\u70ba\u4ec0\u9ebc<span style=\"color: #ff0000;\">\u5916\u9375\uff08Foreign Key\uff09<\/span>\u4e2d\u7684\u503c\u4e0d\u4e00\u81f4\u6703\u5c0e\u81f4\u7279\u5225\u9ebb\u7169\uff1f<br \/>\n<strong>A38\uff1a<\/strong>\u7576<span style=\"color: #ff0000;\">\u5916\u9375<\/span>\u8cc7\u6599\u7de8\u78bc\u4e0d\u4e00\u81f4\u6216\u62fc\u5beb\u932f\u8aa4\u6642\uff0c\u95dc\u806f\u5c07\u4e1f\u5931\u6216\u932f\u8aa4\u3002<\/p>\n<p><strong>Q39\uff1a<\/strong>\u4ec0\u9ebc\u662f<span style=\"color: #ff0000;\">\u7a7a\u503c\uff08Null Value\uff09<\/span>\uff1f \u5b83\u6709\u4ec0\u9ebc\u554f\u984c\uff1f<br \/>\n<strong>A39\uff1a<\/strong><span style=\"color: #ff0000;\">\u7a7a\u503c<\/span>\u8868\u793a\u8b8a\u6578\u5177\u6709\u672a\u77e5\u503c\uff0c\u4e0d\u540c\u65bc\u96f6\u503c\u3002\u82e5\u8981\u89e3\u6c7a\u908f\u8f2f\u554f\u984c\uff0c\u60a8\u64c1\u6709\u8b8a\u6578\u7684\u5df2\u77e5\u503c\u8d8a\u591a\uff0c\u5c31\u8d8a\u5bb9\u6613\u89e3\u6c7a\u554f\u984c\u3002<\/p>\n<p>\u6587\u7ae0\u7d50\u675f\u56c9\uff01\u9019\u771f\u7684\u662f\u840c\u82bd\u7ad9\u9577\u5f88\u7528\u5fc3\u6574\u7406\u7684\uff0c\u771f\u5fc3\u5e0c\u671b\u53ef\u4ee5\u5e6b\u52a9\u5230\u4f60\u4e86\u89e3\u8cc7\u6599\u5eab\u5537\uff01\ud83d\ude4f \ud83e\udd70<\/p>\n<blockquote>\n<h1><span style=\"color: #0000ff;\"><strong>\u66f4\u65b0\u65e5\u8a8c\uff1a<\/strong><\/span><\/h1>\n<p>2019\/04\/10\uff08\u4e09\uff09\uff1a\u9996\u6b21\u767c\u6587\uff0c\u5b8c\u6210\u300c\u8cc7\u6599\u5eab\uff08DataBase\uff09\u7c21\u4ecb\u300d\u3001\u300c\u8cc7\u6599\u5eab\uff08DataBase\uff09 &amp; \u8cc7\u6599\u7d50\u69cb\uff08Data Structure\uff09 \u95dc\u4fc2\u662f\u4ec0\u9ebc\uff1f\u300d\u3001\u300c\u4f55\u8b02\u6b63\u898f\u5316\uff08Normalization\uff09\uff1f\u300d\u548c\u300c\u8cc7\u6599\u5eab\u9818\u57df\u7684\u5e38\u898b\u554f\u984c\uff08Q1~Q22\uff09\u300d\u56db\u500b\u7ae0\u7bc0\u3002<br \/>\n2019\/04\/12\uff08\u4e94\uff09\uff1a\u65b0\u589e\u300c\u9375\u503c\uff08Keys\uff09\u300d\u7ae0\u7bc0\u53ca\u66f4\u65b0\u300c\u8cc7\u6599\u5eab\u9818\u57df\u7684\u5e38\u898b\u554f\u984c\uff08Q23~Q39\uff09\u300d\u7ae0\u7bc0\u3002<\/p><\/blockquote>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>\u9019\u662f\u840c\u82bd\u7ad9\u9577\u7684\u5b78\u696d\u7b46\u8a18\uff0c\u8ab2\u7a0b\u70ba\u8cc7\u7ba1\u7cfb\u300c\u8cc7\u6599\u5eab\u7ba1\u7406\u300d\u3002\u7531\u65bc\u8ab2\u5802\u4e2d\u4e00\u4e0b\u5b50\u63d0\u53ca\u592a\u591a\u5c08\u6709\u540d\u8a5e\uff0c\u4f86\u4e0d\u53ca\u505a\u8a73\u7d30\u6574\u7406\uff0c\u56e0\u6b64\u4e00\u76f4\u62d6\u5ef6\u9019\u7bc7\u767c\u4f48\u7684\u6642\u9593\uff0c\u4e0d\u904e\u5e0c\u671b\u80fd\u5e6b\u52a9\u5230\u60a8\u5b78\u7fd2\uff01\u6211\u6574\u7406\u7684\u975e\u5e38\u8a73\u7d30\uff01\u6709\u4efb\u4f55\u932f\u8aa4\u90fd\u53ef\u4ee5\u5728\u672c\u6587 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9248,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,20,503,478,476,494],"tags":[],"class_list":["post-9246","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-website-tech","category-server","category-database","category-notes","category-academic","category-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 &amp; \u7b46\u8a18 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mnya.tw\/cc\/word\/1366.html\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 &amp; \u7b46\u8a18 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801\" \/>\n<meta property=\"og:description\" content=\"\u9019\u662f\u840c\u82bd\u7ad9\u9577\u7684\u5b78\u696d\u7b46\u8a18\uff0c\u8ab2\u7a0b\u70ba\u8cc7\u7ba1\u7cfb\u300c\u8cc7\u6599\u5eab\u7ba1\u7406\u300d\u3002\u7531\u65bc\u8ab2\u5802\u4e2d\u4e00\u4e0b\u5b50\u63d0\u53ca\u592a\u591a\u5c08\u6709\u540d\u8a5e\uff0c\u4f86\u4e0d\u53ca\u505a\u8a73\u7d30\u6574\u7406\uff0c\u56e0\u6b64\u4e00\u76f4\u62d6\u5ef6\u9019\u7bc7\u767c\u4f48\u7684\u6642\u9593\uff0c\u4e0d\u904e\u5e0c\u671b\u80fd\u5e6b\u52a9\u5230\u60a8\u5b78\u7fd2\uff01\u6211\u6574\u7406\u7684\u975e\u5e38\u8a73\u7d30\uff01\u6709\u4efb\u4f55\u932f\u8aa4\u90fd\u53ef [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mnya.tw\/cc\/word\/1366.html\" \/>\n<meta property=\"og:site_name\" content=\"\u840c\u82bd\u7d9c\u5408\u5929\u5730\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-09T18:57:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-14T05:40:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1366-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u840c\u82bd\u7ad9\u9577\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/x.com\/qwe987299\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005:\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u840c\u82bd\u7ad9\u9577\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9810\u4f30\u95b1\u8b80\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\u9418\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html\"},\"author\":{\"name\":\"\u840c\u82bd\u7ad9\u9577\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#\\\/schema\\\/person\\\/28e9ae25bc418b8ec216b7aa2c848faa\"},\"headline\":\"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 &#038; \u7b46\u8a18\",\"datePublished\":\"2019-04-09T18:57:01+00:00\",\"dateModified\":\"2019-05-14T05:40:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html\"},\"wordCount\":352,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/wp-content\\\/uploads\\\/2019\\\/1366-1.jpg\",\"articleSection\":[\"\u7db2\u7ad9\u6280\u8853\",\"\u4f3a\u670d\u5668\",\"\u8cc7\u6599\u5eab\",\"\u5b78\u696d\u7b46\u8a18\",\"\u5b78\u8853\u8a5e\u5f59\",\"SQL\"],\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html\",\"url\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html\",\"name\":\"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 & \u7b46\u8a18 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/wp-content\\\/uploads\\\/2019\\\/1366-1.jpg\",\"datePublished\":\"2019-04-09T18:57:01+00:00\",\"dateModified\":\"2019-05-14T05:40:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#\\\/schema\\\/person\\\/28e9ae25bc418b8ec216b7aa2c848faa\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html#primaryimage\",\"url\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/wp-content\\\/uploads\\\/2019\\\/1366-1.jpg\",\"contentUrl\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/wp-content\\\/uploads\\\/2019\\\/1366-1.jpg\",\"width\":1024,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1366.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9801\",\"item\":\"https:\\\/\\\/mnya.tw\\\/cc\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 &#038; \u7b46\u8a18\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#website\",\"url\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/\",\"name\":\"\u840c\u82bd\u7d9c\u5408\u5929\u5730\",\"description\":\"\u751f\u6d3b\u4f11\u9592\u2502\u96fb\u5b50\u8cc7\u8a0a\u2502\u5b78\u8853\u77e5\u8b58\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-TW\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#\\\/schema\\\/person\\\/28e9ae25bc418b8ec216b7aa2c848faa\",\"name\":\"\u840c\u82bd\u7ad9\u9577\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g\",\"caption\":\"\u840c\u82bd\u7ad9\u9577\"},\"description\":\"\u60a8\u597d\uff0c\u6211\u662f\u840c\u82bd\u7cfb\u5217\u7db2\u7ad9\uff08Mnya Series Website\uff09\u7684\u7ad9\u9577&amp;\u5275\u59cb\u4eba\uff0c\u53ef\u4ee5\u7a31\u547c\u6211\u300c\u840c\u82bd\u7ad9\u9577\u300d\u3002\u6211\u7684\u8208\u8da3\u8207\u5c08\u9577\u6709\u767b\u5c71\u3001\u89c0\u5bdf\u5730\u5f62\u3001\u651d\u5f71\u3001\u65c5\u904a\u3001\u7db2\u9801\u8a2d\u8a08\uff06\u67b6\u8a2d\uff06\u7d93\u71df\u3001\u52d5\u756b\u88fd\u4f5c\u3001\u5716\u7247\u8655\u7406\u3001\u8cc7\u6599\u5f59\u6574\u7b49\u3002\u6709\u4efb\u4f55\u554f\u984c\u6216\u5efa\u8b70\u8acb\u81f3\u840c\u82bd\u8ad6\u58c7\u767c\u8868\u3002\u7db2\u7ad9\u696d\u52d9\u3001\u5546\u696d\u5408\u4f5c\u7684\u806f\u7d61\u65b9\u5f0f\u5728\u300c\u95dc\u65bc\u672c\u7ad9 \u2192 \u5718\u968a\u4ecb\u7d39 \u2192 \u7ad9\u9577\u4ecb\u7d39\u300d\uff0c\u5f88\u9ad8\u8208\u8a8d\u8b58\u60a8\uff01\u8acb\u591a\u6307\u6559\uff01\",\"sameAs\":[\"https:\\\/\\\/mnya.tw\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/x.com\\\/qwe987299\"],\"url\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/author\\\/qwe987299\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 & \u7b46\u8a18 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mnya.tw\/cc\/word\/1366.html","og_locale":"zh_TW","og_type":"article","og_title":"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 & \u7b46\u8a18 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801","og_description":"\u9019\u662f\u840c\u82bd\u7ad9\u9577\u7684\u5b78\u696d\u7b46\u8a18\uff0c\u8ab2\u7a0b\u70ba\u8cc7\u7ba1\u7cfb\u300c\u8cc7\u6599\u5eab\u7ba1\u7406\u300d\u3002\u7531\u65bc\u8ab2\u5802\u4e2d\u4e00\u4e0b\u5b50\u63d0\u53ca\u592a\u591a\u5c08\u6709\u540d\u8a5e\uff0c\u4f86\u4e0d\u53ca\u505a\u8a73\u7d30\u6574\u7406\uff0c\u56e0\u6b64\u4e00\u76f4\u62d6\u5ef6\u9019\u7bc7\u767c\u4f48\u7684\u6642\u9593\uff0c\u4e0d\u904e\u5e0c\u671b\u80fd\u5e6b\u52a9\u5230\u60a8\u5b78\u7fd2\uff01\u6211\u6574\u7406\u7684\u975e\u5e38\u8a73\u7d30\uff01\u6709\u4efb\u4f55\u932f\u8aa4\u90fd\u53ef [&hellip;]","og_url":"https:\/\/mnya.tw\/cc\/word\/1366.html","og_site_name":"\u840c\u82bd\u7d9c\u5408\u5929\u5730","article_published_time":"2019-04-09T18:57:01+00:00","article_modified_time":"2019-05-14T05:40:15+00:00","og_image":[{"width":1024,"height":768,"url":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1366-1.jpg","type":"image\/jpeg"}],"author":"\u840c\u82bd\u7ad9\u9577","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/x.com\/qwe987299","twitter_misc":{"\u4f5c\u8005:":"\u840c\u82bd\u7ad9\u9577","\u9810\u4f30\u95b1\u8b80\u6642\u9593":"2 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mnya.tw\/cc\/word\/1366.html#article","isPartOf":{"@id":"https:\/\/mnya.tw\/cc\/word\/1366.html"},"author":{"name":"\u840c\u82bd\u7ad9\u9577","@id":"https:\/\/mnya.tw\/cc\/#\/schema\/person\/28e9ae25bc418b8ec216b7aa2c848faa"},"headline":"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 &#038; \u7b46\u8a18","datePublished":"2019-04-09T18:57:01+00:00","dateModified":"2019-05-14T05:40:15+00:00","mainEntityOfPage":{"@id":"https:\/\/mnya.tw\/cc\/word\/1366.html"},"wordCount":352,"commentCount":0,"image":{"@id":"https:\/\/mnya.tw\/cc\/word\/1366.html#primaryimage"},"thumbnailUrl":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1366-1.jpg","articleSection":["\u7db2\u7ad9\u6280\u8853","\u4f3a\u670d\u5668","\u8cc7\u6599\u5eab","\u5b78\u696d\u7b46\u8a18","\u5b78\u8853\u8a5e\u5f59","SQL"],"inLanguage":"zh-TW","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mnya.tw\/cc\/word\/1366.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mnya.tw\/cc\/word\/1366.html","url":"https:\/\/mnya.tw\/cc\/word\/1366.html","name":"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 & \u7b46\u8a18 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801","isPartOf":{"@id":"https:\/\/mnya.tw\/cc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mnya.tw\/cc\/word\/1366.html#primaryimage"},"image":{"@id":"https:\/\/mnya.tw\/cc\/word\/1366.html#primaryimage"},"thumbnailUrl":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1366-1.jpg","datePublished":"2019-04-09T18:57:01+00:00","dateModified":"2019-05-14T05:40:15+00:00","author":{"@id":"https:\/\/mnya.tw\/cc\/#\/schema\/person\/28e9ae25bc418b8ec216b7aa2c848faa"},"breadcrumb":{"@id":"https:\/\/mnya.tw\/cc\/word\/1366.html#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mnya.tw\/cc\/word\/1366.html"]}]},{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/mnya.tw\/cc\/word\/1366.html#primaryimage","url":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1366-1.jpg","contentUrl":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1366-1.jpg","width":1024,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/mnya.tw\/cc\/word\/1366.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/mnya.tw\/cc"},{"@type":"ListItem","position":2,"name":"\u8cc7\u6599\u5eab\u57fa\u672c\u77e5\u8b58 &#038; \u7b46\u8a18"}]},{"@type":"WebSite","@id":"https:\/\/mnya.tw\/cc\/#website","url":"https:\/\/mnya.tw\/cc\/","name":"\u840c\u82bd\u7d9c\u5408\u5929\u5730","description":"\u751f\u6d3b\u4f11\u9592\u2502\u96fb\u5b50\u8cc7\u8a0a\u2502\u5b78\u8853\u77e5\u8b58","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mnya.tw\/cc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-TW"},{"@type":"Person","@id":"https:\/\/mnya.tw\/cc\/#\/schema\/person\/28e9ae25bc418b8ec216b7aa2c848faa","name":"\u840c\u82bd\u7ad9\u9577","image":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/secure.gravatar.com\/avatar\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g","caption":"\u840c\u82bd\u7ad9\u9577"},"description":"\u60a8\u597d\uff0c\u6211\u662f\u840c\u82bd\u7cfb\u5217\u7db2\u7ad9\uff08Mnya Series Website\uff09\u7684\u7ad9\u9577&amp;\u5275\u59cb\u4eba\uff0c\u53ef\u4ee5\u7a31\u547c\u6211\u300c\u840c\u82bd\u7ad9\u9577\u300d\u3002\u6211\u7684\u8208\u8da3\u8207\u5c08\u9577\u6709\u767b\u5c71\u3001\u89c0\u5bdf\u5730\u5f62\u3001\u651d\u5f71\u3001\u65c5\u904a\u3001\u7db2\u9801\u8a2d\u8a08\uff06\u67b6\u8a2d\uff06\u7d93\u71df\u3001\u52d5\u756b\u88fd\u4f5c\u3001\u5716\u7247\u8655\u7406\u3001\u8cc7\u6599\u5f59\u6574\u7b49\u3002\u6709\u4efb\u4f55\u554f\u984c\u6216\u5efa\u8b70\u8acb\u81f3\u840c\u82bd\u8ad6\u58c7\u767c\u8868\u3002\u7db2\u7ad9\u696d\u52d9\u3001\u5546\u696d\u5408\u4f5c\u7684\u806f\u7d61\u65b9\u5f0f\u5728\u300c\u95dc\u65bc\u672c\u7ad9 \u2192 \u5718\u968a\u4ecb\u7d39 \u2192 \u7ad9\u9577\u4ecb\u7d39\u300d\uff0c\u5f88\u9ad8\u8208\u8a8d\u8b58\u60a8\uff01\u8acb\u591a\u6307\u6559\uff01","sameAs":["https:\/\/mnya.tw\/","https:\/\/x.com\/https:\/\/x.com\/qwe987299"],"url":"https:\/\/mnya.tw\/cc\/word\/author\/qwe987299"}]}},"_links":{"self":[{"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/posts\/9246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/comments?post=9246"}],"version-history":[{"count":0,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/posts\/9246\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/media\/9248"}],"wp:attachment":[{"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/media?parent=9246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/categories?post=9246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/tags?post=9246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}