最新數(shù)據(jù)庫課程設(shè)計(jì)之圖書銷售管理系統(tǒng)免費(fèi)下載(編輯修改稿)
2025-05-04 23:13 本頁面
【文章內(nèi)容簡介】 (Cno))。退貨訂購圖書信息表：create table returned(Rno varchar(13) primary key,ISBN varchar(13),Bname char(60),Sno varchar(13),Cno varchar(13),Rnum int,Rprice floatforeign key (Sno) references store(Sno),foreign key (Cno) references customer(Cno))。截圖：三、邏輯設(shè)計(jì)(1).實(shí)體屬性設(shè)計(jì)圖書信息表book：(書編號(hào)ISBN，出版社Bpress，單價(jià)Bprice，書名Bname，作者Bauther，數(shù)量Bnum)顧客信息表customer：（顧客編號(hào)Cno，顧客姓名Cname，地址Cadd，電話Ctel）書店信息表store：（書店編號(hào)Sno，店名Sname，書店地址Sadd，書店電話Stel）供貨商信息表provider：（供貨商編號(hào)Pno，供貨商姓名Pname，供貨商地址Padd，供貨商電話Ptel）訂購圖書信息表orders：（訂單編號(hào)Ono，書編號(hào)ISBN，書名Bname，顧客編號(hào)Cno，書店編號(hào)Sno，訂購數(shù)量Onum，訂購價(jià)格Oprice）退貨訂購圖書信息表returned：（退書編號(hào)Rno，書編號(hào)ISBN，書名Bname，顧客編號(hào)Cno，書店編號(hào)Sno，退書數(shù)量Rnum，退書價(jià)格Rprice）進(jìn)貨信息表jinhuo：（進(jìn)貨編號(hào)Jno，書編號(hào)ISBN，書名Bname，書店編號(hào)Sno，供貨商編號(hào)Pno，進(jìn)貨數(shù)量Jnum，進(jìn)貨金額Jprice）退貨信息表tuihuo：（退貨編號(hào)Tno，書編號(hào)ISBN，書名Bname，書店編號(hào)Sno，供貨商編號(hào)Pno，退貨數(shù)量Tnum，退貨金額Tprice）統(tǒng)計(jì)屬于信息表accord：（統(tǒng)計(jì)編號(hào)Ano，書編號(hào)ISBN，書名Bname，庫存圖書量Bnum，銷售數(shù)量Anum）(2).插入測(cè)試數(shù)據(jù)：insert into book values(39。000000000000139。,39。龍門39。,39。語文39。,39。王源39。,10)insert into customer values(39。0000139。,39。小凱39。,39。重慶39。,39。1877000202139。)insert into store values(39。000139。,39。書吧39。,39。重慶39。,39。1877000202039。)insert into provider values(39。00139。,39。千千39。,39。重慶39。,39。1877000202239。)insert into orders values(39。O0139。,39。000000000000139。,39。語文39。,39。0000139。,39。000139。,1,)insert into returned values(39。R0139。,39。000000000000139。,39。語文39。,39。0000139。,39。000139。,1,)insert into jinhuo values(39。J0139。,39。000000000000139。,39。語文39。,39。000139。,39。00139。,10,)insert into tuihuo values(39。T0139。,39。000000000000139。,39。語文39。,39。000139。,39。00139。,5,)insert into accord values(39。A0139。,39。000000000000139。,39。語文39。,10,0)(3).索引：create unique index ISBN on book(ISBN)。create unique index Cname on customer(Cname)。create unique index Sname on store(Sname)。create unique index Pname on provider(Pname)。create unique index Ono on orders(Ono)。create unique index Rno on returned(Rno)。create unique index Jno on jinhuo(Jno)。create unique index Tno on tuihuo(Tno)。create unique index Ano on accord(Ano)。(4).創(chuàng)建部分存儲(chǔ)過程及觸發(fā)器：，該存儲(chǔ)過程功能是向進(jìn)貨表中插入一條圖書記錄：create procedure inserted @Jno varchar(13),@ISBN varchar(13), @Bname char(60),@Sno varchar(13),@Pno varchar(13),@Jnum int,@Jprice floatas insert into jinhuo(Jno, ISBN, Bname, Sno,Pno,Jnum,Jprice) values(@Jno, @ISBN, @Bname, @Sno,@Pno,@Jnum,@Jprice)goexec inserted 39。J0239。,39。000000000000139。,39。語文39。,39。000139。,39。00139。,10,截圖：，當(dāng)輸入進(jìn)貨號(hào)時(shí)，輸出進(jìn)貨單：create procedure JHXX @Jno varchar(13)as declare @Jnum intselect *from jinhuowhere Jno=@Jnogoexecute JHXX @Jno=39。J0139。截圖：，當(dāng)進(jìn)貨表中增加一條記錄時(shí)觸動(dòng)觸發(fā)器，更新庫存圖書中的圖書數(shù)量信息：Create trigger Trigger_J_insertOn jinhuofor insertasdeclare @Bnum int,@Jnum int,@Ano varchar(13)select @Jnum=Jnumfrom insertedupdate accordset B
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1