关于教务管理系统外文文献的论文

【英文题名】 The Design and Development of the Students' Information Management System 【【关键词】 学生信息管理; 面向对象; 数据库设计; 【英文关键词】 Student's Information Management; Object-Oriented; Database design; 【中文摘要】 近年来,我国中等职业教育迎来了蓬勃发展的新局面,各中等职业学校大量扩招新生,伴随着这种形势,学校教学管理负担越来越重。建立高性能的学生信息管理系统能够极大的提高学生信息管理的效率。本文用面向对象技术来分析和设计学生信息管理系统,较好地解决了学生管理信息的分散采集、综合利用、统一管理、资源共享等问题。 全文共分七个章节:第一章就学生信息管理系统的现状和主要特征进行了阐述;第二章对系统相理论和技术支持进行了说明,简要介绍了面向对象技术、管理信息系统、ADO(Active Data objects)与SQL Server 2000(数据库管理系统);第三章对系统总体设计进行阐述,主要涉及系统总体结构、系统功能模块设计、系统运行环境、系统开发工具和平台;第四章介绍系统数据库设计,依据对学生信息管理系统需求的分析,设计出系统用户表、学生档案信息表、缴纳学费信息表等8个表;第五章为学生信息管理系统开发实践与主要技术分析,主要介绍ADO,配置SQL Server与ODBC的连接,公用模块的创建,并以学生档案的添加、修改和查询为例来论证技术是如何实现的;第六章是系统测试;第七章对全文进行小结。 这套基... 【英文摘要】 Recently, the education of the secondary schools has had a complexion with the schools' enrolling large amount of freshmen. The establishment of high-efficient students' information system has been an indispensable part in secondary schools' management. It will help to increase efficiency in paper mainly analyzes the target's technology and explains the design of the students' information management system. So that it can solve such problems as scattering and gathering data, comprehensive uti... 抱歉阿，只能搜到这么多了

