The Design And Implement Of Books' Purchase-Sales-Inventory System Based On C/S AND B/S

With the rapid development of computer -. network and communication technology ,the manage information systems, especially the commerce manage systems and the finance manage systems ,are extensively applied .A lot of books commercial corporations would like Purchease-Sales-Inventory (PSI) books manage systems ,as one of the most important means of dealing with operations ^ carrying out management and making assistant decisions .At present, Purchease-Sales-Inventory manage systems generally have two types of constructive patterns .One is C/S, the other is B/S .In view of their advantages and shortcomings as well as correlative factors ,such as its operations characteristic and actuality , being changing Intranet environment and customary demanding fashion and developing trend of operations and manage fashions of corporations ,the paper puts forward a kind of mixed constructive pattern of C/S and B/S Aiming at complex operation, frequent data processing , more data transmitting and high-demand to security ,the C/S is used .On the contrary, for those operations of wide scope and low-rise security ,the B/S is used .In this way ,the mixed patterns has the advantages both C/S and B/S and it satisfied different special demands. At the same time, the transition is smooth from the original management systems to the new pattern and it has the sound expansibility meeting with future demands.The paper introduces the status quo of Purchease-Sales-Inventory , operation flow and characteristic and the software structure of Purchease-Sales-Inventory . It analyses the advantages and disadvantages of C/S and B/S and demonstrates the feasibilities and superiorities of mixed pattern.The paper reasons the system structure of C/S and B/S and the key techniques. It puts forward the developing means of mixed pattern and database designing and optimizing principle and noticed proceedings in applying.By the general design principles of Relation Database System, the optimal design methods and the points for attention during applications are developed.The paper expounds the design and implement based on the mixed pattern of C/S andB/S .It consists of demanding analysis s system structure , network structures data flowing diagrams function module .. entity relation chart of database and the application of key techniques .It gives a detailed expounding about database's dynamic links.The paper puts forward making middle table to satisfy different strikes and handling trigger to realize high efficiency and security of strikes. It gives out a security mechanism combined by four kinds security scheme. In the last part, the paper sums up the key points and gives an expectation of Purchease-Sales-Inventory systems developing direction.