ERD_Haksa_Administration_System

Tables (6)

class

  • class_id — INT — Primary key — NOT NULL
  • course_id — INT — Foreign key → course.course_id — NOT NULL
  • prof_id — INT — Foreign key → professor.prof_id — NOT NULL
  • semester — VARCHAR(10) — NOT NULL
  • capacity — INT — NOT NULL
  • classroom — VARCHAR(20)

course

  • course_id — INT — Primary key — NOT NULL
  • course_name — VARCHAR(50) — NOT NULL
  • credits — INT — NOT NULL
  • dept_id — INT — Foreign key → department.dept_id — NOT NULL

department

  • dept_id — INT — Primary key — NOT NULL
  • dept_name — VARCHAR(50) — NOT NULL
  • office_phone — VARCHAR(20)

enrollment

  • enrollment_id — INT — Primary key — NOT NULL
  • student_id — INT — Foreign key → student.student_id — NOT NULL
  • class_id — INT — Foreign key → class.class_id — NOT NULL
  • enroll_date — DATE — NOT NULL
  • grade — NUMERIC(3,1)

professor

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

student

  • student_id — INT — Primary key — NOT NULL
  • student_name — VARCHAR(30) — NOT NULL
  • dept_id — INT — Foreign key → department.dept_id — NOT NULL
  • birth_date — DATE — NOT NULL
  • admission_date — DATE — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • phone — VARCHAR(20)