超市管理系統(tǒng)設(shè)計(jì)概述-全文預(yù)覽
【正文】 money NULL , TotalPrice money NULL , PlanDate datetime NULL , StockDate datetime NULL, StockState int NOT NULL) GO/*創(chuàng)建用戶表*/CREATE TABLE User ( UserID varchar(10) Primary key , UserName varchar(25) NOT NULL , UserPW varchar(50) NOT NULL , UserStyle int NOT NULL ,)GO/*創(chuàng)建表間約束*//*商品信息表中廠商編號(hào)、供應(yīng)商編號(hào)分別與廠商表、供應(yīng)商表之間的外鍵約束*/ALTER TABLE MerchInfo ADD CONSTRAINT [FK_MerchInfo_Factory] FOREIGN KEY ( [FactoryID] ) REFERENCES Factory ( [FactoryID] ), CONSTRAINT [FK_MerchInfo_Provide] FOREIGN KEY ( [ProvideID] ) REFERENCES Provide ( [ProvideID] )GO/*銷售表中商品編號(hào)與商品信息表之間的外鍵約束*/ALTER TABLE Sale ADD CONSTRAINT [FK_Sale_MerchInfo] FOREIGN KEY ( [MerChID] ) REFERENCES MerchInfo ( [MerchID] ) ON DELETE CASCADE GO/*入庫(kù)表中商品編號(hào)與商品信息表之間的外鍵約束*/ALTER TABLE Stock ADD CONSTRAINT [FK_Stock_MerchInfo] FOREIGN KEY ( [MerchID] ) REFERENCES MerchInfo ( [MerchID] ) ON DELETE CASCADE GO/*創(chuàng)建索引*//*在交易表上建立一個(gè)以交易編號(hào)、交易日期為索引項(xiàng)的非聚集索引*/CREATE nonclustered INDEX IX_Dealing ON Dealing(DealingID, DealingDate)GO/*在商品信息表上建立一個(gè)以商品編號(hào)為索引項(xiàng)的非聚集索引*/CREATE nonclustered INDEX IX_MerchInfo ON MerchInfo(MerchID)GO/*在銷售表上建立一個(gè)以銷售編號(hào)、銷售日期為索引項(xiàng)的非聚集索引*/CREATE nonclustered INDEX IX_Sale ON Sale(SaleID, SaleDate)GO/*在入庫(kù)表上建立一個(gè)以入庫(kù)編號(hào)、入庫(kù)日期、商品編號(hào)為索引項(xiàng)的非聚集索引*/CREATE nonclustered INDEX IX_Stock ON Stock(StockID, StockDate, MerchID)GO/*創(chuàng)建視圖*//*創(chuàng)建用于查詢交易情況的視圖*/CREATE VIEW v_DealingASSELECT DealingDate as 交易日期, UserName as 員工名稱, MemberCard as 會(huì)員卡號(hào), DealingPrice as 交易金額FROM Dealing GO/*創(chuàng)建用于查詢進(jìn)貨計(jì)劃的視圖*/CREATE VIEW v_PlanStockASSELECT as SID, as 商品名稱, as 條形碼, as 廠商, as 供貨商, as 計(jì)劃進(jìn)貨數(shù)量, as 計(jì)劃進(jìn)貨日期FROM Stock,MerchInfo,Provide,FactoryWhere = and = and = and =0 GO/*創(chuàng)建用于查詢銷售明細(xì)記錄的視圖*/CREATE VIEW v_SaleASSELECT as 商品名稱, as 條形碼, as 商品價(jià)格, as 銷售價(jià)格, as 銷售數(shù)量, as 銷售日期FROM Sale INNER JOIN MerchInfo ON = GO/*創(chuàng)建用于查詢?nèi)霂?kù)情況的視圖*/CREATE VIEW v_StockASSELECT as 商品名稱, as 條形碼, as 廠商, as 供貨商, as 入庫(kù)價(jià)格, as 入庫(kù)數(shù)量, as 入庫(kù)總額, as 入庫(kù)日期FROM Stock,MerchInfo,Provide,FactoryWhere = and = and = and =1 GO小結(jié)和傳統(tǒng)管理模式相比較，使用本系統(tǒng)，毫無(wú)疑問會(huì)大大提高超市的運(yùn)作效率，輔助提高超市的決策水平，管理水平，為降低經(jīng)營(yíng)成本， 提高效益，減少差錯(cuò)，節(jié)省人力，減少顧客購(gòu)物時(shí)間，增加客流量，提高顧客滿意度，增強(qiáng)超市擴(kuò)張能力， 提供有效的技術(shù)保障。參考文獻(xiàn)[1] 陶宏才編 《數(shù)據(jù)庫(kù)原理及設(shè)計(jì)》 清華大學(xué)出版社[2] 范立南編 《SQL Server 2000 實(shí)用教程》 清華大學(xué)出版社[3] 李香敏編 《SQL Server 2000 編程員指南》 北京希望電子出版社[4] Rebecca 《輕松搞定 SQL Server 2000 程序設(shè)計(jì)》 [5] Watts 《軟件工程規(guī)范》 清華大學(xué)出版社[6] Shari Lawrence Pfleeger編 《軟件工程理論與實(shí)踐》 清華大學(xué)出版社[7] Swapna Kishore編 《軟件需求分析》 機(jī)械工業(yè)出版社[8] 林銳編 《軟件工程思想》33 / 33。 本系統(tǒng)只適合小型超市使用，不能適合中大型超市使用；178。,size=100MB,maxsize=200MB,
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1