Diagrama ER de la base de datos University

This ER diagram shows the main entities and foreign key relationships for the University database.

MariaDB University Database ERD Entity relationship diagram for the MariaDB University database, showing sixteen base tables and their foreign key relationships. departments PKdepartment_id FKparent_id -> departments FKhead_faculty_id -> faculty name code level description faculty PKfaculty_id FKdepartment_id -> departments first_name last_name email title students PKstudent_id FKdepartment_id -> departments first_name last_name email enrollment_date courses PKcourse_id FKdepartment_id -> departments course_code course_name credits description semesters PKsemester_id term academic_year start_date end_date rooms PKroom_id building room_number capacity room_type course_prerequisites PKFKcourse_id -> courses PKFKprerequisite_id -> courses minimum_grade notes sections PKsection_id FKcourse_id -> courses FKfaculty_id -> faculty FKsemester_id -> semesters FKroom_id -> rooms section_number schedule enrollments PKFKstudent_id -> students PKFKsection_id -> sections enrolled_at status final_grade completed_at scholarships PKscholarship_id name provider amount criteria student_scholarships PKFKstudent_id -> students PKFKscholarship_id -> scholarships awarded_at amount_awarded academic_year research_projects PKproject_id FKdepartment_id -> departments FKlead_faculty_id -> faculty title start_date end_date publications PKFKproject_id -> research_projects title publication_year doi citation_count project_members PKFKproject_id -> research_projects PKFKfaculty_id -> faculty FKstudent_id -> students role joined_at left_at grade_events PKFKenrollment_id -> enrollments FKgrader_id -> faculty event_type score graded_at audit_log PKaudit_id table_name record_id operation MariaDB University ERD PKPrimary key FKForeign key Child table points to parent One connector lane per foreign key Views are omitted from this base-table ERD head_faculty_id department_id department_id department_id course_id faculty_id semester_id room_id student_id scholarship_id student_id department_id project_id project_id faculty_id student_id enrollment_id grader_id parent_id