NF

Tables (4)

courses (과목)

  • courses_code (과목 코드) — NOT NULL — Primary key — NOT NULL
  • courses_name (과목명) — NOT NULL
  • credits (학점) — NOT NULL
  • semester (학기) — NULL
  • professors_id (교수ID) — NOT NULL — Foreign key → professors.professors_id — NOT NULL

enrollments (수강)

  • studnets_id (학생 ID) — NOT NULL — Primary key — NOT NULL
  • professors_id (교수 ID) — NOT NULL
  • credits (수강 학점) — NOT NULL
  • students_id (학번) — NOT NULL — Foreign key → students.students_id — NOT NULL
  • courses_code (과목 코드) — NOT NULL — Foreign key → courses.courses_code — NOT NULL

professors (교수)

  • professors_id (교수ID) — NOT NULL — Primary key — NOT NULL
  • professors_name (교수 이름) — NOT NULL
  • professors_email (이메일) — NULL
  • department (소속 학과) — NULL

students (학생)

  • students_id (학번) — NOT NULL — Primary key — NOT NULL
  • studnets_name (학생 이름) — NOT NULL
  • major (전공) — NOT NULL
  • admission_year (입학 년도) — NOT NULL
  • students_email (이메일) — NOT NULL