GradChecker

Tables (6)

Courses (courses)

  • Key (course_number) — int — Primary key — NOT NULL
  • year — int
  • semester — varchar(100)
  • course_number (course_name) — varchar(100)
  • course_classification — string
  • selection_area — string
  • credits — double

Students (students)

  • student_id — int — Primary key
  • pw — varchar(100) — NOT NULL
  • Major (major) — stirng — NOT NULL
  • Field (additional_major) — int
  • Field (email) — varchar(100)

Untitled (history)

  • Key (course_number) — int — Foreign key → Courses.Key — NOT NULL
  • student_id — int — Foreign key → Students.student_id

Untitled (reviews)

  • Key (course_number) — int — Foreign key → Courses.Key — NOT NULL
  • Field (rating) — int
  • Field (comment) — varchar(1000)

Untitled (student_info)

  • student_id — int — Foreign key → Students.student_id
  • Field (student_name)
  • Field (major) — string

Untitled3 (requirements)

  • student_id — int — Foreign key → Students.student_id
  • Field (english) — int
  • Field (west) — int
  • Field (east) — int
  • Field (west_east) — int
  • Field (science) — int