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