University

Tables (5)

course

  • course_id — SERIAL — Primary key — NOT NULL
  • department_id — SERIAL — Foreign key → department.department_id — NOT NULL
  • professor_id — SERIAL — Foreign key → professor.professor_id
  • course_code — VARCHAR(20) — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • credit — INT — NOT NULL
  • capacity — INT — NOT NULL
  • semester — VARCHAR(10) — NOT NULL

department

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

enrollment

  • enrollment_id — SERIAL — Primary key — NOT NULL
  • student_id — SERIAL — Foreign key → student.student_id — NOT NULL
  • course_id — SERIAL — Foreign key → course.course_id — NOT NULL
  • enrollment_date — DATE — NOT NULL
  • grade — VARCHAR(3)
  • score — NUMERIC(5,2)

professor

  • professor_id — SERIAL — Primary key — NOT NULL
  • department_id — SERIAL — Foreign key → department.department_id — NOT NULL
  • professor_name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100)
  • hire_date — DATE — NOT NULL

student

  • student_id — SERIAL — Primary key — NOT NULL
  • department_id — SERIAL — Foreign key → department.department_id — NOT NULL
  • student_name — VARCHAR(100) — NOT NULL
  • student_number — VARCHAR(20) — NOT NULL
  • birth_date — DATE
  • email — VARCHAR(100)
  • admission_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL