Scribd
Upload
8 views2 pages

User Registration Table Design

The document describes the structure of 5 database tables used in a student exam application. The User Registration Table stores user profile information. The Administrator Table stores credentials for admin users. The Question Paper Table stores exam questions and answers. The Result Table stores exam results by student username, ID, email, college, and marks obtained. Each table column name, data type, allowed null values, and description are specified.

Uploaded by

jaikumar_22
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
8 views2 pages

User Registration Table Design

The document describes the structure of 5 database tables used in a student exam application. The User Registration Table stores user profile information. The Administrator Table stores credentials for admin users. The Question Paper Table stores exam questions and answers. The Result Table stores exam results by student username, ID, email, college, and marks obtained. Each table column name, data type, allowed null values, and description are specified.

Uploaded by

jaikumar_22
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Database Tables:

User Registration Table Column Name Data Type Username varchar(50) Emailid varchar(50) Password varchar(50) Securityques varchar(50) Securityans varchar(50) Gender varchar(50) Qualification varchar(50) Clgname varchar(50) Imgname varmax(50) Imgpath varmax(50) Status varchar(50) Studentid varchar(50) Allow Nulls No No No No No No No No No No No No Description
Represents user name Represents email id Represents password Represents security ques Represents security ans Represents gender Represents qualification Represents college name Represent image name Represent image path Represent user status Represent student id

Administrator Table Column Name Userid Password Data Type varchar(50) varchar(50) Allow Nulls No No Description
Represents administrator Id
Represents administrator password

Question Paper Table Column Name Data Type PaperId varchar(50) Question varchar(50) Opt1 varchar(50) Opt2 varchar(50) Opt3 varchar(50) Opt4 varchar(50) Ans varchar(50)

Allow Nulls No No No No No No No

Description
Represents Ques paper Id Represents Question Represents first option Represents second option Represents third option Represents fourth option Represents Answer

Result Table Column Name Username Studentid Emailid Clgname Obtmarks Data Type varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) Allow Nulls No No No No No Description
Represents User name Represents Student Id Represents User Email Id Represents User College name Represents Obtained Marks

You might also like