數(shù)據(jù)庫(kù)超市商品庫(kù)存管理系統(tǒng)課程設(shè)計(jì)報(bào)告(編輯修改稿)
2024-09-03 13:26 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 。,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。好夢(mèng)來(lái)絲被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。個(gè)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。東倉(cāng)庫(kù)39。,39。東郊巷22號(hào)39。,39。aa39。)insert into Storage(Sname,Spac,AD)values(39。西倉(cāng)庫(kù)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)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1