Needs analysis System Target Library management information system is a typical management information system (MIS), including the development of the main background of the establishment and maintenance of database and application development front-end aspects. The former requirement for data consistency and integrity to build strong. Good library of data security. For applications which require full-featured and easy to use and so on. System development to achieve the overall task is to systematize all kinds of information, standardization and automation. Requirements definition As a student of library management system requirements are: 1. According to a variety of ways (such as title, number, author) for the situation of the library collection. 2. The ability to easily borrow books, renew books, the return of books. 3. Be able to query their own data, the situation to borrow books. 4. To familiarize themselves with the use of library management system. As librarians, their library management system requirements are: 1. To facilitate the entry of the registration books, write-off old books. 2. To facilitate the registration of new students, or students who have graduated write-off information (basic information, loan information). 3. Can be released at any time such as the extended college students to borrow books, the Museum's collection, the use of information, etc., so that college students can be kept informed of some of our library information. Function Description System analysis is the overall development of the system based on the completion of tasks. The system needs to be done mainly in the function of Part 5: A basic book of the entry, modify, delete and other basic operations. 1. Standard categories of books, types of information input, including the type of number, category name, keyword, Remarks information. 2. Type of information query book, modify, including the type of number, category name, keyword, Remarks information. 3. Importation of books information, including the book number, book title, book type, author name, publishing the name, date of publication, book pages, keyword, date of registration, information, etc. Note. B for a library card module. 1. New Life for a library card. 2. For the loss of library card. C library functions to achieve. 1. Enter the library information, including library information number, study number, the reader name, book number, book name, date library, information, etc. Note. 2. Library information inquiries, changes of information, including library code, the reader ID, the reader name, book number, book name, date library, information, etc. Note. D realization of the book also features. 1. Enter the book information, including information code book, the reader ID, the reader name, book number, book name, date library, Date Book, Note information. 2. Book of the query and modify information, including information on book number, study number, the reader name, book number, book name, date library, Date Book, Note information. E can make it easier to carry out inquiries on the books. The case of extended automatically given message. Performance requirements The accuracy, reliability, efficiency, integrity, easy to use, maintainability, test line, reusability, security, confidentiality, understandable, and portability, connectivity. Operational flow chart (as follows:) Database design 1. Database Needs Analysis A concrete manifestation of the needs of users in a variety of information, storage, update and query, which requires the database structure to fully meet a variety of output and input information. Basic data collection, data structure to deal with the process, the composition of a detailed data dictionary for the specific design of the back to lay the groundwork. Books for the general demand for management information systems, library management through the contents of the working process and data flow analysis, design as shown in the following data items and data structures: ● the type of information the reader, Attributes: the type of number, type the name of the number of library, library period, the expiry date Remarks. Primary key: the type of number ● reader information Attributes: ID readers, and readers the names of the types of readers, readers of gender, work unit, home address, telephone number, e-mail address, date processing, Remarks. Primary key: the reader code ● books categories information Attributes: type of number, category name, keyword, Remarks information. Primary Key: Type Number ● book information, Attributes: number of books, book title, book type, author name, publishing the name, date of publication, book pages, keyword, date of registration, Remarks information. Primary key: number of books ● loan information, Attribute: Lending information ID, the reader ID, the reader name, book number, book name, date library, Date Book, Note information. Primary Key: Loan Information Number First, the system through the investigation and feasibility analysis, data flow diagram to draw the system: Basic information input basic information input D1 D2 Basic information input basic information input D3 D4 D5 Lending Information Entry Information the reader to return information back to books Data Dictionary (Data Dictionary). 1, data flow, for example the DD table is as follows: Data Flow System name: library management code: Entry Name: readers alias information: Source: reader registration place: D3 Data flow structure: Reader registration number + = (readers readers readers name + gender + work + ... ...) A brief description: Amend the record: the preparation of the date of Audit Date 2, data elements, for example the DD table is as follows: Data elements System name: library management code Entry name: reader ID alias Data streams are: Registration of Storage readers Office: D3 readers information table Data element value: Code type: Character Width: 10 The scope and meaning of values: A brief description: Every reader has a unique ID Amend the record: the preparation of the date of Audit Date 3, data storage, for example the DD table is as follows: Data Storage System name: library management code: D4 Entry Name: Books table alias: Storage organizations: the number of records: about 3000 the main keyword: number of books The amount of data: about 500KB Des keywords: Main Index by Number Record consists of: Field Name: ID books books books the author name ... ... Keywords ... Width: 8 ... 14 32 ... 10 ... A brief description: Amend the record: the preparation of: Date: Audit: Date: 4, data processing, for example the DD table is as follows: Data processing System name: library management code: Entry Name: Loan information alias entry: Input: loan number, the reader ID ... Output: borrow the basic attributes of information table Processing logic: dabase loan information is stored in a database table borrowinfo A brief description: enter a reader's borrowing record books Amend the record: the preparation of: Date: Audit: Date: 2. The concept of the structural design of the database This procedure, including the entities are as follows: Type of information entities readers, and readers of information entities, information entities, categories of books, books of information entities, information entities borrow. The relationship between entities E-R diagram 3. Logical structure of the database design ⑴ basic information table books Book: Field Name Data Type Field Description ISBN bookid save text Save the text of the title bookname booktype text book type of preservation Save the text save bookauthor author of the book Save the text of the book bookpub Press bookpubdate date / time to preserve the book's publication date Digital Preservation bookpages book pages text keyword bookkeyword bookindate date / time storage time whether the loan putup text Remarks Remarks bookmemo ⑵ library card information form (the reader information table) reader: Field Name Data Type Field Description Save the text readers readerno No. readername text) to preserve the names of the readers readersex text) to preserve the reader sex Save the text readers readertype categories Save the text readers readerdep department address preservation of the text addresses the reader Phone text readers readertel Save email text to preserve the reader's e-mail address checkdate Date / Time Loan Date Remarks Remarks readermemo ⑶ Lending Information Table borrowinfo: Field Name Data Type Field Description Loan No. borrowno save text text reader readerid Save ID Save the text readername borrow names borrowdate Date / Time Save Loan Date returndate date / time to preserve the date book memo Remarks Remarks Category ⑷ table books booktype: Field Name Data Type Field Description Save the text books booktypeno words Type the name of the text preserved typename texdisk should be used RAID (RAID 01) 4. In order to preveaddress. Second, the server should be equipped with software a) Operating System: Microsoft Windows 2000 server or Microsoft Windows 2000 Advanced server b) Database: Microsoft SQL Server 2000 (Simplified Chinese) c) the server must use a specialized firewall and anti-virus software. d) In addition to running the procedure must be equipped with outside the recommendations of the server has nothing to do as much as possible not to install additional procedures, procedures to reduce the confusion or conflict in the accident process. e) each department as far as possible a unified operating system. (Windows 9x series, or Windows 2000 series). Management software to avoid them because of the inconsistent versions of the operating system overhead caused by too much. f) each department must also install the machine anti-virus software and firewalls. To prevent the worm on the network throughout the network within the scope of the spread. g) if you want to print more involved in field reports, should be