대학교 학사 관리 시스템의 ERD

테이블 (8)

Assignment

  • AssignmentID — INT
  • AssignmentName — VARCHAR(50)
  • AssignmentDescription — TEXT
  • AssignmentDeadline — DATE
  • LectureID — INT — 외래 키 → Lecture.LectureID

Lecture

  • LectureID — INT
  • LectureName — VARCHAR(50)
  • LectureDescription — TEXT
  • InstructorName — VARCHAR(50)
  • LectureDate — DATE
  • CourseID — INT

Survey

  • SurveyID — INT
  • SurveyName — VARCHAR(50)
  • SurveyDescription — TEXT
  • SurveyDeadline — DATE
  • AssignmentID — INT — 외래 키 → Assignment.AssignmentID

course

  • course_id — INT
  • course_code — VARCHAR(10)
  • course_name — VARCHAR(50)
  • entity_type — ENUM('교양', '전공')

course_offering

  • course_offering_id — INT
  • year — INT
  • semester — ENUM('1학기', '여름학기', '2학기', '겨울학기')
  • professor_id — INT — 외래 키 → professor.professor_id
  • course_id — INT — 외래 키 → course.course_id

enrollment

  • enrollment_id — INT
  • student_id — INT — 외래 키 → student.student_id
  • course_offering_id — INT — 외래 키 → course_offering.course_offering_id

professor

  • professor_id — INT
  • name — VARCHAR(50)
  • email — VARCHAR(50)
  • department — VARCHAR(50)

student

  • student_id — INT
  • name — VARCHAR(50)
  • email — VARCHAR(50)
  • major — VARCHAR(50)