Data Definitions and Algorithms, Essay Example

1. The surveys consist of a series of multiple choice questions.

• Data Layer

Questions Table

ID, Auto Increment Integer

Question, String

2. The surveys are presented on the SRG Web site.

• Presentation Layer: Radio Button Lists

3. The survey application must be able to store the survey questions and results in memory on the Web server.

• Application Layer Algorithm

On Submit

Get responses from Radio Button Lists

Insert responses into Data Table

• Data Layer

Data Table

Data ID, Auto incremented Integer

Question, Indexed to Question Table Question ID

Response, Integer

4. The questions are grouped into a collection of survey groups that include client information and a variety of statistical results for the survey (each statistical result is represented by a title and single floating point number).

Data Layer

• Survey Table

Survey ID, Primary Key

Client, String

Questions, Indexed to Question ID, one-to-many

Status, Integer

• Results Table

Results ID, Indexed to Questions Table, one-to-one

Stats, Indexed to Stats Table, one-to-many

• Stats Table

Stat ID, Auto Increment

Question ID, Indexed to Results Table Results ID, one-to-one

Stat Type, String

Stat, Long Float

• Application Layer Algorithm

Get Data for Each Question

Calculate necessary Stats

Insert Results into Stats Table

5. SRG needs to track the status of surveys. The surveys are provided on the SRG Web site one at a time, in first-come, first-served order, and the status includes position in the waiting line and identification of the survey.

• Application Layer Algorithm

Count or Calculate Queue Position

Insert Into Survey Table Status