Table Description page 2

Expert :

Our Expert table will register the institute or university Expert administrator. This Manage Expert form can access only the controller. This module contain the information about expert like his name & expert in which course.

Subjective Question Attempted :

In this SubQAttempted table will have iSubQAId , iStuId, iSubQusId, And tAns. iStuId will be the foreign key for the table Student.

Objective Question Attempted :

ObjQAttempted table will have iObjQAId, iStuId, iObjQusId, And cAns. iStuId will be the foreign key for the table Student.

Course :

In the course table contains the information about the iCouId,cCouName, iSemester and the iProId. Here the iCouId is the primary key.

Program :

This program table contains the information about the like course iProgId, cProgName, and the iFessof the program. Here the iProgId is the primary key.

Normalization:

Our Database “OnLEDB” is normalized up to 3 NF.

From starting our Database has been designed while strictly keeping in mind the concept of Normalization and their positive effect on the complete output product, so we have kept the tables normalized from the scratch. It means our tables are completely normalized with no unwanted redundancy. And so we need not to normalize it further.

NEXT Chapter 17 Data Integrity Design