HW1
Tables (5)
Course
- course_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- credit — INT — NOT NULL
- start_year — YEAR — NOT NULL
Degree_Program
- program_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- total_credits — INT — NOT NULL
- start_year — YEAR — NOT NULL
Enrollment
- enrollment_id — INT — Primary key
- student_id (student_id2) — INT — Foreign key → Student.student_id
- course_id — INT — NOT NULL
- year — YEAR — NOT NULL
- semester — TINYINT — NOT NULL
- earned_credit — INT
Program_Courses
- course_id (course_id2) — INT — Primary key
- program_id — INT — Foreign key → Degree_Program.program_id
- year — YEAR — NOT NULL
- semester — TINYINT — NOT NULL
Student
- student_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- birth_date — DATE — NOT NULL
- admission_year — YEAR — NOT NULL
- program_id — INT — NOT NULL