|
鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁＋銆佸崥澹爺绌剁敓鍏ュ(xu茅)鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗�锛岄儴鍒嗗(xu茅)鏍℃洿鏂拌嚦2012骞达紝2013骞�锛涘潎鎻愪緵鏀惰不涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛炴搳鈥�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛炴搳鈥�鑰冨崥瑭﹀嵎搴�鈥� 涓嬭級
澶ч€ｅ伐妤�(y猫)澶у(xu茅)
銆婃暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)銆嬬ⅸ澹爺绌剁敓鎷涚敓纰╁＋鐮旂┒鐢熷叆瀛�(xu茅)鑰冭│澶х侗
涓€銆佽€冭│鐨勭洰鐨勫拰鎬ц唱(zh矛)
鏁�(sh霉)鎿�(j霉)搴師鐞嗘槸瑷堢畻姗熺瀛�(xu茅)鑸囨妧琛�(sh霉)灏堟キ(y猫)銆佺恫(w菐ng)绲�(lu貌)宸ョ▼灏堟キ(y猫)鍙婄浉闂�(gu膩n)灏堟キ(y猫)鐨勯噸瑕佸(xu茅)绉戝熀绀�(ch菙)瑾层€傛暩(sh霉)鎿�(j霉)搴妧
琛�(sh霉)鍜屾暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)宸茬稉(j墨ng)鎴愮偤淇℃伅鍩虹(ch菙)瑷�(sh猫)鏂界殑鏍稿績鎶€琛�(sh霉)鍜岄噸瑕佸熀绀�(ch菙)銆傛暩(sh霉)鎿�(j霉)搴妧琛�(sh霉)浣滅偤鏁�(sh霉)鎿�(j霉)绠＄悊鐨勬渶鏈夋晥
鐨勬墜娈�锛屾サ澶х殑淇冮€蹭簡瑷堢畻姗熸噳(y墨ng)鐢ㄧ殑鐧�(f膩)灞�銆傚(xu茅)鐢熷湪绯荤当(t菕ng)鐨勪簡瑙ｆ暩(sh霉)鎿�(j霉)搴妧琛�(sh霉)鐨勫熀鏈師鐞嗗熀绀�(ch菙)涓�锛岄噸榛�
鎺屾彙瑷�(sh猫)瑷堛€佷娇鐢ㄥ強闁嬬櫦(f膩)鏁�(sh霉)鎿�(j霉)搴強鍏舵噳(y墨ng)鐢ㄧ郴绲�(t菕ng)鐨勫熀鏈柟娉�锛岀偤浠婂悗鐨勯枊鐧�(f膩)瀵﹁笎濂犲畾鑹ソ鐨�銆佸爡瀵︾殑鍩�
绀�(ch菙)銆�
浜屻€佽€冭│鐨勫収(n猫i)瀹瑰拰鑼冨湇
鑰冭│鍏�(n猫i)瀹癸細鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勫熀绀�(ch菙)鐞嗚珫銆佸熀鏈妧琛�(sh霉)鍜屽熀鏈柟娉曘€傚収(n猫i)瀹瑰寘鎷細鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勫熀鏈蹇�銆佹暩(sh霉)
鎿�(j霉)妯″瀷銆侀棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴強鍏舵(bi膩o)婧�(zh菙n)瑾炶█ SQL銆佹暩(sh霉)鎿�(j霉)搴畨鍏ㄦ€у拰瀹屾暣鎬х殑姒傚康鍜屾柟娉�銆侀棞(gu膩n)绯昏(gu墨)
鑼冨寲鐞嗚珫銆佹暩(sh霉)鎿�(j霉)搴ō(sh猫)瑷堟柟娉曞拰姝ラ锛屾暩(sh霉)鎿�(j霉)搴仮寰�(f霉)鍜屽苟鐧�(f膩)鎺у埗绛変簨鍕�(w霉)绠＄悊鍩虹(ch菙)鐭ヨ瓨銆�
鑰冭│鑼冨湇:
绗竴绔� 姒傝珫
鑰冩牳鐭ヨ瓨榛烇細鏁�(sh霉)鎿�(j霉)搴妧琛�(sh霉)涓殑鍩烘湰姒傚康銆佹暩(sh霉)鎿�(j霉)妯″瀷鍙婃暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勯珨绯荤祼(ji茅)妲�(g貌u)銆�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴牁(l菒ng)鍩熺殑鍩烘湰姒傚康
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)妯″瀷
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)绲�(ji茅)妲�(g貌u)
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)绲勬垚
绗簩绔� 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�
鑰冩牳鐭ヨ瓨榛烇細闂�(gu膩n)绯绘ā鍨嬬殑涓夊€嬬祫鎴愰儴鍒嗗強鍚勯儴鍒嗘墍鍖呮嫭鐨勪富瑕佸収(n猫i)瀹�锛岄棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)鍙婂叾瀹氱京锛岄棞(gu膩n)绯�
鐨勪笁椤炲畬鏁存€х磩鏉熺殑姒傚康銆�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)鍙婂舰寮忓寲瀹氱京
鈼� 鎺屾彙闂�(gu膩n)绯绘搷浣�
鈼� 闂�(gu膩n)绯荤殑瀹屾暣鎬�
鈼� 闂�(gu膩n)绯讳唬鏁�(sh霉)
绗笁绔� 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴(bi膩o)婧�(zh菙n)瑾炶█ SQL
鑰冩牳鐭ヨ瓨榛烇細SQL 瑾炲彞鍙婂叾鎳�(y墨ng)鐢�銆�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)瀹氱京
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)鏇存柊
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)鏌ヨ
鈼� 鎺屾彙瑕栧湒鐨勬蹇靛強鎳�(y墨ng)鐢�
绗洓绔� 鏁�(sh霉)鎿�(j霉)搴畨鍏ㄦ€�
鑰冩牳鐭ヨ瓨榛烇細鏁�(sh霉)鎿�(j霉)搴畨鍏ㄦ€х殑姒傚康锛屾暩(sh霉)鎿�(j霉)搴鐞嗙郴绲�(t菕ng)瀵︾従(xi脿n)鏁�(sh霉)鎿�(j霉)搴畨鍏ㄦ€ф帶鍒剁殑甯哥敤鏂规硶鍜屾妧琛�(sh霉)銆�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴畨鍏ㄦ€ф帶鍒跺熀鏈蹇�
鈼� 鎺屾彙瀹夊叏鎬ф帶鍒跺父鐢ㄦ妧琛�(sh霉)
绗簲绔� 鏁�(sh霉)鎿�(j霉)搴畬鏁存€�
鑰冩牳鐭ヨ瓨榛烇細鏁�(sh霉)鎿�(j霉)搴殑瀹屾暣鎬ф蹇�锛屼娇鐢� SQL 瑾炶█瀹氱京闂�(gu膩n)绯绘ā寮忕殑瀹屾暣鎬х磩鏉熸浠躲€�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙瀹屾暣鎬ф蹇�
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴殑瀹屾暣鎬ф帶鍒舵鍒�
鈼� 鎺屾彙绱勬潫姗熷埗鐨勪娇鐢�
鈼� 瑙哥櫦(f膩)鍣ㄧ殑姒傚康鍙婁娇鐢�
绗叚绔犻棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴悊璜�
鏁欏(xu茅)鐩殑鍜岃姹�
鑰冩牳鐭ヨ瓨榛烇細瑕�(gu墨)鑼冨寲鐞嗚珫鍜屽劒(y艒u)鍖栨暩(sh霉)鎿�(j霉)搴ā寮忚ō(sh猫)瑷堢殑鏂规硶銆�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴(gu墨)鑼冨寲鐨勫繀瑕佹€�
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴(gu墨)鑼冨寲涓秹鍙婂埌鐨勫悇绋蹇�
鈼� 鏈冮€茶瑕�(gu墨)鑼冨寲
鈼� 鎺屾彙闂�(gu膩n)绯诲垎瑙ｅ師鍓�
绗竷绔� 鏁�(sh霉)鎿�(j霉)搴ō(sh猫)瑷�
鑰冩牳鐭ヨ瓨榛烇細鏁�(sh霉)鎿�(j霉)搴ō(sh猫)瑷堢殑鍛ㄦ湡鍙婂叾宸ヤ綔鍏�(n猫i)瀹广€�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴ō(sh猫)瑷堟柟娉曞拰姝ラ
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴ō(sh猫)瑷堥亷绋嬩腑娑夊強鐨勬妧琛�(sh霉)
鈼� 鎺屾彙瑷�(sh猫)瑷堟暩(sh霉)鎿�(j霉)搴ā寮忓強鍏峰倷闁嬬櫦(f膩)鏁�(sh霉)鎿�(j霉)搴噳(y墨ng)鐢ㄧ郴绲�(t菕ng)鐨勫熀鏈兘鍔�
绗叓绔� 鏁�(sh霉)鎿�(j霉)搴法绋�
鑰冩牳鐭ヨ瓨榛烇細瀛樺劜閬庣▼鍜屾父妯�(bi膩o)鐨勫熀鏈蹇靛拰浣跨敤鏂规硶銆�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙瀛樺劜閬庣▼鐨勬蹇�銆佸劒(y艒u)缂洪粸鍙婂畾缇╂柟娉�
鈼� 鎺屾彙娓告(bi膩o)鐨勬蹇�銆佸劒(y艒u)缂洪粸鍙婂畾缇╂柟娉�
绗節绔� 鏁�(sh霉)鎿�(j霉)搴仮寰�(f霉)鎶€琛�(sh霉)
鑰冩牳鐭ヨ瓨榛烇細浜嬪嫏(w霉)鐨勬蹇点€佺壒鎬у強浣跨敤鏂规硶锛屾仮寰�(f霉)鎶€琛�(sh霉)鐨勫師鐞嗗強瀵︾従(xi脿n)鏂规硶銆�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙浜嬪嫏(w霉)鐨勬蹇靛強瀹氱京鏂规硶
鈼� 鎺屾彙鏁�(sh霉)鎿�(j霉)搴仮寰�(f霉)鐨勬蹇靛強瀵︾従(xi脿n)鏂规硶
绗崄绔� 骞剁櫦(f膩)鎺у埗
鑰冩牳鐭ヨ瓨榛烇細骞剁櫦(f膩)鎺у埗鎶€琛�(sh霉)鐨勫熀鏈師鐞嗗拰瀵︾従(xi脿n)鏂规硶銆�
鑰冩牳瑕佹眰锛�
鈼� 鎺屾彙骞剁櫦(f膩)鎺у埗鐨勬蹇�
鈼� 鎺屾彙灏侀帠姗熷埗鍙婂皝閹栧崝(xi茅)璀�
涓夈€佽€冭│鐨勬柟娉曞拰褰㈠紡
瑭﹂姣斾緥锛氱涓€銆佸洓銆佷竷銆佷節銆佸崄绔� 35鈩咃紝绗簩绔� 20%锛岀涓�銆佷簲銆佸叓绔� 30%锛岀鍏珷 15%銆�
椤屽瀷姣斾緥锛氬瑙€鎬ц│椤屽崰 50%锛岀偤濉┖椤屻€佸柈閬搁銆佽▓绠楅锛�
涓昏鎬ц│椤屽崰 50%锛岀偤缍滃悎椤�銆�
闆ｅ害绛夌礆锛氬垎鐐虹啊鍠�锛屼腑绛夐洠搴︼紝杓冮洠鎴栭洠涓夊€嬬瓑绱�锛屽ぇ鑷寸殑姣斾緥鏄� 50锛�30锛�20銆�
鍥�銆佹ǎ椤岋細
涓€銆侀伕鎿囬锛堝叡 30 鍒�锛屾瘡绌� 2 鍒嗭級锛�
1锛庢槸浜哄€�?y艒u)姒辫嫃J(r猫n)璀樹笘鐣�,浜ゆ祦淇℃伅,鑰屽皪浜嬬墿閫茶鎻忚堪鐨勭铏熴€�
A.鏁�(sh霉)鎿�(j霉)搴� B.瑷堢畻姗熻獮瑷€ C.鏁�(sh霉)鎿�(j霉) D.绋嬪簭
浜�銆佸～绌洪锛堝叡 10 鍒�锛屾瘡绌� 1 鍒嗭級锛�
1锛�?d膩ng)?sh霉)鎿�(j霉)搴槸闀锋湡瀛樺劜鍦ㄨ▓绠楁鍏�(n猫i)銆� 鐨� 銆� 鐨勬暩(sh霉)鎿�(j霉)闆嗗悎銆�
涓�銆佽▓绠楅锛堝叡 10 鍒�锛屾瘡椤� 1 鍒嗭級锛�
1锛庤ō(sh猫)鏈夐棞(gu膩n)绯� R 鍜� S锛�
R A B C S A B D
1 2 3 1 3 6
1 3 5 3 6 8
2 4 6 1 3 5
3 6 9 3 4 5
瑷堢畻锛�1锛塕? S锛�2锛塕? S锛堝叾涓� 2>2 琛ㄧず R.B>S.B锛夈€傦紙鍏� 6 鍒�锛屾瘡灏忛 3 鍒嗭級
鍥�銆佺稖鍚堥锛堝叡 50 鍒嗭級
1锛庯紙10 鍒嗭級瑷�(sh猫)瑷堜竴鍊嬮仼鍚堝ぇ瀛�(xu茅)閬歌鐨勬暩(sh霉)鎿�(j霉)搴�銆傝┎鏁�(sh霉)鎿�(j霉)搴噳(y墨ng)鍖呮嫭瀛�(xu茅)鐢�銆佹暀甯�銆佽绋嬶紝瀛�(xu茅)鐢熼伕瑾�锛屾暀甯�
鏁欒锛屽(xu茅)鐢熼伕瑾插悗鏈夋垚绺俱€備竴鍚嶅(xu茅)鐢熷彲閬稿闁€瑾�锛屼竴闁€瑾插彲浠ヨ澶氬悕瀛�(xu茅)鐢熼伕锛屼竴鍚嶆暀甯彲浠ユ暀鑻ュ共
闁€瑾�锛屼竴闁€瑾插彲浠ヨ澶氬悕鏁欏斧璎�銆�
锛�1锛夌敤 ER 鍦栨弿杩拌┎鏁�(sh霉)鎿�(j霉)搴�锛涳紙5 鍒嗭級锛�2锛夊皣 ER 鍦栬綁(zhu菐n)鎻涙垚闂�(gu膩n)绯绘ā寮�锛屾寚鍑洪棞(gu膩n)绯绘ā寮忕殑涓诲閸�銆傦紙5 鍒嗭級
2>2
鍏嶈铂(z茅)鑱叉槑锛氭湰鏂囩郴杞�(zhu菐n)杓夎嚜缍�(w菐ng)绲�(lu貌)锛屽鏈変镜鐘�锛岃珛鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄わ紝鍙︼細鏈枃鍍呬唬琛ㄤ綔鑰呭€嬩汉瑙€榛�锛岃垏鏈恫(w菐ng)绔欑劇闂�(gu膩n)銆傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏�(n猫i)瀹规湭缍�(j墨ng)鏈珯璀夊锛屽皪鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収(n猫i)瀹广€佹枃瀛楃殑鐪熷鎬�銆佸畬鏁存€с€佸強鏅傛€ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛璁€鑰呭儏浣滃弮鑰�锛屽苟璜嬭嚜琛屾牳瀵︾浉闂�(gu膩n)鍏�(n猫i)瀹广€�
|
鏂囩珷鎼滅储
鎮ㄧ従(xi脿n)鍦ㄧ殑浣嶇疆锛� 
