2006
骞翠笅鏈熶腑鍗楀ぇ瀛︺�婃暟鎹簱鍘熺悊鍙婄▼搴忚璁°�嬭瘯棰樺強绛旀
涓�銆佸垽鏂锛堝垽鏂笅鍒楀悇棰樻槸鍚︽纭紝姝ｇ‘鐨勫垝鈭氾紝閿欒鐨勫垝脳锛屾瘡灏忛
1
鍒嗭紝鍏?/p>
25
鍒嗭級
1.
鏁版嵁搴撴ā鍨嬫垨鏁版嵁妯″瀷鏄竴涓弿杩扮幇瀹炰笘鐣屽浣曡〃绀烘垚璁＄畻鏈轰俊鎭殑瀹氫箟闆嗗悎銆?/p>
(
)
2.
鍦ㄦ暟鎹簱绯荤粺涓紝鏍稿績鐨勯儴鍒嗘槸搴旂敤绋嬪簭銆?/p>
(
)
3.
鐮佸彲浠ラ�変綔涓荤爜
,
浣嗕竴涓富鐮佷笉鎬绘槸鍊欓�夌爜
.
(
)
4.
瑙嗗浘銆佽〃銆佸悓涔夎瘝鏄竴鏍?/p>
,
鍙互杩涜鏇存柊鎿嶄綔鐨勩�?/p>
(
)
5.
鍦ㄥ叧绯荤殑瑙勫垯涓?/p>
,
涓嶅厑璁稿嚭鐜伴噸澶嶇殑鍏冪粍
,
鑰屽湪
ORACLE
鐨勮〃涓嵈鍙互杈撳叆澶氭潯鎵�鏈夊瓧娈靛�?/p>
閮界浉鍚岀殑璁板綍銆?/p>
(
)
6.
琛?/p>
T
涓粎鏈変袱涓厓缁?/p>
,
鎴戜滑鍙互璇?/p>
T
涓�瀹氭槸
BCNF.
(
)
7.
鍦ㄦ暟鎹〃瀹氫箟鏃惰缃?/p>
Primary key
鏄暟鎹簱鐨勫疄浣撳畬鏁存�ф帶鍒躲�?/p>
锛堬級
8.R.A(R.B, R.A(R.C
涓?/p>
R.A(R.(B,C)
绛変环
(
鍏朵腑
A,B,C
涓?/p>
R
鐨勫睘鎬?/p>
)
锛?/p>
锛?/p>
9.
妯″紡鏄暟鎹簱灞�閮ㄩ�昏緫缁撴瀯銆?/p>
(
)
10.
鏁版嵁搴撴槸鏁翠釜鏁版嵁搴撶郴缁熺殑鍩虹
(
)
11.
宸茬煡鍏崇郴妯″紡
TEACH2
锛?/p>
C
锛?/p>
T
锛?/p>
H
锛?/p>
锛?/p>
鍏朵腑
C
琛ㄧず璇剧▼锛?/p>
T
琛ㄧず鏁欏憳锛?/p>
H
琛ㄧず鍙傝�冧功锛?/p>
鍋囪姣忎竴闂ㄨ绋嬪彲鐢卞涓暀鍛樿鎺堬紝姣忎釜鏁欏憳鍙娇鐢ㄤ笉鍚岀殑鍙傝�冧功锛屽苟涓斿彲璁叉巿涓嶅悓鐨勮锛?/p>
鍒?/p>
TEACH2
涓哄叏鐮佸叧绯汇�?/p>
锛堬級
12.
宸茬煡鍏崇郴妯″紡
R(A, B, C),
婊¤冻鍑芥暟渚濊禆闆?/p>
F={A->B,B->C,C->A},
鍒?/p>
R
涓嶅瓨鍦ㄩ潪涓诲睘鎬?/p>
,
鍥犳
,
涓�
瀹氬睘浜?/p>
BCNF
銆?/p>
(
)
13.
鍦ㄦ暟鎹〃瀹氫箟鏃惰缃富閿?/p>
(Primary key)
鍒欎笉鍏佽鎻掑叆鍏ㄤ负绌虹殑璁板綍銆?/p>
锛堬級
14
銆佽嫢
R.A(R.B, R.A(R.C,
鍒?/p>
R.A(R.(B,C) (
鍏朵腑
A,B,C
涓?/p>
R
鐨勫睘鎬?/p>
)
锛?/p>
锛?/p>
15
銆佽嫢
R.(B,C,D)(R.(A,D),
鍒?/p>
R.(B,C)(R.(A,D)(
鍏朵腑
A,B,C,D
涓?/p>
R
鐨勫睘鎬?/p>
)
锛?/p>
锛?/p>
16
銆?/p>
VFP
鏄叧绯荤粺鏁版嵁搴撶郴缁燂紝鑰屼笖鏄畬澶囧紡鐨勫叧绯荤郴缁熴�?/p>
锛?/p>
锛?/p>
17
銆佸湪
ORACLE
鐨勮〃涓彲浠ョ洿鎺ヨ緭鍏ョ┖鍊艰褰曘�?/p>
( )
18
銆佸叧绯绘ā寮?/p>
R
灞炴�х殑灞炴�ф垨灞炴�ч泦濡傛灉鍏锋湁鍞竴鎬э紝鍙叧绯绘ā寮?/p>
R
鐨勭爜銆?/p>
锛?/p>
锛?/p>
19
銆佸叧绯荤殑浼樺寲鏄皢琛ㄥ敖鍙兘鍦板彉灏忥紙鍒楁暟涓庤鏁伴兘灏戯級
銆?/p>
锛?/p>
锛?/p>
20
銆佸妯″紡鏄暟鎹簱鍏ㄥ眬閫昏緫缁撴瀯銆?/p>
锛堬級
21
銆佺幇瀹炰笘鐣岀殑瀵硅薄鍦ㄦ暟鎹簱涓敤瀹炰綋鎻忚堪锛堬級
22
銆佸湪鍩轰簬鏈夋暟鎹簱鐨勮蒋浠剁郴缁熻璁′笌瀹炴柦涓紝鍙湁绋嬪簭缂栧埗鏄渶涓昏鐨勩�?/p>
(
)
23
銆佸浜庢暟鎹噺澶х殑绯荤粺閮藉簲璇ラ噰鐢ㄦ暟鎹簱鎶�鏈繘琛屽紑鍙戯紙锛?/p>
24
銆佸熀浜庢暟鎹簱鐨勭紪绋嬪伐鍏蜂竴鑸�氳繃
ODBC
涓庢暟鎹簱鐩歌仈锛堬級
25
銆佸叧绯绘暟鎹簱宸茬粡鏄渶濂界殑浜嗭紝鐜板湪鐨勫簲鐢ㄩ兘鑳藉緱鍒版弧瓒筹紙锛?/p>
浜屻�佸～绌洪锛堣鎶婄瓟妗堝～鍦ㄩ涓殑妯嚎涓婏紝姣忕┖
1
鍒嗭紝鍏?/p>
30
鍒嗭級
(1)
鍦ㄦ暟鎹簱鐨勪笁绾фā寮忥紝鍖呮嫭鍐呮ā寮忋�?/p>
銆佷笌
___________
銆?/p>
(2)
鍦ㄥ叧绯绘暟鎹簱涓紝琛?/p>
(table)
鏄笁绾фā寮忕粨鏋勪腑鐨勩�?/p>
(3) SQL
鐨勫洓绉嶅姛鑳戒负鎿嶇旱銆?/p>
_______________
銆?/p>
_________________
銆?/p>
________________
銆?/p>
(4)
鏁版嵁搴撲繚鎶ゅ寘鎷畨鍏ㄦ�с�?/p>
________________
銆?/p>
________________
涓庢仮澶嶃�?/p>
(5)
鏁版嵁搴撹璁＄殑涓�鑸楠ゆ湁锛?/p>
闇�姹傚垎鏋愩�?/p>
___________
銆?/p>
____________
銆?/p>
_______________
銆?/p>
________________
銆佽繍琛屼笌缁存姢绛夈�?/p>
(6)
鍏崇郴绯荤粺鐨勫畬鏁存�ф帶鍒跺寘鎷疄浣撳畬鏁存�с�?/p>
____________
銆?/p>
____________
銆?/p>
(7) DB
璁捐涓紭鍖栬璁＄殑鐩爣鏄?/p>
_______________
銆?/p>
____________________
銆?/p>
(8) E
锛?/p>
R
鍥剧殑涓昏鍏冪礌鏄疄浣撳瀷銆?/p>
____________
銆?/p>
____________
銆?/p>
(9)
甯哥敤鐨勫叧绯昏繍绠楁槸鍏崇郴
_______
涓庡叧绯绘紨绠楋紝鍏朵腑鍏崇郴婕旂畻鍖呮嫭
_______
婕旂畻涓庡煙婕旂畻銆?/p>