Developing test database and online examination system with ASP (3)

Four, detailed design

4. 1. The design of the question (objective question part)

In the past exams, the judgment question often is by the painting "╳", "" to judge, and the single choice is often in the four alternative answers a, B, C, D to choose the only correct answer; In addition, multiple-choice topics are fundamentally no different from single choice, but the answer and standard answers are more. Therefore, the system involved in the single selection and multiple-choice in general the same as in the past, the main difference is that the problem is cleverly converted to a single choice of only two options, and the assumption that more than one topic is generally more than six alternative answers, the standard answer at least. Therefore, the design of the sample questions are as follows:

-->: The transmitter is also called Repeater: (A) Wrong (B)

Single selection--> such as: Hub refers to: (A) Network Bridge (B) hub (C) gateway (D) router

Multiple choice--> such as; network protocols used on the Internet are: (A) ipx/spx Compatibility Protocol (B) TCP/IP protocol (C) NetBEUI Protocol (D) X.25 Protocol (E) ATM LAN emulation user (F) Fast Infrared Protocol

4. 2. Database design

4. 2. 1. Question Structure

Usually, each type of question should have a table structure. However, considering the current system storage space has not been limited by physical space. Therefore, we use the subject rather than the question type scheme to build the data table, not all the subjects of all the questions together, but each objective question has six alternative answer items, there is a table to record the relevant attributes of the data table of each account. In this way, the query is more convenient, may save time, and will not cause the data is very messy and so on. Detailed design is shown in the following table:

Description
1. According to the subject (generally 1 semester as the standard) to define each table, the table name is the Chinese characters Pinyin first letter composition. For example, software engineering---RJGC, computer network---JSJWL, mathematics---in the second grade of primary school XXENJSQSX

2. The field name refers to the Chinese name of the field

3. The character mark generally by the Chinese name Pinyin first letter composition, the foreign key field best and the primary table corresponding field has the same name

4. If the field is a character type, then the corresponding length column to fill the maximum allowable length, if the fixed length is added ' fixed ' word

5. If the field can be empty, the corresponding null column fill y, otherwise do not fill

6. If the field is the primary key, then the corresponding main key column fill Y, otherwise do not fill
　　
Account Data Information table

Field moniker identification type length NULL primary key description
Subject Chinese name Kmmc CHAR 50 in Chinese, such as "Computer network"
The Account table name KMBM CHAR Y is composed of the first letter of Chinese phonetic Alphabet above, such as "JSJWL"
operator LRZ CHAR 15 defaults to entry login account
Input date Lr_date Date 10 defaults to the system dates at the time of entry
Note MEMO CHAR Y