Student Result Management System ER Diagram

erDiagram
  DEPARTMENT ||--o{ STUDENT : has
  TEACHER ||--o{ SUBJECT : teaches
  STUDENT ||--o{ ENROLMENT : takes
  SUBJECT ||--o{ ENROLMENT : "taken in"
  SEMESTER ||--o{ ENROLMENT : during
  ENROLMENT ||--o{ MARK : scores
  ENROLMENT ||--o{ ATTENDANCE : records
  STUDENT ||--o{ SEMESTER_RESULT : receives
  SEMESTER ||--o{ SEMESTER_RESULT : "results of"
  DEPARTMENT {
    int dept_id PK
    string name
  }
  STUDENT {
    int student_id PK
    int dept_id FK
    string roll_no
    string name
  }
  TEACHER {
    int teacher_id PK
    string name
  }
  SUBJECT {
    string subject_code PK
    int teacher_id FK
    string title
    int credits
  }
  SEMESTER {
    int semester_id PK
    string term
    int year
  }
  ENROLMENT {
    int enrolment_id PK
    int student_id FK
    string subject_code FK
    int semester_id FK
  }
  MARK {
    int mark_id PK
    int enrolment_id FK
    string assessment
    decimal marks
  }
  ATTENDANCE {
    int attendance_id PK
    int enrolment_id FK
    date class_date
    boolean present
  }
  SEMESTER_RESULT {
    int result_id PK
    int student_id FK
    int semester_id FK
    decimal sgpa
    decimal cgpa
  }