Management system design report

System design: management 0702 XXX

Manage 0702 XXX

Guan Jing 070 1 XXX

Lecturer: XXX

catalogue

Preface 3

The first chapter system overview 3

1. 1 status description 3

1. 1. 1 related functional organization chart 3

1.2. 1 The business flow chart of the current system is as follows: 4.

1.2 system objective 5

Overall goal 5

Specific objectives: 5

1.2.3 innovation goal: 5

1.3 system development method 6

1.4 Development Plan 6

Chapter II System Analysis 7

2. 1 system requirements 7

2. 1. 1 Brief introduction of functional requirements: 7

2. 1.2 Description of functional requirements: 7

2.2 Data Dictionary 7

2.2. 1 related ER design 8

2.3 System Test Plan 8

Chapter III System Design 9

3. 1 code design 9

3. 1. 1 code design principle 9

3. 1. 1 check code calculation formula 9

3.2 Database Design 9

3.2. 1 overall database structure 9

Security design of database

3.3 Input and output design 10

3.3. 1 output design

3.3.2 Output content 10

3.4 output mode 10

Output devices and media 10

3.4.2 Input design 1 1

3.5 module test plan 1 1

The fourth chapter system code and pictures 1 1

4. 1 homepage code 1 1

4.2 Building Management Page Code 14

4.3 Vacancy information management code 15

4.4 User information management code 18

Chapter V Division of Tasks 2 1

Chapter VI Harvest and Perception 2 1

order

In this course design of dynamic service homepage, the design topic we undertake is the analysis and design of student apartment management system of Xi Youshi University. This paper introduces the present situation of student apartment management in our school and the system objectives and requirements analysis, focusing on the implementation process of student apartment management system, including system requirements analysis, system investigation, business process analysis, data flow analysis, function design, database design, system physical configuration scheme, system implementation, system testing and debugging. The main functions of this system include user login, dormitory information input, student information input, school professional information input, class, functional requirements description, database design and so on.

The first chapter is an overview of the system

1. 1 status description

1. 1. 1 organization chart of relevant functions

The informatization of colleges and universities can not be separated from the informatization of dormitory management, and the problems such as enrollment expansion, wide source of students and multi-campus management are outstanding. After investigation, the organizational structure and functions of the current system are as follows:

1.2. 1 The business flow chart of the current system is as follows:

1.2 system objectives

1.2. 1 overall goal: to effectively help the informationization of student apartment building management in our school.

1.2.2 specific objectives:

1. Administrators can easily add, modify, delete and query information;

2. Teachers, students and administrators can access the information within their own authority and modify it in time;

3. Simplify the flow of the existing system to make it more convenient, reasonable and easy to operate;

1.2.3 innovation goal:

1. Realize paperless management as much as possible, and provide the function of submitting reexamination applications online;

2. According to the operation difficulties of the administrator, carry out relevant multimedia navigation to realize the closed-loop teaching system as shown below:

Development method of 1.3 system

Explanation of abbreviations and terms

ASP Dynamic Service Home Page

HTML web design

ACCESS 2003 background database

Xiao AspWebServer fckeditor

DREAMWAVER web design software

1.4 development plan

1.4. 1, preliminary investigation

(1) Investigation methods: inquiry, field investigation, information search, etc.

(2) Investigation contents:

① Investigate the management information system of student apartment building in our school: general situation of organization, system objectives, system status, brief history, basic situation of personnel, existing problems and main difficulties, etc.

② Information demand: Understand the data to be processed by each functional organization, estimate the data generated by each organization, and investigate the information and information sources of internal and external environment.

③ Case study of information system analysis and design.

1.4.2, feasibility analysis

According to the preliminary investigation, we have the ability to write this system with the knowledge taught by the current teachers. This system

The running environment is simple, the goal is easy to achieve and the feasibility is high.

Chapter II System Analysis

2. 1 system requirements

2. 1. 1 Brief introduction of functional requirements:

The student apartment management system plays an extremely important role in strengthening the management of student dormitories in schools. Due to the expanding enrollment scale and the increasing number of students in colleges and universities, the traditional manual score management is not only heavy workload, but also prone to problems.

2. 1.2 Description of functional requirements:

1, user management function

Users are divided into three categories: administrators, teachers and students. Administrators, teachers and students all need to log in with user names and passwords.

2. According to students, administrators and teachers can see students' information and dormitory attendance. Student information includes basic information such as student number, name, class, birthday, gender, address and telephone number. When the administrator wants to view the information of a student, he can automatically display the information of the dormitory where the student is in this course, and at the same time display the attendance of the student's dormitory and other related information. In the dormitory information, teachers can add, modify and delete according to the facts, and can print reports. 3. Student score checking function

