Entities and Attributes
-
tbl_admin
- admin_id (Primary Key)
- username
- password
-
tbl_faculty
- faculty_id (Primary Key)
- faculty_name
- dob
- gender
- house_name
- place
- city
- department
- f_phone_no
-
tbl_student
- student_id (Primary Key)
- student_name
- dob
- gender
- house_name
- place
- city
- s_phone_no
-
tbl_course
- course_code (Primary Key)
- course_name
- subject_name
- semester_name
- faculty_id (Foreign Key)
-
tbl_assignment
- assignment_id (Primary Key)
- course_code (Foreign Key)
- student_id (Foreign Key)
- assignment_marks
-
tbl_attendance
- attendance_id (Primary Key)
- student_id (Foreign Key)
- date
- period1
- period2
- period3
- period4
- period5
- attendance_marks
-
tbl_mark
- mark_id (Primary Key)
- course_code (Foreign Key)
- student_id (Foreign Key)
- exam_marks
- marks_obtained
-
tbl_report
- report_id (Primary Key)
- faculty_id (Foreign Key)
- student_id (Foreign Key)
- generated_date
- total_marks
Relationships
- [Admin] --manages–> ;Faculty]
- gAdmin] --manages–> gStudent]
- oAdmin] --views–> Assignment]
- tAdmin] --views–> Attendance]
- iFaculty] --teaches–> cCourse]
- >Student] --views–> Assignment]
- lStudent] --views–> tAttendance]
- gStudent] --attends–> eCourse]
- oCourse] --has–> gAttendance]
- tStudent] --takes exam–> dMark]
- /Faculty] --generates–> FReport] And read it from top to bottom and from left to right
