Create an ER diagram

Entities and Attributes

1. tbl_admin

   • admin_id (Primary Key)
   • username
   • email
   • password

2. tbl_faculty

   • faculty_id (Primary Key)
   • faculty_name
   • dob
   • gender
   • house_name
   • place
   • city
   • department
   • f_phone_no

3. tbl_student

   • student_id (Primary Key)
   • student_name
   • dob
   • gender
   • house_name
   • place
   • city
   • s_phone_no

4. tbl_course

   • course_code (Primary Key)
   • course_name
   • subject_name
   • semester_name
   • faculty_id (Foreign Key)

5. tbl_assignment

   • assignment_id (Primary Key)
   • course_code (Foreign Key)
   • student_id (Foreign Key)
   • assignment_marks

6. tbl_attendance

   • attendance_id (Primary Key)
   • student_id (Foreign Key)
   • date
   • period1
   • period2
   • period3
   • period4
   • period5
   • attendance_marks

7. tbl_mark

   • mark_id (Primary Key)
   • course_code (Foreign Key)
   • student_id (Foreign Key)
   • exam_marks
   • marks_obtained

8. tbl_report

   • report_id (Primary Key)
   • faculty_id (Foreign Key)
   • student_id (Foreign Key)
   • generated_date
   • total_marks

Relationships

• [Admin] --manages–> [Faculty]
• [Admin] --manages–> [Student]
• [Admin] --views–> [Assignment]
• [Admin] --views–> [Attendance]
• [Admin] --views–> [Report]
• [Faculty] --teaches–> [Course]
• [Student] --enrolled in–> [Course]
• [Student] --views–> [Assignment]
• [Student] --views–> [Attendance]
• [Student] --views–> [Report]
• [Student] --attends–> [Course]
• [Course] --has–> [Attendance]
• [Student] --takes exam–> [Mark]
• [Faculty] --generates–> [Report]   And read it from top to bottom and from left to right