Academin Schema

Tables (5)

course

  • course_id — SERIAL — Primary key — NOT NULL
  • dept_id — INT — Foreign key → department.dept_id — NOT NULL
  • prof_id — INT — Foreign key → professor.prof_id
  • course_name — VARCHAR(100) — NOT NULL
  • credit — INT — NOT NULL
  • semester — VARCHAR(7) — NOT NULL

department

  • dept_id — SERIAL — Primary key — NOT NULL
  • dept_name — VARCHAR(50) — NOT NULL
  • office — VARCHAR(30)

enrollment

  • enroll_id — SERIAL — Primary key — NOT NULL
  • student_id — INT — Foreign key → student.student_id — NOT NULL
  • course_id — INT — Foreign key → course.course_id — NOT NULL
  • enroll_date — DATE — NOT NULL
  • score — NUMERIC(4,1)

professor

  • prof_id — SERIAL — Primary key — NOT NULL
  • dept_id — INT — Foreign key → department.dept_id — NOT NULL
  • prof_name — VARCHAR(30) — NOT NULL
  • email — VARCHAR(100)
  • hire_date — DATE — NOT NULL

student

  • student_id — SERIAL — Primary key — NOT NULL
  • dept_id — INT — Foreign key → department.dept_id — NOT NULL
  • student_no — CHAR(8) — NOT NULL
  • student_name — VARCHAR(30) — NOT NULL
  • email — VARCHAR(100)
  • grade — INT — NOT NULL
  • admission_date — DATE — NOT NULL