기말연습2
테이블 (4)
Course
- CourseID — INT — 기본 키
- CourseName — VARCHAR(100) — NOT NULL
- Credit — INT — NOT NULL
- ProfessorID — INT — 외래 키 → Professor.ProfessorID
Enrollment
- CourseID (CourseID2) — INT — 외래 키 → Course.CourseID
- StudentID — INT — 외래 키 → Student.StudentID
- Grade — CHAR(1)
- CourseID — INT — NOT NULL
Professor
- ProfessorID — INT — 기본 키
- Name — VARCHAR(100) — NOT NULL
- Department — VARCHAR(100) — NOT NULL
Student
- StudentID — INT — 기본 키
- Name — VARCHAR(100) — NOT NULL
- Grade — INT — NOT NULL