P hysi cs Procedi a 25 ( 2012 )1660 – 1665
1875-3892 © 2012 Published by Elvier B.V. Selection and/or peer-review under responsibility of Garry Lee
doi : 10.1016/j.phpro.2012.03.291
2012 International Conference on Solid State Devices and Materials Science
Design of Student Information Management Databa
Application System for Office and Departmental Target
Responsibility System
Hui ZHOU a,b
a
Communist Youth League of Wuhan University of Technology, Wuhan University of Technology b School of Mechanical and Electronic Engineering, Wuhan University of Technology,Wuhan, P.R.China
Abstract
I t is the inevitable outcome of higher education reform to carry out office and departmental target responsibility system, in which statistical processing of students’ information is an important part of students’ performance review. On the basis of the analysis of the students’ evaluation, the student information management databa application system is designed by using relational databa management system software in this paper. In order to implement the function of student information management, the functional requirement, overall structure, data sheets and fields, data sheet Association and software codes are designed in details.
© 2011 Published by Elvier Ltd. Selection and/or peer-review under responsibility of [name organizer] Keywords: Office and Departmental Target Responsibility; Evaluation; Student Information Management; Databa
1. Introduction
With the continuous deepening of higher education reform, higher educational system and philosophy of all institutions of are intensifying and renewing, and carrying out office and departmental target responsibility system is one of the important actions. The goal of office and departmental target responsibility system is linking the benefit and the result together, abandoning the old mechanism, releasing authority to the office and department, to mobilize their enthusiasm and initiative. In the posss of implementation, identification of faculty performance is bad on a ries of evaluation targets such as faculty teaching, scientific rearch, discipline construction and students’ work in the year's end and then faculty benefit is determined, thus brought the pressure for the faculty, yet brought the power and the vigor. As an important part of office and departmental target responsibility system, the evaluation content of students’ work include the student basic situation, the development of party member, the pass percent of CET-4/6, double degree, postgraduate register and enrollment, rewards and punishment and so on. For the annual evaluation, it costs a lot of time and effort for student workers to finish the complicated statistics Available online at
© 2012 Published by Elvier B.V. Selection and/or peer-review under responsibility of Garry Lee
H ui Zhou / P hysics Procedia 25 ( 2012 )1660 – 1665 1661 and each time it is always the repetition
work, therefore results in a waste of resources. In view of this situation, it is extremely esntial to design student information management databa application system
which has friendly man-machine interface and is simple operation.
The basic goal of designing student information management databa system is the databa application system that is directed towards the evaluation content of students’ work under office and departmental target responsibility system, covers students’ majority basic information, conforms to the operation requirements of student workers, and is advantageous for carrying on the data processing.
2.Databa Management System Software
Strictly speaking, databa management system (DBMS) is one kind of system software products and
the core part of databa system, which carries on the unified management to the databa resources, and is responsible for all request orders the urs nd out. It can do the scientific organization data, the perfect
data storage, the highly effective data capture, convenient data maintenance.
According to the data relation, the databa can be divided into the hierarchical model, the network model, the relational model and object-oriented model. Correspondingly the databa management system
is divided into the hierarchical databa management system, the network databa management system,
the relational relations databa management system and object-oriented databa management. The completely object-oriented databa management system is not mature at prent yet, therefore the relational databa management system is widely ud currently. The advantage of relational databa management system is its structure simple, the form unique, the rationale strict, moreover the data sheets relatively independent in which it could carry on the increa, the revision or the deletion of the data
without affecting the other data sheets. When carrying on the inquiry, it also can inquire the extraction
related information from veral data sheets according to the relation of the data sheets. There are many relational databa management system softwares, for example Visual Foxpro, Oracle, DB2, SQL Server
and so on. Visual Foxpro is lected in the student information management databa system.
3.The Structural Design of Student Information Management Databa Application System
The databa application system may be divided into two kinds: one is data-centric and the other is process-centric. The former takes the data provide as the goal, and the data acquisition, the databa construction and maintenance as the key point. Although the latter also includes the, the emphasis is the
rvice data, that is carrying on inquiry, statistics, report output and so on. I n this article the student information management databa application system is mainly process-centric.
3.1.Functional Requirement Design
According to the evaluation content of students’ work under office and departmental target responsibility system, the student information management databa application system would have
functions such as brow, query, statistics, modification, report. Each function should be refined to adapt
can you dig itthe different demand.disregard
3.2.Overall Structural Design
According to the functional requirement of student information management databa application system, the overall structure of the application system could be indicated with the hierarchy chart, from the
top to down: Layer 1 is the system layer, Layer 2 is the function layer, Layer 3 for operation layer. Figure 1
is the overall structure of student information management databa application system.yields
1662H ui Zhou / P hysics Procedia 25 ( 2012 )1660 – 1665高一物理教材
3.3.Data Sheets and the Fields Design
According to the evaluation content of students’ work under office and departmental target responsibility system and the daily requirement of student job, it may design data sheets for the student basic situation, the development of party member, the pass percent of CET-4/6, double degree, postgraduate register and enrollment, reward and punishment and organization activity and so on. Each data sheets contain the corresponding fields, such as the student basic information sheet contains the fields named student I D, name, x, class, post, birthday, dormitory, dormitory telephone, family address, houhold telephone., poverty level, loan application, loan bank and so on.
上海化妆培训
3.4.Establishing Data Sheet Associations
After determined the sheets and the fields in the databa, it is needed to establish the associations between the data sheets, to facilitate the multi-sheet query. According to corresponding associations recorded between the data sheets, the data sheet associations can be divided into three kinds, namely one-to-one associations, one-to-many associations and many-to-many associations. Regarding to many-to-many associations it can u the third table to its transform itlf to two one-to-one associations.
3.5.Code Design
关于圣诞节的英语手抄报
Visual Poxpro introduces the object-oriented programming (OOP), which is a kind of machine language which bad on information hiding, abstract data types and other ideas. Using three elements of Object Property, Event, Method, the framework of the program module is established by creating visual components. When designing programs, the main consideration is how to create objects and u objects to simplify programs.
System layer
Figure 1. the Overall Structure of Student Information Management Databa Application System
H ui Zhou / P hysics Procedia 25 ( 2012 )1660 – 1665 1663
4.Example of Student Information Management Databa Application System for Office and Departmental Target Responsibility System
Combining the contents of the student performance review for office and departmental target responsibility system in Wuhan University of Technology and the need of student information processing,
we design the student information management databa application system by Visual Foxpro6.0 databa management system.
4.1.Establishing the Project of the Student Information Management Databa Application System
The project supervisor is the central console in Visual Foxpro for managing the data and each kind of
module in Visual Foxpro ,which not only can divide the organization according to the type of documents ,facility
but also directly establish and edit each kind of documents, finally compile to the application programs and
the execution documents which we need .Therefore, while designing the student information management databa application system, first, we establish the project document (the .pjx document) of the student information management databa application system through the new- built order in the Visual Foxpro.
After opening the project supervisor, we establish the student information management the databa file
英语字母书写格式(the .dbc document), in order to concentrates various sheet documents in the databa file to carry on the operation management.
4.2.Establishing Databa Sheet Documents and Associations
According to the evaluation content of students’ work under office and departmental target responsib
ility system, we establish databa sheet document (the .dbf document) with the filename of the
student basic situation, the development of party member, the pass percent of CET-4/6, double degree, postgraduate register and enrollment, reward and punishment and organization activity and so on and
design databa sheet structure through sheet designer ,in which including field name, field type, field length, index, valid rule, trigger and so on. Taking the basic information of students as the example, its
letter是什么意思
sheet structure e Table I, where taking student I D as primary index, name, x, class, dormitory as ordinary index, the x valid rule is “the x = “male” or x = “female”. Meanwhile, it establishes that the associations between various sheets taking student ID as the key word is one-to-one associations.
4.3.Creating Form
In order to establish friendly ur interface and enable the ur gets WYSIWYG editor of human-computer interaction effect, we must design ur-friendly form controls using the form designer .Acc
ording to actual need, the realization of function layer in student information management databa application system is all designed in host form main.scx document, while the management lay is realized by many sub-form document, and the connection between the host form and the sub-form is realized through the command button in host form. The order ntence that transferring the sub-form
using the command button is:
do form < sub-form filename .scx>.
4.4.Creating Report
The printout is a basic function for student information management databa application system,
which can be realized through the Visual Foxpro report form designer and the correlation order. Considering the actual demand is different, we can divide the printout report form into three report form
1664H ui Zhou / P hysics Procedia 25 ( 2012 )1660 – 1665
output: the form printing, the grouping printing and the multi-fences prints, in which by clicking different output button, it would appear the corresponding printing choice form.
4.5.Establishing Event Program
The object of Visual FoxPro has three esntial factors: Property, Event and Method. The program execution us the event to actuate. The smallest event collection in Visual Foxpro is Init (when creating object), Destroy (when releasing object) and Error (when run error occurs).When an event occurs, it will cau the execution of certain function program. Visual Foxpro has powerful t of command statements
and functions, meanwhile the data definition of structured query language SQL, the data query and the data operation function, which is convenient for the programming work. Establishing the corresponding disposal procedure regarding the event is also an important work of designing the student information management databa application system.
TABLE I S TUDENTS’B ASIC I NFORMATION S HEET S TRUCTURE
Field Name Student ID Name Sex Class Post Birthday
Dormitory Field Type C C C C C D C Field Length 9 6 2 10 12 8 5
Field Name Dormitory
Telephone
Family
Address
Houhold
达利通留学
Telephone
Poverty
Level
Loan
Application
Loan Bank
Field Type N C N C L C
Field Length 8 40 11 4 1 4
4.6.Generating Applications
After having created documents, databa, sheet, form, report, realized the connection between the objects, and established the event program, it can carry on the compilation and connection to all documents using the project supervisor to get applications. Before getting the application, firstly, we should establish the master control program document as the entrance the application. its main function and order procedure are: initializes application operating environment, display initial ur interface (host form), cleans up the environment when control event circulation and quit.
After choosing project supervisor to compile executable program of the dialog box, retranslate all documents and get them determined, Visual Foxpro then produces executable file of the student information management databa application system “student information management databa application system .EXE”. When duplicating VFP6R.DLL and VFP6RENU.DLL of Visual Foxpro in unified catalogue of the execution file, the execution file then can be carried out under the Windows window, parated from Visual the Foxpro environment Initial surface of the execution of the file as shown in Figure 2.
5.Conclusion
The basic goal of designing student information management databa system is the databa application system that is directed towards the evaluation content of students’ work under office and departmental target responsibility system. I n order to implement the function of student information management, we designed the functional requirement, overall structure, data sheets and fields, data sheet Association and software codes in this paper. Combining the contents of the student performance review for office and departmental target responsibility system in Wuhan University of Technology and the need of student information processing, we designed the student information management databa application system by Visual Foxpro6.0 databa management system.