鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁+銆佸崥澹爺绌剁敓鍏ュ(xu茅)鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗�锛岄儴鍒嗗(xu茅)鏍℃洿鏂拌嚦2012骞�锛�2013骞�锛涘潎鎻愪緵鏀惰不(f猫i)涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛�(di菐n)鎿娾€�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛�(di菐n)鎿娾€�鑰冨崥瑭﹀嵎搴�鈥� 涓嬭級
1 纰╁+鐮旂┒鐢熷叆瀛�(xu茅)鑰冭│澶х侗 鑰冭│绉戠洰鍚嶇ū锛氭暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鍘熺悊 涓€銆佽€冭│澶х侗鎻村紩鏁欐潗 銆婃暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)姒傝珫銆嬬鍥涚増 楂樼瓑鏁欒偛鍑虹増绀� 鐜嬬強 钖╁斧鐓� 浜�銆佽€冭│瑕佹眰 瑕佹眰瀛�(xu茅)鐢熷叏闈㈢郴绲�(t菕ng)鍦版帉鎻℃暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勫熀鏈蹇靛拰鍩烘湰鍘熺悊锛屽苟鑳藉?q奴)顬囶姠椹诡劰纾塎(j矛n)琛岄潏娲婚亱(y霉n)鐢�锛屽叿鏈� 杓冨挤(qi谩ng)鐨勫垎鏋愬晱椤�銆佽В姹哄晱椤岀殑鑳藉姏銆� 涓�銆佽€冭│鍏�(n猫i)瀹癸細 1锛夋暩(sh霉)鎿�(j霉)搴璜� a:浜嗚В鏁�(sh霉)鎿�(j霉)搴殑鍩烘湰姒傚康銆佹暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勭壒榛�(di菐n)銆� b:鎺屾彙鏁�(sh霉)鎿�(j霉)妯″瀷鐨勫熀鏈蹇�銆� c:閲嶉粸(di菐n)鎺屾彙鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)绲�(ji茅)妲�(g貌u)鍜岀祫鎴�銆� 2)闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴� a:浜嗚В闂�(gu膩n)绯绘ā鍨嬬殑鍩烘湰姒傚康锛屼簡瑙i棞(gu膩n)绯绘紨绠�銆� b:鎺屾彙闂�(gu膩n)绯荤殑鍩烘湰琛�(sh霉)瑾炲拰褰㈠紡鍖栧畾缇╋紝鎺屾彙闂�(gu膩n)绯荤殑瀹屾暣鎬х磩鏉�銆� c:閲嶉粸(di菐n)鎺屾彙闂�(gu膩n)绯讳唬鏁�(sh霉)銆� 3)闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴(bi膩o)婧�(zh菙n)瑾炶█ SQL a:浜嗚В SQL 瑾炶█鐨勫熀鏈蹇靛拰鐗归粸(di菐n)銆� b:鎺屾彙鏁�(sh霉)鎿�(j霉)瀹氱京瑾炲彞銆佹暩(sh霉)鎿�(j霉)鏇存柊瑾炲彞鍜屾暩(sh霉)鎿�(j霉)鎺у埗瑾炲彞銆� c:閲嶉粸(di菐n)鎺屾彙鏁�(sh霉)鎿�(j霉)鏌ヨ瑾炲彞銆� d:鎺屾彙瑕栧湒鐨勫畾缇╄垏浣跨敤銆� 4)鏁�(sh霉)鎿�(j霉)搴畨鍏ㄦ€� a:浜嗚В鏁�(sh霉)鎿�(j霉)搴畨鍏ㄦ€х殑姒傚康銆� b:鎺屾彙鏁�(sh霉)鎿�(j霉)搴殑瀹夊叏鎺у埗鎶€琛�(sh霉)銆� 5)鏁�(sh霉)鎿�(j霉)搴畬鏁存€� a:浜嗚В鏁�(sh霉)鎿�(j霉)搴畬鏁存€х殑姒傚康銆� b:鐞嗚В瀹屾暣鎬ф帶鍒舵(j墨)鍒剁殑绲勬垚銆� c: 鎺屾彙鏁�(sh霉)鎿�(j霉)搴畬鏁存€ф帶鍒剁殑鍩烘湰鏂规硶銆� 6)闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)鐞嗚珫 a:浜嗚В闂�(gu膩n)绯绘ā寮忚ō(sh猫)瑷�(j矛)涓瓨鍦ㄧ殑鍟忛銆� b:鎺屾彙鍑芥暩(sh霉)渚濊炒銆侀儴鍒嗗嚱鏁�(sh霉)渚濊炒鍜屽偝閬炲嚱鏁�(sh霉)渚濊炒鐨勬蹇点€� c:鎺屾彙 1NF銆�2NF銆�3NF銆丅CNF 绛夎寖寮忕殑瀹氱京銆� d:鎺屾彙鏁�(sh霉)鎿�(j霉)渚濊炒鐨勫叕鐞嗙郴绲�(t菕ng)銆� e:鐔熺反鎺屾彙灏囬棞(gu膩n)绯昏(gu墨)鑼冨寲鑷� 3NF 鐨勭浉闂�(gu膩n)绠楁硶銆� 7)鏁�(sh霉)鎿�(j霉)搴ō(sh猫)瑷�(j矛) a:鐞嗚В鏁�(sh霉)鎿�(j霉)搴ō(sh猫)瑷�(j矛)鐨勬椹熷強鍚勯殠娈电殑浠诲嫏(w霉)銆� b:鐔熺反鎺屾彙姒傚康绲�(ji茅)妲�(g貌u)瑷�(sh猫)瑷�(j矛)鏂规硶鍜� E-R 鍦栬ō(sh猫)瑷�(j矛)鏂规硶銆� c:鐔熺反鎺屾彙灏� E-R 鍦栬綁(zhu菐n)鎻涙垚闂�(gu膩n)绯绘ā鍨嬬殑鏂规硶銆� d:浜嗚В鏁�(sh霉)鎿�(j霉)搴殑鐗╃悊瑷�(sh猫)瑷�(j矛)銆佹暩(sh霉)鎿�(j霉)搴(sh铆)鏂借垏缍(h霉)銆� 8)鏁�(sh霉)鎿�(j霉)搴法绋� a:鐞嗚В鏁�(sh霉)鎿�(j霉)搴法绋嬩腑寮曞叆宓屽叆寮� SQL 鐨勭洰鐨勫拰浣滅敤銆� 2 b:鎺屾彙宓屽叆寮� SQL 鑸囦富瑾炶█閫氫俊鐨勪笁绋柟寮�銆� c:浜嗚В瀛樺劜(ch菙)閬庣▼鐨勫劒(y艒u)榛�(di菐n)銆� d:浜嗚В ODBC 鐨勪綔鐢ㄥ拰鍩轰簬 ODBC 鐨勬暩(sh霉)鎿�(j霉)搴噳(y墨ng)鐢ㄧ郴绲�(t菕ng)鐨勯珨绯荤祼(ji茅)妲�(g貌u)銆� 9)闂�(gu膩n)绯荤郴绲�(t菕ng)鍙婂叾鏌ヨ鍎�(y艒u)鍖� a:浜嗚В闂�(gu膩n)绯荤郴绲�(t菕ng)鏌ヨ铏曠悊鐨勫熀鏈椹�銆� b:鐞嗚В鏌ヨ鍎�(y艒u)鍖栫殑鍟熺櫦(f膩)寮忚(gu墨)鍓�銆� c:浜嗚В闂�(gu膩n)绯讳唬鏁�(sh霉)绛夊児(ji脿)璁婃彌瑕�(gu墨)鍓囧強琛ㄩ仈(d谩)寮忕殑鍎�(y艒u)鍖栫畻娉曘€� 10)鏁�(sh霉)鎿�(j霉)搴仮寰�(f霉)鎶€琛�(sh霉) a:鎺屾彙浜嬪嫏(w霉)鐨勬蹇靛拰鐗规€�銆� b:鎺屾彙鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)涓晠闅滅殑绋銆� c:鎺屾彙鏁�(sh霉)鎿�(j霉)搴仮寰�(f霉)鐨勫師鐞嗗拰瀵�(sh铆)鐝�(xi脿n)鎶€琛�(sh霉)銆� d: 鎺屾彙鏁�(sh霉)鎿�(j霉)搴殑鎭㈠京(f霉)绛栫暐 e:浜嗚В鍏锋湁妾㈡煡榛�(di菐n)鐨勬晠闅滄仮寰�(f霉)鎶€琛�(sh霉)鍜岄彙鍍忔暩(sh霉)鎿�(j霉)搴殑浣滅敤銆� 11)骞剁櫦(f膩)鎺у埗 a:鐞嗚В鏁�(sh霉)鎿�(j霉)搴苟鐧�(f膩)鎺у埗鐨勬剰缇╁拰鍩烘湰鎶€琛�(sh霉)銆� b:鐞嗚В鍏变韩閹栧拰鎺掑畠閹栫殑鐗归粸(di菐n)锛屾帉鎻′笁绱�(j铆)灏侀帠鍗�(xi茅)璀�銆� c: 鐞嗚В娲婚帠鍜屾閹栫殑鍚京鍜岃В姹鸿睛娉�銆� d: 鐞嗚В浜嬪嫏(w霉)鐨勪覆琛屽寲姒傚康銆� e:鎺屾彙鍏╂閹栭帠鍗�(xi茅)璀扮殑鍏�(n猫i)瀹瑰拰浣滅敤銆� f: 浜嗚В灏侀帠鐨勭矑搴﹀拰涓嶅悓绮掑害灏�(du矛)绯荤当(t菕ng)鐨勫苟鐧�(f膩)搴﹀拰骞剁櫦(f膩)璩囨簮闁嬮姺鐨勫奖闊�銆�
鍏嶈铂(z茅)鑱叉槑锛氭湰鏂囩郴杞�(zhu菐n)杓夎嚜缍�(w菐ng)绲�(lu貌)锛屽鏈変镜鐘�锛岃珛(q菒ng)鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄わ紝鍙︼細鏈枃鍍呬唬琛ㄤ綔鑰呭€�(g猫)浜鸿榛�(di菐n)锛岃垏鏈恫(w菐ng)绔欑劇闂�(gu膩n)銆傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏�(n猫i)瀹规湭缍�(j墨ng)鏈珯璀夊(sh铆)锛屽皪(du矛)鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収(n猫i)瀹�銆佹枃瀛楃殑鐪熷(sh铆)鎬�銆佸畬鏁存€�銆佸強鏅�(sh铆)鎬ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛(q菒ng)璁€鑰呭儏浣滃弮鑰�锛屽苟璜�(q菒ng)鑷鏍稿(sh铆)鐩搁棞(gu膩n)鍏�(n猫i)瀹�銆�
|