db

Tables (6)

class

  • year — INT — Primary key — NOT NULL
  • semester — INT — Primary key — NOT NULL
  • division — CHAR(2) — Primary key — NOT NULL
  • course_id — CHAR(6) — Foreign key → course.course_id — NOT NULL
  • classroom — VARCHAR(10)
  • enroll — INT
  • prof_id — CHAR(5) — Foreign key → professor.prof_id — NOT NULL

course

  • course_id — CHAR(6) — Primary key — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • credit — INT

department

  • dept_id — CHAR(5) — Primary key — NOT NULL
  • dept_name — VARCHAR(30) — NOT NULL
  • office — VARCHAR(20)

professor

  • prof_id — CHAR(5) — Primary key — NOT NULL
  • resident_id — CHAR(14) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • position — VARCHAR(10)
  • year_emp — INT
  • dept_id — CHAR(5) — Foreign key → department.dept_id — NOT NULL

student

  • stu_id — CHAR(10) — Primary key — NOT NULL
  • resident_id — CHAR(14) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • year — INT
  • address — VARCHAR(100)
  • dept_id — CHAR(5) — Foreign key → department.dept_id — NOT NULL

takes

  • stu_id — CHAR(10) — Foreign key → student.stu_id — NOT NULL
  • course_id — CHAR(6) — Foreign key → class.course_id — NOT NULL
  • year — INT — Foreign key → class.year — NOT NULL
  • semester — INT — Foreign key → class.semester — NOT NULL
  • division — CHAR(2) — Foreign key → class.division — NOT NULL
  • grade — CHAR(2)