計(jì)算機(jī)學(xué)院大作業(yè)之醫(yī)藥超市管理系統(tǒng)-資料下載頁(yè)
2025-08-07 09:05本頁(yè)面
【正文】 es medicion (medicionNo),foreign key (partNo) references part (partNo),primary key (medicionNo,partNo ),stocksCount int default 39。039。)。測(cè)試數(shù)據(jù)insert into stock(partNo,medicionNo,stocksCount) values (1,3,100)。insert into stock(partNo,medicionNo,stocksCount) values (3,3,100)。加上門(mén)店表中負(fù)責(zé)人的外碼alter table part add foreign key (clerkNo) references clerk (clerkNo)。下面的功能沒(méi)有測(cè)試。需要完成的功能：。select * from clerk where PartNo=?。，查詢(xún)?cè)撍幤吩谠摰甑膸?kù)存。selcet stocksCount from stock where medicionNo=? and partNo=?。，查找在哪個(gè)店有，有多少。select partNo, stocksCount from stock where stocksCount0 。，查詢(xún)其賣(mài)了哪種藥多少量和銷(xiāo)售額select medicionNo,count(salesCount) as num,num*salesPrice as total from parttomedicin where salesDate=? and partNo=? group by medicionNo。，查詢(xún)平均銷(xiāo)售額create view totals as select count(salesCount)* salesPrice as total from parttomedicin where partNo=? and 日期比較我給忘了 group by medicionNo。select count(total)/30 from totals。，查詢(xún)供應(yīng)商和城市。select providerName,providerCity from provider,providertopart where medicionNo=? and partNo=? and =。
法律信息相關(guān)推薦
鄂ICP備17016276號(hào)-1