After the student user logs in, students can see their own student information and dormitory attendance information. Student information includes student number, name, class, birthday, gender, address, telephone number and other information. Attendance information includes attendance score information of student dormitory.

New system objectives:

For this system, we need to realize the following basic functions:

(1) Student query function: In order to facilitate students to query dormitory attendance and other information, all information is classified as required. In this way, students can easily find the information they need.

(2) Add function: The administrator can fill in the student's sign-in, dormitory attendance and other related information in the form. The system can automatically avoid duplicate information.

(3) Modify function: The administrator can modify the information in the database. The system can find out the information to be modified according to the conditions given by the administrator, save the modified information, and automatically find out whether it is duplicate information.

(4) Delete function: Administrators can delete data. The system can find out the information to be deleted according to the conditions given by the administrator, and prompt whether to delete it. If so, delete the relevant information from the database.

(5) Administrator query function: the administrator can query all information by conditional selection and sort it.

2.2 data dictionary

2.2. 1 student table

Project substantive review

The student number is unique and corresponds to each student.

Name of student

Gender male and female

Age, school days

Dormitory building no.1 student dormitory building

Sleeping beauty. No. Sleeping beauty. No. There is no dormitory for students in this project and dormitory. Determine a dormitory.

… … …

2.2.2 dormitory table

Project substantive review

Dormitory building no.1 student dormitory building

Sleeping beauty. No. Sleeping beauty. No. There is no dormitory for students in this project and dormitory. Determine a dormitory.

Attendance Score Daily Dormitory Attendance Status Table

… … …

Member list

Project substantive review

Members: students, teachers and administrators.

Member login account

Member login password

… … …

2.2. 1 related ER design

2.3 System Test Plan

1 & gt； hardware test

Detect whether the computer provides the corresponding configuration.

2> network testing

If it is a stand-alone environment, there is no need to detect the network; If it is running on a local area network or a wide area network, it is necessary to test the network equipment, and then carry out system testing together with the software and hardware: appearance inspection of the network equipment, hardware testing and network testing.

3> software testing

The system needs corresponding software to test.

4> unit test

Test each program list in the source program to verify whether each module meets the requirements of the system design specification.

5> assembly test

Combine the tested modules into subsystems, focusing on the interfaces and connections between the modules.

6> confirmation test

Check and accept the whole software, and check whether the software meets the requirements according to the system specifications.

7> system testing

Connect the software, hardware, network and other parts of the system to test the overall function and performance of the whole system.

Chapter III System Design

3. 1 code design

3. 1. 1 code design principles

Keyword data elements in the database usually have specific meanings in their codes, and if necessary, they also have check codes. For example, the middle school number code in the report consists of eight characters, the first four characters indicate the year of admission, and the last four are the serial numbers that increase in turn.

3. 1. 1 check code calculation formula

For each keyword code with check code, there must be a code design specification, and the calculation formula of check code can be the same or different.

3.2 Database design

3.2. 1 overall structure of the database

This system adopts relational database mode, so the database consists of several two-dimensional tables (data files), and each data file is designed as the third normal form. The name of the table is expressed by the first letter of the capital pinyin with practical significance, such as the student table:

Xsb

3.2.2 Database Security Design

1. Software system

The access account and password of the database management system are carefully and strictly set, the front-end operation is separated from the background data, and the system administrator account can only be used by the system administrator.

2. Programming aspect

According to the identity of the operator, the operating authority of the system is set, and the operating authority of each form is divided into five functions: adding, modifying, deleting, querying and printing. The operation authority can be set and maintained according to the identity of the operator.

3.3 Input and output design

Input-output design plays an important role in information system, because input-output is the interface between users and the system, and it is the two most closely related parts between users and the system, which is very important to ensure the convenience of users using the system and the safety and reliability of the future system.

When designing the system, the output design should be carried out first, and then the input design should be carried out, because the input information can only be determined according to the output requirements.

3.3. 1 output design

The purpose of output design is to enable the system to output useful information to meet the needs of users, and all kinds of management business and business decision information needed by users are completed by the output part of the system.

3.3.2 Output content

The main output contents are: student attendance report, dormitory status (whether full) and dormitory member status.

3.4 output mode

The system uses screen output and printer printout.

(1) The screen shows the information output on the display screen when students log in to the system to inquire about their grades. Users can let the system display the information through function buttons and input combination conditions. The advantage of this method is real-time, but the output information cannot be saved.

