數(shù)據(jù)庫(kù)課程設(shè)計(jì)(學(xué)院學(xué)生管理信息系統(tǒng))(編輯修改稿)
2025-02-12 14:17 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 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)建在“對(duì)象資源管理器”中“學(xué)院學(xué)生管理信息系統(tǒng)”數(shù)據(jù)庫(kù)右擊“關(guān)系”新建關(guān)系圖。關(guān)系圖如圖52所示。圖62 表間關(guān)系圖第七章 創(chuàng)建存儲(chǔ)過(guò)程并輸入數(shù)據(jù)打開(kāi)數(shù)據(jù)庫(kù)0701410103，在“存儲(chǔ)過(guò)程”上右擊，選擇“新建存儲(chǔ)過(guò)程”，然后輸入代碼。創(chuàng)建存儲(chǔ)過(guò)程，代碼如下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語(yǔ)句向表中輸入數(shù)據(jù)，過(guò)程如圖71所示，表內(nèi)容如圖72所示。圖71運(yùn)用exec語(yǔ)句向college表輸入數(shù)據(jù)圖72表college內(nèi)容創(chuàng)建存儲(chǔ)過(guò)程，過(guò)程如圖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存儲(chǔ)過(guò)程運(yùn)用exec語(yǔ)句向表中輸入數(shù)據(jù)，過(guò)程如圖74所示，表內(nèi)容如圖75所示。圖74運(yùn)用exec語(yǔ)句向表class輸入數(shù)據(jù)圖75 class表內(nèi)容創(chuàng)建存儲(chǔ)過(guò)程，代碼如下: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語(yǔ)句向表中輸入數(shù)據(jù)，過(guò)程如圖76所示，表內(nèi)容如圖77所示。圖76 向表team輸入數(shù)據(jù)圖77 team表內(nèi)容 dorm表創(chuàng)建存儲(chǔ)過(guò)程，代碼
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1