最新數(shù)據(jù)庫(kù)課程設(shè)計(jì)之圖書(shū)銷(xiāo)售管理系統(tǒng)免費(fèi)下載(編輯修改稿)
2025-05-04 23:13 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 (Cno))。退貨訂購(gòu)圖書(shū)信息表：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ì)圖書(shū)信息表book：(書(shū)編號(hào)ISBN，出版社Bpress，單價(jià)Bprice，書(shū)名Bname，作者Bauther，數(shù)量Bnum)顧客信息表customer：（顧客編號(hào)Cno，顧客姓名Cname，地址Cadd，電話Ctel）書(shū)店信息表store：（書(shū)店編號(hào)Sno，店名Sname，書(shū)店地址Sadd，書(shū)店電話Stel）供貨商信息表provider：（供貨商編號(hào)Pno，供貨商姓名Pname，供貨商地址Padd，供貨商電話Ptel）訂購(gòu)圖書(shū)信息表orders：（訂單編號(hào)Ono，書(shū)編號(hào)ISBN，書(shū)名Bname，顧客編號(hào)Cno，書(shū)店編號(hào)Sno，訂購(gòu)數(shù)量Onum，訂購(gòu)價(jià)格Oprice）退貨訂購(gòu)圖書(shū)信息表returned：（退書(shū)編號(hào)Rno，書(shū)編號(hào)ISBN，書(shū)名Bname，顧客編號(hào)Cno，書(shū)店編號(hào)Sno，退書(shū)數(shù)量Rnum，退書(shū)價(jià)格Rprice）進(jìn)貨信息表jinhuo：（進(jìn)貨編號(hào)Jno，書(shū)編號(hào)ISBN，書(shū)名Bname，書(shū)店編號(hào)Sno，供貨商編號(hào)Pno，進(jìn)貨數(shù)量Jnum，進(jìn)貨金額Jprice）退貨信息表tuihuo：（退貨編號(hào)Tno，書(shū)編號(hào)ISBN，書(shū)名Bname，書(shū)店編號(hào)Sno，供貨商編號(hào)Pno，退貨數(shù)量Tnum，退貨金額Tprice）統(tǒng)計(jì)屬于信息表accord：（統(tǒng)計(jì)編號(hào)Ano，書(shū)編號(hào)ISBN，書(shū)名Bname，庫(kù)存圖書(shū)量Bnum，銷(xiāo)售數(shù)量Anum）(2).插入測(cè)試數(shù)據(jù)：insert into book values(39。000000000000139。,39。龍門(mén)39。,39。語(yǔ)文39。,39。王源39。,10)insert into customer values(39。0000139。,39。小凱39。,39。重慶39。,39。1877000202139。)insert into store values(39。000139。,39。書(shū)吧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。語(yǔ)文39。,39。0000139。,39。000139。,1,)insert into returned values(39。R0139。,39。000000000000139。,39。語(yǔ)文39。,39。0000139。,39。000139。,1,)insert into jinhuo values(39。J0139。,39。000000000000139。,39。語(yǔ)文39。,39。000139。,39。00139。,10,)insert into tuihuo values(39。T0139。,39。000000000000139。,39。語(yǔ)文39。,39。000139。,39。00139。,5,)insert into accord values(39。A0139。,39。000000000000139。,39。語(yǔ)文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ǔ)過(guò)程及觸發(fā)器：，該存儲(chǔ)過(guò)程功能是向進(jìn)貨表中插入一條圖書(shū)記錄：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。語(yǔ)文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ā)器，更新庫(kù)存圖書(shū)中的圖書(shū)數(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