Data Dictionary
The following are the details of the Tables based on which this Application works.
1.Login
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.
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.