Table Name : PersonalInfo
Field Name StudentId StuName Fname Occupation Phone1 Phone2 Age Gender Street1 Street2 CourseRegId PlaceOfBirth Data Type Integer Varchar2 Varchar2 Varchar2 Integer Integer Integer Enum Varchar2 Varchar2 integer Char Size 6 25 25 20 11 11 2 (M,F) 50 50 6 15 Constraints Primary key
Table Name: CourseFee
Field Name
FeeID FeeAmount FSubDate ExStudent(Y/N)
Data Type
Integer Integer Date Integer
Size 6 6 2
Constraints
Primary key
TableName:CourceReg
Field Name
CourseReg ID FeeID CourseCode StudentID
Data Type
Integer Integer Integer Integer
Size
6 6 6 6
Constraints
Primary key Foreign key Foreign key Foreign key
Reference Table
CourseFee Courses PersonalInfo
Table Name: Courses
Field Name
CoursesCode Duration CourseFee CourseTitle CTypeID
Data Type
Integer Varchar2 Integer Varchar2 Integer
Size
6 10 6 30 6
Constraints
Primary key
Reference Table
Foreign key
CourseType
Table Name: City
Field Name
CityCode CityName StudentID
Data Type
Integer char Integer
Size
6 25 6
Constraints
Primary key
Reference Table
Foreign key
PersonalInfo
Table Name: User
Field Name
UserID StudentID Password FeeID CourseRegID UserID StudentID
Data Type
Integer Integer Integer Integer integer
Size
6 6 6 6 6
Constraints
Reference Table
Foreign key
PersonalInfo
Foreign key Foreign key Primary key
CourseFee CourseReg
Table Name: CourseType
Field Name
CTypeID CTypeTitle
Data Type
Integer Varchar2
Size
6 15
Constraints
Primary key
Type Name: Schedule
Fieldname
ScheduleID StartingAssiDate EndingAssiDate StartingExam Date EndingExam Date CoursesRegID CourseOutline
Data Type
Integer Date Date Date Date Integer Varchar2
Size
6
Constraints
Primary key
Reference Table
6 50
Foreign key
CourseReg
Table Name: Questions
Field Name Q# CoursesCode QDiscription CorrectOption Q# CoursesCode Data Type Integer integer Varchar2 Varchar2 Size 6 6 50 25 Primary key Foreign key Courses Constraints Reference Table
Table Name: Options
Field Name Options# Q# CourseCode ODiscription Options# Q# Course Code Data Type Integer Integer Integer Varchar2 Size 2 6 6 50 Constraints Foreign key Foreign key Primary key Reference Table Questions Courses
Table Name: Assignment
Field Name AssignmentId AssiSelectedOption# AssiCorrect(Y/N) AssiSequence# Q# CourseCode CourseRegID ATotalQ StudentId Data Type Integer Varchar2 Integer Integer Integer Integer Integer Integer Integer Size 6 2 2 6 6 6 6 6 6 Constraints Primary key Reference Table
Foreign key Foreign key Foreign key Foreign key
Questions Courses CoursesReg PersonalInfo
Table Name: Exam
Field Name ExamID ExamCorrect(Y/N) ExamSequence# ExamSelectedOption# Q# CourseCode CourseRegID FTotalQ StudentID Data Type Integer Integer Integer Integer Integer Integer Integer Integer Size 6 6 6 6 6 6 6 6 Constraints Primary key Reference Table
Foreign key Foreign key Foreign key Foreign key
Questions Courses CoursesReg PersonalInfo
Table Name: Result
Field Name ResultID TotalAssiMarks TotalExamMarks GAssi Marks GExamMarks CourseRegID Data Type Integer Integer Integer Integer Integer Integer Size 6 6 6 6 6 6 Constraints Primary key Reference Table
Foreign key
Courses
Tablename:Certification
Field Name CertificateID StudentID CourseRegID Data Type Integer Integer Integer Size 6 6 6 Constraints Primary key Reference Table PersonalInfo Course
Tablename:CourseContent
Field Name CoContent# File CourseCode CTypeId Data Type Integer Integer Integer Integer Size 6 6 6 6 Constraints Primary key Foreign key Foreign key Foreign key Reference Table PersonalInfo Course CourseType
