1、1Design And Implementation Of The Theaters Multiple Management SystemAbstract. The paper introduces the design and realization of the Theater Management Information System Based on C/S Mode. This system is developed by VB and SQL. It can improve working efficiency of multimedia data management of Th
2、eater Technology. The system has good succession and transportability. Key words： Theater； C/S； VB； SQL； MIS （Management Information System） A modern Theater in normal operation is always in the face of a large number of consumers， the film information and both interact to produce pre-sale informati
3、on and refund information. In the face of tens of thousands of films， numerous and complicated employee information， and frequent replacement of advance information， the traditional method is not only extremely inconvenient and very easy to appear loophole， resulting in the loss. Therefore Theater c
4、omprehensive management informatization is the inevitable trend . It is is very necessary to have an intelligent and information Theater comprehensive management system， which can make full use of 2the computer to realize the function of the Theater，room，video information， screening program informat
5、ion， open booking information to bring about administrator information automation control.It just can reduce theater comprehensive management work greatly. Convenient friendly graphical interface， easy operation， perfect database management will make cinema management system maximum apply to modern
6、cinema comprehensive management， becoming a right-hand tool of management personnel. The cinema comprehensive management system is a typical managing information system （know as MIS） ， which is business integrated service platform to realize set cinema， room management， film showing management， tick
7、et statistics and analysis， management， a comprehensive cinema management system and realize the diversification of cinema business management based on Client/Server structure. 2. Theater s Multiple Management System design At present the popular management system structure is C/S and B/S. Through a
8、nalysis and comparison，combining its business characteristics of theater s multiple management system， this system uses C/S structure to achieve and uses the Visual Basic 6.0 as the front of the development software of 3database management information system， middle layer using ADO data access techn
9、ology which database operation will be in the form of class package and SQL Server 2000 is as background development tool. This is development combination of classic database management information system. 2.1 function structure design （1） system Settings module System Settings module includes user
10、information， system cancellation and system exit. This module manages the user of using this system software， set user name ， password and access， thus effectively ensuring the security of the system. System in the start or login time will call login interface， it is used to verify the legitimacy of
11、 the user. （2） foundation information setting module Basic information setting module mainly includes setting management of the theater and vedio hall， the films management， showing planning. The theater and vedio hall Settings management module are used for processing all kinds of relevant informat
12、ion concerning theater and vedio hall. The film planning module lays out each film for each vedio hall . It is the foundation and the premise of the theater s multiple management mystem design and implementation. 4（3） the daily business processing module The daily business processing module is the c
13、ore of the system， including booking and refund management，which mainly is used for ticket reservation ， sale and refund. （4） information query and statistics module Information query and statistics is based on daily business processing module， mainly used to films query ， film ticket query and the
14、statistics of a week at the box office. It includes ticketing inquiries， refund inquiries， film inquiries， film screening plan inquiries， the box office and sales statistics， etc. （5） help 2.2 Database design Database structure design is very important link in the overall design stage. The general d
15、atabase design is divided into logical design and physical design of database. The logic of the database design is to transform relationship meetting the third paradigm for the data sheet of a specific database management system. According to the systems E-R chart，we get each relationship. Firstly w
16、e put them into relation model. Based on logical design we transform entity into the following relation table： theater， room， 5seats， movie （film Numbers， the movie name， class Numbers， issuing unit， issue time， copy number， unit price） ， the film category， screening， departments， management personn
17、el， ticket reservation customer information， box office statistical and the user information. After the completion of the logic design of database， then we carry out physical design of database. Based on the above database logic design， this system database decides to use more popular Microsoft SQL
18、Sever at present， which have absolute advantages in safety， accuracy， speed ， process large amount of data and have high efficiency. The system decides to use a database， under which create six data tables： Theater， Room， Seat， FilmType ， Film ， Play ， Department ， Employee ， Ticket ， OrderTicket ，
19、Booking ， Users . 2.3 Engineering framework design System adopts more popular ADO data access technology at present， and packages each database table field and operating to the class， thus successfully applys the thought of object-oriented program design to the database application programming. This
20、 is also the system characteristics and advantages. In the project， we need to create class module for 6table，which packaging all the database operation in the class of this table. Normally， the class member variables and field name of the corresponding to the table are same. 2.3.1 Film class 2.4 Sy
21、stem running environment design Theater multiple management system architecture uses two layer client/server mode， namely the client and database server section. The client provides user operation interface， receives various operating information of user input， and sends all commands or data request
22、 to the database server， receives the data result after executing the commands.According to the business logic it does related operation， displays the corresponding information to customers. The database server receives client data or command request， and implements corresponding command to get the
23、corresponding data set， then processes the data set ， and sets the data set or processed data back to the client. 2.5 System test After the system design，we must carry on the system test to determine the system can realize a series of normal functions. The system adopts the BLACK BOX testing method， that is， 7no matter how the test parts realize， a test method only for the part of the input/output results. In the test， according to each module of the corresponding information，we input test data， run the program and check output results and the state of the system.