(2) When the printer outputs statistical analysis results, the output information needs to be stored for a long time or transmitted in a wider range, and the information will be printed and output.

3.4. 1 Output devices and media

The output devices of the system include display terminals, printers, etc. The medium is paper.

3.4.2 Input Design

The basic task of input design is to ensure that data is input into the system quickly and correctly.

This system uses keyboard input.

3.5 Module Test Plan

(1) Test content: After users with different identities log in to the system, verify their operating authority and inquire about students' grades.

(2) Progress: After the database table structure is designed, the corresponding test cases are designed and the corresponding module codes are tested immediately.

(3) Environment and equipment required for testing: The development version of this system is based on single WindowsXP, the background database is ACCESS 2003, and the testers are developers.

(4) Implement the test.

(5) generating a test report

The fourth chapter system code and picture

4. 1 home page code

& ltstyle type="text/css " >

& lt！ -

Text {

Background-image: URL ();

}

. STYLE6 {font-size: x-large}

. style 9 { font-size:xx-large； Color: # 0000FF}

-& gt；

& lt/style & gt；

& ltform id = " form 1 " name = " form 1 " method = " post " action = " " & gt；

& lttable width = " 102 1 " height = " 542 " border = " 0 " align = " center " cellspacing = " 0 " background = " Images/BAK _ CLOUDS。 JPG " >

& lttr & gt

& lttd height="324" colspan="7 " >& lttable width = " 469 " border = " 0 " align = " center " >

& lttr & gt

& lttd width = "459" height = "62" >< span class = "style9" > Xi Youshi University.

& lt/tr & gt；

& lttr & gt

& lttd height = "76" align = "right" >< span class = "style9" > apartment building information management system.

& lt/tr & gt；

& lt/table & gt； & lt/TD & gt；

& lt/tr & gt；

& lttr & gt

& lttd height = "36" colspan = "6" align = "center" >< span class = "style6" >< strong & gt User name:

& ltinput type = " text " name = " uid " size = " 14 "/>

& lt/span>。 & lt/TD & gt；

& lt/tr & gt；

& lttr & gt

& lttd height = "45" colspan = "6" align = "center" >< span class = "style6" >< strong & gt password:

& ltinput type = " password " name = " upwd " size = " 14 "/>

& lt/span>。 & lt/TD & gt；

& lt/tr & gt；

& lttr & gt

& lttd width="292" align="center " >？ & lt/TD & gt；

& ltTD width = " 157 " align = " center " >& ltspan class="STYLE6 " >& ltstrong & gt

& ltinput type = " radio " name = " rd " value = " administrator " checked/& gt；

administrative staff

& lttd width="204" align="center " >& ltspan class="STYLE6 " >& ltstrong & gt

& ltinput type = " radio " name = " rd " value = " student "/& gt。

student

& lttd width="229" align="center " >& ltspan class="STYLE6 " >& ltstrong & gt

& ltinput type = " radio " name = " rd " value = " building management "/& gt。

building control

& ltTD width = " 1 17 " height = " 44 " align = " center " >？ & lt/TD & gt；

& lt/tr & gt；

& lttr & gt

& ltTD height = " 90 " colspan = " 8 " align = " center " >& lttable width="292" border="0 " >

& lttr align="center " >

& ltTD width = " 186 " class = " style 6 " >& ltinput type = " submit " value = " log in " name = " log in "/& gt； & lt/TD & gt；

& ltTD width = " 10 " class = " style 6 " >？ & lt/TD & gt；

& lttd width="206" class="STYLE6 " >& lta href = " zhuce.asp " & gt& ltimg src = " Images/index _ BTN _ log in . gif " width = " 42 " height = " 22 " border = " 0 "/& gt； & lt/a & gt； & lt/TD & gt；

& lt/tr & gt；

& lt/table & gt；

& lt/TD & gt；

& lt/tr & gt；

& lt/table & gt；

& lt/form & gt；

& lt%

If required. form(" uid ")& lt； & gt ""and request. form(" upwd ")& lt； & gt ""So

Uid = request. Form ("uid")

Upwd = request. Table ("upwd")

Rd = request. Form ("R&D")

Set conn = server. CreateObject("adodb.connection ")

conn . open " provider = Microsoft . jet . oledb . 4.0； Data source = "& ampserver.mappath ("dormitory management.mdb ")

If rd= "Administrator", then

strsql = " select * from users where uid = " & amp； Uid & "and upwd =" & ampupwd & UTYPER =' "&R&D and marketing;"

response.write strsql

Set rs=conn.execute(strsql)

If rs.eof, then

response . write(" & lt； Div align = right & gt < font size = 6 color = red> User or password entered incorrectly! & lt/font & gt； & lt/div >；" )

other

Session ("uid")=uid

response . redirect(" guanliyuan . ASP ")

If ... it will be over.

Elseif rd= "student "and then

strsql = " select * from users where uid = " & amp； Uid & "and upwd =" & ampupwd & UTYPER =' "&R&D and marketing;"

response.write strsql

Set rs=conn.execute(strsql)

If rs.eof, then

response . write(" & lt； Div align = right & gt < font size = 6 color = red> User or password entered incorrectly! & lt/font & gt； & lt/div >；" )

other

Session ("uid")=uid

response.redirect("student.asp ")

If ... it will be over.

other

strsql = " select * from users where uid = " & amp； Uid & "and upwd =" & ampupwd & UTYPER =' "&R&D and marketing;"

Set rs=conn.execute(strsql)

If rs.eof, then

response . write(" & lt； Div align = right & gt < font size = 6 color = red> User or password entered incorrectly! & lt/font & gt； & lt/div >；" )

other

Session ("uid")=uid

Response.redirect ("Louguan _ index. ASP”)

If ... it will be over.

If ... it will be over.

If ... it will be over.

% & gt

4.2 Floor Management Page Code

& lt% @ LANGUAGE = " VBSCRIPT " code page = " 936 " % & gt；

& lt！ DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN " " http://www . w3 . org/TR/XHTML 1/DTD/XHTML 1-Transitional . DTD " & gt；

& lthtml xmlns = " http://www . w3 . org/ 1999/XHTML " & gt；

& lthead & gt

& ltmeta http-equiv = " Content-Type " Content = " text/html； charset=gb23 12" />

& lttitle & gt untitled document

& lt/head & gt；

& ltframeset border = " false " frame border = " 0 " frame spacing = " 0 " cols = " 15%，*，25% " & gt；

& ltframe name = " left " scrolling = " no " src = " left . ASP " target = " main " & gt；

& ltframe name = " middle " src = " middle . ASP " scrolling = " auto " & gt；

& ltframe name = " right " src = " right . ASP " scrolling = " no " & gt；

& lt/frameset & gt； & ltnoframes & gt& lt/no frames & gt；

& lt/html & gt；

4.3 vacancy information management code

& lt% @ LANGUAGE = " VBSCRIPT " code page = " 936 " % & gt；

& lt！ DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN " " http://www . w3 . org/TR/XHTML 1/DTD/XHTML 1-Transitional . DTD " & gt；

& lthtml xmlns = " http://www . w3 . org/ 1999/XHTML " & gt；

& lthead & gt

& ltmeta http-equiv = " Content-Type " Content = " text/html； charset=gb23 12" />

& lttitle & gt untitled document

& ltstyle type="text/css " >

& lt！ -

. style 1 { font-size:x-large }

. style 2 { font-size:medium； }

. STYLE3 {

Font size: xx- large;

Color: # 000000;

}

-& gt；

& lt/style & gt；

& lt/head & gt；

& ltbody & gt

& lt%

A dim connection

Set conn = server. CreateObject("adodb.connection ")

conn . open " provider = Microsoft . jet . oledb . 4.0； Data source = "& ampserver.mappath ("dormitory management.mdb ")

% & gt

& lttable width = " 999 " border = " 0 " align = " center " cell padding = " 0 " cell spacing = " 0 " bgcolor = " # 999999 " >

& lt！ -DWLayoutTable-& gt；

& lttr & gt

& ltTD width = " 192 " height = " 1 18 " bgcolor = " # add 1EB " >？ & lt/TD & gt；

& ltTD width = " 807 " bgcolor = " # add 1EB " >？ & lt/TD & gt；

& lt/tr & gt；

& lttr & gt

& lttd height = "788" bgcolor = "# add1EB" > & ltpclass = "style1"> user management.

& ltp class="STYLE2 "> user information

& ltp class="STYLE 1 "> housework management

& ltp> Housing Transfer Management

& ltp & gt& lta href="d.asp" target="_top">。 Vacancy inquiry

& ltp> Registration Inquiry

& ltp> personnel statistics

& ltp class="STYLE 1 "> apartment building management

& ltp> room statistics

& ltp> room inquiry

& ltp class="STYLE 1 "> equipment management in computer room

& ltp> room facilities inquiry

& ltp> public property damage query

& lttdalign = "center" valign = "top" background = "images/bak _ cloud. JPG ">& ltp class="STYLE3" > User information management

& lt form & gt

& ltspan class="STYLE 1 "> building number:

& lt label & gt

& ltselect name = " select " & gt