姝¤繋瑷晱鑰冪爺绉樼睄鑰冪爺缍�(w菐ng)!    鐮旂┒鐢熸嫑鐢熶俊鎭恫(w菐ng)    鑰冨崥鐪熼涓嬭級    鑰冪爺鐪熼涓嬭級    鍏ㄧ珯鏂囩珷绱㈠紩
鏂囩珷鎼滅储
   
  楂樼礆鎼滅储   

 鎮ㄧ従(xi脿n)鍦ㄧ殑浣嶇疆锛� 鑰冪爺绉樼睄鑰冪爺缍�(w菐ng) >> 鏂囩珷涓績 >> 灏堟キ(y猫)瑾� >> 姝f枃  2018骞磋彲鍍戝ぇ瀛�(xu茅)826鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鍘熺悊纰╁+鐮旂┒鐢熷叆瀛�(xu茅)鑰冭│瑭﹂

鏂拌仦璩囪▕
鏅€氭枃绔� 涓婃捣甯�50瀹跺柈浣嶇恫(w菐ng)涓婃帴鍙楀挩瑭㈠拰鍫卞悕
鏅€氭枃绔� 鍖椾含澶у(xu茅)鐢�“灏辨キ(y猫)涔嬪”鐮旂┒鐢熷皥鍫存嫑鑱樺牬闈㈢伀鐖�
鏅€氭枃绔� 寤堝ぇ濂崇爺绌剁敓琚妗堢祩瀵╁垽姹� 鍏囨墜琚垽姝诲垜
鏅€氭枃绔� 寤f澅鍏牎缍�(w菐ng)涓婅│榛�(di菐n)鑰冪爺鍫卞悕灏囬枊濮�
鏅€氭枃绔� 2004骞寸ⅸ澹寳浜嫑鐢熷柈浣嶅牨鍚嶉粸(di菐n)涓€瑕�
鏅€氭枃绔� 娲涢櫧楂樻柊鍗€(q奴)21鍚嶇ⅸ澹爺绌剁敓琚仒鐐轰腑灞ら牁(l菒ng)灏�(d菐o)
鏅€氭枃绔� 娴欐睙鐪佺ⅸ澹爺绌剁敓鍫卞悕寰炰笅鍛ㄤ竴闁嬪
鏅€氭枃绔� 2004骞翠笂?锛熺礀^(q奴)缍�(w菐ng)涓婂牨鍚嶆檪闁撳畨鎺掕〃
鏅€氭枃绔� 寤f澅锛氱爺绌剁敓鍏ュ(xu茅)鑰冭│2003骞磋捣閲嶅ぇ瑾�(di脿o)鏁�
鏅€氭枃绔� 2004骞村叏鍦嬬爺鎷涗笂?锛熺礀^(q奴)鍫卞悕榛�(di菐n)涓€瑕借〃
瑾�(di脿o)鍔戜俊鎭�
鏅€氭枃绔� 瀵у澶у(xu茅)04骞寸ⅸ澹爺绌剁敓瑾�(di脿o)鍔戜俊鎭�
鏅€氭枃绔� 澶ч€i惖閬撳(xu茅)闄�04骞寸ⅸ澹帴鏀惰(di脿o)鍔戠敓婧愬熀鏈師鍓�
鏅€氭枃绔� 鍚夋灄澶у(xu茅)寤鸿ō(sh猫)宸ョ▼瀛�(xu茅)闄�04骞寸爺绌剁敓瑾�(di脿o)鍔戜俊鎭�
鏅€氭枃绔� 婧窞甯寖瀛�(xu茅)闄�(婧窞澶у(xu茅)绫�)05鐮旂┒鐢熻(di脿o)鍔戜俊鎭�
鏅€氭枃绔� 浣虫湪鏂ぇ瀛�(xu茅)04骞磋€冪爺瑾�(di脿o)鍔戜俊鎭�
鏅€氭枃绔� 娌堥櫧寤虹瓚宸ョ▼瀛�(xu茅)闄�04骞寸爺绌剁敓瑾�(di脿o)鍔戜俊鎭�
鏅€氭枃绔� 澶╂触甯寖澶у(xu茅)鏀挎不鑸囪鏀垮(xu茅)闄�05骞寸ⅸ澹(di脿o)鍔戦渶姹�
鏅€氭枃绔� 绗簩蹇楁効鑰冪爺瑾�(di脿o)鍔戠▼搴忕瓟鐤�
鏅€氭枃绔� 涓婃捣澶у(xu茅)04骞寸爺绌剁敓鎷涙敹绲�(t菕ng)鑰冪敓瑾�(di脿o)鍔戜俊鎭�
鏅€氭枃绔� 寤hタ澶у(xu茅)04骞寸ⅸ澹爺绌剁敓瑾�(di脿o)鍔戜俊鎭�

鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁+銆佸崥澹爺绌剁敓鍏ュ(xu茅)鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗�锛岄儴鍒嗗(xu茅)鏍℃洿鏂拌嚦2012骞�锛�2013骞�锛涘潎鎻愪緵鏀惰不(f猫i)涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛�(di菐n)鎿娾€�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛�(di菐n)鎿娾€�鑰冨崥瑭﹀嵎搴�鈥� 涓嬭級 

绗� 1 闋� 鍏� 6 闋�
鑿儜澶у(xu茅) 2018 骞寸ⅸ澹爺绌剁敓鍏ュ(xu茅)鑰冭│灏堟キ(y猫)瑾茶│鍗�
锛堢瓟妗堝繀闋堝鍦ㄧ瓟椤岀礄涓婏級
鎷涚敓灏堟キ(y猫) 杌熶欢宸ョ▼
绉戠洰鍚嶇ū 鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鍘熺悊 绉戠洰浠g⒓ 826
涓€銆侀伕鎿囬 (姣忛 3 鍒�锛屽叡 60 鍒�)
1銆侀棞(gu膩n)浜庨嵉鐨勬弿杩�锛屼笅闈㈤尟瑾ょ殑鏄� 锛� 锛�銆�
A锛夊湪闂�(gu膩n)绯讳腑鑳藉敮涓€妯�(bi膩o)璀樺厓绲勭殑灞€ч泦绋辩偤闂�(gu膩n)绯绘ā寮忕殑瓒呴嵉
B锛変笉鍚湁澶氫綑灞€х殑瓒呴嵉绋辩偤鍊欓伕閸�
C锛夊鏋滄ā寮� R 涓爆鎬� K 鏄叾浠栨ā寮忕殑涓婚嵉锛岄偅涔� K 鍦ㄦā寮� R 涓ū鐐哄収(n猫i)閸�
D锛夌敤鎴堕伕浣滃厓绲勬(bi膩o)璀樼殑鍊欓伕閸电ū鐐轰富閸�
2銆佸湪闂�(gu膩n)绯绘ā鍨嬩腑锛屽皪闂�(gu膩n)绯荤殑鏁樿堪涓嶆纰虹殑鏄紙 锛�銆�
A锛夐棞(gu膩n)绯讳腑姣忎竴鍊嬪爆鎬у€奸兘鏄笉鍙垎瑙g殑
B锛夐棞(gu膩n)绯讳腑鍏佽ū鍑虹従(xi脿n)閲嶅京(f霉)鍏冪祫
C锛夌敱浜庨棞(gu膩n)绯绘槸涓€鍊嬮泦鍚堬紝鍥犳涓嶈€冩叜鍏冪祫闁撶殑闋嗗簭锛屽嵆娌掓湁琛屽簭
D锛夊厓绲勪腑鐨勫爆鎬у湪鐞嗚珫涓婁篃鏄劇搴忕殑
3銆佹暩(sh霉)鎿�(j霉)搴笁绱氭ā寮忎腑,鐢ㄦ埗鑸囨暩(sh霉)鎿�(j霉)搴噳(y墨ng)鐢ㄧ郴绲�(t菕ng)鐨勬帴鍙f槸锛� 锛夈€�
A)妯″紡 B)澶栨ā寮� C)鍏�(n猫i)妯″紡 D)閭忚集妯″紡
4銆佺偤浜嗚В姹哄苟鐧�(f膩)鎿嶄綔甯朵締鐨勬暩(sh霉)鎿�(j霉)涓嶄竴鑷寸殑鍟忛锛孌BMS 閫氬父閲�?銆�?锛夋妧琛�(sh霉)銆�
A) 鎭㈠京(f霉) B) 瀹屾暣鎬ф帶鍒� C) 鎺堟瑠(qu谩n) D) 灏侀帠
5銆佸湪鏁�(sh霉)鎿�(j霉)搴妧琛�(sh霉)涓�,"鑷熸暩(sh霉)鎿�(j霉)"鏄寚( )銆�
A)鏈洖閫€鐨勬暩(sh霉)鎿�(j霉) B)鏈彁浜ょ殑鏁�(sh霉)鎿�(j霉)
C)鍥為€€鐨勬暩(sh霉)鎿�(j霉) D)鏈彁浜ら毃鍚庡張琚挙閵风殑鏁�(sh霉)鎿�(j霉)
6銆侀棞(gu膩n)绯绘ā寮忚嚦灏戞噳(y墨ng)瑭插爆浜�( )銆�
A)1NF B)2NF C)3NF D)BCNF
7銆佽ō(sh猫)闂�(gu膩n)绯绘ā寮� R(A,B,C,D)锛孎(xi脿n)={A鈫払, B鈫扖 }鏄� R 涓婄殑 FD 闆�锛屽墖灞€ч泦 BD 鐨勯枆鍖厈BD}
+
鐐猴紙 锛夈€�
A锛塀D B锛塁D C锛塀C D锛塀CD
8銆佷笅闈笉鏄暩(sh霉)鎿�(j霉)搴仮寰�(f霉)閲囩敤鐨勬柟娉曟槸锛� 锛�銆�
A)寤虹珛妾㈡煡榛�(di菐n) B)寤虹珛鍓湰 C)寤虹珛鏃ュ織鏂囦欢 D)寤虹珛绱㈠紩
绗� 2 闋� 鍏� 6 闋�
9銆佸湪闂�(gu膩n)绯讳唬鏁�(sh霉)閬�(y霉n)绠椾腑锛屼簲绋熀鏈亱(y霉n)绠楃偤锛� 锛�銆�
A锛夊苟銆佸樊銆侀伕鎿囥€佹姇褰�銆佽嚜鐒堕€f帴 B锛夊苟銆佸樊銆佷氦銆侀伕鎿�銆佹姇褰�
C锛夊苟銆佸樊銆侀伕鎿�銆佹姇褰便€佺瑳鍗$埦绌� D锛夊苟銆佸樊銆佷氦銆侀伕鎿�銆佷箻绌�
10銆佷笅闈㈤棞(gu膩n)浜庡鍊间緷璩寸殑閬搁爡(xi脿ng)涓�锛岄尟瑾ょ殑鏄紙 锛�銆�
A) 鑻� A鈫掆啋BC锛屽墖 A鈫掆啋B锛孉鈫掆啋C B) 鑻� A鈫掆啋B锛屽墖 A鈫払
C) 鑻� A鈫掆啋B锛孊鈫掆啋C锛屽墖 A鈫掆啋C D) 鑻� A鈫掆啋B锛屽墖 A鈫掆啋C锛屽叾涓� C=Z-A-B
11銆佸湪 SQL 瑾炶█涓�锛岀敤浜庢脯瑭﹀垪鍊奸潪绌虹殑鐭獮鏄�( ) 銆�
A. IS NOT EMPTY B. NOT UNIQUE
C. IS NOT NULL D. NOT EXISTS
12銆丼QL2 鎻愪緵浜嬪嫏(w霉)鐨勫洓绋殧闆㈢礆鍒ワ紝鍏朵腑鏈€楂樼礆鍒ユ槸( )銆�
A. SERIALIZABLE B. REPEATABLE READ
C. READ COMMITTED D. READ UNCOMMITTED
13銆乆鈫扽 鑳界敤 FD 鎺ㄧ悊瑕�(gu墨)鍓囨帹鍑虹殑鍏呭垎蹇呰姊濅欢鏄�( ) 銆�
A.Y X B.Y X+
C.X Y+
D.X+
=Y+
14銆佽ō(sh猫)鏈夐棞(gu膩n)绯� R锛圓,B,C锛夌殑鍊煎涓�锛屼笅鍒楁晿杩版纰虹殑鏄紙 锛夈€�
A) 鍑芥暩(sh霉)渚濊炒 A鈫払 鍦ㄤ笂杩伴棞(gu膩n)绯讳腑鎴愮珛
B) 鍑芥暩(sh霉)渚濊炒 BC鈫扐 鍦ㄤ笂杩伴棞(gu膩n)绯讳腑鎴愮珛
C) 鍑芥暩(sh霉)渚濊炒 B鈫扐 鍦ㄤ笂杩伴棞(gu膩n)绯讳腑鎴愮珛
D) 鍑芥暩(sh霉)渚濊炒 A鈫払C 鍦ㄤ笂杩伴棞(gu膩n)绯讳腑鎴愮珛
15銆佽ō(sh猫)灏嶅苟鐧�(f膩)浜嬪嫏(w霉) T1 鍜� T2 鐨勪氦鍙夊苟琛屽煼(zh铆)琛屽涓嬶紝鍩�(zh铆)琛岄亷绋嬩腑锛� 锛夈€�
T1 T2
鈶� READ(A)
鈶� READ(A)
鈶� A=A+10 瀵洖
鈶� READ锛圓锛�
A) 鏈変笩澶变慨鏀瑰晱椤� B) 鏈変笉鑳介噸寰�(f霉)璁€鍟忛
C) 鏈夎畝鑷熸暩(sh霉)鎿�(j霉)鍟忛 D) 娌掓湁浠讳綍鍟忛
16銆佸湪宓屽叆寮� SQL 瑾炶█涓娇鐢ㄦ父妯�(bi膩o)鐨勭洰鐨勫湪浜庯紙 锛夈€�
A B C
a2 b2 c3
a2 b3 c5
a1 b3 c4
绗� 3 闋� 鍏� 6 闋�
A锛夊崁(q奴)鍒� SQL 鑸囧涓昏獮瑷€ B锛夎垏鏁�(sh霉)鎿�(j霉)搴€氫俊
C锛夎檿鐞嗛尟瑾や俊鎭� D锛夎檿鐞嗗琛岃閷�
17銆佸湪闂�(gu膩n)绯� R 鑸囬棞(gu膩n)绯� S 閫�(j矛n)琛岃嚜鐒堕€f帴鏅�锛屾妸 R 鍜� S 涓殑鎳告诞鍏冪祫淇濆瓨鍒扮祼(ji茅)鏋滈棞(gu膩n)绯讳腑锛岄€�
绋搷浣滅ū鐐猴紙 锛�銆�
A) 瀹屽叏澶栭€f帴 B) 鍏�(n猫i)閫f帴 C) 宸﹀閫f帴 D) 鍙冲閫f帴
18銆佸凡鐭ラ棞(gu膩n)绯� R 鍜� S 濡傚湒鎵€绀�锛屽爆鎬� A 鐐� R 鐨勪富纰�锛孲 鐨勫纰�锛屽爆鎬� C 鐐� S 鐨勪富纰�. S 涓�
閬曞弽鍙冪収瀹屾暣鎬х祼(ji茅)鏉熺殑鍏冪祫鏄紙 锛�銆�
R S
A B
a1
a2
b1
b5
A) {c1,d1,a1} B) {c2,d4,null} C) {c3,d1,a3} D) {c4,d3,a2}
19銆佷笅鍒� SQL 瑾炲彞涓�锛岃兘澶�?q奴)宕縁(xi脿n)鈥滄敹鍥炵敤鎴� ZHAO 灏嶅(xu茅)鐢熻〃锛圫TUDENT锛変腑瀛�(xu茅)铏燂紙XH锛夌殑
淇敼娆�(qu谩n)鈥濋€欎竴鍔熻兘鐨勬槸锛� 锛�銆�
A锛塕EVOKE UPDATE(XH) ON TABLE FROM ZHAO
B锛塕EVOKE UPDATE(XH) ON TABLE FROM PUBLIC
C锛塕EVOKE UPDATE(XH) ON STUDENT FROM ZHAO
D锛塕EVOKE UPDATE(XH) ON STUDENT FROM PUBLIC
20銆佷笅闈㈤伕闋�(xi脿ng)涓�锛屼笉鏄崐绲�(ji茅)妲�(g貌u)鏁�(sh霉)鎿�(j霉)鐗归粸(di菐n)鐨勬槸锛� 锛�銆�
A锛夋湁鍥哄畾鐨勬暩(sh霉)鎿�(j霉)妯″紡 B锛夋ā寮忛毐鍚簬鏁�(sh霉)鎿�(j霉)涓�
C锛夐潏娲绘€ч珮 D锛夋湁鍒╀簬鏁�(sh霉)鎿�(j霉)闆嗘垚
浜屻€佺啊绛旈锛�7 椤�锛屽叡 70 鍒嗭級
1銆佷粈涔堟槸灞€х殑闁夊寘锛屽爆鎬ч枆鍖呰▓绠楁湁浣曠敤閫�锛屽爆鎬х殑闁夊寘鍜岄嵉涔嬮枔鏈変綍闂�(gu膩n)绯�銆� (8 鍒�)
2銆佷粈涔堟槸鈥滀覆琛岃(di脿o)搴︹€�锛屼粈涔堟槸鈥滃苟琛岃(di脿o)搴︹€濓紝琛¢噺骞惰瑾�(di脿o)搴︽纰鸿垏鍚︾殑妯�(bi膩o)婧�(zh菙n)鏄粈涔�锛�
绨¤堪浜嬪嫏(w霉)鐨勫苟鐧�(f膩)瑾�(di脿o)搴︽渻甯朵締鐨勫晱椤�銆傦紙8 鍒嗭級
C D A
c1
c2
c3
c4
d1
d4
d1
d3
a1
null
a3
a2
绗� 4 闋� 鍏� 6 闋�
3銆佽珛绨¤堪闂�(gu膩n)绯绘ā寮忓垎瑙g殑鈥滅劇鎼嶅垎瑙f€р€濆拰鈥滃嚱鏁�(sh霉)渚濊炒淇濇寔鎬р€濄€侭CNF 鍜� 3NF 鍒嗗垾婊胯冻
鍝ó鍒嗚В鐗规€�銆傦紙8 鍒嗭級
4銆佽ō(sh猫)闂�(gu膩n)绯绘ā寮� R(A,B,C)涓婃湁涓€鍊嬪鍊间緷璩� A鈫掆啋C銆傚鏋滃凡鐭� R 鐨勭暥(d膩ng)鍓嶉棞(gu膩n)绯讳腑瀛樺湪涓夌祫
(a,b1,c1)銆�(a,b2,c2)鍜�(a,b3,c3),閭d箞閫欏€嬮棞(gu膩n)绯讳腑蹇呭畾閭勫瓨鍦ㄧ殑鍏朵粬涓€浜涘厓绲�锛屽鍑�
鎵€鏈夊叾浠栧厓绁栵紝骞惰鏄庡師鍥�銆傦紙8 鍒嗭級
5銆佽ō(sh猫)闂�(gu膩n)绯� U銆乂 濡傚彸涓嬪湒鎵€绀猴紝鍦ㄥ寘涓婂仛涓嬪垪闂�(gu膩n)绯婚亱(y霉n)绠�锛屽鍑洪亱(y霉n)绠楃祼(ji茅)鏋溿€傦紙姣忓皬椤� 2 鍒�锛�
鍏� 8 鍒嗭級
锛�1锛夆垙B,C(U) - 鈭廈,C (V)
锛�2锛夆垙A,B-A锛孉+C(U)
锛�3锛塙 V
锛�4锛壩� B,COUNT(*)
?
E,MAX(D)
?
F (V)
6銆佽ō(sh猫)鏈変竴闂�(gu膩n)绯绘ā寮� R(A,B,C,D,E)锛屽湪瑭查棞(gu膩n)绯绘ā寮忎笂鏈夊嚱鏁�(sh霉)渚濊炒闆� F={A鈫扗, C鈫扙, AB鈫扖,
E鈫払}锛岃珛瀹屾垚涓嬪垪鍚勯锛�
1) 姹傞棞(gu膩n)绯绘ā寮� R 鐨勬墍鏈夊€欓伕纰硷紱 锛�4 鍒嗭級
2) 姹傜郸瀹氱殑鍑芥暩(sh霉)渚濊炒闆� F 鐨勪竴鍊嬫渶灏忓熀鏈泦锛涳紙3 鍒嗭級
3) 鍒ゆ柗闂�(gu膩n)绯绘ā寮� R 鏄惁鏄� 3NF锛屽苟瑾槑鐞嗙敱锛岃嫢 R 涓嶆槸 3NF锛屽墖灏囬棞(gu膩n)绯绘ā寮� R 鍒嗚В
鐐� 3NF锛屽苟涓斾繚鎸佸嚱鏁�(sh霉)渚濊炒鍜岀劇鎼嶉€f帴鎬с€傦紙5 鍒嗭級
7銆佸亣瑷�(sh猫)鏌愰珮鏍℃暀鍕�(w霉)鏁�(sh霉)鎿�(j霉)搴腑瀛樺湪瀛�(xu茅)鐢熻〃 Students銆佽绋嬭〃 Courses 鍜岄伕瑾茶〃 SC锛屽叾涓�锛�
Students 鐨勫爆鎬у寘鎷(xu茅)铏�銆佸鍚�銆佹€у垾銆佸勾榻�锛岀郴鍒ュ拰鐛庡(xu茅)閲�锛汣ourses 鐨勫爆鎬у寘鎷绋�
铏�銆佽绋嬪悕銆佸厛淇绋嬭櫉鍜屽(xu茅)鍒�锛汼C 鐨勫爆鎬у寘鎷(xu茅)铏�(char(10))銆佽绋嬭櫉(char(10))鍜屾垚绺�
绛夌礆(char(1))銆傞棞(gu膩n)绯绘ā寮忓涓嬶細
Students(sno,sname,ssex,sage,sdept,fellowship)
Courses(cno,cname,cpno,ccredit)
SC(sno,cno,grade)
A B C
1 2 3
6 7 8
9 7 8
3 6 5
B C D
2 3 4
2 3 5
7 8 10
U
绗� 5 闋� 鍏� 6 闋�
锛�1锛夎珛鐢ㄥ劒(y艒u)鍖栫殑闂�(gu膩n)绯讳唬鏁�(sh霉)琛ㄩ仈(d谩)寮忚〃绀猴細閬镐慨浜嗏€滄暩(sh霉)鎿�(j霉)搴€濈殑瀛�(xu茅)鐢熺殑瀛�(xu茅)铏熷拰濮撳悕銆傦紙3 鍒嗭級
锛�2锛夎珛鐢ㄩ棞(gu膩n)绯讳唬鏁�(sh霉)琛ㄩ仈(d谩)寮忚〃绀猴細妾㈢储"瑷堢畻姗�(j墨)"灏堟キ(y猫)鍚屽(xu茅)娌掓湁閬镐慨鐨勮绋嬬殑瑾茬▼铏�銆傦紙3
鍒嗭級
锛�3锛夎珛鐢ㄩ棞(gu膩n)绯讳唬鏁�(sh霉)琛ㄩ仈(d谩)寮忕当(t菕ng)瑷堝悇鍊嬪皥妤�(y猫)鐨勫(xu茅)鐢熶汉鏁�(sh霉)鑸囧钩鍧囧勾榻°€傦紙3 鍒嗭級
锛�4锛夎珛鐢� SQL 瑾炲彞鍓�(chu脿ng)寤洪伕瑾茶〃 SC锛屽爆鎬ч鍨嬪涓婃墍绀猴紝瑕佹眰瀵槑涓婚嵉绱勬潫锛屽閸电磩鏉�锛�
骞剁磩鏉熸垚绺� grade 鍙兘鐐衡€橝鈥欍€佲€橞鈥�銆佲€機鈥�銆佲€橠鈥欐垨鈥橢鈥�銆� 锛�3 鍒嗭級
锛�5锛夎珛浣跨敤 SQL 鐨� NOT EXISTS 瀛愭煡瑭�锛屾煡瑭㈡矑鏈夐伕淇€滄暩(sh霉)鎿�(j霉)搴€濈殑瀛�(xu茅)鐢熺殑瀛�(xu茅)铏熷拰濮�
鍚�銆傦紙3 鍒嗭級
锛�6锛夎珛浣跨敤 SQL 瑾炶█灏�"瑷堢畻姗�(j墨)"灏堟キ(y猫)鐨勫コ鍚屽(xu茅)鐨勭崕瀛�(xu茅)閲戞彁楂� 5%銆傦紙3 鍒嗭級
涓�銆佽ō(sh猫)瑷堥锛�20 鍒嗭級
鏌愯臣鐗╁钩鑷烘暩(sh霉)鎿�(j霉)搴腑娑夊強鐨勯儴鍒嗕俊鎭涓嬶細
? 搴楅嫪淇℃伅锛屽寘鎷簵閶法铏�銆佸簵閶悕绋便€佷俊璀�(y霉)鍊�銆佷富鐕熼鐩�銆佽í瀹㈡暩(sh霉)绛夛紱
? 鍟嗗搧淇℃伅锛屽寘鎷晢鍝佺法铏熴€佸晢鍝佸悕绋�銆佸児鏍笺€佸搧鐗�銆佸瀷铏熺瓑锛涘叾涓彧鏈夌壒鎯犲晢鍝佸叿
鏈夋姌鎵e拰鍎�(y艒u)鎯犺鏄庣瓑灞€�锛�
? 瑷傚柈淇℃伅锛屽寘鎷▊鍠櫉銆佷笅鍠檪闁�銆侀亱(y霉n)璨�(f猫i)銆佽▊鍠劒(y艒u)鎯犵瓑锛�
? 鏀粯鏂瑰紡淇℃伅锛屽寘鎷敮浠樻柟寮忕法铏熴€佹敮浠樻柟寮忓悕绋�銆佹敮浠樻柟寮忓劒(y艒u)鎯犵瓑锛�
? 鐢ㄦ埗淇℃伅锛屽寘鎷敤鎴惰櫉銆佺敤鎴跺悕銆佹€у垾銆侀兊绠辩瓑锛�
? 閫佽波淇℃伅锛屽寘鎷€佽波鍦板潃銆佽伅(li谩n)绯婚浕瑭辩瓑锛�
瑭茶臣鐗╁钩鑷猴紝姣忓€嬪簵閶嚭鍞绋晢鍝�锛屾瘡绋晢鍝佸彧鑳藉湪涓€鍊嬪簵閶嚭鍞�锛屾瘡绋晢鍝佸湪
搴楅嫪閲岄兘鏈夊韩瀛樺拰閵烽噺灞€с€傛瘡鍊嬭▊鍠寘鍚绋晢鍝�锛屾瘡绋晢鍝佸湪姣忎唤瑷傚柈涓兘鏈変竴鍊�
璩艰卜鏁�(sh霉)閲忕殑灞€�锛屾瘡绋晢鍝佸彲浠ュ爆浜庡鍊嬭▊鍠€傛瘡鍊嬭▊鍠彧鑳介伕鎿囦竴绋敮浠樻柟寮�锛屾瘡绋�
鏀粯鏂瑰紡鍙敤浜庡鍊嬭▊鍠€傛瘡鍊嬬敤鎴跺彲浠ユ湁澶氬€嬭▊鍠�锛屾瘡鍊嬭▊鍠彧鑳藉爆浜庝竴鍊嬬敤鎴躲€傛瘡
鍊嬬敤鎴跺彲鐧昏澶氬€嬮€佽波淇℃伅锛屽悓涓€鍊嬬敤鎴朵笉鍙互閲嶅京(f霉)鐧昏鐩稿悓鐨勯€佽波淇℃伅锛岃€屼笉鍚岀敤鎴�
鐧昏鐨勯€佽波淇℃伅鍏佽ū閲嶅京(f霉)銆備竴鍊嬭▊鍠彧鑳介伕鎿囦竴姊濋€佽波淇℃伅閫�(j矛n)琛岀櫦(f膩)璨�锛屼竴姊濋€佽波淇℃伅鍙�
浠ョ敤浜庡鍊嬭▊鍠�銆傝珛鏍规摎(j霉)涓婅堪鎻忚堪锛屽洖绛斾笅鍒楀晱椤岋細
1銆佸缓绔嬩竴鍊嬪弽鏄犱笂杩板眬閮ㄦ噳(y墨ng)鐢ㄧ殑 E/R 妯″瀷銆傚湪 E/R 鍦栦笂瑕佹眰琛ㄧず鍑洪嵉灞€�銆佸公鍔╁舰鎴�
閸电殑灞€�銆佸瓙椤炵壒鏈夊爆鎬т互鍙婅伅(li谩n)绯荤殑鑷韩灞€�锛屽叾浣欎竴鑸爆鎬т笉闇€瑕佸湪 E/R 鍦栦腑琛ㄧず鍑�
渚嗐€傚彟澶�锛岄倓闇€鐢ㄦ纰虹殑绗﹁櫉妯�(bi膩o)娉ㄥ嚭鑱�(li谩n)绯婚鍨嬶紝浠ュ強寮卞(sh铆)楂旈泦銆佹敮鎸佽伅(li谩n)绯诲拰瀛愰绲�(ji茅)妲�(g貌u)銆�
绗� 6 闋� 鍏� 6 闋�
锛�8 鍒嗭級
2銆佸皣 E/R 妯″瀷杞�(zhu菐n)鐐洪棞(gu膩n)绯绘ā鍨嬶紝骞舵(bi膩o)娉ㄦ瘡鍊嬮棞(gu膩n)绯绘ā寮忕殑涓婚嵉銆傚叾涓瓙椤炵祼(ji茅)妲�(g貌u)鐢� E/R 娉曡綁(zhu菐n)
鍖�銆傦紙7 鍒嗭級
3銆佺敤 ODL 鎻忚堪鍑鸿兘鍙嶆槧鐢ㄦ埗鍙婂叾鑸囪▊鍠箣闁撹伅(li谩n)绯荤殑椤�銆傦紙5 鍒嗭級

