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