學生學籍管理系統(tǒng)數(shù)據(jù)庫設計(編輯修改稿)
2025-06-18 21:20 本頁面
【文章內(nèi)容簡介】 ot null, foreign key (number) references student_information (number), ) . 課程評估表建立 create table course_evaluate ( number varchar(40) not null, nam varchar(40) not null, course varchar(40) not null, Course_number varchar(40) not null, teacher varchar(40) not null, grade varchar(40) not null, foreign key (number) references student_information (number), ) . 選課表建立 create table course_select ( number varchar(40) not null, nam varchar(40) not null, course varchar(40) not null, Course_number varchar(40) not null, teacher varchar(40) not null, coursetime varchar(40) not null, classroom varchar(40)not null, foreign key (number) references student_information (number), ) . 網(wǎng)上報名表建立 create table enroll_online ( number varchar(40) not null, nam varchar(40) not null, project varchar(40) not null , datelimit datetime not null, enrolldate datetime not null, givemoney varchar(40), foreign key (number) references student_information (number), ) . 數(shù)據(jù)初始化 USE studentsys go . 將學生信息加入表 student_information中 insert into student_information(number,nam,ID,borndate,enterdate,institute,subject,phone) values(39。20210605306039。,39。林峰39。,39。44078219890819214039。,39。1989081939。,39。2021090539。,39。經(jīng)濟與管理學院 39。,39。信管39。,39。1512069023439。) insert into student_information(number,nam,ID,borndate,enterdate,institute,subject,phone) values(39。20210605306139。,39。佘詩曼39。,39。44078219880819214339。,39。1988081939。,39。2021090539。,39。經(jīng)濟與管理學院 39。,39。營銷39。,39。1512069023939。) insert into student_information(number,nam,ID,borndate,enterdate,institute,subject) values(39。20210605306239。,39。吳卓羲 39。,39?！?9。,39。19900819 39。,39。2021090539。,39。旅游學院39。,39。廣告設計 39。) insert into student_information(number,nam,ID,borndate,enterdate,institute,subject) values(39。20210605306339。,39。陳豪39。,39。44078219890822214039。,39。1989082239。,39。2021090539。,39。經(jīng)濟與管理學院 39。,39。信 管39。) insert into student_information(number,nam,ID,borndate,enterdate,institute,subject) values(39。20210605306439。,39。葉璇39。,39。44078219880819235639。,39。1988081939。,39。2021090539。,39。法學院 39。,39。法律 39。) insert into student_information(number,nam,ID,borndate,enterdate,institute,subjec t,phone) values(39。20210605306539。,39。陳鍵鋒39。,39。4407821991072214039。,39。1991072239。,39。2021090539。,39。旅游學院 39。,39。旅游39。,39。1512069018939。) . 將已有的成績加入 score_search表中 insert into score_search (nam,number,yea,term,course,score,credit,point,Course_number ) values(39。林峰 39。,39。20210605306039。,39。202139。,39。139。,39。數(shù)據(jù)庫原理39。,39。9039。,39。439。,39。39。,39。017739。)。 insert into score_search (nam,number,yea,term,course,score,credit,point,Course_number ) values(39。佘詩曼 39。,39。20210605306139。,39。202139。,39。239。,39。市場營銷39。,39。9039。,39。439。,39。39。,39。016439。)。 insert into score_search (nam,number,yea,term,course,score,credit,point,Course_number ) values(39。吳卓羲 39。,39。20210605306239。,39。202139。,39。139。,39。廣告概述39。,39。8539。,39。439。,39。39。,39。023739。)。 insert into score_search (nam,number,yea,term,course,score,c
法律信息相關(guān)推薦
鄂ICP備17016276號-1