【導(dǎo)讀】隨著計(jì)算機(jī)技術(shù)的發(fā)展和普及,各行各業(yè)的管理機(jī)構(gòu)需要由計(jì)算機(jī)處理大量的信息。者會(huì)造成諸多的不便，還有可能疏忽一些細(xì)節(jié)。利用計(jì)算機(jī)進(jìn)行藥品管理，堵塞了藥品的流失。規(guī)范了價(jià)格管理，避免了人為的物價(jià)損。失，從而明顯地提高了經(jīng)濟(jì)效益。將銷售行為納入規(guī)范化、公開化的軌道。的信息管理所取代，所以實(shí)現(xiàn)藥品的信息智能化管理特別重要。因此，本人此次決定選擇藥品銷售管理系統(tǒng)作為數(shù)據(jù)庫課程設(shè)計(jì)。方法為系統(tǒng)開發(fā)帶來了便利。本設(shè)計(jì)成功運(yùn)用了PowerDesigner、SQLServer開發(fā)技術(shù)，此次設(shè)計(jì)含有供應(yīng)商信息，客戶信息，藥品信息，倉庫信息，管理。員信息，銷售信息，供應(yīng)信息，供應(yīng)明細(xì)，銷售明細(xì)，供應(yīng)商往來賬，退貨返廠。據(jù)庫使用的是SQLserver2021。店收入、及時(shí)獲取信息、減少?zèng)Q策失誤、減少庫存積壓、提升員工的素質(zhì)。Designer、SQLServer技術(shù)設(shè)計(jì)的基本方法，并學(xué)會(huì)了SQLServer查詢分析器和企業(yè)管理。點(diǎn)，藥品信息整理與修改,銷售藥單整理統(tǒng)計(jì),銷售額統(tǒng)計(jì)等。

　　

【正文】 /*==============================================================*/ create table Sales table ( Sells the money shop varchar(20) not null, ID int, Time DateTime, Has the amount money, constraint PK_SALES TABLE primary key (Sells the money shop) )。 塔里木大學(xué)信息工程學(xué)院課程設(shè)計(jì) 第 21 頁 共 23 頁 /*==============================================================*/ /* Table: Supplier current account */ /*==============================================================*/ create table Supplier current account ( Account serial number char(8) not null, ID char(8), Time varchar(15), Billing method varchar(10), Settlement amount money, constraint PK_SUPPLIER CURRENT ACCOUNT primary key (Account serial number) )。 /*==============================================================*/ /* Table: Suppliers */ /*==============================================================*/ create table Suppliers ( ID char(8) not null, Full title varchar(20), Abbreviation varchar(10), Telephone varchar(15), Address varchar(20), Respective area varchar(10), Bank account number char(20), Taxpayer registration varchar(20), constraint PK_SUPPLIERS primary key (ID) )。 /*==============================================================*/ /* Table: Supply */ /*==============================================================*/ create table Supply ( ID char(8) not null, Supply time char(20), Has the amount money, constraint PK_SUPPLY primary key (ID) )。 /*==============================================================*/ /* Table: SupplyDetail */ /*==============================================================*/ create table SupplyDetail 塔里木大學(xué)信息工程學(xué)院課程設(shè)計(jì) 第 22 頁 共 23 頁 ( ID char(8) not null, Dru_ID char(8), Supply float not null, Unit price money not null, Specifications varchar(20), constraint PK_SUPPLYDETAIL primary key (ID) )。 /*==============================================================*/ /* Table: Warehouse */ /*==============================================================*/ create table Warehouse ( ID char(8) not null, Name varchar(20), Administrator char(15), Category char(15), Area float, constraint PK_WAREHOUSE primary key (ID) )。 alter table Customer add constraint FK_CUSTOMER_REFERENCE_MANAGER foreign key (ID) references Manager (ID) on update restrict on delete restrict。 alter table Distribution add constraint FK_DISTRIBU_REFERENCE_WAREHOUS foreign key (War_ID) references Warehouse (ID) on update restrict on delete restrict。 alter table Distribution add constraint FK_DISTRIBU_REFERENCE_SUPPLYDE foreign key (ID) references SupplyDetail (ID) on update restrict on delete restrict。 alter table Return Fanchang add constraint FK_RETURN F_REFERENCE_SUPPLYDE foreign key (ID) references SupplyDetail (ID) on update restrict 塔里木大學(xué)信息工程學(xué)院課程設(shè)計(jì) 第 23 頁 共 23 頁 on delete restrict。 alter table SaleDetail add constraint FK_SALEDETA_REFERENCE_DRUGS foreign key (Dru_ID) references Drugs (ID) on update restrict on delete restrict。 alter table SaleDetail add constraint FK_SALEDETA_REFERENCE_SALES TA foreign key (Sells the money shop) references Sales table (Sells the money shop) on update restrict on delete restrict。 alter table Sales table add constraint FK_SALES TA_REFERENCE_CUSTOMER foreign key (ID) references Customer (ID) on update restrict on delete restrict。 alter table Supplier current account add constraint FK_SUPPLIER_REFERENCE_SUPPLIER foreign key (ID) references Suppliers (ID) on update restrict on delete restrict。 alter table Supply add constraint FK_SUPPLY_REFERENCE_SUPPLIER foreign key (ID) references Suppliers (ID) on update restrict on delete restrict。 alter table SupplyDetail add constraint FK_SUPPLYDE_REFERENCE_DRUGS foreign key (Dru_ID) references Drugs (ID) on update restrict on delete restrict。 alter table SupplyDetail add constraint FK_SUPPLYDE_REFERENCE_SUPPLY foreign key (ID) references Supply (ID) on update restrict on delete restrict。