A System Of Benefit Checking For The Industrial And Commercial Bank Of Yili In XinJiang

A benefit checking system for the Industrial and Commercial Bank of YiLi in Sinkiang is proudced in this research using full cost managing and operation managing. The system consists of three subsystems:the managing subsystem, the apportioning of cost subsystem and the evaluating of achievement subsystem.The managing subsystem realize the quintuplicate system of bank, obligation center,product, subject and client. The subsystem also can manage the identity and purview of operator, prevent the illegal users from invading the system , and the legal user from exceeding their authority;The apportioning subsystem read the data stored in computer firstly. In the second it proportion the cost of the bank to the obligationg centers . The apportioning subsystem continue apportioning until the cost is proportioned to the group of clients; The evaluating of achievement subsystem evaluate the achievement of bank, and grade the bank according to the evaluating result.Conceptual model , physical model and object oriented model are developed with the Computer Aided Software Engineering tool(PowerDesinger) in this research , then the object design, the database design and the DBMS are integerated.According to the charactar of bank, the refer integrality of database is designed , the integrity of affair is developed and the sql is optimized.In the last research probe into the sql attacking and give some advice of security.