數(shù)據(jù)庫課程設(shè)計(jì)(學(xué)院學(xué)生管理信息系統(tǒng))(編輯修改稿)
2025-02-12 14:17 本頁面
【文章內(nèi)容簡介】 eate table dorm(dorm_num char(3) primary key, building_num char(4), total_member char(2), adm char(8))。create table student(stu_num char(10) primary key, stu_name char(8) not null, gender char(2) check (gender in (39。男39。,39。女39。)), 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))。圖61 表結(jié)構(gòu)的創(chuàng)建在“對象資源管理器”中“學(xué)院學(xué)生管理信息系統(tǒng)”數(shù)據(jù)庫右擊“關(guān)系”新建關(guān)系圖。關(guān)系圖如圖52所示。圖62 表間關(guān)系圖第七章 創(chuàng)建存儲過程并輸入數(shù)據(jù)打開數(shù)據(jù)庫0701410103，在“存儲過程”上右擊，選擇“新建存儲過程”，然后輸入代碼。創(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)運(yùn)用exec語句向表中輸入數(shù)據(jù)，過程如圖71所示，表內(nèi)容如圖72所示。圖71運(yùn)用exec語句向college表輸入數(shù)據(jù)圖72表college內(nèi)容創(chuàng)建存儲過程，過程如圖73所示，代碼如下:CREATE PROCEDURE add_class @class_num char(5),@class_namechar(20),@major char(20),@classroom char(8),@college_num char (5)ASInsert into class(class_num,class_name,major, classroom,college_num)values (@class_num,@class_name,@major,@classroom,@college_num)圖73創(chuàng)建表class存儲過程運(yùn)用exec語句向表中輸入數(shù)據(jù)，過程如圖74所示，表內(nèi)容如圖75所示。圖74運(yùn)用exec語句向表class輸入數(shù)據(jù)圖75 class表內(nèi)容創(chuàng)建存儲過程，代碼如下:CREATE PROCEDURE add_team @team_num char(5), @team_name char(8),@coach char(8),@place char(10),@sporttime datetime,@college_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)運(yùn)用exec語句向表中輸入數(shù)據(jù)，過程如圖76所示，表內(nèi)容如圖77所示。圖76 向表team輸入數(shù)據(jù)圖77 team表內(nèi)容 dorm表創(chuàng)建存儲過程，代碼
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1