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)