鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁+銆佸崥澹爺绌剁敓鍏ュ鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗�锛岄儴鍒嗗鏍℃洿鏂拌嚦2012骞达紝2013骞�锛涘潎鎻愪緵鏀惰不涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛炴搳鈥�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛炴搳鈥�鑰冨崥瑭﹀嵎搴�鈥� 涓嬭級
1 鑿腑绉戞妧澶у鍗氬+鐮旂┒鐢熷叆瀛歌€冭│銆婃暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)锛堜簩锛夈€嬭€冭│澶х侗 涓€銆� 鑰冭│鎬ц唱(zh矛) 閫氶亷鑰冭│锛屼繚璀夋墍閷勫彇鐨勮€冪敓宸插叿鍌欐暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勫熀绀�(ch菙)鐞嗚珫鐭ヨ瓨鍙婄浉 鎳夌殑缍滃悎閬嬬敤鑳藉姏銆傜啛鎮夋暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勫熀鏈蹇�銆佸師鐞嗗拰鍩虹(ch菙)鐞嗚珫锛涚啛鎮� 闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)妯″瀷锛岄棞(gu膩n)绯讳唬鏁�(sh霉)銆侀棞(gu膩n)绯荤郴绲�(t菕ng)銆侀棞(gu膩n)绯昏(gu墨)鑼冨寲绛夐棞(gu膩n)绯荤悊璜�锛屼互鍙婃暩(sh霉)鎿�(j霉) 搴仮寰┿€佸苟鐧�(f膩)鎺у埗銆佸畨鍏ㄦ€�銆佸畬鏁存€х瓑鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鎶€琛�(sh霉)锛涙帉鎻� SQL 浣跨敤鏂� 娉曪紝骞惰兘閲濆皪鐢熺墿淇℃伅瀛搁牁(l菒ng)鍩熻ō瑷堣垏鍒朵綔鐩告噳鐨勯棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴噳鐢ㄧ郴绲�(t菕ng)锛涘皪 web 鏁�(sh霉)鎿�(j霉)搴妧琛�(sh霉)绛夋湁涓€瀹氱殑浜嗚В銆� 浜�銆� 鑰冭│褰㈠紡 1銆佽€冭│鏂瑰紡锛氶枆鍗�銆佺瓎瑭� 2銆佽€冭│鏅傞枔锛�180 鍒嗛悩 3銆侀鍨嬪強姣斾緥锛� 濉┖椤� 10%宸﹀彸 閬告搰椤� 10%宸﹀彸 绨$瓟椤� 20%宸﹀彸 瑷▓瑷堢畻 30%宸﹀彸 缍滃悎鎳夌敤 30%宸﹀彸 鍥�銆� 鑰冩煡瑕侀粸 1銆佸熀鏈蹇� 鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)姒傝堪锛氭暩(sh霉)鎿�(j霉)銆佹暩(sh霉)鎿�(j霉)搴€佹暩(sh霉)鎿�(j霉)搴鐞嗙郴绲�(t菕ng)銆佹暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)銆佹暩(sh霉) 鎿�(j霉)搴郴绲�(t菕ng)鐨勭壒榛炵瓑鍩烘湰姒傚康鐨勫畾缇╄垏鐞嗚В銆� 鏁�(sh霉)鎿�(j霉)妯″瀷锛氬堡娆�銆佺恫(w菐ng)鐙€銆侀棞(gu膩n)绯�銆丒-R 妯″瀷绛夌殑妲�(g貌u)閫犲舰寮忓強鐗归粸銆傞噸榛� 鏄棞(gu膩n)绯诲強 E-R 妯″瀷锛岃姹傜啛绶存帉鎻″叾姒傚康銆佹妧琛�(sh霉)鍙婂缓妯℃柟娉�銆� 鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)绲�(ji茅)妲�(g貌u)锛氭暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勪笁绱氭ā寮忚垏浜岀礆鏄犺薄銆� 2 2銆侀棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴� 浜嗚В闂�(gu膩n)绯绘ā鍨�銆侀棞(gu膩n)绯绘ā寮�銆侀棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴瓑鍩烘湰姒傚康浠ュ強闂�(gu膩n)绯讳唬鏁�(sh霉)鑸囬棞(gu膩n) 绯绘紨绠楃悊璜�銆� 3銆侀棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴婧栬獮瑷€ SQL 鍚勯 SQL 瑾炲彞鐨勮獮娉曟(g貌u)鎴�銆佽獮缇╄垏鍔熻兘锛岀壒鍒ユ槸 Select 瑾炲彞鐨勪笉鍚屾噳 鐢ㄦ柟娉�銆� 4銆侀棞(gu膩n)绯荤郴绲�(t菕ng)鍙婂叾鏌ヨ鍎�(y艒u)鍖� 闂�(gu膩n)绯荤郴绲�(t菕ng)鐨勫熀鏈蹇碉紝闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勬煡瑭㈣檿鐞嗗強鍏跺劒(y艒u)鍖栨柟娉�銆� 5銆侀棞(gu膩n)绯绘暩(sh霉)鎿�(j霉)鐞嗚珫 闂�(gu膩n)绯昏(gu墨)鑼冨寲锛氬嚱鏁�(sh霉)渚濊炒涓殑閮ㄥ垎鍑芥暩(sh霉)渚濊炒銆佸畬鍏ㄥ嚱鏁�(sh霉)渚濊炒銆佸偝閬炲嚱鏁�(sh霉) 渚濊炒锛涢棞(gu膩n)绯昏寖寮忎腑鐨� 1NF銆�2NF銆�3NF銆丅CNF銆� 鏁�(sh霉)鎿�(j霉)渚濊炒鐨勫叕鐞嗙郴绲�(t菕ng) 妯″紡鐨勫垎瑙o細妯″紡鍒嗚В鐨勭劇鎼嶉€f帴鎬�銆佷繚鎸佸嚱鏁�(sh霉)渚濊炒鎬у強妯″紡鍒嗚В绠� 娉�銆� 6銆佹暩(sh霉)鎿�(j霉)搴ō瑷� 鏁�(sh霉)鎿�(j霉)搴ō瑷堢殑鍩烘湰姝ラ銆佸眬閮� E-R 鍦栬ō瑷�銆佸眬閮� E-R 鍦栧埌鍏ㄥ眬 E-R 鍦� 鐨勫悎骞躲€丒-R 鍦栧悜闂�(gu膩n)绯绘ā寮忕殑杞�(zhu菐n)鎻�銆佹暩(sh霉)鎿�(j霉)搴殑鐗╃悊瑷▓浠ュ強閲濆皪鐢熺墿淇℃伅 瀛搁牁(l菒ng)鍩熺殑鎳夌敤瀵︿緥绛�銆� 7銆佹暩(sh霉)鎿�(j霉)搴仮寰╂妧琛�(sh霉) 浜嬪嫏鐨勬蹇靛強鐗瑰緛銆佹暩(sh霉)鎿�(j霉)杞�(zhu菐n)鍎茶垏鏃ュ織绛夋仮寰╃殑瀵︾従(xi脿n)鎶€琛�(sh霉)銆佹晠闅滄仮寰╃瓥 鐣ョ瓑銆� 8銆佸苟鐧�(f膩)鎺у埗 骞剁櫦(f膩)鎺у埗鐨勫熀鏈蹇�锛屽苟鐧�(f膩)鎺у埗鑸囧鐝�(xi脿n)鎶€琛�(sh霉)锛屽挨鍏舵槸灏侀帠鎶€琛�(sh霉)鐨勫鏂� 绛�銆� 9銆佹暩(sh霉)鎿�(j霉)搴畨鍏ㄦ€� 瑷堢畻姗熺郴绲�(t菕ng)鐨勪笁椤炲畨鍏ㄦ€у晱椤屼互鍙婃暩(sh霉)鎿�(j霉)搴畨鍏ㄦ€ф帶鍒剁殑鍩烘湰鎶€琛�(sh霉)銆� 3 10銆佹暩(sh霉)鎿�(j霉)搴畬鏁存€� 瀹屾暣鎬х磩鏉熸浠跺強瀹屾暣鎬ф帶鍒�銆� 11銆佹暩(sh霉)鎿�(j霉)搴鐞嗙郴绲�(t菕ng) DBMS 鐨勫熀鏈蹇佃垏绯荤当(t菕ng)灞ゆ绲�(ji茅)妲�(g貌u)銆� 12銆佹暩(sh霉)鎿�(j霉)搴噳鐢ㄧ郴绲�(t菕ng) 閲濆皪鐢熺墿淇℃伅瀛搁牁(l菒ng)鍩�锛岀祼(ji茅)鍚� web 鎶€琛�(sh霉)锛屽埄鐢ㄥ凡鏈夌殑 MySQL 绛夐棞(gu膩n)绯绘暩(sh霉) 鎿�(j霉)搴鐞嗙郴绲�(t菕ng)瑷▓鑸囧埗浣滅浉鎳夌殑鐢熺墿淇℃伅瀛� web 鏁�(sh霉)鎿�(j霉)搴噳鐢ㄧ郴绲�(t菕ng)銆�
鍏嶈铂鑱叉槑锛氭湰鏂囩郴杞�(zhu菐n)杓夎嚜缍�(w菐ng)绲★紝濡傛湁渚电姱锛岃珛鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄わ紝鍙︼細鏈枃鍍呬唬琛ㄤ綔鑰呭€嬩汉瑙€榛�锛岃垏鏈恫(w菐ng)绔欑劇闂�(gu膩n)銆傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏�(n猫i)瀹规湭缍�(j墨ng)鏈珯璀夊锛屽皪鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収(n猫i)瀹�銆佹枃瀛楃殑鐪熷鎬с€佸畬鏁存€�銆佸強鏅傛€ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛璁€鑰呭儏浣滃弮鑰�锛屽苟璜嬭嚜琛屾牳瀵︾浉闂�(gu膩n)鍏�(n猫i)瀹�銆�
|