|
鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁＋銆佸崥澹爺绌剁敓鍏ュ鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗�锛岄儴鍒嗗鏍℃洿鏂拌嚦2012骞�锛�2013骞�锛涘潎鎻愪緵鏀惰不涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛炴搳鈥�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛炴搳鈥�鑰冨崥瑭﹀嵎搴�鈥� 涓嬭級
澶ч€ｆ捣浜嬪ぇ瀛哥ⅸ澹爺绌剁敓鍏ュ鑰冪爺澶х侗
鑰冭│绉戠洰锛氭暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鍙婂叾鎳夌敤
瑭﹀嵎婊垮垎鍙婅€冭│鏅傞枔锛氳│鍗锋豢鍒嗙偤 100 鍒�锛岃€冭│鏅傞枔鐐� 120 鍒嗛悩銆�
瑭﹀嵎鍏у绲愭锛氭暩(sh霉)鎿�(j霉)搴師鐞� 80锛咃紝鏁�(sh霉)鎿�(j霉)搴噳鐢� 20锛�
涓€銆佺窉璜�
鑰冭│鍏у
鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)姒傝堪銆佹暩(sh霉)鎿�(j霉)妯″瀷銆佹暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)绲愭銆佹暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勭祫鎴�銆佹暩(sh霉)鎿�(j霉)搴í鍟�
閬庣▼銆佹暩(sh霉)鎿�(j霉)搴妧琛撶爺绌堕牁鍩�
鑰冭│瑕佹眰锛�
1锛� 鐞嗚В鏁�(sh霉)鎿�(j霉)銆佹暩(sh霉)鎿�(j霉)搴�銆佹暩(sh霉)鎿�(j霉)搴鐞嗙郴绲�(t菕ng)銆佹暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勬蹇�锛岀悊瑙ｆ暩(sh霉)鎿�(j霉)搴
鐞嗙郴绲�(t菕ng)鐨勫姛鑳借姹�锛屼簡瑙ｆ暩(sh霉)鎿�(j霉)鑸囦俊鎭�銆佺煡璀樼殑鍗€(q奴)鍒ヨ垏鑱�(li谩n)绯�
2锛� 浜嗚В鏁�(sh霉)鎿�(j霉)绠＄悊鐧�(f膩)灞曠殑涓嶅悓闅庢鍙婂叾鐗瑰緛
3锛� 鐞嗚В妯″瀷鐨勬蹇点€佸垎椤�銆佺祫鎴愯绱�锛岀悊瑙ｆ蹇垫ā鍨嬫秹鍙婄殑鐩搁棞姒傚康鍙婂叾甯�
鐢ㄧ殑琛ㄧず鏂规硶鈥斺€斿楂旇伅(li谩n)绯绘柟娉曪紙ER 鍦栵級
4锛� 浜嗚В鏁�(sh霉)鎿�(j霉)閭忚集妯″瀷鐨勭ó椤�锛屾帉鎻￠棞绯绘ā寮忔秹鍙婂埌鐨勭浉闂滄蹇�锛屼簡瑙ｅ堡娆℃ā
鍨嬪拰缍茬媭妯″瀷鐨勫畾缇╁強鍏跺熀鏈祫鎴愬柈浣�
5锛� 浜嗚В寰炴渶绲傜敤鎴跺妰鍒�锛屾暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勭祼妲嬪浣曞妰鍒�锛涚悊瑙ｅ緸鏁�(sh霉)鎿�(j霉)绠＄悊绯荤当(t菕ng)
瑙掑害鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勪笁绱氭ā寮忕祼妲嬪強鍏朵簩绱氭槧灏�
6锛� 浜嗚В鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勭祫鎴愬強鐩搁棞鏁�(sh霉)鎿�(j霉)搴鐞嗗摗銆佹暩(sh霉)鎿�(j霉)搴ō瑷堜汉鍝＄瓑鑱疯铂
7锛� 浜嗚В鏁�(sh霉)鎿�(j霉)搴í鍟忛亷绋嬪強鏁�(sh霉)鎿�(j霉)搴妧琛撶爺绌剁浉闂滈牁鍩�
浜�銆侀棞绯绘暩(sh霉)鎿�(j霉)搴�
鑰冭│鍏у
闂滅郴妯″瀷銆侀棞绯绘暩(sh霉)鎿�(j霉)搴祼妲嬪強褰㈠紡鍖栧畾缇�銆侀棞绯诲畬鏁存€�銆侀棞绯讳唬鏁�(sh霉)銆侀棞绯绘紨绠�
鑰冭│瑕佹眰
1锛庣悊瑙ｉ棞绯绘ā鍨嬬殑绲勬垚銆侀棞绯绘搷浣滆獮瑷€绋銆侀棞绯诲畬鏁存€х磩鏉熺殑姒傚康鍙婂寘鍚殑
鍏у锛�
2锛庣悊瑙ｉ棞绯绘暩(sh霉)鎿�(j霉)搴舰寮忓寲瀹氱京鐨勭敱渚�銆侀棞绯绘暩(sh霉)鎿�(j霉)搴舰寮忓寲瀹氱京浜斿厓绲勭殑鍏у鍜�
鎰忕京锛�
3锛庣悊瑙ｉ棞绯荤殑鎬ц唱鍜岀ó椤�锛�
4锛庝簡瑙ｇ浉闂滅殑闂滅郴浠ｆ暩(sh霉)鎿嶄綔鍜岄棞绯绘紨绠楁搷浣�锛�
涓夈€侀棞绯绘暩(sh霉)鎿�(j霉)搴婧栬獮瑷€ SQL
鑰冭│鍏у
SQL 瑾炶█姒傝堪銆佺壒榛�銆佸強鍏舵墍鍖呭惈鐨� DCL銆丏ML銆丏CL 瑾炶█
鑰冭│瑕佹眰
1锛庣悊瑙� SQL 瑾炶█鐨勭壒榛�锛�
2锛庢帉鎻″皪鏁�(sh霉)鎿�(j霉)搴�銆佹暩(sh霉)鎿�(j霉)琛ㄣ€佺储寮曠瓑鏁�(sh霉)鎿�(j霉)鎿嶄綔灏嶈薄鐨勫畾缇�锛�
3锛庢帉鎻″皪鍠〃鍙婂琛ㄧ殑鍚勭ó鏁�(sh霉)鎿�(j霉)鏌ヨ鎿嶄綔锛涙帉鎻″皪鍠倞鐨勬暩(sh霉)鎿�(j霉)鏇存柊鎿嶄綔锛�
4锛庣悊瑙ｈ鍦栫殑姒傚康銆佷綔鐢紝鎺屾彙鐩搁棞鐨勮鍦栨搷浣滆獮鍙�锛�
5锛庣悊瑙ｉ€氫俊鍘�銆佷富璁婇噺銆佹父妯欑殑姒傚康锛屾帉鎻″祵鍏ュ紡 SQl 瑾炶█鐨勪娇鐢紱
鍥�銆佹暩(sh霉)鎿�(j霉)搴畨鍏ㄦ€у拰瀹屾暣鎬�
鑰冭│鍏у
鏁�(sh霉)鎿�(j霉)搴畨鍏ㄦ€ф帶鍒�銆佹暩(sh霉)鎿�(j霉)搴畬鏁存€х磩鏉�
鑰冭│瑕佹眰
1锛庝簡瑙ｆ暩(sh霉)鎿�(j霉)搴畨鍏ㄦ€ф秹鍙婄殑瀹夊叏鎬ц寖鐤囧拰绋锛�
2锛庣悊瑙ｅ叿楂斿畨鍏ㄦ€ф帶鍒舵柟娉曪紝鐞嗚В瀹夊叏鎬ц嚜鍔╁瓨鍙栨帶鍒跺拰寮峰埗瀛樺彇鎺у埗姗熷埗锛�
鎺屾彙鐩搁棞鐨勫畨鍏ㄦ€ф帶鍒舵搷浣滆獮鍙ワ紱
3锛庝簡瑙ｅ畬鏁存€х磩鏉熸帶鍒剁殑姒傚康銆侀鍒ャ€佹檪姗燂紱
4锛庣悊瑙ｅ楂斿畬鏁存€�銆佸弮鐓у畬鏁存€�銆佺敤鎴惰嚜瀹氱京瀹屾暣鎬х殑姒傚康锛屾帉鎻＄浉闂滅殑鎺у埗
鎿嶄綔绛栫暐锛�
浜斻€侀棞绯绘暩(sh霉)鎿�(j霉)搴悊璜�
鑰冭│鍏у
鏁�(sh霉)鎿�(j霉)鎿嶄綔鐣板父鍟忛銆佹暩(sh霉)鎿�(j霉)渚濊炒銆佽(gu墨)鑼冨寲銆佹暩(sh霉)鎿�(j霉)渚濊炒鐨勫叕鐞嗙郴绲�(t菕ng)銆佹ā寮忓垎瑙�
鑰冭│瑕佹眰
1锛庝簡瑙ｆ暩(sh霉)鎿�(j霉)鎿嶄綔鐣板父鐨勬蹇靛拰绋鍙婂叾鐢㈢敓鐨勫師鍥�锛�
2锛庝簡瑙ｆ暩(sh霉)鎿�(j霉)渚濊炒姒傚康鍙婂叾绋锛�
3锛庣悊瑙ｅ嚱鏁�(sh霉)渚濊炒鐨勫畾缇�锛屾帉鎻″嚱鏁�(sh霉)渚濊炒鐨勭ó椤�锛涗簡瑙ｅ鍊间緷璩寸殑鍏у锛�
4锛庣悊瑙ｆ暩(sh霉)鎿�(j霉)瑕�(gu墨)鑼冨寲鐨勫惈缇╁強鐩搁棞鐨勫緸 1NF 鍒� 4NF 鐨勫畾缇╁拰鍖呭惈鍏у锛屾帉鎻¤(gu墨)鍔�
鍖栧拰渚濊炒涔嬮枔鐨勯棞绯诲強鑼冨紡瑕�(gu墨)鑼冨寲閬庣▼锛�
5锛庣悊瑙ｅ嚱鏁�(sh霉)渚濊炒鍏悊绯荤当(t菕ng)鎵€鍖呭惈鐨勫収瀹�锛屾帉鎻″叕鐞嗙郴绲�(t菕ng)鍖呭惈鐨勪笁鍊嬪畾寰嬪拰鎺ㄨ珫
瑕�(gu墨)鍓囧苟鑳介潏娲婚亱鐢紝鎺屾彙鏁�(sh霉)鎿�(j霉)渚濊炒鐨勯枆鍖�銆佸爆鎬ч枆鍖呫€佹渶灏忓嚱鏁�(sh霉)渚濊炒闆嗙殑姹傝В绠�
娉�锛�
6锛庢帉鎻� 3NF銆丅CNF銆�4NF 鐨勬ā寮忓垎瑙ｇ畻娉曪紝骞惰兘鍒ゆ柗妯″紡鍒嗚В妯″紡鍒嗚В鐨勭劇鎼嶉€�
鎺ユ€у拰鍑芥暩(sh霉)渚濊炒鎬�锛�
鍏�銆佹暩(sh霉)鎿�(j霉)搴ō瑷�
鑰冭│鍏у
鏁�(sh霉)鎿�(j霉)搴ō瑷堟杩�銆侀渶姹傚垎鏋�銆佹蹇电祼妲嬭ō瑷堛€侀倧杓祼妲嬭ō瑷�銆佹暩(sh霉)鎿�(j霉)搴殑鐗╃悊瑷�
瑷堛€佹暩(sh霉)鎿�(j霉)搴殑瀵︽柦鍜岀董璀�
鑰冭│瑕佹眰
1锛庝簡瑙ｆ暩(sh霉)鎿�(j霉)搴ō瑷堢殑鐩搁棞姒傚康鍙婂叾姝ラ鍜岄亷绋�锛�
2锛庝簡瑙ｉ渶姹傚垎鏋愮殑浠诲嫏銆佹椹熼亷绋嬪拰鏂规硶锛岀悊瑙ｉ渶姹傚垎鏋愪腑鏁�(sh霉)鎿�(j霉)瀛楀吀鐨勬蹇靛拰
鍖呭惈鐨勫収瀹�锛�
3锛庣悊瑙ｆ蹇电祼妲嬭ō瑷堢殑浠诲嫏銆佹椹熼亷绋嬪拰鏂规硶锛岀啛绶存帉鎻℃蹇电祼妲嬭ō瑷堜腑 ER 鍦�
鐨勭躬鍒�锛�
4锛庣悊瑙ｉ倧杓祼妲嬭ō瑷堢殑浠诲嫏銆佹椹熼亷绋嬪拰鏂规硶锛屾帉鎻� ER 鍦栧悜闂滅郴閭忚集绲愭杞夊寲
鐨勮(gu墨)鍓�锛�
5锛庝簡瑙ｆ暩(sh霉)鎿�(j霉)搴墿鐞嗙祼妲嬭ō瑷堢殑鍏у銆佺洰妯欏拰姝ラ閬庣▼锛�
6锛庝簡瑙ｆ暩(sh霉)鎿�(j霉)搴鏂藉拰瑭﹂亱琛屾墍鍖呭惈鐨勫収瀹癸紱鐞嗚В鏁�(sh霉)鎿�(j霉)缍鎵€鍖呭惈鐨勫収瀹瑰強瑭查殠
娈垫暩(sh霉)鎿�(j霉)搴鐞嗗摗鐨勮伔璨�锛�
涓冦€侀棞绯荤郴绲�(t菕ng)鍙婃煡瑭㈠劒(y艒u)鍖�
鑰冭│鍏у
闂滅郴绯荤当(t菕ng)銆佹煡瑭㈠劒(y艒u)鍖�
鑰冭│瑕佹眰
1锛庣悊瑙ｉ棞绯荤郴绲�(t菕ng)鐨勫畾缇╁強鍏跺垎椤炴婧栧拰绋锛�
2锛庝簡瑙ｆ煡瑭㈠劒(y艒u)鍖栫殑姒傚康銆佸繀瑕佹€�銆佷竴鑸簴鍓囧拰閬庣▼
鍏€佹暩(sh霉)鎿�(j霉)搴仮寰╁拰骞剁櫦(f膩)鎺у埗
鑰冭│鍏у
浜嬪嫏姒傚康銆佸苟鐧�(f膩)鎺у埗銆佹暩(sh霉)鎿�(j霉)搴仮寰�
鑰冭│瑕佹眰
1锛庣悊瑙ｄ簨鍕欑殑姒傚康銆佹鎴愭柟寮忓強鐗规€э紱
2锛庝簡瑙ｅ苟鐧�(f膩)瑾垮害鎿嶄綔锛岀悊瑙ｅ苟鐧�(f膩)瑾垮害鎿嶄綔涓嶇暥甯朵締鐨勭浉闂滃晱椤�锛�
3锛庝簡瑙ｅ彲涓茶鍖栬搴︾殑姒傚康鍜屾柟娉曪紝鐞嗚В鍔犻帠鎺у埗姗熷埗鍙婄浉闂滄蹇�锛�
4锛庣悊瑙ｄ笁绱氬皝閹栧崝(xi茅)璀板拰鍏╅殠娈靛皝閹栧崝(xi茅)璀板強鍏舵墍鑳借В姹虹殑鍟忛锛�
5锛庣悊瑙ｆ閹栫殑鍚京銆佺敘鐢熸浠朵互鍙婄浉闂滅殑瑙ｆ焙杈︽硶锛�
6锛庝簡瑙ｅ绮掑害灏侀帠鍜屾剰鍚戦帠鐨勬蹇�锛�
7锛庣悊瑙ｆ暩(sh霉)鎿�(j霉)搴晠闅滅殑绋鍜岀壒寰侊紱
8锛庢帉鎻℃暩(sh霉)鎿�(j霉)搴嚭鐝�(xi脿n)鏁呴殰鍚庨€茶鎭㈠京鐨勬蹇靛拰渚濊炒鐨勪富瑕佹妧琛�锛�
9锛庣悊瑙ｆ暩(sh霉)鎿�(j霉)搴倷浠芥妧琛撲互鍙婂倷浠芥柟寮忓拰绛栫暐锛�
10锛庣悊瑙ｆ暩(sh霉)鎿�(j霉)搴棩蹇楃殑鐩搁棞姒傚康锛�
11锛庢帉鎻″悇绋晠闅滃悗鏁�(sh霉)鎿�(j霉)搴仮寰╃殑绛栫暐鍜屽師鐞嗛亷绋�锛�
? 鍙冮柋锛�
銆婃暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)姒傝珫銆� 钖╁斧鐓娿€佺帇 鐝� 楂樼瓑鏁欒偛鍑虹増
鍏嶈铂鑱叉槑锛氭湰鏂囩郴杞夎級鑷恫绲�锛屽鏈変镜鐘�锛岃珛鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄わ紝鍙︼細鏈枃鍍呬唬琛ㄤ綔鑰呭€嬩汉瑙€榛�锛岃垏鏈恫绔欑劇闂溿€傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏у鏈稉鏈珯璀夊锛屽皪鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収瀹�銆佹枃瀛楃殑鐪熷鎬с€佸畬鏁存€�銆佸強鏅傛€ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛璁€鑰呭儏浣滃弮鑰�锛屽苟璜嬭嚜琛屾牳瀵︾浉闂滃収瀹�銆�
|
鏂囩珷鎼滅储
鎮ㄧ従(xi脿n)鍦ㄧ殑浣嶇疆锛� 
