as1

Tables (6)

class

  • year — INT — Primary key — NOT NULL
  • semester — INT — Primary key — NOT NULL
  • division — INT — Primary key — NOT NULL
  • course_id — INT — Foreign key → course.course_id — NOT NULL
  • classroom — VARCHAR(100)
  • enroll — INT
  • prof_id — INT — Foreign key → professor.prof_id — NOT NULL

course

  • course_id — INT — Primary key — NOT NULL
  • title — VARCHAR(100)
  • credit — INT

department

  • dept_id — INT — Primary key — NOT NULL
  • dept_name — VARCHAR(100)
  • office — VARCHAR(100)

professor

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

student

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

takes

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