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)