Using ASP to do an online survey (1)

On the online survey you will not be unfamiliar with it, give a question and several answers, let users fill out, and then save the results to the database, automatic statistics, and finally give a statistical figure. This period of learning to do with me to do an online survey system.

First, the function design

This simple system also needs to do functional design? Some people may feel strange, but anyway, regardless of how the system, the first functional design can always have a comparative understanding of the system. Let's take a look at the function of the online survey. The basic function has already said, is to give a question and several answers, then statistics, finally gives the graph. On this basis, we can consider adding a time period (validity period) to a survey, in which the investigation is effective, and after that time, the survey is automatically concluded. In addition, we can specify that a user can submit only one answer at a time. If you want to limit more, you can assign an IP can only submit an answer once, however, this may be a person in the Internet café can only have one submitted. Some of the problems in the survey may be a single choice, and some may be multiple-choice. Finally, the statistics chart, in the statistical chart to give the answer, the number of votes for each answer, and to show the number of votes in each answer percentage. The general use of horizontal map on it, but also relatively easy to achieve, of course, if you want to change to vertical, you can.

Now based on the above summary of the online survey functions are as follows:

1, the data is kept in ACCESS 2000 database;

2. One visit per user can vote once

3, give the statistics of each survey, with a statistical map to show

4, each investigation has an expiration date, automatically end after expiration. The completed survey can only view the results.

5, the administrator can increase the investigation, modify the investigation of the answer (add, modify, delete, modify type).

6. For the completed investigation, the administrator can only delete the investigation, but not the answer.

7, only one administrator (single user)