Abstract
In recent years, as the continual development of web communication technology and capacity of h& s changed with each day, a great world of transformation has been taken in field of finance, commodity circulation, carrying trade, tourism and so on. It also causes the translation of people’s living and consumption styles. One of the most important fruition brought with the development of web tech is POS which emphasizes applying system based on storage. It has a great number of advantages such as new theories on design, explicit digital flow, especially the functional maturity, high effect and the easy to alter and expand.
POS management system is a typical of management information systems. The invention includes two sides: the establishment and maintenance of background database and development of front-end applications. Database requires the establishment of data consistency and integrity of strong data security for the first, as for the latter demanding the functional application maturity, and easy to use.
I have a deep study and application in both MS SQL Server 2000 database management system and ASP applications design according to requirements of information management systems, the main job is to complete the analysis of the management system requirement, functional modules and database modeling, then design the structure of the database and application procedures. As constructed by ASP, this system can run not only in single computer but network as well with the high flexibility.
Keywords: The POS system; Inquiry; SQL Server 2000; ASP
