音響店vcd零售出租管理系統(tǒng)設(shè)計數(shù)據(jù)庫原理與應(yīng)用課程設(shè)計論文-資料下載頁
2025-06-19 13:46本頁面
【正文】 state,u_id)。end $delimiter 。：delimiter $create procedure Sale_insert (in v_id char(10),in u_id char(9),in time date , in amount char(5) )begin insert into user( Vid,UserID,Stime,Samount ) values (v_id,u_id,time,amount)。end $delimiter 。附錄2 數(shù)據(jù)查看和存儲過程功能的驗證1） 查看VCD表中的信息：2） 查看Type(VCD類型)表中的信息：3） 查看Hire(VCD出租)表中的信息：4） 查看User(用戶信息)表中的信息：5） 查看Sale(VCD銷售)表中的信息：6） 用戶查詢VCD視圖：7） 管理員視圖a：8） 管理員視圖b：：： ： ：3 觸發(fā)器驗證：a. 刪除Hire表中的一條記錄，觸發(fā)VCD表更新：其他驗證省略.(在數(shù)據(jù)庫測試中均通過)附錄3 所有的SQL運行語句Create database ManagerVCD。Create table User( UserID char(10) primary key, UserSex char(2) not null, UserTel char(11) not null, UserNum char(18) not null )Create table VCD( Vid char(10) primary key, Vname char(30) not null, Vtype char(20) not null, Vdirector char(20), Vact char(20), Vdate date, Vamount int not null, Vform char(5) not null )Create table Type( Vtype char(20) primary key, Tname char(20) not null, )Create table Hire( Hid char(5) primary key, Vid char(10) not null, Hamount char(5), Htime date, Hre date, Hmoney int, Hstate char(2) not null, UserID char(9) not null )Create table Sale( UserID char(9) primary key, Vid char(10) primary key, Samount char(5) not null, Stime date )Create table admina( Vid char(10) primary key, Samount char(5) not null, Hamount char(5) not null, )Create table adminb( Ano char(20) primary key, Aname char(20) not null, Apwd char(20) not null, )。alter table Hireadd constraint fk_hire_userid foreign key User(UserID)alter table Hireadd constraint fk_hire_vid foreign key VCD(Vid)alter table Saleadd constraint fk_sale_userid foreign key User(UserID)alter table Saleadd constraint fk_sale_vid foreign key VCD(Vid)alter table VCDadd constraint fk_vcd_vtype foreign key Type(Vtype)Create view user_viewasSelect * from UserCreate view user_QueryASselect , , , from VCD,Typewhere = Create View Manager_HAsSelect , From VCD , Hire Where = Create View Manager_SAsSelect , From VCD , SaleWhere = Create unique index user_id on User(UserID)。Create unique index vcd_id on VCD(Vid)。Create cluster index VCD_index on VCD(Vname)。Create cluster index Type_index on Type(Tname)。delimiter $create trigger t_vcd_hire_deleteafter delete on hirefor each rowbegin update vcd set vamount = vamount where = 。end $create trigger t_vcd_hire_insertbefore insert on hirefor each rowbegin update vcd set vamount = vamount where = 。end $create trigger t_vcd_hire_updateafter update on hirefor each rowbegin update vcd set vamount = vamount where = 。end $create trigger t_vcd_sale_deleteafter delete on salefor each rowbegin update vcd set vamount = vamount where = 。end $create trigger t_vcd_sale_insertafter insert on salefor each rowbegin update vcd set vamount = vamount where = 。end $create trigger t_vcd_sale_updateafter update on salefor each rowbegin update vcd set vamount = vamount where = 。end $delimiter 。35
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1