求助：一篇关于管理信息系统的英文文献及翻译

Question

马上就要交论文了，现在就还差一篇英文文献及翻译，所涉及的领域是关于管理信息系统的，小弟才疏学浅，找不到相关英文文献，恳请各位帮帮忙，小弟的积分全部奉上了~可以发到我的邮箱里：190739218@qq.com,我会第一时间查看的~先谢过了~

Answer 1

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

参考资料：www.gnnu.cn/jpkc/xxxt/down/6-2-2.doc