Education Management System
Tables (3)
all the subjects (전체과목)
- IDX (고유번호) — Int — Primary key
- em_code (강의코드) — Int — Foreign key → taking classes.em_code — NOT NULL
- subject name (과목이름) — String
- grade (학년) — Int
- place (장소) — String
student (학생)
- student number (학번) — Int — Primary key — NOT NULL
- name (이름) — String
- major (학과) — String
- grade (학년) — Int
taking classes (수강과목)
- em_code (강의코드) — Int — Primary key — NOT NULL
- student number (학번) — Int — Foreign key → student.student number — NOT NULL
- subject name (과목이름) — String
- major (학과) — Int
- grade (학년) — Int