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