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