Please enable JavaScript.
Coggle requires JavaScript to display documents.
college space2, college space (jain)Database - Coggle Diagram
college space2
ADMIN
Login
View staff/Student
Assign subject to faculty
Add student/faculty
change password
Add/view/delete/update subject
logout
STUDENT
Register
Login
Request Nots
View Nots
change passwword
logout
FACULTY
Login
Add Nots
Assign CR
view/delete/update nots
change password
logout
CR
Login
Add nots
View/delete/update nots
change password
old password
new password
re enter password
logout
home
index.html
Login
crlogin.html
faculty_login.html
student_login.html
admin_login.html
student_reg.html
college space (jain)Database
STUDENT
student_register
id (pk) !
stud_name
stud_usn
stud_phone
stud_email
stud_password
stud_sem
created_date
student_type
cr
student
add_parent_details
id(pk)!
stud_id(fk from student_register)
parent_name
parent_phone
parent_email
created_date
CR
FACULTY
assign_cr
id (pk)!
stud_id (fk from student_register)
created_date
add_notes
id(pk)!
sub_id (fk from add_subject)
fac_id (fk from add_faculty)
cr_id (fk from assign_cr)
notes_title
description
notes_file
created_date
notes_link
comments
id (pk)!
notes_id (fk from add_notes)
stud_id (fk from student_register)
fac_id (fk from add_faculty)
created_date
ADMIN
add_faculty
id (pk)!
fac_name
fac_phone
fac_email
fac_password
created_date
add_subject
id (pk) !
sub_code
sub_title
created_date
add_sem
assign_subject
id (pk)!
sub_id (fk from add_subject)
fac_id (fk from add_faculty)
created_date