University.db

Tables (6)

ACADEMIC_HISTORY

  • history_id — SERIAL — Primary key — NOT NULL
  • student_id — VARCHAR(50) — Foreign key → STUDENT.student_id
  • status — VARCHAR(50) — NOT NULL
  • change_date — DATE — NOT NULL

COURSE

  • course_code — VARCHAR(50) — Primary key — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • course_type — VARCHAR(50)
  • capacity — INT — NOT NULL
  • credits — INT — NOT NULL
  • dept_code — VARCHAR(50) — Foreign key → DEPARTMENT.dept_code
  • prof_id — VARCHAR(50) — Foreign key → PROFESSOR.prof_id

DEPARTMENT

  • dept_code — VARCHAR(50) — Primary key — NOT NULL
  • dept_name — VARCHAR(100) — NOT NULL

ENROLLMENT

  • student_id — VARCHAR(50) — Foreign key → STUDENT.student_id — NOT NULL
  • course_code — VARCHAR(50) — Foreign key → COURSE.course_code — NOT NULL
  • attendance_score — INT
  • assignment_score — INT
  • exam_score — INT
  • final_grade — VARCHAR(10)

PROFESSOR

  • prof_id — VARCHAR(50) — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • contact — VARCHAR(100)
  • hire_date — DATE — NOT NULL
  • resign_date — DATE
  • dept_code — VARCHAR(50) — Foreign key → DEPARTMENT.dept_code

STUDENT

  • student_id — VARCHAR(50) — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • year — INT — NOT NULL
  • major_code — VARCHAR(50) — Foreign key → DEPARTMENT.dept_code
  • minor_code — VARCHAR(50) — Foreign key → DEPARTMENT.dept_code
  • double_major_code — VARCHAR(50) — Foreign key → DEPARTMENT.dept_code
  • advisor_id — VARCHAR(50) — Foreign key → PROFESSOR.prof_id