數(shù)據(jù)庫原理與技術(shù)課程設計-資料下載頁
2025-06-03 14:28本頁面
【正文】 ustomer(customerno), furniturename char(8), typeno int, salesvolume int, saleprice money, salesamount money, salesdate datetime constraint pk_furnituresales primary key (furnitureno,customerno,salesdate) ) (7)庫存表 create table stock ( furnitureno int primary key references furniture(furnitureno), furniturename char(8), typename char(8), number int, ) （ 8） 收款管理表 create table collection ( gatheringtime datetime , receiptor char(5), typeno int, paymentamount money, furnitureno int references furniture(furnitureno), customerno int references customer(customerno), constraint pk_collection primary key(gatheringtime, receiptor, typeno, furnitureno, customerno) ) (9)創(chuàng)建觸發(fā)器 實現(xiàn)家具入庫和銷售時自動修改庫存 create trigger t_stock on stock for update as declare @number int select @number=number from inserted if @number in (select number from stock) begin update stock set number=number+@number where number=@number end else begin insert stock (number) values(@number) end select * from stock （ 10） 創(chuàng)建存儲過程統(tǒng)計某段時間內(nèi)各種商品的入庫數(shù)量和銷售數(shù)量 create procedure up_stock as select typeno,sum(number) 入 庫 存 數(shù) 量 ,sum(salesvolume) 銷 售 數(shù) 量 from furniturewarehousing,furnituresales group by typeno
畢業(yè)設計相關推薦
鄂ICP備17016276號-1