|
鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁＋銆佸崥澹爺绌剁敓鍏ュ鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗堬紝閮ㄥ垎瀛告牎鏇存柊鑷�2012骞�锛�2013骞�锛涘潎鎻愪緵鏀惰不涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛炴搳鈥�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛炴搳鈥�鑰冨崥瑭﹀嵎搴�鈥� 涓嬭級
婀栧崡甯寖澶у纰╁＋鐮旂┒鐢熷叆瀛歌€冭│鑷懡椤岃€冭│澶х侗
鑰冭│绉戠洰浠ｇ⒓锛歔 ] 鑰冭│绉戠洰鍚嶇ū锛氭暩(sh霉)鎿氬韩绯荤当(t菕ng)姒傝珫
涓€銆佽│鍗风祼妲�
1) 瑭﹀嵎鎴愮妇鍙婅€冭│鏅傞枔
鏈│鍗锋豢鍒嗙偤 100 鍒嗭紝鑰冭│鏅傞枔鐐� 180 鍒嗛悩銆�
2)绛旈鏂瑰紡锛氶枆鍗�
3)瑭﹀嵎鍏у绲愭
锛堜竴锛夋暩(sh霉)鎿氬韩鍩虹 绱� 15%
锛堜簩锛夐棞绯绘暩(sh霉)鎿氬韩 绱� 15%
锛堜笁锛夐棞绯绘暩(sh霉)鎿氬韩妯欐簴瑾炶█ SQL 绱� 25%
锛堝洓锛夐棞绯绘暩(sh霉)鎿氱悊璜栬垏闂滅郴鏌ヨ鍎�(y艒u)鍖� 绱� 15%
锛堜簲锛夋暩(sh霉)鎿氬韩鐨勫畨鍏ㄨ垏淇濊 绱� 20%
锛堝叚锛夋暩(sh霉)鎿氬韩瑷▓ 绱� 10%
4)椤屽瀷绲愭
a: 鍠爡閬告搰椤�锛�15 灏忛锛屾瘡灏忛 2 鍒嗭紝鍏� 30 鍒�
b: 濉┖椤�锛�10 灏忛锛屾瘡灏忛 2 鍒�锛屽叡 20 鍒�
c: 绨＄瓟椤岋紝3 灏忛锛屾瘡灏忛 5 鍒嗭紝鍏� 15 鍒�
d: 鎳夌敤椤�锛�7 灏忛锛屾瘡灏忛 5 鍒�锛屽叡 35 鍒�
浜屻€佽€冭│鍏у鑸囪€冭│瑕佹眰
锛堜竴锛�銆佹暩(sh霉)鎿氬韩鍩虹
鑰冭│鍏у
锛�1锛夋暩(sh霉)鎿氬韩绯荤当(t菕ng)姒傝堪
锛�2锛夋暩(sh霉)鎿氭ā鍨�
锛�3锛夋暩(sh霉)鎿氬韩绯荤当(t菕ng)绲愭
锛�4锛夋暩(sh霉)鎿氬韩绯荤当(t菕ng)鐨勭祫鎴�
鑰冭│瑕佹眰
锛�1锛変簡瑙ｆ暩(sh霉)鎿�銆佹暩(sh霉)鎿氬韩銆佹暩(sh霉)鎿氬韩绠＄悊绯荤当(t菕ng)鍜屾暩(sh霉)鎿氬韩绯荤当(t菕ng)鐨勬蹇�銆�
锛�2锛変簡瑙ｆ暩(sh霉)鎿氱鐞嗘妧琛撶殑鐧�(f膩)灞曢亷绋嬨€�
锛�3锛変簡瑙ｆ帉鎻℃暩(sh霉)鎿氬韩绯荤当(t菕ng)鐨勭壒榛�
锛�3锛夌悊瑙ｆ暩(sh霉)鎿氬韩鐨勪笁绱氭ā寮忕祼妲�銆佸叐绱氭槧鍍忓姛鑳藉強鏁�(sh霉)鎿氱崹绔嬫€с€�
锛�4锛変簡瑙ｆ蹇垫ā鍨嬪拰鏁�(sh霉)鎿氭ā鍨嬬殑姒傚康鍙婂崁(q奴)鍒�銆�
锛�5锛夌悊瑙ｆ暩(sh霉)鎿氭ā鍨嬬殑绲勬垚瑕佺礌鍜屽吀鍨嬫暩(sh霉)鎿氭ā鍨嬬殑鐗归粸
锛堜簩锛夐棞绯绘暩(sh霉)鎿氬韩
鑰冭│鍏у
锛�1锛夐棞绯绘暩(sh霉)鎿氱祼妲嬪強褰㈠紡鍖栧畾缇�
锛�2锛夐棞绯绘搷浣�
锛�3锛夐棞绯荤殑瀹屾暣鎬�
锛�4锛夐棞绯讳唬鏁�(sh霉)
锛�5锛夐棞绯绘紨绠�
鑰冭│瑕佹眰锛�
锛�1锛夌悊瑙ｉ棞绯荤殑鍩烘湰琛撹獮鍜屽舰寮忓寲瀹氱京
锛�2锛変簡瑙ｉ棞绯绘ā鍨嬬殑绲勬垚
锛�3锛夌悊瑙ｉ棞绯荤殑瀹屾暣鎬х磩鏉�
锛�4锛夋帉鎻￠棞绯讳唬鏁�(sh霉)鐨勫苟銆佷氦銆佸樊銆佺瑳鍗＄埦绌�銆侀伕鎿�銆佹姇褰便€侀€ｆ帴鍜岄櫎閬嬬畻
锛�5锛夋帉鎻￠棞绯绘紨绠楃殑鍏冪祫闂滅郴婕旂畻鍜屽煙闂滅郴婕旂畻
锛堜笁锛夐棞绯绘暩(sh霉)鎿氬韩妯欐簴瑾炶█ SQL
锛�1锛塖QL 姒傝堪
锛�2锛夋暩(sh霉)鎿氬畾缇�
锛�3锛夋暩(sh霉)鎿氭煡瑭�
锛�4锛夋暩(sh霉)鎿氭洿鏂�
锛�5锛夎鍦�
鑰冭│瑕佹眰锛�
锛�1锛変簡瑙� SQL 鐨勭櫦(f膩)灞曡垏妯欐簴鍖�锛屽強 SQL 瑾炶█鐨勭壒榛�銆�
锛�2锛夋帉鎻′娇鐢� SQL 瑾炲彞瀹氱京銆佸埅闄よ垏淇敼鍩烘湰琛�锛屽缓绔嬭垏鍒櫎绱㈠紩
锛�3锛夋帉鎻� SELECT 瑾炲彞鏍煎紡锛堝寘鎷付 WHERE銆丟ROUP BY銆丣OIN 瀛愬彞锛�銆侀€ｆ帴鏌ヨ鍜屽祵
濂楁煡瑭�
锛�4锛夋帉鎻� SQL 涓暩(sh霉)鎿氭洿鏂扮殑 INSERT銆丏ELETE銆乁PDATE 瑾炲彞鏍煎紡鍜岀敤娉曘€�
锛�5锛夌悊瑙� SQL 瑾炶█鐨勬巿娆� GRANT 瑾炲彞鍜屾敹鍥炴瑠闄� REVOKE 瑾炲彞
锛�6锛夋帉鎻′娇鐢� SQL 瑾炲彞瀹氱京鍜屾挙娑堣鍦�锛涙煡瑭㈠拰鏇存柊瑕栧湒
锛堝洓锛夐棞绯绘暩(sh霉)鎿氱悊璜栬垏闂滅郴鏌ヨ鍎�(y艒u)鍖�
鑰冭│鍏у锛�
锛�1锛夎(gu墨)鑼冨寲
锛�2锛夋ā寮忓垎瑙�
锛�3锛夐棞绯绘煡瑭㈠劒(y艒u)鍖�
鑰冭│瑕佹眰
锛�1锛変簡瑙ｉ棞绯绘ā寮忎腑瀛樺湪鐨勫晱椤�
锛�2锛夌悊瑙ｉ棞绯绘ā寮忕殑鍑芥暩(sh霉)渚濊炒锛堝畬鍏�銆侀儴鍒�銆佸偝閬烇級
锛�3锛変簡瑙ｇ⒓娑夊強鐨勬蹇�
锛�3锛夋帉鎻￠棞绯绘ā寮忕殑 1NF-3NF 鍙� BCNF
锛�4锛夌悊瑙ｉ棞绯绘ā寮忕殑鍒嗚В鐗规€э細鐒℃悕/鏈夋悕閫ｆ帴鍒嗚В銆佷繚鎸佸嚱鏁�(sh霉)渚濇嚩鎬у垽鏂�
锛�5锛夌悊瑙ｆ煡瑭㈠劒(y艒u)鍖栫殑鍎�(y艒u)榛炲強绛栫暐
锛�6锛夋帉鎻￠棞绯讳唬鏁�(sh霉)绛夊児璁婃彌瑕�(gu墨)鍓囷紝鍙婇棞绯讳唬鏁�(sh霉)琛ㄩ仈寮忕殑鍎�(y艒u)鍖栫畻娉�
锛堜簲锛�銆佹暩(sh霉)鎿氬韩鐨勫畨鍏ㄨ垏淇濊
鑰冭│鍏у
锛�1锛夋暩(sh霉)鎿氬韩鐨勫畨鍏ㄦ€�
锛�2锛夋暩(sh霉)鎿氬韩鐨勫畬鏁存€�
锛�3锛夋暩(sh霉)鎿氬韩鐨勫苟鐧�(f膩)鎺у埗
锛�4锛夋暩(sh霉)鎿氬韩鐨勬仮寰╂妧琛�
鑰冭│瑕佹眰锛�
锛�1锛夌悊瑙ｆ暩(sh霉)鎿氬韩瀹夊叏鎬х殑姒傚康
锛�2锛変簡瑙ｇ敤鎴舵璀樿垏閼掑垾銆佸瓨鍙栨帶鍒�銆佽嚜涓绘帶鍒舵柟娉�銆佽鍦栨鍒�銆佸瑷�銆佹暩(sh霉)鎿氬姞瀵嗙瓑瀹夊叏
鎬ф帾鏂�
锛�2锛変簡瑙ｅ畬鏁�(sh霉)鎿氬韩瀹屾暣鎬х殑姒傚康鍜岀磩鏉熸浠�
锛�3锛夋帉鎻′笁椤炲畬鏁存€э紙鍙冪収銆佸楂斿拰鐢ㄦ埗鑷畾缇╋級鐨勫鐝�(xi脿n)
锛�4锛変簡瑙ｄ簨鍕欑殑姒傚康鍙婂熀鏈€ц唱
锛�5锛夌悊瑙ｅ苟鐧�(f膩)鑸囧苟鐧�(f膩)鎺у埗鍩烘湰姒傚康锛屽強骞剁櫦(f膩)甯朵締鐨勫晱椤�
锛�6锛夌悊瑙ｅ叡浜帠鍜屾帓浠栭帠鐨勭壒榛�锛屽強涓夌礆灏侀帠鍗�(xi茅)璀板拰浜岄殠娈甸帠鍗�(xi茅)璀般€�
锛�7锛変簡瑙ｆ椿閹栬垏姝婚帠鐨勬蹇佃垏瑙ｆ焙鏂规硶锛屽強灏侀帠绮掑害姒傚康
锛�8锛変簡瑙ｆ暩(sh霉)鎿氬韩绯荤当(t菕ng)涓晠闅滅殑绋锛屾暩(sh霉)鎿氬韩鎭㈠京鐨勬剰缇╁拰瀵︾従(xi脿n)鎶€琛�
锛�9锛夋帉鎻″悇绋晠闅滄仮寰╃瓥鐣�
锛堝叚锛�銆佹暩(sh霉)鎿氬韩瑷▓
鑰冭│鍏у
锛�1锛夋暩(sh霉)鎿氬韩瑷▓姒傝堪
锛�2锛夋暩(sh霉)鎿氬韩瑷▓鐨勯殠娈�
锛�3锛夋暩(sh霉)鎿氬韩鐨勫鏂借垏閬嬭缍
鑰冭│瑕佹眰
锛�1锛変簡瑙ｆ暩(sh霉)鎿氬韩瑷▓鏂规硶銆佹椹�锛屽強鍚勮ō瑷堥殠娈电殑浠诲嫏鍜屾柟娉�
锛�2锛夋帉鎻℃暩(sh霉)鎿氬瓧鍏哥殑绶ㄥ埗
锛�4锛夋帉鎻℃蹇电祼妲嬭ō瑷堟柟娉曞拰锛�-锛插湒瑷▓鏂规硶
锛�5锛夋帉鎻″皣 E-R 妯″瀷杞夋彌鐐洪棞绯绘ā鍨嬬殑鏂规硶鍜岃綁鎻涜(gu墨)鍓�
锛�6锛変簡瑙ｆ暩(sh霉)鎿氬韩鐨勭墿鐞嗚ō瑷堛€佹暩(sh霉)鎿氬韩瀵︽柦鑸囩董璀�
涓�銆佸弮鑰冩浉鐩�
[1] 鐜嬬強锛岃柀甯厞 . 鏁�(sh霉)鎿氬韩绯荤当(t菕ng)姒傝珫(绗洓鐗�). 楂樼瓑鏁欒偛鍑虹増绀�, 2006
[2] 鍔夊厛閶掔瓑. 鏁�(sh霉)鎿氬韩绯荤当(t菕ng)鍘熺悊鑸囨噳鐢�. 鑿腑绉戞妧澶у鍑虹増绀�锛�2012
鍏嶈铂鑱叉槑锛氭湰鏂囩郴杞夎級鑷恫绲�锛屽鏈変镜鐘�锛岃珛鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄わ紝鍙︼細鏈枃鍍呬唬琛ㄤ綔鑰呭€嬩汉瑙€榛�锛岃垏鏈恫绔欑劇闂�銆傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏у鏈稉鏈珯璀夊锛屽皪鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収瀹�銆佹枃瀛楃殑鐪熷鎬с€佸畬鏁存€�銆佸強鏅傛€ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛璁€鑰呭儏浣滃弮鑰�锛屽苟璜嬭嚜琛屾牳瀵︾浉闂滃収瀹�銆�
|
鏂囩珷鎼滅储
鎮ㄧ従(xi脿n)鍦ㄧ殑浣嶇疆锛� 
