학사관리
테이블 (5)
Course (강의)
- CourseID (PK) — 기본 키 — NOT NULL
- DepartmentID (Key) — 외래 키 → Department.DepartmentID — NOT NULL
- ProfessorID (pk2) — 외래 키 → Department.ProfessorID — NOT NULL
- DepartmentID (Key22) — 외래 키 → Department.DepartmentID — NOT NULL
- ProfessorID (Field)
- DepartmentID (Field2)
- Name (Field3)
- Credits (Field4)
- Schedule (Field5)
- Room (Field6)
- ProfessorID (pk) — 외래 키 → Professor.ProfessorID — NOT NULL
- DepartmentID (Key3) — 외래 키 → Professor.DepartmentID — NOT NULL
- DepartmentID (Key2) — 외래 키 → Professor.DepartmentID — NOT NULL
- DepartmentID (Key5) — 외래 키 → Professor.DepartmentID — NOT NULL
Department (학과)
- DepartmentID (Key) — 기본 키 — NOT NULL
- ProfessorID (pk) — 외래 키 → Professor.ProfessorID — NOT NULL
- DepartmentID (Key2) — 외래 키 → Professor.DepartmentID — NOT NULL
- Name (Field)
- Phone (Field2)
Enrollment (수강)
- EnrollmentID (Key) — 기본 키 — NOT NULL
- DepartmentID (Key5) — 외래 키 → Department.DepartmentID — NOT NULL
- ProfessorID (pk) — 외래 키 → Department.ProfessorID — NOT NULL
- DepartmentID (Key22) — 외래 키 → Department.DepartmentID — NOT NULL
- StudentID (Field)
- CourseID (Field2)
- ProfessorID (Field3)
- AttendanceScore (Field4)
- MidtermScore (Field5)
- FinalScore (Field6)
- OtherScore (Field7)
- TotalScore (Field8)
- Grade (Field9)
- CourseID (PK) — 외래 키 → Course.CourseID — NOT NULL
- DepartmentID (Key3) — 외래 키 → Course.DepartmentID — NOT NULL
- DepartmentID (Key2) — 외래 키 → Course.DepartmentID — NOT NULL
- DepartmentID (Key4) — 외래 키 → Course.DepartmentID — NOT NULL
Professor (교수)
- ProfessorID (pk) — 기본 키 — NOT NULL
- DepartmentID (Key2) — 외래 키 → Department.DepartmentID — NOT NULL
- ProfessorID (pk2) — 외래 키 → Department.ProfessorID — NOT NULL
- DepartmentID (Key22) — 외래 키 → Department.DepartmentID — NOT NULL
- DepartmentID (Field)
- Name (Field2)
- SSN (Field3)
- Address (Field4)
- Phone (Field5)
- Photo (Field6)
- StudentID (Key) — 외래 키 → Student.StudentID — NOT NULL
- DepartmentID (Key3) — 외래 키 → Student.DepartmentID — NOT NULL
- DepartmentID (Key4) — 외래 키 → Student.DepartmentID — NOT NULL
- DepartmentID (Key5) — 외래 키 → Student.DepartmentID — NOT NULL
Student (학생)
- StudentID (Key) — 기본 키 — NOT NULL
- DepartmentID (Key3) — 외래 키 → Department.DepartmentID — NOT NULL
- ProfessorID (pk) — 외래 키 → Department.ProfessorID — NOT NULL
- DepartmentID (Key23) — 외래 키 → Department.DepartmentID — NOT NULL
- DepartmentID (Field)
- ProfessorID (Field2)
- name (Field3)
- SSN (Field4)
- Address (Field5)
- Phone (Field6)
- Email (Field7)
- Photo (Field8)
- EnrollmentID (Key2) — 외래 키 → Enrollment.EnrollmentID — NOT NULL
- DepartmentID (Key22) — 외래 키 → Enrollment.DepartmentID — NOT NULL
- DepartmentID (Key4) — 외래 키 → Enrollment.DepartmentID — NOT NULL
- DepartmentID (Key5) — 외래 키 → Enrollment.DepartmentID — NOT NULL