City public traffic inquiry system is an important part in traffic and transportation domain, and it's also the inevitable result of social economy's development in urban areas. It is one of typical MSI (Management information system)
This paper has introduced the realized functions of entire system in detail. Firstly, the system has realized many inquiry functions. The system can search bus route by the name of business station, the number of public transport, ordinary bus station and two arbitrary stations. Secondly, the system provides the functions of consumer message. And then, it supplies bus number managing on the backstage and consumer managing. The functions of bus number managing are mainly to add, update and delete the number of bus and the station on the backstage. These can enable the system have the quality of real-time updating to provide the accurate information for user. Besides, the system design by the tool of SQL Server database and PowerBuilder 9.0
Keywords SQL Server; MIS; City Public Traffic Inquiry System