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)