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)
This site is designed to help BCA MCA student to develop final project and synopsis Download Free BCA Project, MCA Project, IT Projects, Final report and Project synopsis with Full documentation and code
free download MCA projects in ASP.NET with complete source code, Free download MCA projects in VB,NET with complete source code, Free download MCA MSc projects in C#.net with complete source code,
Free download MCA projects in JAVA with complete source code, Free download MCA projects in PHP with complete source code, Free download BSc CS IT projects in PHP,JAVA, ASP.NET with source code