數(shù)據(jù)庫超市商品庫存管理系統(tǒng)課程設(shè)計報告(編輯修改稿)
2025-09-03 13:26 本頁面
【文章內(nèi)容簡介】 。,39。1516795235639。,39。天津39。)select * from Providercreate table Goods (Gno char(8) primary key, Gname char(50), Defau char(20), Gpice int, )insert into Goods(Gno,Gname,Defau,Gpice)values(39。10139。,39。爽一爽冰紅茶39。,39。瓶39。,5)insert into Goods(Gno,Gname,Defau,Gpice)values(39。10239。,39。雙貝殼面包39。,39。袋39。,10)insert into Goods(Gno,Gname,Defau,Gpice)values(39。10339。,39。雅萊姿正裝39。,39。套39。,300)insert into Goods(Gno,Gname,Defau,Gpice)values(39。10439。,39。好夢來絲被39。,39。箱39。,100) insert into Goods(Gno,Gname,Defau,Gpice)values (39。10539。,39。三鮮拉面39。,39。袋39。,2)insert into Goods(Gno,Gname,Defau,Gpice)values(39。10639。,39。正德皮靴39。,39。雙39。,300)insert into Goods(Gno,Gname,Defau,Gpice)values(39。10739。,39。紅門床柜39。,39。個39。,400)select * from Goodscreate table Supply( Pno char(8), Gno char(8), QTY int primary key(Pno,Gno), foreign key (Gno) references Goods(Gno), foreign key (Pno) references Provider(Pno))insert into Supply(Pno,Gno,QTY)values(39。A139。,39。10139。,370)insert into Supply(Pno,Gno,QTY)values(39。A239。,39。10239。,150)insert into Supply(Pno,Gno,QTY)values(39。A339。,39。10339。,40)insert into Supply(Pno,Gno,QTY)values(39。A139。,39。10539。,120)insert into Supply(Pno,Gno,QTY)values(39。A339。,39。10639。,20)insert into Supply(Pno,Gno,QTY)values(39。A439。,39。10739。,10)insert into Supply(Pno,Gno,QTY)values(39。A439。,39。10439。,10)select * from Supplycreate table Storage( Sname char(20) primary key, Spac char(20) , AD char(10), )insert into Storage(Sname,Spac,AD)values(39。東倉庫39。,39。東郊巷22號39。,39。aa39。)insert into Storage(Sname,Spac,AD)values(39。西倉庫39。,39。市民路39。,39。bb39。)select * from Storagecreate table Inventory( Gno char(8), Sname char(20), Pno char(8), Numbers int, primary key(Gno,Sname,Pno), foreign key (Gno) references Goods(Gno), foreign key (Sname) references Storage(Sname), foreign key (Pno) references Provider(Pno))insert into Invent
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1