I want an ER diagram with tables :1)tbl_admin:admin_id,username,email,password.2)tbl_faculty:faculty_id,faculty_name,dob,gender,house_name,place,city,department,f_phone_no.3)tbl_student:student_id,student_name,dob,gender,house_name,place,city,s_phone_no.4)tbl_course:course_code,course_name,subject_name,semester_name,faculty_id.5)tbl_assignment:assignment_id,course_code,student_id,assignment_marks.6)tbl_attendance:attendance_id,student_id,date,period1,period2,period3,period4,period5,attendance_marks.7)tbl_mark:mark_id,course_code,student_id,exam_marks,marks_obtained.8)tbl_report:report_id,faculty_id,student_id,generated_date,total_marks.then relations are :.And then it can be read from top to bottom and left to right
[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]
