"Network Test System" (PHP, ExtJS) for curriculum design

1.TestSystem approximate structural block diagram

2. Database design (11 sheets)

Database name: Db_testsystem

Database tables:

Tb_admin record Question Bank Administrator account information

Code

Tb_allcontent record the contents of a randomly extracted topic

Code

Tb_answer record the answers to the candidates ' responses

Code

Tb_paper records randomly generated papers

Code

Tb_parameter to record additional information such as IP and account of customer login

Code

Tb_record record the types and quantity of each topic

Code

Tb_selfanswer record the answer to a candidate's self-test

Code

Tb_student Record candidate account information

Code

Tb_style Record Topic types

Code

Tb_teacher Record Change teacher account information

Code

Tb_testpaper record randomly generated test paper content

Code

3. General arrangement and management of documents

Testsystem---admin (question Bank Management)---add_admin---add_admin.js extjs interface

---delete_admin.php delete

---read_admin.php read

---search_adm_login.php Search account

---search_adm_name.php Search name

---update_admin.php Update account information

---add_student--....

---add_style---....

---bar.gif

---charts.js

---charts.swf

---add_teacher---....

---add_homepage---show_admin.php

---show_rules.html

---insert---....

---new_paper---....

---old_paper---....

---add_admin.php

---add_student.php

---add_style.php

---add_style_number.php

---add_teacher.php

---admin.js

---homepage.php

---insert.php

---new_paper.php

---old_paper.php

---login (login)---....

---public (common library)---ext

---pictures

---add_pictures.css icons, etc.

---pagingmemoryproxy.js extjs disposable page

---rowexpander.js topics show expanded use

---slidertip.js slide for paging

---slidingpager.js slide for paging

---register (registration)---...

---student (exam)---....

---student_self (self test)---....

---teacher (change to roll)---....

---admin.php

---login.html

---register.php

---student.php

---student_self

---teacher

4. System operation and function

5. Summary of the Experience

5.1 Design is very important in the whole system formation.

5.2 Unification in naming norms

5.3 When designing the system, we should learn to design and encode it in the form of interface, business, database operation and database.

6. Deficiencies

6.1 Because the curriculum design is oneself set the demand for oneself, the grasp degree is not good enough.

6.2 Database design is not good enough, too many contacts

6.3 Design of the overall idea is not clear enough, not fully grasp

6.4 Do not know how to set up the corresponding model for each function module

6.5 Myself too lazy, the course design end period, the refactoring of the lazy refactoring, the database that set up the trigger place lazy to build, the establishment of the storage process is too lazy to do.

7. Sentiment

7.1 When working with people, we have to admit that everyone has Sui

7.2 Avenue to Jane's truth should be well understood

7.3 The importance of model building affects the direction of future development

From:http://www.cnblogs.com/yongfeng/archive/2010/05/23/1742076.html

Network Exam system for Course design (PHP, ExtJS)