|
ERD
A Student can enroll in different courses made available by the College or University. Each course contains several Subjects which are handled by the Professors or Teachers. The main entities in Student Information System are Student, Course, Subjects and Teacher. Matriculation Number, Name, Date of Birth, Contacts are the main attributes of the Student. Similarly, Teacher has attributes like Name, Unique ID, Contacts and an option to set Threshold attendance value. Entity Subjects contain the Matriculation Number of the Student and Unique ID of the Teacher. Attendances, Grades are the other attributes. Entity Course is recognized by a unique ID and contains the list of the Students enrolled along with the list of the core & elective Subjects offered. |