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