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 (성적)