DB_HW
Tables (5)
COURSE (과목)
- Course_number — VARCHAR(15) — Primary key — NOT NULL
- Course_name — VARCHAR(20)
- Credit_hours — INT(2)
- Department — VARCHAR(10)
GRADE_REPORT (성적표)
- Student_number — INT(3) — Foreign key → STUDENT.Student_number — NOT NULL
- Section_identifier — INT(5) — Foreign key → SECTION.Section_identifier — NOT NULL
- Grade — VARCHAR(1)
PREREQUISITE (선행조건)
- Course_number — VARCHAR(15) — Foreign key → COURSE.Course_number — NOT NULL
- Prerequisite_number — VARCHAR(15)
SECTION (섹션)
- Section_identifier — INT(5) — Primary key — NOT NULL
- Course_number — VARCHAR(15) — Foreign key → COURSE.Course_number — NOT NULL
- Student_number — INT(3) — Foreign key → STUDENT.Student_number — NOT NULL
- Semester — VARCHAR(5)
- Year — INT(3)
- Instructor (Instructur) — VARCHAR(20)
STUDENT (학생)
- Student_number — INT(3) — Primary key — NOT NULL
- NAME — VARCHAR(5)
- CLASS — INT(3)
- Major — VARCHAR(10)