db_assignment

Tables (7)

Course (과목)

  • 과목Id (course_Id) — NOTNULL — Primary key — NOT NULL
  • 교수Id (professor_Id) — NOTNULL — Foreign key → Professor.교수Id — NOT NULL
  • 학생Id (student_Id) — NOTNULL — Foreign key → Professor.학생Id — NOT NULL
  • 수강정보Id (enrollment_Id) — NOTNULL — Foreign key → Enrollment.수강정보Id — NOT NULL
  • 학생Id (student_Id2) — NOTNULL — Foreign key → Enrollment.학생Id — NOT NULL
  • 과목번호 (courseNum) — NOTNULL
  • 과목이름 (courseName) — NOTNULL
  • 이수학점 (credit) — NOTNULL

Department (부서)

  • 부서ID (department_Id) — NOTNULL — Primary key — NOT NULL
  • 부서번호 (deptNo) — NOTNULL
  • 부서이름 (deptName) — NOTNULL

Employee (직원)

  • 직원ID (employee_Id) — NOTNULL — Primary key — NOT NULL
  • 부서ID (department_Id) — NOTNULL — Foreign key → Department.부서ID — NOT NULL
  • 사번 (empNo) — NOTNULL
  • 이름 (name) — NOTNULL
  • 나이 (age) — NOTNULL

Enrollment (수강정보)

  • 수강정보Id (enrollment_Id) — NOTNULL — Primary key — NOT NULL
  • 학생Id (student_Id) — NOTNULL — Foreign key → Student.학생Id — NOT NULL
  • 학점 (grade) — NOTNULL

History (근무이력)

  • 근무이력ID (history_Id) — NOTNULL — Primary key — NOT NULL
  • 직원ID (employee_Id) — NOTNULL — Foreign key → Employee.직원ID — NOT NULL
  • 부서ID (department_Id) — NOTNULL — Foreign key → Department.부서ID — NOT NULL
  • 부서ID (department_Id2) — NOTNULL — Foreign key → Employee.부서ID — NOT NULL
  • 근무기간 (period) — NOTNULL
  • 직책 (position) — NOTNULL

Professor (교수)

  • 교수Id (professor_Id) — NOTNULL — Primary key — NOT NULL
  • 학생Id (student_Id) — NOTNULL — Foreign key → Student.학생Id — NOT NULL
  • 교수번호 (professor_num) — NOTNULL
  • 이름 (name) — NOTNULL
  • 전공 (major) — NOTNULL
  • 소속학과 (department) — NOTNULL

Student (학생)

  • 학생Id (student_Id) — NOTNULL — Primary key — NOT NULL
  • 학번 (student_number) — NOTNULL
  • 이름 (name) — NOTNULL
  • 학년 (grade) — NOTNULL