數(shù)據(jù)庫課程設(shè)計(學院學生管理信息系統(tǒng))-文庫吧資料
2025-01-22 14:17本頁面
【正文】 ollege_num char(5)AS Insert into team(team_num,team_name,coach,place,sporttime,college_num)values(team_num,team_name,coach,place,sporttime,college_num)運用exec語句向表中輸入數(shù)據(jù)，過程如圖76所示，表內(nèi)容如圖77所示。創(chuàng)建存儲過程，代碼如下CREATE PROCEDURE add_college college_num char(5),college_name char(20)AS insert into college(college_num,college_name)values (college_num,college_name)運用exec語句向表中輸入數(shù)據(jù)，過程如圖71所示，表內(nèi)容如圖72所示。關(guān)系圖如圖52所示。)), age smallint default 21, class_num char (5) not null,references class(class_num), team_num char(5) references team(team_num), dorm_num char(3) references dorm(dorm_num), pro char(10))。,39。create table student(stu_num char(10) primary key, stu_name char(8) not null, gender char(2) check (gender in (39。create table team(team_num char(5) primary key, team_name char(8) not null, coach char(8), place char(10), sporttime datetime, college_num char(5) references college(college_num))。調(diào)用查詢分析器，用代碼創(chuàng)建表，編寫代碼過程如圖51,代碼如下：create table college(college_num char(5) primary key, college_name char(20) not null)。學院（學院編號，學院名稱）班級（班級號，班級名，專業(yè)，教室，學院編號）運動隊（隊號，隊名，教練員，活動時間，活動地點，學院編號）宿舍（宿舍號，樓號，人數(shù)，管理員）學生（學號，姓名，性別，年齡，班級號，隊號，宿舍號，參加項目）第五章 表結(jié)構(gòu)設(shè)計表51學院表（College）表結(jié)構(gòu)列名說明數(shù)據(jù)類型數(shù)據(jù)長度約束college_num學院編號char5主鍵College_name學院名稱char20非空 表52班級表（class）表結(jié)構(gòu)列名 說明數(shù)據(jù)類型數(shù)據(jù)長度約束Class_num班級號Char5主鍵Class_name班級名稱char20非空major專業(yè)Char20classroom教室Char8College_num學院編號char5外鍵，引用College表的college_num 表53運動
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1