Data Dictionary

 

The following are the details of the Tables based on which this Application works.

1.Login
This Table responsible for storing of all the user information both Instructor and Student, UserID Field is the Primary Key, Instructor is a Boolean Field (True/False) if True then user is Instructor else He is a Student.

Sno

Field Name

Data Type

Constraints

1.

2.

3.

4.

5.

User ID

First Name

Last Name

Password

Instructor

Text(10)

Text(20)

Text(20)

Text(10)

Boolean

Primary Key

Not Null

Not Null

Not Null

Not Null

 

2.Test_Assign

This Table is used to keep all Assigned Test Information of the Students, it has a Composite Key (more than one Primary key) of UserID, Test_Name and File_Path, UserID refers to UserID of login Table having a One to Many relation.
E_date Field holds the Expire Date of the Test.

Attempt Field shows wether the Student has attempted the Test or not if True then Score_p Field has the percentage he scored and A_date stores the date when attempted the Test.

Sno

Field Name

Data Type

Constraints

1.

2.

3.

4.

5.

6.

7.

User ID

Test_Name

File_Path

Attempt

Score_p

E_date

A_date

Text(10)

Text(50)

Text(50)

Boolean

Integer

Date

Date

Primary Key

Primary Key

Primary Key

 

Not Null

 

 

 

3.Q_bank

This is the actual Question Bank Table which holds all the Questions and their optional answers and also the correct answer, the Type Field holds information about the type of question Multiple choice or True/False.

 

Sno

Field Name

Data Type

Constraints

1.

2.

3.

4.

5.

6.

7.

8.

Q_ID

Question

Type

OptA

OptB

OptC

OptD

Answer

Integer

Text(250)

Text(1)

Text(100)

Text(100)

Text(100)

Text(100)

Text(1)

Primary Key

Not Null

Not Null

Not Null

Not Null

 

Not Null

 

 

 

4.Test Paper Table

When we intend to create a new Test Paper based on a Question Bank the this Table is dynamically created a stores the information about the Test.
Q_ID is the Primary Key and also refers to Q_ID of Q_Bank Table, this is a One to One relationship.
Time Field is the time in seconds allotted for that particular Question, P_mark is Positive marks and N_mark is the Negative marks awarded for that Question.

Sno

Field Name

Data Type

Constraints

1.

2.

3.

4.

Q_ID

Time

P_mark

N_mark

Integer

Integer

Integer

Integer

Primary Key

Not Null

 

5.All_Test

This Table gets a row each time we create a Test Paper, having details of that Test Paper like Date of creation, UserID of the creator and the Pass Percentage (PP). UserID refers to UserID of login Table having a One to Many relationship.

Sno

Field Name

Data Type

Constraints

1.

2.

3.

4.

Test_Name

Date

User_ID

PP

Text(50)

Date

Text(10)

Integer

Primary Key

Not Null

Foreign Key

Not Null

 

 

 

 

 

 

Description

 

A brief description of how the Application runs its features and options are listed below.

Sample Instructor

User ID : SYSTEM Password : 123456

Sample Student

User ID : ssi Password : 123456

The first form that pops up is the Login Form it asks of a UserID and a Password.
There a two modes in which a user can log in, An Instructor Mode or A Student Mode.

Instructor Mode

The Test Creator Form has a number options for creating the Test Paper.

 

Once the Test Paper has been created, the Instructor now needs to Assign this test to Students using Test Assignor.

 

Instructors can create New Student Logins using User ID manager.

 



Student Mode


If the user has a valid Student ID and Password then he logs in as a Student.
All the test that have been assigned to him appear in combo box and by selecting the name and clicking the Start Test button the Student can start the test.

 

 

 

The Test Paper Form gives all the Information to about the test to the User


Reports

Reports are summarized information in a well-formatted manner meant for higher managerial levels to help them in Decision-making.

The current Application creates a total of four such reports.
1. Test Result Report.
2. Student Report.
3. Instructor Report.
4. Test Report.

  1. Test Result Report.
  2. This Report is created as soon as the student completes the Test, it gives information about what question did the Student attempt and the Positive or Negative marks scored and did the Student Pass of Fail In the Test.

  3. Student Report.
    This report gives the over all Performance of a student, how many test did he attempt, date when he took the test, what percentage he scored in each and finally his Average Score. This Report can be generated from the Test Creator Report menu Report>Student Report.
  4. Instructor Report.
    This Report give the details of a particular Instructor, the total number of test he created, the average score of the student in each test. This Report can be generated from the Test Creator Report menu Report>Instructor Report.
  5. Test Report.
    This Report gives the details of a particular Test, the total number of students who took the test, the average score of the all student. This Report can be generated from the Test Creator Report menu Report>Test Report.