test

Tables (7)

course

  • course_id — INTEGER — Primary key — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • credits — INTEGER

department

  • dept_id — INTEGER — Primary key — NOT NULL
  • dept_name — VARCHAR(50) — NOT NULL

enrollment

  • enroll_id — INTEGER — Primary key — NOT NULL
  • student_id — INTEGER — Foreign key → student.student_id — NOT NULL
  • section_id — INTEGER — Foreign key → section.section_id — NOT NULL
  • score — NUMERIC(3,1)
  • enroll_date — DATE
  • is_retake — BOOLEAN
  • is_forced — BOOLEAN

professor

  • prof_id — INTEGER — Primary key — NOT NULL
  • prof_name — VARCHAR(50) — NOT NULL
  • dept_id — INTEGER — Foreign key → department.dept_id

section

  • section_id — INTEGER — Primary key — NOT NULL
  • course_id — INTEGER — Foreign key → course.course_id — NOT NULL
  • prof_id — INTEGER — Foreign key → professor.prof_id
  • year — INTEGER — NOT NULL
  • semester — VARCHAR(10) — NOT NULL
  • classroom — VARCHAR(50)

student

  • student_id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • grade — INTEGER
  • email — VARCHAR(100)
  • entrance_date — DATE
  • dept_id — INTEGER — Foreign key → department.dept_id

student_major

  • major_id — INTEGER — Primary key — NOT NULL
  • student_id — INTEGER — Foreign key → student.student_id — NOT NULL
  • dept_id — INTEGER — Foreign key → department.dept_id — NOT NULL
  • major_type — VARCHAR(10) — NOT NULL