Application Of Database In Teaching Management

With the database's growing, the management and normalization problems are very critical.. Obtained from the analysis modernization workcharacteristic, the concept of database and the method of SQL language application are systematically described, and the standardized design method of relational database are grasped. Regarding the most basic type module of teachimg management ---system , the class and grade management, the student management, the curriculum management, the result management, the report form management. From such aspects as entering a school, the class and grade , the specialty, choosing the class, the result and so on, unifies the characteristic and the design method are comprehensively systematically introduced ,using the VB programming technology and the databank technology. The head adoption web page form proceeds to handle.The student result management system is the typical information management system (MIS). Its development mainly includes the establishment of backstage database and the maintenance as well as front ends the application procedure development. Regarding former, the data uniformity and the integrity the database of good security are requested to be established. But regarding latter, the complete application procedure function and the characteristic of being easy to use are to be established. Some problems are still difficult to solve of how the data is described in the treating processes, the memory, the index, the inquiry and the renewal and so on. The main work of this article was to realize corresponding work of increase and deletion through the research of the input data in the treating processes of some essential technologies. In design process, from the data acquisition and the demand analyze to the system investigation and the analysis, the relation of data and entity (E -R Charts) is expounded. The key description is carried on regarding the database development design stage, from the demand analysis, the concept structural design, the logical organization design, the database physics structural design, the database implemented to the database movement and the maintenance , the six stages are carried on in detail. From database constructing, Uses SQL Sever 2,000 is the foundation establishment, which is advantageous for the maintenance and the use, meanwhile has carried on the explanation to the SQL sentence function and the application method, and also is advantageous for more people to visit reading the data. Its significance lies in the fact that the student result management system is an education unit essential part. Its content is very important for the school policy-maker and the superintendent, therefore the student result management system should be able to provide the sufficient information and the quick inquiry method for the user. For select elective courses used the body calculate way beg the superior solution proceeds the analysis handles, passing the replication, cross, variation etc. method selects the superior turning calculates the son, then proceed the sieving with the coordination term, adopting a kind of new heredity strategy.Proceed the conservancy the superior individual of inside of each generation, each time after producing the new community, judge the new community whether inside have or not ratio current and superior individual orientation value better, if have, then use the current superior individual in its replacement.Pass the father on behalf to compete with the son on behalf, can increase to solve of refrain from rash action the speed from but get a possibility select elective courses the method. In summary, this article takes in student result management in SQL Sever data processing some essential technologies as the essential target, through thorough discussion, the certain research has been done and the certain result yielded. But in these research topics many partial difficulties are very big. This article work is an application merely. So the work in this dissertation is just an application. More knowledge regarding SQL Sever is to study. We will study it further in the future work...