瀹為獙涓�
鏁版嵁瀹氫箟鎿嶄綔
瀹為獙鐩殑
1.
鎺屾彙鏁版嵁搴撳拰琛ㄧ殑鍩虹鐭ヨ瘑
2.
鎺屾彙浣跨敤鍒涘缓鏁版嵁搴撳拰琛ㄧ殑鏂规硶
3.
鎺屾彙鏁版嵁搴撳拰琛ㄧ殑淇敼銆佹煡鐪嬨�佸垹闄ょ瓑鍩烘湰鎿嶄綔鏂规硶
瀹為獙鍐呭鍜岃姹?/p>
涓�銆佹暟鎹簱鐨勫垱寤?/p>
鍦ㄥ紑濮嬭彍鍗曚腑锛屽惎鍔?/p>
SQl Server
绋嬪簭涓殑鈥?/p>
SQL Server Management Studio
鈥?/p>
锛屽湪瀵硅薄
璧勬簮绠＄悊鍣ㄧ獥鍙ｄ腑锛屽彸閿崟鍑烩�滄暟鎹簱鈥?/p>
锛岄�夋嫨鈥滄柊寤烘暟鎹簱鈥?/p>
锛?/p>
鍒涘缓鎴愮哗绠＄悊鏁版嵁搴?/p>
Grademanager
锛岃姹傚涓嬭〃鎵�绀猴細
Grademanager
鏁版嵁搴撳弬鏁拌〃
鍙傛暟
鍙傛暟鍊?/p>
鍙傛暟
鍙傛暟鍊?/p>
瀛樺偍鐨勬暟鎹枃浠惰矾
寰?/p>
D:\db\
瀛樺偍鐨勬棩蹇楁枃浠惰矾寰?/p>
D:\db\
鏁版嵁鏂囦欢鍒濆澶у皬
5MB
鏃ュ織鏂囦欢鍒濆澶у皬
2MB
鏁版嵁鏂囦欢鏈�澶у�?/p>
20MB
鏃ュ織鏂囦欢鏈�澶у�?/p>
15MB
鏁版嵁鏂囦欢澧為暱閲?/p>
鍘熸潵
10%
鏃ュ織鏂囦欢澧為暱閲?/p>
2MB
浜屻�佽〃鐨勫垱寤恒�佹煡鐪嬨�佷慨鏀瑰拰鍒犻櫎
1
锛庤〃鐨勫垱寤?/p>
鍦?/p>
Grademanager
鏁版嵁搴撲腑锛屽彸閿崟鍑烩�滆〃鈥?/p>
锛岄�夋嫨鈥滄柊寤鸿〃鈥濆懡浠わ紝鍒涘缓濡備笅琛ㄦ墍绀虹殑琛細
锛?/p>
1
锛?/p>
Student
琛ㄧ殑琛ㄧ粨鏋?/p>
瀛楁鍚嶇О
鏁版嵁绫诲瀷
闀垮害
绮惧害
灏忔暟浣嶆暟
鏄?/p>
鍚?/p>
鍏?/p>
璁?/p>
Null
鍊?/p>
璇存槑
Sno
Char
10
0
0
鍚?/p>
瀛﹀彿锛屼富鐮?/p>
Sname
Varchar
8
0
0
鏄?/p>
濮撳悕
Ssex
Char
2
0
0
鏄?/p>
鎬у埆锛屽彇鍊硷細鐢锋垨濂?/p>
Sbirthday
Date
8
0
0
鏄?/p>
鍑虹敓鏃ユ湡
Sdept
Char
16
0
0
鏄?/p>
绯诲悕
Speciality
Varchar
20
0
0
鏄?/p>
涓撲笟鍚?/p>
鐗瑰埆娉ㄦ剰锛?/p>
涓哄睘鎬?/p>
Ssex
璁剧疆绾︽潫锛?/p>
闇�閫変腑灞炴�?/p>
Ssex
琛岋紝
鐒跺悗鍗曞嚮鑿滃崟涓殑
鈥滆〃璁捐鍣ㄢ�?/p>
锛?/p>
閫夋嫨
鈥?/p>
CHECK
绾︽潫鈥濆懡浠わ紝鐒跺悗鎸夌収鍥?/p>
1
杩涜璁剧疆銆?/p>