학사관리

테이블 (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