university_db

Tables (5)

courses

  • course_id — SERIAL — Primary key — NOT NULL
  • course_code — VARCHAR(20) — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • department_id — INTEGER — Foreign key → departments.department_id — NOT NULL
  • credits — INTEGER — NOT NULL
  • capacity — INTEGER — NOT NULL
  • academic_year — INTEGER — NOT NULL
  • semester — INTEGER — NOT NULL

departments

  • department_id — SERIAL — Primary key — NOT NULL
  • department_code — VARCHAR(10) — NOT NULL
  • department_name — VARCHAR(100) — NOT NULL
  • office_phone — VARCHAR(20)

enrollments

  • enrollment_id — SERIAL — Primary key — NOT NULL
  • student_id — INTEGER — Foreign key → students.student_id — NOT NULL
  • course_id — INTEGER — Foreign key → courses.course_id — NOT NULL
  • enrolled_at — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • score — NUMERIC(5, 2)

professors

  • professor_id — SERIAL — Primary key — NOT NULL
  • employee_no — VARCHAR(20) — NOT NULL
  • professor_name — VARCHAR(50) — NOT NULL
  • department_id — INTEGER — Foreign key → departments.department_id — NOT NULL
  • email — VARCHAR(100)
  • hire_date — DATE — NOT NULL

students

  • student_id — SERIAL — Primary key — NOT NULL
  • student_no — VARCHAR(20) — NOT NULL
  • student_name — VARCHAR(50) — NOT NULL
  • department_id — INTEGER — Foreign key → departments.department_id — NOT NULL
  • grade — INTEGER — NOT NULL
  • birth_date — DATE — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • admission_date — DATE — NOT NULL