School_information
Tables (5)
Courses (Untitled3)
- course_id (Key) — Primary key — NOT NULL
- enrollment_id (PK) — Foreign key → enrollment.enrollment_id — NOT NULL
- course_name (Field)
- credits (Field2)
- program_id (Field3)
degree_programs (Untitled2)
- program_id (Key) — Primary key — NOT NULL
- course_id (Key2) — Foreign key → Courses.course_id — NOT NULL
- Student_id (Key3) — Foreign key → student_degree.Student_id — NOT NULL
- enrollment_id (PK) — Foreign key → Courses.enrollment_id — NOT NULL
- program_name (Field)
- required_credits (Field2)
enrollment (Untitled5)
- enrollment_id (PK) — Primary key — NOT NULL
- student_id (FK)
- course_id (Field2)
- year (Field3)
- semester (Field4)
- grade (Field5)
student_degree (Untitled4)
- Student_id (Key) — Primary key — NOT NULL
- student_id (id) — INT
- program_id (Field2)
students (Untitled)
- student_id (Key) — Primary key — NOT NULL
- Key (Key2) — Foreign key → student_degree.Student_id — NOT NULL
- enrollment_id (PK) — Foreign key → enrollment.enrollment_id — NOT NULL
- name (Field)
- birth_date (Field2)
- admission_year (Field3)