2. 1 Information requirements (basic information)
Drug information: drug number, drug name, drug category code, selling price, ex-factory price, unit, inventory, expiration date, approval number, etc.
Drug classification index information: drug category code, category description, etc.
Supplier information: supplier number, supplier name, contact person, telephone number, city, etc.
Drug sales information: sales code, drug code, drug name, sales price, unit, quantity, total amount, sales date, etc.
User information: employee number, name, user login name, user password, user identity, user authority, etc.
2.2 functional requirements
The main functions to be realized by the system are:
(1) The maintenance and management of drug information can add, modify and delete ten thousand volumes of drug information, and query drug information according to certain conditions.
(2) The management of supplier information can add, modify and delete information, and query information according to certain conditions.
(3) User information management can complete the addition, modification and deletion of information, and query information according to certain conditions.
(4) Warehouse management, which can query the drug information in stock, update and count the inventory.
(5) Query function, which requires you to query by date, or by fields selected by users and contents entered.
In the design stage, I first understand the medical management and carefully analyze the requirements of this management for system functions. According to these functional requirements, define the system and determine what the system must do. However, due to the lack of understanding of medical management, the demand analysis is inevitably imperfect, but considering the basic needs, the requirements of the system are accurately recorded with documents. After that, start the design of the system. First, design the conceptual structure. According to the results of demand analysis, the entities in the system are summarized, and the local ER diagram and the global ER diagram of the system are drawn. Then, logical structure design, combining requirement analysis and conceptual structure design, transforms the designed ER diagram into the logical structure of data model supported by DBMS(SQL Server 2000). Finally, function coding is carried out with the development tool VB6.0.
In the end, the system can basically achieve most functions, but there are many things that have not been done, such as the information function of storing new drugs in the warehouse. However, because of the change of purchase price and expiration date, not only can the inventory of drugs be changed, but the purchase price can be changed by the addition pricing method, but the expiration date has not been solved.