DB_hw3
Tables (5)
COURSE (교과목정보)
- Course_number (과목코드) — VARCHAR — Primary key — NOT NULL
- Prerequisite_number (선수과목) — VARCHAR — Foreign key → COURSE.Course_number — NOT NULL
- Course_name (과목명) — VARCHAR(40)
- Credit_hours (과목차수) — INTEGER
- Department (과목부서) — VARCHAR
GRADE_REPORT (성적결과)
- Student_number (학번) — INTEGER — Foreign key → STUDENT.Student_number — NOT NULL
- Course_number (과목코드) — VARCHAR — Foreign key → SECTION.Course_number — NOT NULL
- Grade (성적) — CHAR(1)
PREREQUISITE (선수과목)
- Course_number (과목코드) — VARCHAR — Primary key — NOT NULL
- Prerequisite_number (선수과목) — VARCHAR — Foreign key → COURSE.Course_number — NOT NULL
SECTION (학기)
- Section_identifier (식별번호) — INTEGER — Primary key — NOT NULL
- Course_number (과목코드) — VARCHAR — Foreign key → COURSE.Course_number — NOT NULL
- Semester (학기) — VARCHAR
- Year (년도) — VARCHAR(2)
- Instructor (교수) — VARCHAR
STUDENT (학생)
- Student_number (학번) — INTEGER — Primary key — NOT NULL
- Field (이름) — VARCHAR
- Class (반) — INTEGER
- Major (전공) — VARCHAR