exam_id (PK)

course_id (FK)

exam_type

exam_date

max_marks

semester

reg_date

course_id (PK)

name

department_id (FK)

credits

semester

faculty_id (FK)

policy_id (PK)

course_id (FK)

min_pass_mrks

grade_a_range

grade_b_range

grade_c_range

grade_f_range

student_id (PK)

name

dob

gender

department_id (FK)

email

phone

reg_date

department_id (PK)

name

hod_id (FK)

faculty_id (PK)

name

email

phone

department_id (FK)

designation

registration_id (PK)

student_id (FK)

course_id (FK)

semester

academic_year

result_id (PK)

student_id (FK)

exam_id (FK)

marks_obtained

grade

status (pass/fail)

remarks