backend-ERD

Tables (6)

Classroom (강의실)

  • ClassroomID (강의실 ID) — Primary key — NOT NULL
  • ClassroomNumber (강의실 번호)
  • Location (위치)
  • Capacity (수용 인원)

Department (학과)

  • DepartmentID (학과 ID) — Primary key — NOT NULL
  • Name (학과 이름)

Enrollment (수강정보)

  • EnrollmentID (수강정보 ID) — Primary key — NOT NULL
  • StudentID (학번) — Foreign key → Student.StudentID — NOT NULL
  • LectureID (강의 ID) — Foreign key → Lecture.LectureID — NOT NULL
  • Grade (성적)

Lecture (강의)

  • LectureID (강의 ID) — Primary key — NOT NULL
  • ClassroomID (강의실 ID) — Foreign key → Classroom.ClassroomID — NOT NULL
  • ProfessorID (교수 ID) — Foreign key → Professor.ProfessorID — NOT NULL
  • Name (강의명)
  • Price (수강료)

Professor (교수)

  • ProfessorID (교수 ID) — Primary key — NOT NULL
  • DepartmentID (학과 ID) — Foreign key → Department.DepartmentID — NOT NULL
  • Name (이름)
  • Major (전공)

Student (학생)

  • StudentID (학번) — Primary key — NOT NULL
  • DepartmentID (학과 ID) — Foreign key → Department.DepartmentID — NOT NULL
  • Name (이름)