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 (이름)