Course and Grades Database Schema

erDiagram
  STUDENT ||--o{ ENROLLMENT : enrols
  COURSE ||--o{ COURSE_OFFERING : "offered as"
  INSTRUCTOR ||--o{ COURSE_OFFERING : teaches
  COURSE_OFFERING ||--o{ ENROLLMENT : has
  COURSE_OFFERING ||--o{ ASSESSMENT : includes
  ASSESSMENT ||--o{ GRADE : "graded in"
  STUDENT ||--o{ GRADE : receives
  STUDENT {
    int id PK
    string roll_no
    string name
    string email
  }
  COURSE {
    int id PK
    string code
    string title
    int credits
  }
  INSTRUCTOR {
    int id PK
    string name
    string department
  }
  COURSE_OFFERING {
    int id PK
    int course_id FK
    int instructor_id FK
    string term
  }
  ENROLLMENT {
    int id PK
    int student_id FK
    int offering_id FK
    date enrolled_on
  }
  ASSESSMENT {
    int id PK
    int offering_id FK
    string name
    decimal weight
  }
  GRADE {
    int id PK
    int student_id FK
    int assessment_id FK
    decimal marks
  }