erd과제
테이블 (5)
class
- class_id — VARCHAR2(50) — 기본 키 — NOT NULL
- course_id — VARCHAR2(50) — 외래 키 → course.course_id — NOT NULL
- location — VARCHAR2(50)
- coach_id — VARCHAR2(50) — 외래 키 → coach.coach_id — NOT NULL
coach
- coach_id — VARCHAR2(50) — 기본 키 — NOT NULL
- name — VARCHAR2(50)
- resposibility (responsibility) — VARCHAR2(50)
consultant
- consul_id — VARCHAR2(50) — 기본 키 — NOT NULL
- student_id — VARCHAR2(50) — 외래 키 → students.student_id — NOT NULL
- class_id — VARCHAR2(50) — 외래 키 → class.class_id — NOT NULL
- course_id — VARCHAR2(50) — 외래 키 → class.course_id — NOT NULL
- name — VARCHAR2(50)
- responsbility (responsbilty) — VARCHAR2(50)
course
- course_id — VARCHAR2(50) — 기본 키 — NOT NULL
- type — VARCHAR2(50)
students
- student_id — VARCHAR2(50) — 기본 키 — NOT NULL
- generation — VARCHAR(100)
- major — VARCHAR2(50)
- graduated — VARCHAR2(20)
- class_id — VARCHAR2(50) — 외래 키 → class.class_id — NOT NULL
- course_id — VARCHAR2(50) — 외래 키 → class.course_id — NOT NULL
- ffd (Field)