鍏嶈铂(z茅)鑱叉槑锛氭湰鏂囩郴杞�(zhu菐n)杓夎嚜缍�(w菐ng)绲�(lu貌)锛屽鏈変镜鐘�锛岃珛鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄�锛屽彟锛氭湰鏂囧儏浠h〃浣滆€呭€嬩汉瑙€榛�(di菐n)锛岃垏鏈恫(w菐ng)绔欑劇闂�(gu膩n)銆傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏�(n猫i)瀹规湭缍�(j墨ng)鏈珯璀夊(sh铆)锛屽皪鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収(n猫i)瀹�銆佹枃瀛楃殑鐪熷(sh铆)鎬�銆佸畬鏁存€�銆佸強鏅傛€ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛璁€鑰呭儏浣滃弮鑰�锛屽苟璜嬭嚜琛屾牳瀵�(sh铆)鐩搁棞(gu膩n)鍏�(n猫i)瀹�銆�

  • 涓婁竴绡囨枃绔狅細

  • 涓嬩竴绡囨枃绔狅細
  • 鑰冨崥鍜ㄨQQ 3455265070 榛�(di菐n)鎿婇€欓噷绲︽垜鐧�(f膩)娑堟伅 鑰冪爺鍜ㄨ QQ 3455265070 榛�(di菐n)鎿婇€欓噷绲︽垜鐧�(f膩)娑堟伅 閮电锛� 3455265070@qq.com
    鍏徃鍚嶇ū:鏄嗗北鍓�(chu脿ng)閰蜂俊鎭鎶€鏈夐檺鍏徃 鐗堟瑠(qu谩n)鎵€鏈�
    鑰冪爺绉樼睄缍�(w菐ng) 鐗堟瑠(qu谩n)鎵€鏈� © kaoyanmiji.com All Rights Reserved
    鑱叉槑锛氭湰缍�(w菐ng)绔欏皧閲嶅苟淇濊(h霉)鐭ヨ瓨鐢�(ch菐n)娆�(qu谩n)锛屾牴鎿�(j霉)銆婁俊鎭恫(w菐ng)绲�(lu貌)鍌虫挱娆�(qu谩n)淇濊(h霉)姊濅緥銆�锛屽鏋滄垜鍊戣綁(zhu菐n)杓夋垨寮曠敤鐨勪綔鍝佷镜鐘簡鎮ㄧ殑娆�(qu谩n)鍒╋紝璜嬮€氱煡鎴戝€�锛屾垜鍊戞渻鍙婃檪鍒櫎锛