NEXT Chapter 17 Data Integrity Design

Student

Primary key – iStuId

Alternate key – cENo, cFName, cLName, cProgram, iStudyCenCode, vLoginName,

vPasswd

Foreign key –iCouId (for Student table)

Course

Primary key – iCouId

Alternate key – CouCode, CouName, iSemester

Foreign key –iCouId(for Course table)

ExamDept

Primary key – iUserId

Alternate key – vLoginName, vPasswde

Expert

Primary key – iExId

Alternate key – cFName, cLname, cCourse, vLoginName, vPasswd

ObjQAttempted

Primary key – iObjQAId

Alternate key – cAns

Foreign key –iObjQusId (for ObjQAttempted table)

ObjQus

Primary key – iObjQusId

Alternate key – tObjQus, cOptionA, cOptionB, cOptionC, cOptionD, cAns, CStatus

Foreign key –iExpertId (for Expert table)

Program

Primary key – iProgId

Alternate key – cProgName, cDuration, iFess

Result

Primary key – iResultId

Alternate key – iMarkOfSub, iMarkOfObj, bStatus

Foreign key– iStuId(for result table )

Schedule

Primary key – iSchId

Alternate key – dtSDate

Foreign key– iStuId(for Schedule table)

SubQAttempted

Primary key – iSubQAId

Alternate key –tAns

SubQus

Primary key – iSubQusId

Foreign key –iSubQusId(for SubQAttempted table)

Alternate key – tQus,tAns, iMaxMarks, cStatus

Foreign key –iExpertId(for SubQus table)

NEXT Chapter 18 - Process Logic