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