Please enable JavaScript.

Coggle requires JavaScript to display documents.

College - Coggle Diagram

- - - - Study Plan
        
        course
        
        exam
        
        exam_id INT (PK, AUTO_INCREMENT) Unique ID
        
        course_id INT (FK) Associated course
        
        exam_type ENUM('Midterm', 'Final', 'Quiz') Type of exam
        
        total_marks INT
        
        attendance
        
        attendance_id INT (PK, AUTO_INCREMENT) Unique ID
        
        student_id INT (FK) Student attending
        
        course_id INT (FK) Course attended
        
        date DATE Date of attendance
        
        status
        
        enrollment and registeration
        
        enrollment_id INT (PK, AUTO_INCREMENT) Unique ID
        
        student_id INT (FK) Student enrolled
        
        semester_id INT (FK) Semester enrolled in
        
        course_id INT (FK) Course registered for
        
        status ENUM('Active', 'Dropped', 'Completed')
        
        course attributes
        
        course_id INT (PK, AUTO_INCREMENT) Unique ID for the course
        
        study_plan_id INT (FK) Associated study plan
        
        name VARCHAR(255) Course name
        
        course_code VARCHAR(50) Unique course code (e.g., CS101)
        
        credits INT Number of credits
        
        type ENUM('Core', 'Elective', 'Advanced') Type of course
        
        workload_hours INT Weekly hours required
        
        grading_method VARCHAR(255)
        
        study plan attributes
        
        study_plan_id INT (PK, AUTO_INCREMENT) Unique ID
        
        program_id INT (FK) Associated program
        
        total_courses INT Total number of courses
        
        course_sequence TEXT Order of courses per level
        
        prerequisite_rules TEXT
      - academic program attributes
        
        program_id INT (PK, AUTO_INCREMENT) Unique ID for the academic program
        
        study_system_id INT (FK) Associated study system
        
        name VARCHAR(255) Program name (e.g., Computer Science BSc)
        
        description TEXT Description of the program
        
        duration INT Duration in years/semesters
        
        graduation_requirements TEXT Minimum GPA, credit hours, thesis/project requirements
    - - semester_id INT (PK, AUTO_INCREMENT) Unique ID
        
        study_system_id INT (FK) Study system it belongs to
        
        start_date DATE Start date of the semester
        
        end_date DATE End date of the semester
        
        term_type VARCHAR(50)
    - - graduation_id INT (PK, AUTO_INCREMENT) Unique ID
        
        student_id INT (FK) Student applying for graduation
        
        program_id INT (FK) Program graduated from
        
        gpa DECIMAL(3,2) Final GPA
        
        status
    - - study_system_id INT (PK, AUTO_INCREMENT) Unique ID for the study system
        
        name VARCHAR(255) Study system type (Semester-based, Annual, etc.)
        
        description TEXT General description of the system
        
        total_duration INT Total duration (Years/Semesters)
        
        min_passing_requirements TEXT Attendance, exams, projects, etc.
        
        gpa_calculation_method VARCHAR(255) Weighted average, percentage-based, etc.
        
        grading_scale VARCHAR(255) A-F, Percentage, Points-based
        
        academic_load_per_term INT Max/Min courses per semester/year
        
        dropout_reenrollment_rules TEXT Rules for dropout and re-enrollment
        
        attendance_policy TEXT Required attendance percentage