6번 문제

테이블 (4)

Course Offering (Untitled4)

  • co_id — INT — 기본 키 — NOT NULL
  • year — DATE
  • semester — INT
  • section — VAR(30)
  • timings — INT
  • classroom — INT

Courses (Untitled)

  • courses_id — INT — 기본 키 — NOT NULL
  • co_id — INT — 외래 키 → Course Offering.co_id — NOT NULL
  • instructors id — INT — 외래 키 → Instructors.instructors id — NOT NULL
  • student_id — INT — 외래 키 → Students.student_id — NOT NULL
  • credits — VAR(10)
  • syllabus — VAR(40)
  • prerequisites — VAR(40)

Instructors (Untitled3)

  • instructors id — INT — 기본 키 — NOT NULL
  • name — VAR(40)
  • department — VAR(40)
  • title — VAR(40)

Students (Untitled2)

  • student_id — INT — 기본 키 — NOT NULL
  • name — VAR(40)
  • program — VAR(40)