attandencabook

Tables (6)

Attendance

  • 출석Id (AttendanceId) — Primary key — NOT NULL
  • 출석차시 (AttendanceSession)
  • 강의Id (CoursesId) — Foreign key → Courses.강의Id — NOT NULL
  • 학생Id (StudentId) — Foreign key → Students.학생Id — NOT NULL

Courses

  • 강의Id (CourseId) — Primary key — NOT NULL
  • 강의 이름 (CourseName) — NOT NULL
  • 전공 (department)
  • 교수Id (ProfessorId) — Foreign key → Professors.교수Id — NOT NULL

CoursesAttendance

  • 강의Id (CoursesId) — Foreign key → Courses.강의Id — NOT NULL
  • 출석 차시 (AttendanceSession) — NOT NULL
  • 출석 시간 (AttendanceData) — NOT NULL

Professors

  • 교수Id (ProfessorId) — Primary key — NOT NULL
  • 교수 이름 (ProfessorName) — NOT NULL
  • 전공 (Department)
  • 이메일 (email)

StudentEnrollments

  • 수강번호 (EnrollmentId) — Primary key — NOT NULL
  • 등급 (Grand)
  • 학생Id (StudentId) — Foreign key → Students.학생Id — NOT NULL
  • 강의Id (CoursesId) — Foreign key → Courses.강의Id — NOT NULL

Students

  • 학생Id (StudentId) — Primary key — NOT NULL
  • 학생 이름 (StudentName) — NOT NULL
  • 전공 (Major)
  • 이메일 (email)