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)