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