cnu_likelion_week5

Tables (5)

ClassRoom (강의실)

  • ClassRoomNumber (강의실 번호) — Primary key — NOT NULL
  • ClassRoomLocation (위치)
  • ClassRoomMax (수용인원)

Lecture (강의)

  • LectureNumber (강의번호) — Primary key — NOT NULL
  • LectureName (강의명)
  • LectureFee (수강료)
  • ProfessorNumber (교수번호) — Foreign key → Professor.ProfessorNumber — NOT NULL
  • ClassRoomNumber (강의실 번호) — Foreign key → ClassRoom.ClassRoomNumber — NOT NULL
  • StudentNumber (학번) — Foreign key → Student.StudentNumber — NOT NULL

Professor (교수)

  • ProfessorNumber (교수번호) — Primary key — NOT NULL
  • ProfessorName (교수 이름)
  • Major (전공)
  • AffiliatedDepartment (소속 학과)

Student (학생)

  • StudentNumber (학번) — Primary key — NOT NULL
  • StudentName (학생 이름)
  • Major (학과)
  • LectureNumber (강의번호) — Foreign key → Lecture.LectureNumber — NOT NULL

enrollment (등록자)

  • StudentNumber (학번) — Foreign key → Student.StudentNumber — NOT NULL
  • LectureNumber (강의번호) — Foreign key → Lecture.LectureNumber — NOT NULL
  • Field (성적)