學生學籍管理系統(tǒng)sql數(shù)據(jù)庫系統(tǒng)設計(編輯修改稿)
2025-05-04 23:06 本頁面
【文章內(nèi)容簡介】 ade on update cascade, )gocreate table S 學生表( S_NO char(10) not null, S_NAME varchar(10), S_SEX char(2) check(S_SEX in(39。男39。,39。女39。)), S_BIRT varchar(10), S_NAFA varchar(8), S_BIPL varchar(10) , S_ADDR varchar(50), S_POST char(6), 郵政編碼 S_TEL varchar(20), S_ID char(18),返回不帶前導空格(LTrim)、后續(xù)空格(RTrim) 或前導與后續(xù)空格(Trim) 的字符串副本。 S_POLA varchar(10) check( rtrim(S_POLA) in (39。其他39。, 39。群眾39。,39。共青團39。,39。中共黨員39。)), S_YEAR varchar(10),入學時間 S_DEPA CHAR(4), 院系 S_PROF CHAR(4), 專業(yè) S_CLAS CHAR(4), 班級 S_NOTE varchar(1000), constraint pk_S primary key(S_NO), constraint fk_S_CLAS foreign key (S_CLAS) references B (B_ID) on delete cascade on update cascade,) gocreate table C 課程表( C_ID CHAR(4) not null, C_NAME varchar(20), C_PRNO CHAR(4) , C_CREDIT int not null, C_NOTE varchar(200), constraint pk_C primary key (C_ID), constraint fk_C foreign key (C_PRNO) references C(C_ID))gocreate table CS 選課表( S_No char(10) not null, C_ID CHAR(4) not null, CS_RESULT FLOAT, constraint pk_C_S primary key(S_No,C_ID), constraint fk_C_S_S foreign key(S_No) references S(S_No), constraint fk_C_S_C foreign key(C_ID) references C(C_ID))gocreate table T 教師表( T_ID CHAR(4) not null, T_NAME varchar(4), T_COR varchar(20) , T_TEL char(11), constraint pk_T primary key (T_ID))gocreate table J 授課表表( T_ID char(4) not null, C_ID CHAR(4) not null, J_TIME varchar(20), constraint pk_T_C primary key(C_ID,T_ID), constraint fkJ_C foreign key(C_ID) references C(C_ID), constraint fkJ_T foreign key(T_ID) references T(T_ID))go插入數(shù)據(jù)：insert A(A_ID,A_PERM,A_PW,A_USER)values (39。000139。,39。139。,39。password139。,39。張六39。)goinsert A(A_ID,A_PERM,A_PW,A_USER)values (39。000239。,39。239。,39。password239。,39。張齊39。)goinsert D (D_ID,D_Name,D_NUM,D_MASTER)values (39。000139。,39。信息技術學院39。,5000,39。張五39。)goinsert P (P_ID,D_ID,P_NAME,P_NUM)values (39。000139。,39。000139。,39。數(shù)字媒體技術39。,120)goinsert P (P_ID,D_ID,P_NAME,P_NUM)values (39。000239。,39。000139。,39。軟件工程39。,120)goinsert B (B_ID,P_ID,B_NAME,B_NUM,B_MASTER)values (39。000139。,39。000139。,39。1班39。,120,39。李麗39。)goinsert B (B_ID,P_ID,B_NAME,B_NUM,B_MASTER)values (39。000239。,39。000239。,39。1班39。,120,39。王宏39。)goinsert Svalues(39。100101001839。,39。蘇希39。,39。女39。,39。198971039。,39。漢族39。,39。廣東省39。,39。北京師范大學珠海分校39。,39。51907839。,39。158********39。,39。44188219910805062739。,39。中共黨員39。,39。20079139。,39。000139。,39。000139。,39。000139。,39。無39。)goinsert Svalues(39。100101076439。,39。張妮39。,39。女39。,39。199081039。,39。漢族39。,39。貴州省39。,39。北京師范大學珠海分校39。,39。5190
公司管理相關推薦
鄂ICP備17016276號-1