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 (학기)