Graduation requirements

Tables (5)

course (과목)

  • c_code (과목코드) — Primary key — NOT NULL
  • c_name (과목이름)
  • category (분류)
  • earned_credit (이수학점)
  • is_req_major (전공필수여부)

department (학과)

    enrollment (수강)

    • s_id (주키 아이디) — Foreign key → student.s_id — NOT NULL
    • c_code (과목코드) — Foreign key → course.c_code — NOT NULL
    • pass (합/불)

    major (전공)

      student (학생)

      • s_id (주키 아이디) — Primary key — NOT NULL
      • name (이름)
      • major (전공)
      • semester (학기)