|
鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�(gu贸)400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁＋銆佸崥澹爺绌剁敓鍏ュ(xu茅)鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗�锛岄儴鍒嗗(xu茅)鏍℃洿鏂拌嚦2012骞达紝2013骞�锛涘潎鎻愪緵鏀惰不(f猫i)涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛�(di菐n)鎿娾€�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛�(di菐n)鎿娾€�鑰冨崥瑭﹀嵎搴�(k霉)鈥� 涓嬭級
鏉� 宸� 甯� 鑼� 澶� 瀛�(xu茅) 纰� 澹� 鐮� 绌� 鐢� 鍏� 瀛�(xu茅) 鑰� 瑭� 鍛� 椤� 绱�
2018 骞� 鑰冭│绉戠洰浠ｇ⒓ 861 鑰冭│绉戠洰鍚嶇ū 杌熶欢灏堟キ(y猫)鍩虹(ch菙) 锛堟湰鑰冭│绉戠洰鍏� 6 闋�(y猫)锛岀 1 闋�(y猫)锛�
鏉� 宸� 甯� 鑼� 澶� 瀛�(xu茅)
2018 骞存嫑鏀舵敾璁€纰╁＋鐮旂┒鐢熷叆瀛�(xu茅)鑰冭│椤�
鑰冭│绉戠洰浠ｇ⒓锛� 861
鑰冭│绉戠洰鍚嶇ū锛� 杌熶欢灏堟キ(y猫)鍩虹(ch菙)
瑾�(shu艒)鏄庯細鑰冪敓绛旈鏅�(sh铆)涓€寰嬪鍦ㄧ瓟椤岀礄涓婏紝鍚﹀墖婕忔壒璨�(z茅)浠昏嚜璨�(f霉)銆�
绗竴閮ㄥ垎銆丆 绋嬪簭瑷�(sh猫)瑷�(j矛)
涓€銆佸柈閬搁锛堟瘡椤� 1 鍒�锛屽叡 15 鍒嗭級
1. 鍋囪ō(sh猫)鏈夊畾缇╋細
int k锛�
涓嬮潰绋嬪簭娈电法璀亱(y霉n)琛岀殑鎯呮硜鏄痏____銆�
for (k=1; k; k++)
printf ("%d ", k);
A.鑳介亱(y霉n)琛�, 姝ｅ父绲�(ji茅)鏉� B.浠ヤ笂瑾�(shu艒)娉曢兘涓嶅皪(du矛) C.绶ㄨ閷�(cu貌)瑾� D.鑳介亱(y霉n)琛�, 鏄寰挵(hu谩n)
2.寰挵(hu谩n)瑾�(y菙)鍙�
while (!x&&!y)
涓殑寰挵(hu谩n)姊濅欢琛ㄩ仈(d谩)寮忕瓑鍍�(ji脿)浜�
A.!(x!=0||y!=0) B.!(x==0 && y==0) C.!(x==0 || y==0) D.x=0 && y=0
3. 鑻ュ畾缇�
char s[2][3]={鈥渁b鈥�, 鈥渃d鈥潁, *p=(char *)s;
閭ｄ箞涓嬪垪琛ㄩ仈(d谩)寮忚獮(y菙)娉曟纰�锛屽苟涓斿叾鍊艰垏 s[1][1]鐩哥瓑鐨勮〃閬�(d谩)寮忥紙骞堕潪涓€瀹氳垏鍏剁瓑鍍�(ji脿)锛夋槸
A.*(p+4) B.*(s+3) C.*(p+3) D.*s+2
4. 灏�(du矛)浜� int x, y;
瑾�(y菙)鍙�
if (x < 0)
y = -1;
else if (!x)
y = 0;
else
y = 1;
绛夊児(ji脿)浜�
鏉� 宸� 甯� 鑼� 澶� 瀛�(xu茅) 纰� 澹� 鐮� 绌� 鐢� 鍏� 瀛�(xu茅) 鑰� 瑭� 鍛� 椤� 绱�
2018 骞� 鑰冭│绉戠洰浠ｇ⒓ 861 鑰冭│绉戠洰鍚嶇ū 杌熶欢灏堟キ(y猫)鍩虹(ch菙) 锛堟湰鑰冭│绉戠洰鍏� 6 闋�(y猫)锛岀 2 闋�(y猫)锛�
A. B. C. D.
if (x != 0)
if (x > 0)
y = 1;
else
y = -1;
if (x>=0)
y=0;
if(x)
y=1;
else
y=-1;
y=0;
if (x>=0)
if(x)
y=1;
else
y=-1;
y=0;
if (x!=0)
if(x>0)
y=1;
else
y=-1;
5. 瑕佹眰鍑芥暩(sh霉)鐨勫姛鑳芥槸浜ゆ彌 x 鍜� y 涓殑鍊�锛屼笖閫氶亷(gu貌)姝ｇ⒑瑾�(di脿o)鐢ㄨ繑鍥炰氦鎻涚祼(ji茅)鏋溿€傝兘姝ｇ⒑瀵�(sh铆)鐝�(xi脿n)姝ゅ姛鑳�
鐨勫嚱鏁�(sh霉)鏄�
A. B.
void funa(int x , int y)
{
int t;
t=x;x=y;y=t;
}
void funa(int *x , int *y)
{
int t = *x;
*x = *y;
*y = t;
}
C. D.
void funa(int *x , int *y)
{
int *p;
*p=*x;*x=*y;*y=*p;
}
int funa(int *x , int *y)
{
*x=*y;*y=*x;
}
6. 灏�(du矛)浜庡涓嬪畾缇╋細
int k,a[10],*p=a;
鍝€�(g猫)琛ㄩ仈(d谩)寮忔槸涓嶆纰虹殑
A.a++ B.p++ C.a[0]=k D.*p++=2
7. 涓嬪垪鎻忚堪涓嶆纰虹殑鏄�
A.鍏ㄥ眬璁婇噺瀹氱京鍦ㄥ嚱鏁�(sh霉)澶栭儴 B.闈滄厠(t脿i)鏈湴璁婇噺鍒嗛厤鍦ㄥ叏灞€璁婇噺鎵€鍦ㄧ殑鍦版柟
C.闈滄厠(t脿i)鏈湴璁婇噺瀹氱京鍦ㄥ嚱鏁�(sh霉)澶栭儴 D.鏈湴璁婇噺瀹氱京鍦ㄥ嚱鏁�(sh霉)鍏�(n猫i)閮�
8.鏈夊涓嬪畾缇╋細
int x[]={1,2,3},*p=x,y;
鍓�
y=*p++;
鐩哥暥(d膩ng)浜巁____
A.y=1, x++ B.y=2, p=x+1 C.y=*p, p++ D.y=2, p=&x[1]
9. 鑸�
while( *s++ = *t++ );
绛夊児(ji脿)鐨勭▼搴忔鏄�
A. B. C. D.
do {
*s++ = *t++;
} while ( *t );
while ( *t )
*s++ = *t++;
do {
*s = *t++;
} while ( *s++ );
while ( *s )
*s++ = *t++;
鏉� 宸� 甯� 鑼� 澶� 瀛�(xu茅) 纰� 澹� 鐮� 绌� 鐢� 鍏� 瀛�(xu茅) 鑰� 瑭� 鍛� 椤� 绱�
2018 骞� 鑰冭│绉戠洰浠ｇ⒓ 861 鑰冭│绉戠洰鍚嶇ū 杌熶欢灏堟キ(y猫)鍩虹(ch菙) 锛堟湰鑰冭│绉戠洰鍏� 6 闋�(y猫)锛岀 3 闋�(y猫)锛�
10. 鏈変互涓嬬祼(ji茅)妲�(g貌u)楂旇(shu艒)鏄庡拰璁婇噺瀹氱京锛屾寚閲� p銆乹銆乺 渚濇鎸囧悜涓€鍊�(g猫)閺堣〃涓殑涓夊€�(g猫)閫ｇ簩(x霉)绲�(ji茅)榛�(di菐n)銆�
struct node
{
int data
struct node *next ;
} *p, *q, *r;
鐝�(xi脿n)瑕佸皣 q 鍜� r 鎵€鎸囩祼(ji茅)榛�(di菐n)鐨勫厛鍚庝綅缃氦鎻�锛屽悓鏅�(sh铆)瑕佷繚鎸侀張琛ㄧ殑閫ｇ簩(x霉)锛屼互涓嬮尟(cu貌)瑾ょ殑绋嬪簭娈垫槸
A.r->next=q; q->next=r->next; p->next=r;
B.p->next=r; q->next=r->next; r->next=q;
C.q->next=r->next; p->next=r; r->next=q;
D.q->next=r->next; r->next=q; p->next=r;
11. 鏈変互涓嬬▼搴�
void WriteStr(char *fn,char *str)
{
FILE *fp;
fp=fopen(fn,"w");
fprintf(fp, "%s", str);
fclose(fp);
}
int main()
{
WriteStr("t1.dat","start");
WriteStr("t1.dat","end");
return 0;
}
绋嬪簭閬�(y霉n)琛屽悗,鏂囦欢 t1.dat 涓殑鍏�(n猫i)瀹规槸
A.start B.endrt C.startend D.end
12.瑾�(y菙)鍙�
while(x%3) a++;
涓殑琛ㄩ仈(d谩)寮�
x%3
绛夊児(ji脿)浜巁______.
A.x%3!=0 B.x%3==1 C.x%3==2 D.x%3==0
13.鐣�(d膩ng)鏂囦欢鎵撻枊鍑虹従(xi脿n)閷�(cu貌)瑾ゆ檪(sh铆)锛宖open 杩斿洖鐨勬槸锛�
A.娌�(m茅i)鏈夎繑鍥炲氨灏�(d菐o)鑷寸▼搴忛€€鍑轰簡 B.-1 C.1 D.0
14.鍦ㄤ竴鍊�(g猫)閺堣〃涓紝瑕佹妸 s 鎵€鎸囩殑涓€鍊�(g猫)绲�(ji茅)榛�(di菐n)鎻掑叆鍒� p 鎵€鎸囩殑涓€鍊�(g猫)绲�(ji茅)榛�(di菐n)鍚庨潰鍘�锛屾纰虹殑瑾�(y菙)鍙ユ槸锛�
A.s->next=p; p->next=s; B.s->next=p?->next; p=s;
C.p->next=s; s->next=p; D.s->next=p->next; p->next=s;
15.涓嬪垪鏁�(sh霉)绲勫畾缇�锛屼笉姝ｇ⒑鐨勬槸 _______.
A.int a[1][3]; B.int m[][3]={1,2,3,4,5,6};
C.int x[2][]={1,2,4,6}; D.int x[2][2]={1,2,3,4};
鏉� 宸� 甯� 鑼� 澶� 瀛�(xu茅) 纰� 澹� 鐮� 绌� 鐢� 鍏� 瀛�(xu茅) 鑰� 瑭� 鍛� 椤� 绱�
2018 骞� 鑰冭│绉戠洰浠ｇ⒓ 861 鑰冭│绉戠洰鍚嶇ū 杌熶欢灏堟キ(y猫)鍩虹(ch菙) 锛堟湰鑰冭│绉戠洰鍏� 6 闋�(y猫)锛岀 4 闋�(y猫)锛�
浜屻€佸晱(w猫n)绛旈锛堟瘡灏忛 3 鍒�锛屽叡 15 鍒嗭級
1. 瑾�(y菙)鍙�
if (4/5 > 3/4)
a=1;
else
a=0;
閬�(y霉n)琛屽悗锛宎 鐨勫€兼槸锛�
2. 琛ㄩ仈(d谩)寮�
!!鈥�2010-01-27鈥�
鐨勫€肩偤锛堜互 1 琛ㄧず鐪�锛�0 琛ㄧず鍋囷級
3. 鍋囪ō(sh猫)瀛楃璁婇噺 ch 涓瓨鏀炬湁澶у鑻辨枃瀛楁瘝锛屽皣鍏惰綁(zhu菐n)鎻涚偤鐩告噳(y墨ng)鐨勫皬瀵嫳鏂囧瓧姣嶇殑琛ㄩ仈(d谩)寮忔槸锛堝舰
濡� ch=...绛旀涓嶇暀浠讳綍鐨勭┖鏍硷紝涓嶅付绲�(ji茅)灏剧殑鍒嗚櫉(h脿o)锛�
4. 涓嬪垪绋嬪簭娈电殑杓稿嚭鏄痏______銆�
#define DF(a,b) (a+2*b)
int s=5;
int k= DF(s+1,s-3);
printf("%d",k);
5.浠ヤ笅浠ｇ⒓娈电殑杓稿嚭鏄細
int x, y, z, w;
void p(int *y, int x)
{
static int w;
*y++; x++; w = x+*--y;
printf("%d#%d#%d#%d#",x,*y,z,w);
}
int main(void)
{
int x, y, z, w;
x=y=z=w=1;
do{
static int x;
p(&x, y);
printf("%d#%d#%d#%d#",x,y,z,w);
} while(0);
return 0;
}
涓夈€佽珛(q菒ng)鐢� C 瑾�(y菙)瑷€瀵嚭鍐掓场鎺掑簭鐨勭▼搴�銆傦紙20 鍒嗭級
鍥�銆佽珛(q菒ng)鐢� C 瑾�(y菙)瑷€瀵嚭鍦ㄤ竴鍊�(g猫)鍗囧簭鐨勬暣鏁�(sh霉)鏁�(sh霉)绲勪腑鎶樺崐鏌ユ壘(浜屽垎娉曟悳绱�)鐨勫嚱鏁�(sh霉)銆傦紙25 鍒嗭級
鏉� 宸� 甯� 鑼� 澶� 瀛�(xu茅) 纰� 澹� 鐮� 绌� 鐢� 鍏� 瀛�(xu茅) 鑰� 瑭� 鍛� 椤� 绱�
2018 骞� 鑰冭│绉戠洰浠ｇ⒓ 861 鑰冭│绉戠洰鍚嶇ū 杌熶欢灏堟キ(y猫)鍩虹(ch菙) 锛堟湰鑰冭│绉戠洰鍏� 6 闋�(y猫)锛岀 5 闋�(y猫)锛�
绗簩閮ㄥ垎銆佹暩(sh霉)鎿�(j霉)搴�(k霉)鍘熺悊
浜�銆侀伕鎿囬锛堝叡 15 鍒�锛屾瘡灏忛 3 鍒嗭級
1銆佽嫢浜嬪嫏(w霉) T 灏�(du矛)鏁�(sh霉)鎿�(j霉)灏�(du矛)璞� A 鍔犱笂 S 閹栵紙鍏变韩閹栵級鑰屾湭鍔� X 閹栵紙浜掓枼閹栵級锛屽墖___________銆�
A锛庝簨鍕�(w霉) T 鍙互璁€ A 鍜屼慨鏀� A锛屽叾瀹冧簨鍕�(w霉)鍙兘鍐嶅皪(du矛) A 鍔� S 閹栵紝鑰屼笉鑳藉姞 X 閹�銆�
B锛庝簨鍕�(w霉) T 鍙互璁€ A 浣嗕笉鑳戒慨鏀� A锛屽叾瀹冧簨鍕�(w霉)鍙兘鍐嶅皪(du矛) A 鍔� S 閹�锛岃€屼笉鑳藉姞 X 閹�銆�
C锛庝簨鍕�(w霉) T 鍙互璁€ A 浣嗕笉鑳戒慨鏀� A锛屽叾瀹冧簨鍕�(w霉)鑳藉皪(du矛) A 鍔� S 閹栧拰 X 閹�銆�
D锛庝簨鍕�(w霉) T 鍙互璁€ A 鍜屼慨鏀� A锛屽叾瀹冧簨鍕�(w霉)鑳藉皪(du矛) A 鍔� S 閹栧拰 X 閹�
2銆佹湁涓€鍚嶇偤鈥滆埅鐝亱(y霉n)鐕�(y铆ng)鈥濆(sh铆)楂�锛屽惈鏈夎埅鐝櫉(h脿o)銆佹棩鏈�銆佽▓(j矛)鍔冭捣椋涙檪(sh铆)闁擄紝瑷�(j矛)鍔冨埌閬�(d谩)鏅�(sh铆)闁�锛屽(sh铆)闅涜捣椋�
鏅�(sh铆)闁�銆佸(sh铆)闅涘埌閬�(d谩)鏅�(sh铆)闁�銆佹儏娉佹憳瑕佺瓑灞€�锛岃┎瀵�(sh铆)楂斾富纰煎彲鑳芥槸_________銆�
A锛庤埅鐝櫉(h脿o) B锛庢棩鏈� C锛庤埅鐝櫉(h脿o)+鏃ユ湡 D锛庤埅鐝櫉(h脿o)+鎯呮硜鎽樿
3銆佸湪鐝�(xi脿n)浠ｆ暩(sh霉)鎿�(j霉)搴�(k霉)绠＄悊绯荤当(t菕ng)涓紝瑷橀寗鏁�(sh霉)鎿�(j霉)搴�(k霉)浜嬪嫏(w霉)鎿嶄綔淇℃伅鐨勬枃浠舵槸_______銆�
A. 鏁�(sh霉)鎿�(j霉)鏂囦欢 B. 绱㈠紩鏂囦欢 C. 杓斿姪鏁�(sh霉)鎿�(j霉)鏂囦欢 D. 鏃ュ織鏂囦欢
4锛庤ō(sh猫)闂�(gu膩n)绯� R 鍜岄棞(gu膩n)绯� S 鍏锋湁鐩稿悓鐨勫厓鏁�(sh霉)锛堢洰锛夛紝涓斿皪(du矛)鎳�(y墨ng)鐨勫爆鎬у彇鑷浉鍚岀殑鍩�銆傞泦鍚坽t|t鈭圧鈭鈭圫}
妯�(bi膩o)瑷樼殑鏄紙 锛�銆�
A銆丷鈭猄 B銆丷-S C銆丷脳S D銆丷鈭㏒
5銆佹湁涓€鍊�(g猫)闂�(gu膩n)绯伙細鑱峰伐锛堝伐铏�(h脿o)锛屽鍚嶏紝宕椾綅銆佸伐璩囷級锛岃(gu墨)瀹氬伐璩囩殑鑼冨湇鎳�(y墨ng)瑭插湪 3000-30000 鍏冧箣
闁擄紝閫欎竴瑕�(gu墨)鍓囧湪 SQL 涓彲浠ョ敤__________瀛愬彞绱勬潫銆�
A銆亀hereB銆乧heck C銆乸rimary key D銆乫oreign key
鍏�銆佸～绌洪锛堝叡 10 鍒嗭紝姣忕┖鏍� 2 鍒嗭級
1锛�?d膩ng)?sh霉)鎿�(j霉)搴�(k霉)绠＄悊绯荤当(t菕ng)涓�锛岃嫢涓€鍊�(g猫)浜嬪嫏(w霉)鍥犳煇绋師鍥犲煼(zh铆)琛屽け鏁�锛屽皣鍩�(zh铆)琛宊___________鎿嶄綔锛屼互淇濊瓑
鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨勪竴鑷存€�銆�
2锛庤ō(sh猫)闂�(gu膩n)绯绘ā寮� R(A,B,C,D,E)鐨勫嚱鏁�(sh霉)渚濊炒闆嗙偤 F={AB鈫扖, C鈫扗, D鈫扙}锛屽墖 R 鐨勫€欓伕纰�
(Candidate Key)鍙偤______________________銆�
3锛嶴QL 鏌ヨ瑾�(y菙)瑷€涓�锛屽瑕佽〃閬�(d谩)浠绘剰澶氬€�(g猫)浠绘剰瀛楃锛屾噳(y墨ng)浣跨敤閫氶厤绗__________銆�
4锛�?d膩ng)?sh霉)鎿�(j霉)搴�(k霉)绠＄悊绯荤当(t菕ng)涓�锛岀偤浜嗕繚璀変簨鍕�(w霉)鐨勬纰哄煼(zh铆)琛�锛岀董璀�(h霉)鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨勫畬鏁存€�锛岃姹傛暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)缍�
璀�(h霉)浠ヤ笅浜嬪嫏(w霉)鐗规€э細________銆佷竴鑷存€�銆侀殧闆㈡€у拰鎸佺簩(x霉)鎬�銆�
5锛庨棞(gu膩n)绯绘ā寮忕殑涓夌ó瀹屾暣鎬х磩鏉熷垎鍒ユ槸______________锛屽弮鐓у畬鏁存€х磩鏉熷拰鐢ㄦ埗鑷畾缇╃殑瀹屾暣
鎬х磩鏉熴€�
涓�銆佺稖鍚堟噳(y墨ng)鐢ㄩ锛堝叡 50 鍒嗭級
1. 鏁�(sh霉)鎿�(j霉)搴�(k霉)姒傚康瑷�(sh猫)瑷�(j矛)锛�16 鍒嗭級
鏉� 宸� 甯� 鑼� 澶� 瀛�(xu茅) 纰� 澹� 鐮� 绌� 鐢� 鍏� 瀛�(xu茅) 鑰� 瑭� 鍛� 椤� 绱�
2018 骞� 鑰冭│绉戠洰浠ｇ⒓ 861 鑰冭│绉戠洰鍚嶇ū 杌熶欢灏堟キ(y猫)鍩虹(ch菙) 锛堟湰鑰冭│绉戠洰鍏� 6 闋�(y猫)锛岀 6 闋�(y猫)锛�
涓€鍊�(g猫)鐮旂┒鐢熺鐞嗘暩(sh霉)鎿�(j霉)搴�(k霉)瑕佹眰鎻愪緵涓嬭堪鏈嶅嫏(w霉)锛�
? 鍙毃鏅�(sh铆)鏌ヨ瀛�(xu茅)鏍′腑鎵€鏈夌郴鐨勪俊鎭�锛屽寘鎷郴鐨勫悕绋�銆佺郴杈﹀叕瀹ゅ湴鍧€鍜屽€肩彮闆昏┍銆傛墍鏈夌郴鍧囩敱
绯荤殑鍚嶇ū鍞竴妯�(bi膩o)璀�(sh铆)銆�
? 鍙毃鏅�(sh铆)鏌ヨ鎵€鏈夋暀甯殑淇℃伅锛屽寘鎷叾濮撳悕銆佸勾榻�銆佽伔绋�銆佹墍灞郴浠ュ強鍦ㄨ┎绯诲叆鑱锋檪(sh铆)闁撱€備竴
鍊�(g猫)绯绘湁澶氬悕鏁欏斧锛屼竴鍚嶆暀甯彧鑳藉湪涓€鍊�(g猫)绯诲伐浣�锛屽伐浣滆瓑铏�(h脿o)鍏锋湁鍞竴鎬�銆�
? 鍙毃鏅�(sh铆)鏌ヨ姣忓€�(g猫)绯荤爺绌剁敓淇℃伅锛屽寘鎷(xu茅)铏�(h脿o)銆佸鍚�銆佸皫(d菐o)甯紙鏁欏斧锛夈€佸皥妤�(y猫)鏂瑰悜銆備竴鍚嶆暀甯彲
浠ユ寚灏�(d菐o)澶氫綅鐮旂┒鐢�锛屼竴浣嶇爺绌剁敓鐨勫皫(d菐o)甯彧鑳芥湁涓€鍊�(g猫)銆�
锛�1锛夋牴鎿�(j霉)浠ヤ笂闇€姹�锛岀躬鍒跺嚭 E-R 鍦�銆傦紙8 鍒嗭級
锛�2锛夋牴鎿�(j霉) E-R 鍦栬綁(zhu菐n)鎻涙垚闂�(gu膩n)绯绘ā鍨嬶紝骞舵(bi膩o)鏄庝富閸靛拰澶栭嵉銆傦紙8 鍒嗭級
2. 瑕�(gu墨)鑼冨寲椤岋紙10 鍒嗭級
鍋囪ō(sh猫)鏈変竴鍊�(g猫)鍔犳补绔欑殑绯荤当(t菕ng)涓湁濡備笅闂�(gu膩n)绯� R(鍔犳补鍝� ID锛屽姞娌瑰摗濮撳悕锛屾祦姘磋櫉(h脿o)锛岄噾椤�)銆傚叾涓�锛屾瘡
涓€娆″姞娌规搷浣滈兘鏈変竴鍊�(g猫)娴佹按铏�(h脿o)锛屽苟鐢辩浉鎳�(y墨ng)閲戦銆傛瘡鍊�(g猫)鍔犳补鍝″悇鑷法鍒舵祦姘磋櫉(h脿o)锛屼笉鍚屽姞娌瑰摗鐨勬祦
姘磋櫉(h脿o)鏈夊彲鑳界浉鍚�銆�
锛�1锛夌郸鍑轰笂杩伴棞(gu膩n)绯� R 鐨勫嚱鏁�(sh霉)渚濊炒闆�锛屼互鍙婂€欓伕纰笺€�
锛�2锛夎(shu艒)鏄� R 闈� BCNF 妯″紡鐨勭悊鐢�锛屽苟灏囦笂杩伴棞(gu膩n)绯� R 鍒嗚В鐐� BCNF 妯″紡銆�
3. SQL 鎳�(y墨ng)鐢ㄩ(24 鍒�锛屽叡 6 灏忛锛屾瘡灏忛 4 鍒�)
瑷�(sh猫)鏈変竴鍊�(g猫)閱�(y墨)闄㈢鐞嗙郴绲�(t菕ng)锛�
绉戝锛堢瀹よ櫉(h脿o)锛岀瀹ゅ悕绋憋紝鍊肩彮闆昏┍锛�
閱�(y墨)鐢燂紙宸ヨ櫉(h脿o)锛屽鍚嶏紝鎬у垾锛岃伔绋�锛屾墍灞瀹よ櫉(h脿o)锛屽叆鑱锋檪(sh铆)闁�锛岀媭鎱�(t脿i)锛�
鐥呬汉锛堢梾浜虹法铏�(h脿o)锛屽鍚�锛屾€у垾锛屽嚭鐢熸棩鏈�锛岄浕瑭憋級
闁€瑷鸿閷勶紙闁€瑷鸿櫉(h脿o)锛岀梾浜虹法铏�(h脿o)锛屽伐铏�(h脿o)锛屾棩鏈�锛屼富瑷达紝瑷烘柗锛岃檿鐞嗗缓璀帮級
瑕佹眰鐢� SQL 瑾�(y菙)瑷€瀹屾垚濡備笅椤岀洰锛屽瓧娈靛悕绋卞拰鏁�(sh霉)鎿�(j霉)琛ㄥ悕璜�(q菒ng)鐩存帴浣跨敤涓婇潰鐨勬饥瀛楋細
锛�1锛夊壍(chu脿ng)寤虹瀹よ〃锛屾敞鎰忓畬鏁存€х磩鏉�銆傦紙4 鍒嗭級
锛�2锛夋绱㈠嚭鎵€鏈夎伔绋辩偤鈥滀富浠婚啱(y墨)甯€濈殑閱�(y墨)鐢熶俊鎭€傦紙4 鍒嗭級
锛�3锛夋绱㈠嚭鎵€鏈夊湪 2017 骞� 11 鏈� 11 鏃ョ湅閬�(gu貌)闁€瑷虹殑鐥呬汉濮撳悕鍜屽嚭鐢熸棩鏈�銆傦紙4 鍒嗭級
锛�4锛夋绱㈠嚭鍚勭瀹ら杸瑷洪噺鏈€澶х殑閱�(y墨)鐢熺殑闁€瑷洪噺锛岃姹傝繑鍥炵瀹よ櫉(h脿o)锛岄杸瑷洪噺銆傦紙4 鍒嗭級
锛�5锛夋煡瑭�?c猫)\鏂峰寘鍚€滈珮琛€澹撯€濈殑鐥呬汉绶ㄨ櫉(h脿o)銆佺梾浜哄鍚嶅拰鍑虹敓鏃ユ湡銆傦紙4 鍒嗭級
锛�6锛夊皣璩堝閱�(y墨)鐢熺殑鐙€鎱�(t脿i)瑷�(sh猫)缃偤鈥滈€€浼戔€�銆傦紙4 鍒嗭級
鍏嶈铂(z茅)鑱叉槑锛氭湰鏂囩郴杞�(zhu菐n)杓夎嚜缍�(w菐ng)绲�(lu貌)锛屽鏈変镜鐘�锛岃珛(q菒ng)鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄�锛屽彟锛氭湰鏂囧儏浠ｈ〃浣滆€呭€�(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)瀹�銆�
|
鏂囩珷鎼滅储
鎮ㄧ従(xi脿n)鍦ㄧ殑浣嶇疆锛� 
