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)