鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�(gu贸)400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁+銆佸崥澹爺绌剁敓鍏ュ(xu茅)鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗堬紝閮ㄥ垎瀛�(xu茅)鏍℃洿鏂拌嚦2012骞�锛�2013骞达紱鍧囨彁渚涙敹璨�(f猫i)涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛�(di菐n)鎿娾€�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛�(di菐n)鎿娾€�鑰冨崥瑭﹀嵎搴�(k霉)鈥� 涓嬭級
鍖椾含鏋楁キ(y猫)澶у(xu茅)闆诲瓙鍟嗗嫏(w霉)瀛�(xu茅)绉戙€婃暩(sh霉)鎿�(j霉)搴�(k霉)鎳�(y墨ng)鐢ㄦ妧琛�(sh霉)銆�鑰冪爺澶х侗 锛堣€冭│鏅�(sh铆)闁撶偤 3 灏忔檪(sh铆)锛岀附鍒嗙偤 150 鍒嗭級 銆婃暩(sh霉)鎿�(j霉)搴�(k霉)鎳�(y墨ng)鐢ㄦ妧琛�(sh霉)鏄牨(b脿o)鑰冮浕瀛愬晢鍕�(w霉)瀛�(xu茅)绉戠ⅸ澹爺绌剁敓灏堟キ(y猫)鍩虹(ch菙)瑾茶€冭│绉戠洰涔� 涓€锛� 瑕佹眰瀛�(xu茅)鐢熸帉鎻℃暩(sh霉)鎿�(j霉)搴�(k霉)鐞嗚珫銆佸叿鍌欐噳(y墨ng)鐢ㄦ暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)閫�(j矛n)琛屾暩(sh霉)鎿�(j霉)搴�(k霉)瑷�(sh猫)瑷�(j矛)鍜屾噳(y墨ng)鐢ㄧ殑 鑳藉姏銆�鑰冪爺澶х侗濡備笅锛� 涓€銆佹€ц唱(zh矛) 鍦ㄤ俊鎭寲绀炬渻(hu矛)锛屽厖鍒嗘湁鏁堝湴绠$悊鍜屽埄鐢ㄥ悇椤炰俊鎭硣婧愶紝鏄€�(j矛n)琛岀瀛�(xu茅)鐮旂┒鍜屾焙 绛栫鐞嗙殑鍓嶆彁姊濅欢銆傛暩(sh霉)鎿�(j霉)搴�(k霉)鎶€琛�(sh霉)鏄浕瀛愬晢鍕�(w霉)绯荤当(t菕ng)銆佺鐞嗕俊鎭郴绲�(t菕ng)銆佽睛鍏嚜鍕�(d貌ng)鍖栫郴 绲�(t菕ng)銆佹焙绛栨敮鎸佺郴绲�(t菕ng)绛夊悇椤炰俊鎭郴绲�(t菕ng)鐨勬牳蹇冮儴鍒嗭紝鏄€�(j矛n)琛岀瀛�(xu茅)鐮旂┒鍜屾焙绛栫鐞嗙殑閲� 瑕佹妧琛�(sh霉)鎵嬫銆傛暩(sh霉)鎿�(j霉)搴�(k霉)鎳�(y墨ng)鐢ㄦ妧琛�(sh霉)鏄牨(b脿o)鑰冮浕瀛愬晢鍕�(w霉)瀛�(xu茅)绉戠ⅸ澹爺绌剁敓鐨勯噸瑕佸収(n猫i)瀹�锛屽叡 150 鍒嗐€傜偤渚夸簬鑰冪敓鏄庣⒑鑰冭│寰�(f霉)缈�(x铆)鑼冨湇鍜屼簡瑙h€冭│瑕佹眰锛岀壒鍒跺畾鏈�鑰冪爺澶х侗銆� 浜�銆佺法鍒朵緷鎿�(j霉)鍜岄仼鐢ㄨ寖鍦� 鏈�鑰冪爺澶х侗涓昏鏍规摎(j霉)鍖椾含鏋楁キ(y猫)澶у(xu茅)鏈銆婃暩(sh霉)鎿�(j霉)搴�(k霉)鍘熺悊銆嬫暀瀛�(xu茅)鑰冪爺澶х侗绶ㄥ埗鑰屾垚锛� 閬╃敤浜庡牨(b脿o)鑰冨寳浜灄妤�(y猫)澶у(xu茅)鍏ㄦ棩鍒堕浕瀛愬晢鍕�(w霉)瀛�(xu茅)绉戠ⅸ澹(xu茅)浣嶇爺绌剁敓鐨勮€冪敓銆� 涓�銆� 鑰冭│鍏�(n猫i)瀹� 1. 鏁�(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)姒傝堪 (1) 鏁�(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)姒傝珫 鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨� 4 鍊�(g猫)鍩烘湰姒傚康锛屾暩(sh霉)鎿�(j霉)绠$悊鎶€琛�(sh霉)鐨勭敘(ch菐n)鐢熷拰鐧�(f膩)灞曪紝鏁�(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)鐨勭壒榛�(di菐n)銆� (2) 鏁�(sh霉)鎿�(j霉)妯″瀷 鍏╅鏁�(sh霉)鎿�(j霉)妯″瀷锛屾蹇垫ā鍨�锛屾暩(sh霉)鎿�(j霉)妯″瀷鐨勭祫鎴愯绱�锛屽父鐢ㄧ殑鏁�(sh霉)鎿�(j霉)妯″瀷锛屽堡娆�銆� 缍�(w菐ng)鐙€鍜岄棞(gu膩n)绯讳笁绋ā鍨嬨€� (3) 鏁�(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)绲�(ji茅)妲�(g貌u) 鏁�(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)妯″紡鐨勬蹇�锛屾暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)鐨勪笁绱�(j铆)妯″紡绲�(ji茅)妲�(g貌u)锛屾暩(sh霉)鎿�(j霉)搴�(k霉)鐨勪簩绱�(j铆)鏄犲儚鍔� 鑳借垏鏁�(sh霉)鎿�(j霉)鐛�(d煤)绔嬫€�銆� (4) 鏁�(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)鐨勭祫鎴愩€� 2. 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�(k霉) (1) 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)鍙婂舰寮忓寲瀹氱京锛氶棞(gu膩n)绯�锛岄棞(gu膩n)绯绘ā寮�锛岄棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�(k霉)銆� (2) 闂�(gu膩n)绯绘搷浣滐細鍩烘湰鎿嶄綔锛岄棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)瑾�(y菙)瑷€鐨勫垎椤�銆� (3) 闂�(gu膩n)绯荤殑瀹屾暣鎬э細瀵�(sh铆)楂斿畬鏁存€э紝鍙冪収瀹屾暣鎬�锛岀敤鎴惰嚜瀹氱京瀹屾暣鎬�銆� (4) 闂�(gu膩n)绯讳唬鏁�(sh霉)锛氶泦鍚堥亱(y霉n)绠楋紝闂�(gu膩n)绯婚亱(y霉n)绠�銆� 3. 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�(k霉)妯�(bi膩o)婧�(zh菙n)瑾�(y菙)瑷€鈥斺€擲QL (1) SQL 姒傝堪銆� (2) 瀛�(xu茅)鐢�-瑾茬▼鏁�(sh霉)鎿�(j霉)搴�(k霉)锛屾暩(sh霉)鎿�(j霉)瀹氱京銆� (3) SQL 鏌ヨ锛�?ji菐n)浼伩妯�?锛岄€f帴鏌ヨ锛屽祵濂楁煡瑭�锛岄泦鍚堟煡瑭�锛屽熀浜庢淳鐢熻〃鐨� 鏌ヨ銆� (4) SQL 鏁�(sh霉)鎿�(j霉)鏇存柊锛氭彃鍏ユ暩(sh霉)鎿�(j霉)锛屼慨鏀规暩(sh霉)鎿�(j霉)锛屽埅闄ゆ暩(sh霉)鎿�(j霉)銆� (5) 绌哄€肩殑铏曠悊銆� (6) 瑕栧湒锛氬畾缇╄鍦栵紝鏌ヨ瑕栧湒锛屾洿鏂拌鍦�锛岃鍦栫殑浣滅敤銆� 4. 鏁�(sh霉)鎿�(j霉)搴�(k霉)瀹夊叏鎬� (1) 瀹夊叏鎬ф杩帮細涓嶅畨鍏ㄥ洜绱狅紝瀹夊叏妯�(bi膩o)婧�(zh菙n)銆� (2) 瀹夊叏鎬ф帶鍒讹細鑷富瀛樺彇鎺у埗鏂规硶锛屾巿娆�(qu谩n)鑸囧洖鏀�銆� (3) 瑕栧湒姗�(j墨)鍒躲€� (4) 瀵╄▓(j矛)銆� (5) 鏁�(sh霉)鎿�(j霉)鍔犲瘑銆� 5. 鏁�(sh霉)鎿�(j霉)瀹屾暣鎬� 瀵�(sh铆)楂斿畬鏁存€�锛屽弮鐓у畬鏁存€э紝鐢ㄦ埗鑷畾缇╁畬鏁存€�锛屽畾缇╂暩(sh霉)鎿�(j霉)搴�(k霉)琛ㄧ祼(ji茅)妲�(g貌u)鏅�(sh铆)濡備綍娣� 鍔犱笁绋畬鏁存€�銆� 6. 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�(k霉)鐞嗚珫 (1) 鍟忛鐨勬彁鍑� (2) 瑕�(gu墨)鑼冨寲锛氬嚱鏁�(sh霉)渚濊炒锛岀⒓锛岃寖寮忥紝2NF锛�3NF锛孊CNF锛屽鍊间緷璩达紝4NF锛岃(gu墨) 鑼冨寲灏忕祼(ji茅)銆� 7. 鏁�(sh霉)鎿�(j霉)搴�(k霉)瑷�(sh猫)瑷�(j矛) (1) 鏁�(sh霉)鎿�(j霉)搴�(k霉)瑷�(sh猫)瑷�(j矛)鐨勬杩帮細鏂规硶锛屽熀鏈椹熴€� (2) 闇€姹傚垎鏋愶細浠诲嫏(w霉)銆佹柟娉�銆佹暩(sh霉)鎿�(j霉)瀛楀吀 (3) 姒傚康绲�(ji茅)妲�(g貌u)瑷�(sh猫)瑷�(j矛)锛氭蹇垫ā鍨嬶紝ER 鍦栵紝UML銆� 8. 闂�(gu膩n)绯绘煡瑭㈣檿鐞嗗拰鏌ヨ鍎�(y艒u)鍖� (1) 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�(k霉)鐨勬煡瑭㈣檿鐞嗭細姝ラ锛岀畻娉曠ず渚�銆� (2) 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�(k霉)鐨勬煡瑭㈠劒(y艒u)鍖栵細姒傝堪鑸囧(sh铆)渚�銆� 9. 鏁�(sh霉)鎿�(j霉)搴�(k霉)鎭㈠京(f霉)鎶€琛�(sh霉) (1) 浜嬪嫏(w霉)鐨勫熀鏈蹇� (2) 鏁�(sh霉)鎿�(j霉)搴�(k霉)鎭㈠京(f霉)姒傝堪 (3) 鏁呴殰鐨勭ó椤� (4) 鎭㈠京(f霉)鐨勫(sh铆)鐝�(xi脿n)鎶€琛�(sh霉) (5) 鎭㈠京(f霉)绛栫暐 10. 骞剁櫦(f膩)鎺у埗 (1) 骞剁櫦(f膩)鎺у埗姒傝堪 (2) 灏侀帠 鍥涖€� 鑰冭│瑕佹眰 鑰冪敓鎳�(y墨ng)鍏ㄩ潰鎺屾彙鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨勫熀鏈蹇�銆佺煡璀�(sh铆)鍜岀悊璜栵紱鎺屾彙鏁�(sh霉)鎿�(j霉)搴�(k霉)瑷�(sh猫)瑷�(j矛)鍙婃噳(y墨ng)鐢ㄧ殑 鍩烘湰鐭ヨ瓨(sh铆)鍜屾妧鑳斤紝浜嗚В鍏稿瀷鐨勫ぇ鍨嬪拰妗岄潰鏁�(sh霉)鎿�(j霉)搴�(k霉)绠$悊绯荤当(t菕ng)鐨勪娇鐢ㄧ煡璀�(sh铆)銆� 浜斻€� 瑭﹂绲�(ji茅)妲�(g貌u) 涓€鑸湁浠ヤ笅骞鹃椤屽瀷锛� 1銆佸柈闋�(xi脿ng)閬告搰椤�銆佸闋�(xi脿ng)閬告搰椤�锛� 2銆佸~绌�銆佸垽鏂�銆佸悕瑭炶В閲�锛� 3銆佹暩(sh霉)鎿�(j霉)搴�(k霉)瑷�(sh猫)瑷�(j矛)锛欵R 鍦�锛孍R 鍦栫殑 UML 琛ㄧず鏂规硶锛� 4銆丼QL 瑾�(y菙)鍙ユ噳(y墨ng)鐢�銆� 鍏�銆� 鑰冭│鏂瑰紡 鑰冭│鏂瑰紡鐐洪枆鍗风瓎瑭︼紙鍙冭€冪敤鏅�(sh铆) 180 鍒嗛悩锛�銆� 涓冦€� 涓昏鍙冭€冩浉 銆婃暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)姒傝珫銆嬶紙绗� 5 鐗堬級鐜嬬強锛岃柀甯厞钁�,楂樼瓑鏁欒偛鍑虹増绀惧嚭鐗�锛�2014 骞� 9 鏈�銆� 銆婃暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)姒傝珫 (绗� 5 鐗�) 缈�(x铆)椤岃В鏋愯垏瀵�(sh铆)椹�(y脿n)鎸囧皫(d菐o)銆嬶紝鐜嬬強銆佸嫉淇�锛岄珮绛夋暀 鑲插嚭鐗堢ぞ锛�2015 骞� 7 鏈�銆�
鍏嶈铂(z茅)鑱叉槑锛氭湰鏂囩郴杞�(zhu菐n)杓夎嚜缍�(w菐ng)绲�(lu貌)锛屽鏈変镜鐘�锛岃珛(q菒ng)鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄�锛屽彟锛氭湰鏂囧儏浠h〃浣滆€呭€�(g猫)浜鸿榛�(di菐n)锛岃垏鏈恫(w菐ng)绔欑劇(w煤)闂�(gu膩n)銆傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏�(n猫i)瀹规湭缍�(j墨ng)鏈珯璀夊(sh铆)锛屽皪(du矛)鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収(n猫i)瀹广€佹枃瀛楃殑鐪熷(sh铆)鎬�銆佸畬鏁存€с€佸強鏅�(sh铆)鎬ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛(q菒ng)璁€鑰呭儏浣滃弮鑰�锛屽苟璜�(q菒ng)鑷鏍稿(sh铆)鐩搁棞(gu膩n)鍏�(n猫i)瀹广€�
|